Database is Open and is Valid but Server has gone away...

[U7Development]

Hi !

After some time of idle, the connection to database seems to be lost, lastError() returns "Server has gone away..." ..

I thought i could control this by checking if isOpen() is false, if so, then i could try to re-connect to DB.. but isOpen() returns true even if the DB's server has gone away...

The only becoming thing to my mind i can try is to detect the string error and check it, if it is "Server has gone away..." i reconnect to DB, but i'm pretty sure there must to be another way to check this..

Any ideas?
Thanks in advance.

[JonB]

@U7Development said in Database is Open and is Valid but Server has gone away...:

Server has gone away

See the answer at https://stackoverflow.com/a/15059387/489865. It's from 2013, but that way may be just as valid now, since there doesn't seem to be anything better. There is an unaddressed bug report https://bugreports.qt.io/browse/QTBUG-223. There is also the MYSQL_OPT_RECONNECT (db.setConnectOptions("MYSQL_OPT_RECONNECT=1");) option if you are MySQL. You can also Google for qt database Server has gone away.

[U7Development]

@JonB

I'm using MariaDB (MySQL) and did not know about that string.. i will try it.
MYSQL_OPT_RECONNECT (db.setConnectOptions("MYSQL_OPT_RECONNECT=1");)

Thanks.

[Pablo J. Rogina]

@U7Development said in Database is Open and is Valid but Server has gone away...:

try is to detect the string error and check it,

In addition to @JonB suggestion to use the reconnection setting, instead of checking the string you could check the error number (less error prone...) see this post