[OpenSIPS-Users] db_mysql timeout

[Bogdan-Andrei Iancu]

Hi Jeff,

This is normal - mysql server is hanging up the TCP connections if there 
is no traffic. In such a case opensips will restart the connections.

The ping_interval is not used at all - it is simply leftover from the 
previous version (without statements).

Regards,
Bogdan

Jeff Pyle wrote:
> Hello,
>
> Each morning I face each Opensips child re_initing all its prepared
> statements as an INVITE hits it for the first time in a while.  I see logs
> like this:
>
>  INFO:db_mysql:db_mysql_submit_query: disconect event for 0x823fb54
>  INFO:db_mysql:reset_all_statements: reseting all statements on connection:
> (0x823fa90) 0x823fb54
>  INFO:db_mysql:db_mysql_submit_query: re-connected successful for 0x823fb54
>
> There are some for sip_trace and other DB operations as well.
>
> My only paramater for the db_mysql module is as follows:
>  modparam("db_mysql", "ping_interval", 180)
>
> It doesn't help.  Any thoughts?
>
>
>
> Thanks,
> Jeff
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro