RE: MySQL server has gone away

We've had a similar problem using MySQL 4 due to exceeding the max_packet
size for a result set.  I have not experienced a timeout or MySQL server
restart causing this issue yet though.  In our case simply increasing the
MySQL servers max_packet size setting resolved our issue.  This can be done
either in the MySQL server's configuration or using a query to the server on
a priviledged account.  The query would be something like:

    db.query('SET GLOBAL max_allowed_packet=%s' % maxpacket)

Hope that helps,

Lee McAllister, Developer
www.mcomi.com | vc 250.380.2006 | fx 250.380.2008
	
 	
 

>-----Original Message-----
>From: [email protected] 
>[mailto:[email protected]] On Behalf Of Mike Orr
>Sent: Tuesday, January 17, 2006 1:40 PM
>To: [email protected]
>Subject: [Quixote-users] MySQL server has gone away
>
>I moved my Quixote applications to a new Linux server and upgraded to
>MySQL 5, and suddenly now things hang up sometimes with 'MySQL server
>has gone away' exceptions.  The MySQL manual suggests several possible
>reasons (timeout on client thread, large query size/result size, MySQL
>server restarting itself), but I was wondering whether anyone else is
>getting this in a Quixote context, especially with session2.  Using
>Quixote 2.4, scgi 1.9, session2 0.6, Apache 2.0.54, MySQL 5.0.16,
>Linux Gentoo 2005.1.
>
>The MySQL server is responding fine; I just have to restart the
>Quixote application.  But MySQL shows three idle connections from
>Quixote sleeping.  Is something in Quixote or session2 using
>persistent connections?
>
>--
>Mike Orr <[email protected]>
>([email protected] address is semi-reliable)
>_______________________________________________
>Quixote-users mailing list
>[email protected]
>http://mail.mems-exchange.org/mailman/listinfo/quixote-users
>
>