Server gone away after a select query

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
zippo
Silver Boarder
Silver Boarder
Posts: 322
Joined: 12.10.2005, 18:01
Location: Slovenia

Server gone away after a select query

Post by zippo »

Hi!

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!

BDS2006,
MySQL 5.0.51 on Linux
Zeos 6.5.x
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

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.

Mark
Image
zippo
Silver Boarder
Silver Boarder
Posts: 322
Joined: 12.10.2005, 18:01
Location: Slovenia

Post by zippo »

Found the bug.. It was a communication problem. Our client got a very unstable line and strange things happened.

Thanx!
zippo
Silver Boarder
Silver Boarder
Posts: 322
Joined: 12.10.2005, 18:01
Location: Slovenia

Post by zippo »

Jost for curiosity - how you know what version of the DLL ar you using..? I use the Zeos bundled mysql5.dll
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

Hi zippo,

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.

Mark
Image
Post Reply