[Mod_log_sql] "db reconnect successful" errors

Tim Gustafson tjg at soe.ucsc.edu
Tue Apr 22 14:36:36 EDT 2008


mySQL is configured for 250 connections right now, and there are usually
10-15 active connections.

I can't use the LogSQLMassVirtualHosting option for my installation because
of the way that we are logging and processing data.

This is not a table creation issue or a query error issue. (I checked
mySQL's query log.)  I think this might just be a "mod_log_sql needing to
reconnect" error, and maybe if that's the case, it shouldn't be logged
normally or something.

I was thinking that maybe it was mySQL's interactive timeout or wait timeout
setting, but my server is getting on average 2 hits/sec, and interactive
timeout and wait timeout are both set to 7200, so that's not it.

"mysqladmin processlist" shows 1 connection for each apache server process,
which is to be expected, and none of these have more than a few seconds of
idle ever.

Any other suggestions?

Tim Gustafson
SOE Webmaster
UC Santa Cruz
tjg at soe.ucsc.edu
(831) 459-5354


-----Original Message-----
From: mod_log_sql-bounces at lists.outoforder.cc
[mailto:mod_log_sql-bounces at lists.outoforder.cc] On Behalf Of Peter
Sent: Tuesday, April 22, 2008 11:30 AM
To: General mod_log_sql discussion
Subject: Re: [Mod_log_sql] "db reconnect successful" errors

Sorry I missed more to the solution.


I did considerable testing yesterday with this mod and have found a
solution. 1) I increased my allowed connections to mysql 2) I turned on
LogSQLMassVirtualHosting On

#2 seems to have fixed all of the connection errors as well as solving
the problem of manually creating tables for each host.

I have been running now for months without an error


Tim Gustafson wrote:
> Oh, and I should also say that "LogSQLCreateTables On" was already in my
> configuration.  :) 
> 
> Tim Gustafson
> SOE Webmaster
> UC Santa Cruz
> tjg at soe.ucsc.edu
> (831) 459-5354
> 
> 
> -----Original Message-----
> From: mod_log_sql-bounces at lists.outoforder.cc
> [mailto:mod_log_sql-bounces at lists.outoforder.cc] On Behalf Of Peter
> Sent: Tuesday, April 22, 2008 10:57 AM
> To: General mod_log_sql discussion
> Subject: Re: [Mod_log_sql] "db reconnect successful" errors
> 
> I recall having the same issue. There is an option to have mod_log_sql 
> create the tables.
> 
>> LogSQLCreateTables On
> 
> Try that then check for errors.
> 
> Cheers,
> Peter
> 
> Tim Gustafson wrote:
>> Hello,
>>
>> I'm getting zillions of these in my httpd error log:
>>
>> [Tue Apr 22 10:03:50 2008] [error] mysql_query returned (1)
>> [Tue Apr 22 10:03:50 2008] [notice] db reconnect successful
>>
>> I checked through the mailing list archives, and some noise was made
about
>> this error message a few years ago, but the messages said that the
problem
>> would be fixed.  I checked my SQL query log, and the queries that are
> being
>> issued for zero-byte requests are indeed being inserted with a '0'
instead
>> of a '-', so that's not it.
>>
>> I'm using Apache 2.2 on CentOS 5.1 with mod_log_sql 1.100, with mySQL
>> 5.0.22.
>>
>> Thanks for any advice you can give!
>>
>> Tim Gustafson
>> SOE Webmaster
>> UC Santa Cruz
>> tjg at soe.ucsc.edu
>> (831) 459-5354
>>
>>
>> _______________________________________________
>> Download the latest version at
> http://www.outoforder.cc/projects/apache/mod_log_sql/
>> To unsubscribe send an e-mail to 
>> mod_log_sql-unsubscribe at lists.outoforder.cc
> _______________________________________________
> Download the latest version at
> http://www.outoforder.cc/projects/apache/mod_log_sql/
> 
> To unsubscribe send an e-mail to 
> mod_log_sql-unsubscribe at lists.outoforder.cc
> 
> _______________________________________________
> Download the latest version at
http://www.outoforder.cc/projects/apache/mod_log_sql/
> 
> To unsubscribe send an e-mail to 
> mod_log_sql-unsubscribe at lists.outoforder.cc
_______________________________________________
Download the latest version at
http://www.outoforder.cc/projects/apache/mod_log_sql/

To unsubscribe send an e-mail to 
mod_log_sql-unsubscribe at lists.outoforder.cc




More information about the Mod_log_sql mailing list