[Users] Mysql connection timeout issue

Bogdan-Andrei Iancu bogdan at voice-system.ro
Sat Jan 28 15:31:23 CET 2006


Hi,

yes, on CVS there are couple of bug fixes applied. Please try using 
either the CVS or the latest 1.0.0 snapshot.

regards,
bogdan

Bastian Schern wrote:

> I'm using OpenSER from this tar.gz:
> http://openser.org/pub/openser/1.0.0/src/openser-1.0.0-tls_src.tar.gz
>
> Is there a difference between this package and CVS rel_1_0_0 sip-server?
>
> Regards
>     Bastian
>
> Bogdan-Andrei Iancu schrieb:
>
>> 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
>
>





More information about the sr-users mailing list