<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"Préformaté HTML Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.PrformatHTMLCar
{mso-style-name:"Préformaté HTML Car";
mso-style-priority:99;
mso-style-link:"Préformaté HTML";
font-family:Consolas;
color:black;
mso-fareast-language:EN-US;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Verdana",sans-serif;
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Verdana",sans-serif;
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Verdana",sans-serif;
color:#1F497D;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Verdana",sans-serif;
color:#1F497D;}
span.EmailStyle24
{mso-style-type:personal;
font-family:"Verdana",sans-serif;
color:windowtext;}
span.EmailStyle25
{mso-style-type:personal;
font-family:"Verdana",sans-serif;
color:#1F497D;}
span.EmailStyle26
{mso-style-type:personal;
font-family:"Verdana",sans-serif;
color:#1F497D;}
span.EmailStyle27
{mso-style-type:personal-reply;
font-family:"Verdana",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=white lang=FR link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Hello,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>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?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Regards,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Igor.<o:p></o:p></span></p><p class=MsoNormal><a name="_MailEndCompose"><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'><o:p> </o:p></span></a></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='color:windowtext;mso-fareast-language:FR'>De :</span></b><span style='color:windowtext;mso-fareast-language:FR'> Igor Potjevlesch [mailto:igor.potjevlesch@gmail.com] <br><b>Envoyé :</b> vendredi 24 février 2017 10:14<br><b>À :</b> miconda@gmail.com; 'Kamailio (SER) - Users Mailing List' <sr-users@lists.sip-router.org><br><b>Objet :</b> RE: [SR-Users] Lost of connection with MySQL?<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Hello,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Same issue this morning.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Feb 24 08:42:51 /usr/local/sbin/kamailio[25368]: 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)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Feb 24 08:42:51 /usr/local/sbin/kamailio[25368]: ERROR: db_mysql [km_dbase.c:149]: db_mysql_async_exec_task(): failed to execute query [insert into acc_2017_2 (method,from_tag,to_tag,callid,sip_code,sip_reason,time,src_user,username,src] on async worker<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Feb 24 08:42:51 /usr/local/sbin/kamailio[25299]: 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)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Feb 24 08:42:52 /usr/local/sbin/kamailio[25259]: 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)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Feb 24 08:42:52 /usr/local/sbin/kamailio[25275]: 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)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Feb 24 08:42:52 /usr/local/sbin/kamailio[25297]: 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)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Feb 24 08:42:52 /usr/local/sbin/kamailio[25287]: 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)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Feb 24 08:42:52 /usr/local/sbin/kamailio[25290]: 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)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>So, even the async process has failed. <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Could it be an issue on MySQL himself?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Regards,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Igor.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-GB style='color:windowtext;mso-fareast-language:FR'>De :</span></b><span lang=EN-GB style='color:windowtext;mso-fareast-language:FR'> Igor Potjevlesch [</span><span style='color:windowtext;mso-fareast-language:FR'><a href="mailto:igor.potjevlesch@gmail.com"><span lang=EN-GB>mailto:igor.potjevlesch@gmail.com</span></a></span><span lang=EN-GB style='color:windowtext;mso-fareast-language:FR'>] <br><b>Envoyé :</b> vendredi 17 février 2017 17:25<br><b>À :</b> </span><span style='color:windowtext;mso-fareast-language:FR'><a href="mailto:miconda@gmail.com"><span lang=EN-GB>miconda@gmail.com</span></a></span><span lang=EN-GB style='color:windowtext;mso-fareast-language:FR'>; 'Kamailio (SER) - Users Mailing List' <</span><span style='color:windowtext;mso-fareast-language:FR'><a href="mailto:sr-users@lists.sip-router.org"><span lang=EN-GB>sr-users@lists.sip-router.org</span></a></span><span lang=EN-GB style='color:windowtext;mso-fareast-language:FR'>><br><b>Objet :</b> RE: [SR-Users] Lost of connection with MySQL?<o:p></o:p></span></p></div></div><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Hello,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Thank you Daniel, and Daniel </span><span style='font-size:9.0pt;font-family:Wingdings;color:#1F497D'>J</span><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'> for your advises and analyse of this problem.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>I will also check if the DB replies before the timeout in db_mysql module.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Regards,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Igor.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-GB style='color:windowtext;mso-fareast-language:FR'>De :</span></b><span lang=EN-GB style='color:windowtext;mso-fareast-language:FR'> Daniel-Constantin Mierla [</span><span style='color:windowtext;mso-fareast-language:FR'><a href="mailto:miconda@gmail.com"><span lang=EN-GB>mailto:miconda@gmail.com</span></a></span><span lang=EN-GB style='color:windowtext;mso-fareast-language:FR'>] <br><b>Envoyé :</b> vendredi 17 février 2017 08:10<br><b>À :</b> Igor Potjevlesch <</span><span style='color:windowtext;mso-fareast-language:FR'><a href="mailto:igor.potjevlesch@gmail.com"><span lang=EN-GB>igor.potjevlesch@gmail.com</span></a></span><span lang=EN-GB style='color:windowtext;mso-fareast-language:FR'>>; 'Kamailio (SER) - Users Mailing List' <</span><span style='color:windowtext;mso-fareast-language:FR'><a href="mailto:sr-users@lists.sip-router.org"><span lang=EN-GB>sr-users@lists.sip-router.org</span></a></span><span lang=EN-GB style='color:windowtext;mso-fareast-language:FR'>><br><b>Objet :</b> Re: [SR-Users] Lost of connection with MySQL?<o:p></o:p></span></p></div></div><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p><p>Hello,<o:p></o:p></p><p>as I said, if the execution if the query takes too long, then async mode doesn't really solve the problem completely -- the record will not be stored in db because the client library will cancel the query due to execution timeout. However, the async mode ensures that the sip traffic is routed, so at least you solve the sip signaling problems.<o:p></o:p></p><p>A complete solution is async mode for accounting together and fixing the database to do the queries under the timeout value you set to db_mysql module.<o:p></o:p></p><p>Cheers,<br>Daniel<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>On 16/02/2017 12:16, Igor Potjevlesch wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Hello,</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Indeed, I think there are some DB access external of kamailio.cfg.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>If accounting process is implied in the freeze of SIP handling, and if aysnc accounting can solve this, it's my priority. Even if accounting fails due to the timeout you reminded.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Regards,</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Igor.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'> </span><o:p></o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='color:windowtext;mso-fareast-language:FR'>De :</span></b><span style='color:windowtext;mso-fareast-language:FR'> Daniel-Constantin Mierla [<a href="mailto:miconda@gmail.com">mailto:miconda@gmail.com</a>] <br><b>Envoyé :</b> mercredi 15 février 2017 08:57<br><b>À :</b> Igor Potjevlesch <a href="mailto:igor.potjevlesch@gmail.com"><igor.potjevlesch@gmail.com></a>; 'Kamailio (SER) - Users Mailing List' <a href="mailto:sr-users@lists.sip-router.org"><sr-users@lists.sip-router.org></a><br><b>Objet :</b> Re: [SR-Users] Lost of connection with MySQL?</span><o:p></o:p></p></div></div><p class=MsoNormal> <o:p></o:p></p><p>Hello,<o:p></o:p></p><p>it doesn't have to be from kamailio.cfg, but any query from external tools, like cron jobs, billing applications, etc ...<o:p></o:p></p><p>Can you measure how long it takes to do a query from the command line? Just try to select the records by a call-id.<o:p></o:p></p><p>Also, there are some core parameters that will print log messages in case of slow queries/actions, see the core cookbook.<o:p></o:p></p><p>Moreover, the db_mysql module has some parameters to tune the timeouts.<o:p></o:p></p><p>Cheers,<br>Daniel<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><div><p class=MsoNormal>On 14/02/2017 14:22, Igor Potjevlesch wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Hello,</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>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.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>The structure is: id as primary and callid is an index.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Regards,</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Igor.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'> </span><o:p></o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='color:windowtext;mso-fareast-language:FR'>De :</span></b><span style='color:windowtext;mso-fareast-language:FR'> Daniel-Constantin Mierla [<a href="mailto:miconda@gmail.com">mailto:miconda@gmail.com</a>] <br><b>Envoyé :</b> mardi 14 février 2017 12:06<br><b>À :</b> Igor Potjevlesch <a href="mailto:igor.potjevlesch@gmail.com"><igor.potjevlesch@gmail.com></a>; 'Kamailio (SER) - Users Mailing List' <a href="mailto:sr-users@lists.sip-router.org"><sr-users@lists.sip-router.org></a><br><b>Objet :</b> Re: [SR-Users] Lost of connection with MySQL?</span><o:p></o:p></p></div></div><p class=MsoNormal> <o:p></o:p></p><p>Hello,<o:p></o:p></p><p>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?<o:p></o:p></p><p>Have you created other constraints (e.g., unique keys) over the table?<o:p></o:p></p><p>Cheers,<br>Daniel<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><div><p class=MsoNormal>On 14/02/2017 11:51, Igor Potjevlesch wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Hello Daniel,</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Actually 9 031 181.<br><br>Regards,</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'>Igor.</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1F497D'> </span><o:p></o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='color:windowtext;mso-fareast-language:FR'>De :</span></b><span style='color:windowtext;mso-fareast-language:FR'> sr-users [<a href="mailto:sr-users-bounces@lists.sip-router.org">mailto:sr-users-bounces@lists.sip-router.org</a>] <b>De la part de</b> Daniel-Constantin Mierla<br><b>Envoyé :</b> mardi 14 février 2017 10:57<br><b>À :</b> Kamailio (SER) - Users Mailing List <a href="mailto:sr-users@lists.sip-router.org"><sr-users@lists.sip-router.org></a><br><b>Objet :</b> Re: [SR-Users] Lost of connection with MySQL?</span><o:p></o:p></p></div></div><p class=MsoNormal> <o:p></o:p></p><div><p class=MsoNormal>Hello,<br><br>do you have a lot of records inside the acc table?<br><br>Cheers,<br>Daniel<br><br>On 14/02/2017 09:54, Igor Potjevlesch wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif'>Hello,</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana",sans-serif'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif'>Two times in the last week, Kamailio reports MySQL errors like these:</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif'>/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)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif'>/usr/local/sbin/kamailio[19225]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif'>/usr/local/sbin/kamailio[19225]: ERROR: acc [acc.c:504]: acc_db_request(): failed to insert into database</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif'>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.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif'>Anyone has already had this issue and had solved it?</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif'>Regards,</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;font-family:"Verdana",sans-serif'>Igor.</span><o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt'> </span><o:p></o:p></p><div class=MsoNormal align=center style='text-align:center'><span style='font-size:12.0pt'><hr size=1 width="99%" noshade style='color:#909090' align=center></span></div><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 style='border-collapse:collapse'><tr><td style='padding:0cm 11.25pt 0cm 6.0pt'><p class=MsoNormal><span style='font-size:12.0pt'><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient"><span style='text-decoration:none'><img border=0 id="_x0000_i1026" src="http://static.avast.com/emails/avast-mail-stamp.png" alt="Avast
logo"></span></a></span><o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p><span style='font-family:"Calibri",sans-serif;color:#3D4D5A'>L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast. <br><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient">www.avast.com</a> </span><o:p></o:p></p></td></tr></table><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt'><br><br><br><br><br></span><o:p></o:p></p><pre>_______________________________________________<o:p></o:p></pre><pre>SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<o:p></o:p></pre><pre><a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><o:p></o:p></pre><pre><a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><o:p></o:p></pre></blockquote><p> <o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt'><br><br><br></span><o:p></o:p></p><pre>-- <o:p></o:p></pre><pre>Daniel-Constantin Mierla<o:p></o:p></pre><pre><a href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a><o:p></o:p></pre><pre>Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) - <a href="http://www.asipto.com">www.asipto.com</a><o:p></o:p></pre><pre>Kamailio World Conference - May 8-10, 2017 - <a href="http://www.kamailioworld.com">www.kamailioworld.com</a><o:p></o:p></pre><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt'> </span><o:p></o:p></p><div class=MsoNormal align=center style='text-align:center'><span style='font-size:12.0pt'><hr size=1 width="99%" noshade style='color:#909090' align=center></span></div><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 style='border-collapse:collapse'><tr><td style='padding:0cm 11.25pt 0cm 6.0pt'><p class=MsoNormal><span style='font-size:12.0pt'><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient"><span style='text-decoration:none'><img border=0 id="_x0000_i1028" src="http://static.avast.com/emails/avast-mail-stamp.png" alt="Avast logo"></span></a></span><o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p><span style='font-family:"Calibri",sans-serif;color:#3D4D5A'>L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast. <br><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient">www.avast.com</a> </span><o:p></o:p></p></td></tr></table><p class=MsoNormal><span style='font-size:12.0pt'> </span><o:p></o:p></p></blockquote><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt'><br><br></span><o:p></o:p></p><pre>-- <o:p></o:p></pre><pre>Daniel-Constantin Mierla<o:p></o:p></pre><pre><a href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a><o:p></o:p></pre><pre>Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) - <a href="http://www.asipto.com">www.asipto.com</a><o:p></o:p></pre><pre>Kamailio World Conference - May 8-10, 2017 - <a href="http://www.kamailioworld.com">www.kamailioworld.com</a><o:p></o:p></pre><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt'> </span><o:p></o:p></p><div class=MsoNormal align=center style='text-align:center'><span style='font-size:12.0pt'><hr size=1 width="99%" noshade style='color:#909090' align=center></span></div><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 style='border-collapse:collapse'><tr><td style='padding:0cm 11.25pt 0cm 6.0pt'><p class=MsoNormal><span style='font-size:12.0pt'><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient"><span style='text-decoration:none'><img border=0 id="_x0000_i1030" src="http://static.avast.com/emails/avast-mail-stamp.png" alt="Avast logo"></span></a></span><o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p><span style='font-family:"Calibri",sans-serif;color:#3D4D5A'>L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast. <br><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient">www.avast.com</a> </span><o:p></o:p></p></td></tr></table><p class=MsoNormal><span style='font-size:12.0pt'> </span><o:p></o:p></p></blockquote><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><pre>-- <o:p></o:p></pre><pre>Daniel-Constantin Mierla<o:p></o:p></pre><pre><a href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a><o:p></o:p></pre><pre>Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) - <a href="http://www.asipto.com">www.asipto.com</a><o:p></o:p></pre><pre>Kamailio World Conference - May 8-10, 2017 - <a href="http://www.kamailioworld.com">www.kamailioworld.com</a><o:p></o:p></pre><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:FR'><o:p> </o:p></span></p><div class=MsoNormal align=center style='text-align:center'><span style='font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:FR'><hr size=1 width="99%" noshade style='color:#909090' align=center></span></div><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 style='border-collapse:collapse'><tr><td style='padding:0cm 11.25pt 0cm 6.0pt'><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:FR'><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient"><span style='text-decoration:none'><img border=0 id="_x0000_i1032" src="http://static.avast.com/emails/avast-mail-stamp.png" alt="Avast logo"></span></a><o:p></o:p></span></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p><span style='font-family:"Calibri",sans-serif;color:#3D4D5A'>L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast. <br><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient">www.avast.com</a> <o:p></o:p></span></p></td></tr></table><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:FR'><o:p> </o:p></span></p></blockquote><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:FR'><o:p> </o:p></span></p><pre>-- <o:p></o:p></pre><pre>Daniel-Constantin Mierla<o:p></o:p></pre><pre><a href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a><o:p></o:p></pre><pre>Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) - <a href="http://www.asipto.com">www.asipto.com</a><o:p></o:p></pre><pre>Kamailio World Conference - May 8-10, 2017 - <a href="http://www.kamailioworld.com">www.kamailioworld.com</a><o:p></o:p></pre><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:windowtext;mso-fareast-language:FR'><o:p> </o:p></span></p><div class=MsoNormal align=center style='text-align:center'><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:windowtext;mso-fareast-language:FR'><hr size=1 width="99%" noshade style='color:#909090' align=center></span></div><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 style='border-collapse:collapse'><tr><td style='padding:0cm 11.25pt 0cm 6.0pt'><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:windowtext;mso-fareast-language:FR'><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient"><span style='text-decoration:none'><img border=0 id="_x0000_i1034" src="http://static.avast.com/emails/avast-mail-stamp.png" alt="Avast logo"></span></a><o:p></o:p></span></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p><span style='font-family:"Calibri",sans-serif;color:#3D4D5A'>L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast. <br><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient">www.avast.com</a> <o:p></o:p></span></p></td></tr></table><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:windowtext;mso-fareast-language:FR'><o:p> </o:p></span></p><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:windowtext;mso-fareast-language:FR'><o:p> </o:p></span></p><div class=MsoNormal align=center style='text-align:center'><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:windowtext;mso-fareast-language:FR'><hr size=1 width="99%" noshade style='color:#909090' align=center></span></div><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 style='border-collapse:collapse'><tr><td style='padding:0cm 11.25pt 0cm 6.0pt'><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:windowtext;mso-fareast-language:FR'><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient"><span style='text-decoration:none'><img border=0 id="_x0000_i1036" src="http://static.avast.com/emails/avast-mail-stamp.png" alt="Avast logo"></span></a><o:p></o:p></span></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p><span style='font-family:"Calibri",sans-serif;color:#3D4D5A'>L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast. <br><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient">www.avast.com</a> <o:p></o:p></span></p></td></tr></table><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:windowtext;mso-fareast-language:FR'><o:p> </o:p></span></p></div>
<br /><br />
<hr style='border:none; color:#909090; background-color:#B0B0B0; height: 1px; width: 99%;' />
<table style='border-collapse:collapse;border:none;'>
<tr>
<td style='border:none;padding:0px 15px 0px 8px'>
<a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient">
<img border=0 src="http://static.avast.com/emails/avast-mail-stamp.png" alt="Avast logo" />
</a>
</td>
<td>
<p style='color:#3d4d5a; font-family:"Calibri","Verdana","Arial","Helvetica"; font-size:12pt;'>
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
<br><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient">www.avast.com</a>
</p>
</td>
</tr>
</table>
<br />
</body></html>