Hello all,
I have the following config: Apache 1.3.19 with mod_perl 1.25 and PHP4 built
statically into the server. I am using Perl DBI 1.14 and the MySql module 1.2215.
(Note: this problem also existed using apache 1.3.14 and mod_perl 1.24_1)
I have a CGI script that queries a table in MySQL, after executing the script X number
of times (sometime X=1, sometimes X=10, never consistent), I get this error in the
apache error log:
DBD::mysql::st execute failed: MySQL server has gone away at
/usr/local/apache/cgi-bin/query_results.cgi line 215.
Issuing rollback() for database handle being DESTROY'd without explicit disconnect()
at /usr/lib/perl5/site_perl/5.005/i586-linux/Ap
ache/Registry.pm line 144.
[Fri Mar 23 10:01:50 2001] [error] Fri Mar 23 10:01:44 2001: Can't execute query:
MySQL server has gone away
This also happens when I use scripts that talk to an Oracle database, on the same
sever.
I do not even know where to look: mod_perl, DBI, DBD, or Apache itself. There hasn't
been any new versions of DBI and DBD in a few months. The latest mod_perl and apache
upgrades did not fix the problem.
Anyone have any ideas where to look? I am leaning towards a problem with mod_perl,
maybe memory corruption, but thought I'd ask here.
All my perl scripts use 'strict'. Once this error occurs, regardless of how long I
wait, I am forced to bounce the apache server before the script will work again.
Thanks greatly for any help,
CC
p.s. Are there any mod_perl mailing lists or newsgroups out there?
