DB connection problem

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

DB connection problem

Woody Dickson
Hi,

After I have opensips left idle for a couple of days, I am getting the following error:

Dec 15 14:14:22 localhost openser-1.2.0-ul[4195]: ERROR:core:db_do_query: error while submitting query
Dec 15 14:14:22 localhost openser-1.2.0-ul[4195]: ERROR:domain:is_domain_local: Error while querying database
Dec 15 14:14:29 localhost openser-1.2.0-ul[4197]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Lost connection to MySQL server at 'reading initial communication

Does anyone know what could be causing this problem?

Thanks,
Woody

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: DB connection problem

Bogdan-Andrei Iancu
Hi Woody,

If the connection to mysql server is not used for some time, the
connection is closed, so there is the need to reconnect to the mysql
server (on the fly).
Did you opensips recovered (like connection t mysql) after the first query ?

Regards,
Bogdan

Woody Dickson wrote:

> Hi,
>
> After I have opensips left idle for a couple of days, I am getting the
> following error:
>
> Dec 15 14:14:22 localhost openser-1.2.0-ul[4195]:
> ERROR:core:db_do_query: error while submitting query
> Dec 15 14:14:22 localhost openser-1.2.0-ul[4195]:
> ERROR:domain:is_domain_local: Error while querying database
> Dec 15 14:14:29 localhost openser-1.2.0-ul[4197]:
> ERROR:db_mysql:db_mysql_submit_query: driver error on query: Lost
> connection to MySQL server at 'reading initial communication
>
> Does anyone know what could be causing this problem?
>
> Thanks,
> Woody
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>  


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users