[SR-Users] Lost of connection with MySQL?

[Igor Potjevlesch]

Hello Daniel,

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

Regards,

Igor.

-----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.
https://www.avast.com/antivirus