'MySQL server has gone away'
Can be a network problem,
Just to increase complexity :)
On May 26, 2011 11:03 PM, "Prabhat Kumar" <aim.prabhat@stripped> wrote:
> I had experience with such type of error, It was due lack of resources
> available to MySql, max connections exceeds on the server.
> you can write a simple script which will grab and store output of 'show
> processlist' every min. and later you cna investigate the issue.
> On Wed, May 25, 2011 at 3:34 AM, Aveek Misra <aveekm@stripped> wrote:
>> Nothing in the error log or the slow query log that suggests that the
>> size is too large or us taking too much time to execute.
>> On May 25, 2011, at 3:53 PM, Rik Wasmus wrote:
>> >> 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
>> >> 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
>> >> happens if the query size is very large or if there is a timeout. None
>> >> them seems to be a probable cause. The "max_allowed_packet" on the
>> >> is 16 MB and as can be seen in the query above, the query is very
>> >> and nowhere near the size limit. We also have a timeout setting
>> >> (wait_timeout) of 10 minutes and the above query for us cannot
>> >> take that amount of time. In any case, given the same query, it
>> >> 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
>> >> connections on the server at that time (around ~80) and it is much
>> >> than the limit we have (limit is 1000). How can I extract more
>> >> when this happens? This error message sucks since it does not tell me
>> >> exactly happened. The server version is 5.1.45.
>> > Can you access the error log of the server? That can probably shed more
>> > on the issue...
>> > --
>> > Rik Wasmus
>> > --
>> > MySQL General Mailing List
>> > For list archives: http://lists.mysql.com/mysql
>> > To unsubscribe:
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
> Best Regards,
> Prabhat Kumar
> MySQL DBA
> My Blog: http://adminlinux.blogspot.com
> My LinkedIn: http://www.linkedin.com/in/profileprabhat