"MySQL server has gone away" error message
Brought to you by:
whity
Menu
▾
▴
First of all, the set:
I use C++Builder 6 with Zeos 5.4 and DirectSQL to access a MySQL 3.23.52 database on a remote RedHat Linux machine and on a local WinXP(test machine).
One of the tables has a blob field (containing an image). When uploading a large image to the DB I would get the above error.
Reading about its possible causes, I have increased the MySQL "max_allowed_packet" parameter, but this solved the problem ONLY for the localhost database ?!?!
For the remote DB, if the query(blob field) exceeds something around 17kb (compressed data!), it fails.
I have disabled the usage of Direct SQL code and used the Zeos library with the supplied "libmySQL.dll" and the problem disappeared (even with 2MB data)!!!
So, it should be a problem of Direct SQL!
I can supply additional information, if necessary!
The increase in speed when using DirectSQL is obvious, so I hope this bug(?!?!) could be fixed!
Any ideas?
This is a known problem and there has been a fix issued for it:
http://sourceforge.net/forum/forum.php?forum_id=206198
Regards,
Cristian Nicola
Great!
I did not check the NEWS section, otherwise I would not have posted the message.
Thanks!
Regards,
Dragos Dobrota