MySQL: A reconnect after "Server has gone away" error

[hubblec4]

Hi everyone

I have an issue with the SQLConnection. Sometimes i get this "... gone away"-error.

My aim is it to handle this error with an automaticly reconnect to the Sql-server.

The error is not caused by a timeout! (there are many stuff for this topic but no information for an reconnect)

I use the SQL_Library_Loader, SQLConnector, SQLTransaction, SQLQuery and a DataSource.


I found a public property at the SQLConnector

"SQLConnector.ConnOptions" how i can use this property, which options i can set?


hubble

[hubblec4]

When i try SQLConnector.connected:=false i get the same "...gone away"-error.
There is no chance for a reconnect to the SQL-DB. only when i restart my programm.

Or anyone knows how to do that?

[LacaK]

Try use SQLConnector.Close(True);
or
SQLConnector.Proxy.Close(True);

Parameter "ForceClose" = True

[hubblec4]

ok i will try it.

EDIT: SQL.Connectore.Close(True) dont work, you get the same "gone away -error", cause allways a rollback is attempted.

But we talked in the german forum and we found the bug. (http://www.lazarusforum.de/viewtopic.php?f=17&t=7953)

http://bugs.freepascal.org/view.php?id=26505

[LacaK]

Can you post here any compilable simple application which will show error ?

[hubblec4]

Can you post here any compilable simple application which will show error ?

Sorry not really. I can't extract der Fail-procedure to a simple application.

[Michl]

I can. Please read the bug tracker entry first. With the one of the last patchs it is possible to execute the two buttonclicks in the .exe. You have to copy "libmysql.dll" in your project order.

I use MySQL 5.6 if you use a other version, you have to change the Connection (with the name Connection!). Parameters are written in the private section of TForm1 and setted in TForm1.FormCreate.