[Mod_log_sql] "db reconnect successful" errors

[Peter]

Sorry I have no more suggestions. There should be something in the 
preserve file for every error I would think at least there was for me.

Tim Gustafson wrote:
> No, the preserve file doesn't have anything in it.
> 
> Again, stuff is being logged to the database, so there's not a general query
> problem.
> 
> 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:44 AM
> To: General mod_log_sql discussion
> Subject: Re: [Mod_log_sql] "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 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
>>
>> _______________________________________________
>> 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