I have a very strange problem. When executing a select query (that is correct, because it works in the MySQL Browser) instead of the result i get an error "MySql has gone away". Must say that the server works without problems.
- It happens only on one database.
- The server doesn't crash.
I noticed the big number at system status variable "Aborted_clients", but I can't explain what could be possibly wrong. I tried:
- To connect as a different user.
- To connect from a different client
Please, I need urgent help, because in the testing phase this never happened (onn the same server) and now that we use the application "live" this is a critical issue!
THis usually means some minor incompatibility between client dll and mysql server. Are ou using the 5.0.51 dll?
I have no explanation what the number of aborted clients concerns. It may very well be related.
At the moment we don't bundle the dll's anymore in the official releases. the general advise is to use the official dll's for the server release you're using.
To know what version you're using you can always use the ZConnection.ClientVersionStr property.