Devart Forums

Hello

I am executing a long (about 1-2 mins) query and it says at some point "Lost connection with MySQL server".
I am using MyDAC 5.10.0.10. CommandTimeout = 0. The connection is local network. A lot of people is working with this MySQL server so I guess it is not a problem of the server or of the application.

Can you please point me out what can the problem be?
I thought that this problem was solved in MyDAC 5.xx and as I understood it has to reissue the last query. Or am I doing sth wrong?

Thank you for the past help. And hope that you will be able to help me now too

Most likely this issue depends on MySQL server settings. Please see this topic of MySQL Reference Manual for more information.

GuzunNicolae wrote:I thought that this problem was solved in MyDAC 5.xx and as I understood it has to reissue the last query. Or am I doing sth wrong?

You are right, if a query failed to execute in Failover mode, MyDAC tries to reexecute it if it is possible.

Do I have to do sth special to run the query in Failover mode?

You should set the LocalFailover option of TMyConnection to True.

Thank you for the help
The problem was in the server wait_timeout set to 300.
Smb changed it w/o my knowledge. That's why I was sure it is not the server.