MySQL server has gone away?

[prev] [thread] [next] [Date index for 2005/04/10]

Hi all,

I've been using Apache/mod_perl/MySQL combined with Apache::DBI for 
years, and it has been working like a charm. However, while preparing 
for a new release of the system I built, I'm getting this:

DBD::mysql::st execute failed: MySQL server has gone away at 
/opt/ttgp/dev/webapp/ttgp/smsclient/perl/sms line 111.

This happens after several hours of idle time in the webserver.

I'm doing the general thing: use Apache::DBI (); in my startup.pl, it 
just works, until now.

Three things are different:

- in a BEGIN block, I connect to the database, retrieve data, and then 
generate perl code on the fly;
- server is a slackware 10.1 box instead of a redhat 9 box;
- MySQL is 4.1.10a, compiled from source i.s.o. an rpm install.

Other than that, it's basically the same system I've used for years. 2 
daemons in the system that do other stuff keep working just fine, they 
open a db connection when they start, and do small queries every 5 to 
10 seconds. They don't loose the connection.

Anyone any ideas?

Thanks,

Bas.