Re: "db reconnect successful" errors

Do you see anything in the preserve file?

Maybe something here will help. Here are my setup entries.

http.config

LogSQLLoginInfo mysql://xxxxxx:xxxxxxx@localhost/apachelogs
LogSQLDBParam socketfile /var/run/mysqld/mysqld.sock
LogSQLCreateTables On
LogSQLMassVirtualHosting Off
LogSQLMachineID web01

vhost config

LogSQLTransferLogTable access_iwebsl_com
LogSQLScoreDomain iwebsl.com
LogSQLRequestIgnore .gif .jpg .jpeg .png .ico .css .js
LogSQLTransferLogFormat AabfHhIMmPRSsTtUuv

Tim Gustafson wrote:
> 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-Emgmuai4XwL2fBVCVOL8/[email protected]
> (831) 459-5354
> 
> 
> -----Original Message-----
> From: mod_log_sql-bounces-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org
> [mailto:mod_log_sql-bounces-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org] 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-Emgmuai4XwL2fBVCVOL8/[email protected]
>> (831) 459-5354
>>
>>
>> -----Original Message-----
>> From: mod_log_sql-bounces-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org
>> [mailto:mod_log_sql-bounces-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org] 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-Emgmuai4XwL2fBVCVOL8/[email protected]
>>> (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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org
>> _______________________________________________
>> 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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org
>>
>> _______________________________________________
>> 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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org
> _______________________________________________
> 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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org
> 
> _______________________________________________
> 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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org
_______________________________________________
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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org