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-boun...@lists.sip-router.org] De la part de Daniel Tryba Envoyé : mercredi 1 mars 2017 12:18 À : Kamailio (SER) - Users Mailing List <sr-users@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@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 _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
