Hi, Looks to be a good idea. I use MySQL and MyISAM, so I understand that async is supported.
How should I dimension the number of async_workers? Regards, -- Adrien LEMOINE alemo...@legos.fr Tel : +33 1 75 85 00 11 Mob : +33 7 55 50 00 11 Fax : +33 1 75 85 00 01 Skype : pcman-vdh Local Exchange Global Operation Services - Legos.fr 40, rue d’Oradour sur Glane – 75015 Paris -----Message d'origine----- De : sr-users [mailto:sr-users-boun...@lists.sip-router.org] De la part de Daniel Tryba Envoyé : mardi 14 février 2017 12:08 À : Kamailio (SER) - Users Mailing List <sr-users@lists.sip-router.org> Objet : Re: [SR-Users] Lost of connection with MySQL? On Tue, Feb 14, 2017 at 09:54:42AM +0100, Igor Potjevlesch wrote: [mysql query fails] > These errors are repeated many times and cause Kamailio to hang and > don't reply to SIP requests. A reboot of Kamailio solves the issue. > > Anyone has already had this issue and had solved it? This is "normal" behavior. The source of your problem is mysql though. You might have locks or other performance killer at that moment running mysql. My experience is that it wasn't necessary to restart kamailio, once the mysqldb started responding again, calls would start to flow again. In some instances kamailio crashed on these locked queries. For acc there is a workaround is either to use async on mysql level: http://blog.miconda.eu/2014/10/kamailio-42-tips-8-asynchronous.html db_insert_mode 1 doesn't work with InnoDB backends. If you use InnoDB set the mode to 2 and enable atleast 1 async worker (async_workers=1) See: http://www.kamailio.org/docs/modules/4.3.x/modules/acc.html#acc.p.db_insert_mode _______________________________________________ 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
