[Users] Mysql connection timeout issue

Bogdan-Andrei Iancu bogdan at voice-system.ro
Sat Jan 28 14:53:40 CET 2006


Hi guys,

are you using the latest version from CVS (from 1.0.0 or head) - there 
was a recent fix about mysql re-connection.

regards,
bogdan

Bastian Schern wrote:

> Marcello Lupo schrieb:
>
>> Hi to all,
>> i'm experiencing strange behavior and want to ask a clue.
>> After some time of inactivity (around 15 hour more or less) or few 
>> activity on my Openser i start getting message in my logs:
>>
>> submit_query: MySQL server has gone away
>> db_query: Error while submitting query
>> is_local(): Error while querying database
>>
>
> I really have the same error. But I feel that the error will occur 
> after a random time. But I'm not sure.
>
>
>> and obviously openser is no more working. I have to restart openser 
>> to have reopened the connection.
>> I'm using mysql 5.0.15-max and was thinking on the wait_timeout or 
>> interactive_timeout variables in mysql that by default are at 28800 
>> (8 hour).
>> I raised both variables to 1000000 but still getting the problem.
>> Did you have any ideas?
>
>
> I'm also using MySQL 5 (mysql 5.0.18-max). Could this be the reason?
>
>
> Regards
>     Bastian
>
> ____________
> Virus checked by G DATA AntiVirusKit
> Version: AVK 16.5138 from 28.01.2006
> Virus news: www.antiviruslab.com
>
>
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>





More information about the Users mailing list