[Mod_log_sql] "db reconnect successful" errors

[Peter]

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