Re: [SR-Users] Lost of connection with MySQL?

Hello, There is only queries on a replication server, so not the one reported in the errors, to make some fraud detections. But, directly from Kamailio config file, there's no queries. The structure is: id as primary and callid is an index. Regards, Igor. *De :*Daniel-Constantin Mierla [mailto:miconda@gmail.com] *Envoyé :* mardi 14 février 2017 12:06 *À :* Igor Potjevlesch &lt;igor.potjevlesch(a)gmail.com&gt;om>; 'Kamailio (SER) - Users Mailing List' &lt;sr-users(a)lists.sip-router.org&gt; *Objet :* Re: [SR-Users] Lost of connection with MySQL? Hello, it is a lot if you have over 9 million records. Do you run other periodical queries over acc, like generating full cdrs every N minutes? Have you created other constraints (e.g., unique keys) over the table? Cheers, Daniel On 14/02/2017 11:51, Igor Potjevlesch wrote: Hello Daniel, Actually 9 031 181. Regards, Igor. *De :*sr-users [mailto:sr-users-bounces@lists.sip-router.org] *De la part de* Daniel-Constantin Mierla *Envoyé :* mardi 14 février 2017 10:57 *À :* Kamailio (SER) - Users Mailing List &lt;sr-users(a)lists.sip-router.org&gt; <mailto:sr-users@lists.sip-router.org> *Objet :* Re: [SR-Users] Lost of connection with MySQL? Hello, do you have a lot of records inside the acc table? Cheers, Daniel On 14/02/2017 09:54, Igor Potjevlesch wrote: Hello, Two times in the last week, Kamailio reports MySQL errors like these: /usr/local/sbin/kamailio[19225]: ERROR: db_mysql [km_dbase.c:126]: db_mysql_submit_query(): driver error on query: Can't connect to MySQL server on '192.168.2.6' (4) (2003) /usr/local/sbin/kamailio[19225]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query /usr/local/sbin/kamailio[19225]: ERROR: acc [acc.c:504]: acc_db_request(): failed to insert into database 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? Regards, Igor. ------------------------------------------------------------------------ Avast logo <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org <mailto:sr-users@lists.sip-router.org> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users -- Daniel-Constantin Mierla www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda> Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) - www.asipto.com <http://www.asipto.com> Kamailio World Conference - May 8-10, 2017 - www.kamailioworld.com <http://www.kamailioworld.com> ------------------------------------------------------------------------ Avast logo <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> -- Daniel-Constantin Mierla www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda> Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) - www.asipto.com <http://www.asipto.com> Kamailio World Conference - May 8-10, 2017 - www.kamailioworld.com <http://www.kamailioworld.com> ------------------------------------------------------------------------ Avast logo <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>