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.




Reply via email to