[SR-Users] Lost of connection with MySQL?

Igor Potjevlesch igor.potjevlesch at gmail.com
Thu Mar 2 09:52:42 CET 2017

Hello Daniel,

Thank you for your feedback. I will look deeper into the MySQL server.



-----Message d'origine-----
De : sr-users [mailto:sr-users-bounces at lists.sip-router.org] De la part de Daniel Tryba
Envoyé : mercredi 1 mars 2017 12:18
À : Kamailio (SER) - Users Mailing List <sr-users at lists.sip-router.org>
Objet : Re: [SR-Users] Lost of connection with MySQL?

On Wed, Mar 01, 2017 at 09:55:52AM +0100, Igor Potjevlesch wrote:
> Again this morning. It looks to be during the beginning of the peak. I don't have any idea where to search the issue. Any ideas?

The root cause has always been the mysqlserver in my case. I've seen the following jobs causing locks on tables:
-generating CDRs from acc (custom cron job) -mysqldumps

Kamailio complaining is just a symptom (unless kamailio itself is causing locking issues).

I'd start by generating dumps of "show full processlist" every 15s to see what is going on.

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users at lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.

More information about the sr-users mailing list