durusmail: quixote-users: MySQL server has gone away
MySQL server has gone away
2006-01-17
2006-01-18
2006-01-18
2006-01-19
2006-02-01
MySQL server has gone away
CarePrep
2006-01-18
We are not using scgi or session2 but have had similar issues with the MySQL
maxpacket size limitation.  In our case simply bumping the maxpacket size
limit resolved our problem.

This can be done either in the MySQL server configuration or remotely using
a query like:

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

Hope this helps.

Lee


>-----Original Message-----
>From: quixote-users-bounces@mems-exchange.org
>[mailto:quixote-users-bounces@mems-exchange.org] On Behalf Of Mike Orr
>Sent: Tuesday, January 17, 2006 1:40 PM
>To: quixote-users@mems-exchange.org
>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 
>(mso@oz.net address is semi-reliable)
>_______________________________________________
>Quixote-users mailing list
>Quixote-users@mems-exchange.org
>http://mail.mems-exchange.org/mailman/listinfo/quixote-users
>
>

reply