[Mod_log_sql] "db reconnect successful" errors

[Peter]

I found my original email to the list and the reply.

+++++++++++++++++++++++
> mysql server version: 5.0.32-Debian_7etch1-log
> MySQL client version: 5.0.32
> 
> Apache 2.2
> 
> It all seems to be working okay but there are a tremendous amount of
> connection errors occurring in my logs like the sample below. At the
> same time of course my mod_log_sql-preserve is filling up as well. I've
> tried changing my access_log table to MyISAM and InnoDB but it has not
> helped.
> 
> Any hints to fix this would be appreciated. 
> 
> [Sat Jul 14 19:46:02 2007] [error] mysql_query returned (1)
> [Sat Jul 14 19:46:02 2007] [notice] db reconnect successful
> [Sat Jul 14 19:46:02 2007] [error] mysql_query returned (1)
> [Sat Jul 14 19:46:02 2007] [error] second attempt failed

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Reply
> Try verifying that the SQL queries placed in mod_log_sql-preserve are
> actually valid SQL queries.  As when the [error] mysql_query returned
> (1) shows up in the log file that means a SQL error occurred (table not
> found, field not found, invalid SQL, etc...)
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




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