[OpenSIPS-Users] SQL query

[Bogdan-Andrei Iancu]

Hi Denis,

As the messages say, they are just info, they are not indicating a 
problem. The Info is about a reconnect event to DB - as the FIFO process 
(doing the reload) is most of the time idle, the mysql server probably 
disconnects it, so it need to reconnects when a DB query must be done.

Nothing to worry.

Regards,
Bogdan

Denis Putyato wrote:
>
> Hello!
>
> Opensips 1.6.4-2, MySQL installed on the same server as opensips.
>
> Please can somebody explain why such message can appear in syslog? 
> This happens when I make “opensipsctl fifo dp_reload” after long 
> period of time nothing to do with opensips.
>
> During processing calls opensips make some SQL queries (there is no 
> problem with it).
>
> “Feb 3 16:17:33 opensips 
> /usr/local/opensips1.6.4-2/sbin/opensips[1355]: 
> INFO:db_mysql:switch_state_to_disconnected: disconnect event for 0x8078e0
>
> Feb 3 16:17:33 opensips 
> /usr/local/opensips1.6.4-2/sbin/opensips[1355]: 
> INFO:db_mysql:reset_all_statements: reseting all statements on 
> connection: (0x808bf0) 0x8078e0
>
> Feb 3 16:17:33 opensips 
> /usr/local/opensips1.6.4-2/sbin/opensips[1355]: 
> INFO:db_mysql:connect_with_retry: re-connected successful for 0x8078e0”
>
> Thank you for any help
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   


-- 
Bogdan-Andrei Iancu
OpenSIPS Event - expo, conf, social, bootcamp
2 - 4 February 2011, ITExpo, Miami,  USA
OpenSIPS solutions and "know-how"