mysql server has gone away

Hi,

We are considering upgrading our production servers from using MySQL
3.23 to
MySQL 4.0 so I was asked to see how our scripts work with v4. I
installed v4 on
one of our test environments and immediately saw this:

DBD::mysql::st execute failed: MySQL server has gone away.

I googled it and read the suggestions in the MySQL documentation and
increased
the allowed packet size to max_allowed_packet = 256. This did not fix
it. Also, I
know that the connection isnt timing out.

Can someone please offer some advice on the matter, I am stumped. I
noticed that
if I set : $dbh->{mysql_auto_reconnect} = 1 in my code that the problem
appears
to go away, but I still dont know what the real problem was, or if this
auto_reconnect
setting is causing any harm.

Any input is much appreciated,

Thank you

M. Yogarajah


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org