> failed to execute " SELECT * FROM cluster_info WHERE cluster = ?": > MySQL server has gone away > > The error "MySQL server has gone away" is the error from the db handle. Can > anyone give me any pointers on why that happens? I looked up the > documentation in MySQL docs and the most common reason seems to be that it > happens if the query size is very large or if there is a timeout. None of > them seems to be a probable cause. The "max_allowed_packet" on the server > is 16 MB and as can be seen in the query above, the query is very small > and nowhere near the size limit. We also have a timeout setting > (wait_timeout) of 10 minutes and the above query for us cannot possibly > take that amount of time. In any case, given the same query, it executes > correctly 99% of time (so to speak). It fails intermittently with the > above error. What possibly could be the reason? I also looked at the max > connections on the server at that time (around ~80) and it is much less > than the limit we have (limit is 1000). How can I extract more information > when this happens? This error message sucks since it does not tell me what > exactly happened. The server version is 5.1.45.
Can you access the error log of the server? That can probably shed more light on the issue... -- Rik Wasmus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org