[OpenSIPS-Users] 100% CPU on MySQL connection lost

[Bogdan-Andrei Iancu]

And what are the king of errors/warnings/logs (if any) from the db_mysql 
module when trying to do quires (while table is locked) - just to see 
how opensips "sees" the DB.

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com


On 12/10/2012 08:53 PM, Adam Raszynski wrote:
> MySQL server is running all the time. I think that while making 
> backups tables are blocked by LOCK TABLES statement
>
>
> 2012/12/10 Bogdan-Andrei Iancu <bogdan at opensips.org 
> <mailto:bogdan at opensips.org>>
>
>     Hi Adam,
>
>     What exactly is the "experience" of OpenSIPs in regards to DB? DB
>     simply blocks, so whatever query is pushed to DB, opensips will
>     block in waiting ?
>
>     Or the DB disconnescts opensips's connections ?
>
>     You mentioned both, locking up and reconnect :)
>
>     Regards,
>
>     Bogdan-Andrei Iancu
>     OpenSIPS Founder and Developer
>     http://www.opensips-solutions.com
>
>
>     On 12/10/2012 05:00 PM, Adam Raszynski wrote:
>>     Hi
>>
>>     Tried versions: 1.7.2 and 1.8
>>
>>     I have problem with OpenSIPS taking 100% CPU while trying to
>>     reconnect on MySQL connection lost.
>>
>>     I make database backups every night and then for about 15 minutes
>>     database is locked during backup procedure to prevent data
>>     corruption.
>>
>>     I understand that OpenSIPS is trying to do it's best to reconnect
>>     to database, but how to decrease reconnect interval or make it
>>     less CPU intensive?
>>
>>     Regards
>>
>>
>>     _______________________________________________
>>     Users mailing list
>>     Users at lists.opensips.org  <mailto:Users at lists.opensips.org>
>>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121211/a74a148c/attachment.htm>