Hello, guys!
I use this configuration for quite a while and under a hard traffic:
Apache 1.3.29
mod_perl 1.29
mysql 4.0.3 (a rather old one)
for sometime I have this minor problem - each time I restart servers
there are few failures right after the restart. It's always "Lost
connection" error. As it's a hits counter I can live with it. After the
startup this problem never appears again.
But today I finally decided to explore what happens. Here is from my log
right immediatelly after restart:
(nnnnn) is child's pid, thread is $thread_id = $dbh->{mysql_thread_id}
[Thu May 27 08:10:33 2004] [error] reinit (11154) thread:133
[Thu May 27 08:10:33 2004] [error] reinit (11155) thread:133
[Thu May 27 08:10:33 2004] [error] reinit (11162) thread:133
[Thu May 27 08:10:33 2004] [error] reinit (11156) thread:134
[Thu May 27 08:10:33 2004] [error] reinit (11166) thread:136
[Thu May 27 08:10:33 2004] [error] ListTables: Lost connection to MySQL
server d
uring query
at /host/counter/lib/Counter/ShowCounter.pm line 204
[Thu May 27 08:10:33 2004] [error] reinit (11168) thread:137
[Thu May 27 08:10:33 2004] [error] reinit (11167) thread:142
[Thu May 27 08:10:33 2004] [error] reinit (11159) thread:135
[Thu May 27 08:10:33 2004] [error] reinit (11158) thread:139
[Thu May 27 08:10:33 2004] [error] reinit (11157) thread:140
[Thu May 27 08:10:33 2004] [error] reinit (11160) thread:144
[Thu May 27 08:10:33 2004] [error] reinit (11165) thread:146
[Thu May 27 08:10:33 2004] [error] SQL execute error: SELECT VERSION()
Lost connection to MySQL server during query
at /host/counter/lib/SQL/BuilderExt.pm line 147
[Thu May 27 08:10:33 2004] [error] server_version: could not determine
version
at /host/counter/lib/SQL/BuilderExt.pm line 147
See, in the very beginning - 3 child processes started and connected to
the same mysql thread_id
None of my processes ever disconnects, they all use Apache:DBI and
everything is checked to be correct.
Seems like it's mysql error in dispatching threads?
I scanned mysql changelog - nothing that would look like this was fixed
up to the current version.
I tried all kinds of adjusting from
StartServers => 15,
MinSpareServers => 5,
MaxSpareServers => 50,
to
StartServers => 0,
MinSpareServers => 0,
MaxSpareServers => 50,
But at least 2 childs always connect to the same thread.
Any ideas?
Thanks!
--
==================================
Mike Blazer
[EMAIL PROTECTED]
==================================
--
Report problems: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
List etiquette: http://perl.apache.org/maillist/email-etiquette.html
