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@lists.sip-router.org] De la part de Daniel Tryba
Envoyé : mercredi 1 mars 2017 12:18
À : Kamailio (SER) - Users Mailing List <sr-users(a)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(a)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