On 23 Mar 2001, at 10:10, Perl-DBI Mailing List wrote:
> 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
Umm... the only time I really got that error was when mysql really
went away :) ... it's been a long time since I've seen it. I program
using mod_perl and all the work is always done in modules ...
when a cgi script is used it is only used to route to the proper
module.
You say it happens with Oracle as well. I would look at your script.
Perhaps you are disconnecting instead of finishing and then trying
to connect again ... Are you using Apache::DBI ?
> p.s. Are there any mod_perl mailing lists or newsgroups out there?
mod_perl here:
http://perl.apache.org/
Here is a great guide to mod_perl:
http://perl.apache.org/guide/index.html
Mailing lists and info:
http://perl.apache.org/#maillists
Peter
ps very active and helpful mod_perl list see above
---------------------------
"Reality is that which, when you stop believing in it, doesn't go
away".
-- Philip K. Dick
