Well, I tried increasing the max packet size, but all that did was decrease the frequency of the problem appearing. I increased it from 1MB to 8MB. Think that was enough?
By the way, I think the code is using Apache::DBD. I'm a sys admin, not a very good perl programmer. ;) Still, I can restart apache and it fixes the problem. Thanks, Chris Miller Compuville www.compuville.net -----Original Message----- From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 10:55 AM To: 'Andrew Green' Cc: [EMAIL PROTECTED] Subject: RE: "MySQL server has gone away" Think I should up the max packet size?? Thanks, Chris Miller Compuville www.compuville.net -----Original Message----- From: Andrew Green [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 10:55 AM To: Chris Miller Cc: [EMAIL PROTECTED] Subject: Re: "MySQL server has gone away" On Thu, 18 Mar 2004 10:23:42 -0500, Chris Miller wrote: > DBD::mysql::st execute failed: MySQL server has gone away at > /usr/local/lib/perl/5.6.1/Mysql.pm line 175. I was bitten by this once when trying to write records to the MySQL server that were bigger than the server's configured maximum packet size -- the MySQL server would simply drop the connection, prompting DBI to give that error. I imagine that if you're using Apache::DBI, restarting Apache would appear to fix the connection, leading you to suspect a mod_perl problem. Cheers, Andrew. -- :: article seven Andrew Green automatic internet [EMAIL PROTECTED] | www.article7.co.uk -- Report problems: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html List etiquette: http://perl.apache.org/maillist/email-etiquette.html -- Report problems: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html List etiquette: http://perl.apache.org/maillist/email-etiquette.html
