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.
