<div dir="ltr"><div>I don't have any ideas for this particular issue other than general db connection troubleshooting tips.<br></div><div><br>Are you using SQLite or odbc w/ mysql or postgresql? Are database handles being released? Is a new long / inefficient query consuming all your connections? Does the issue go away if you disable mod_xml_rpc? Find out these things to troubleshoot your issue.<br><br></div>Also- I noticed you are running an old version of FS based on the line numbers in your logs, so your likelihood of getting free support is not good.<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Dec 3, 2014 at 11:03 AM, Andri Hadjiefstathiou [IronFX Global] <span dir="ltr"><<a href="mailto:AHadjiefstathiou@ironfx.com" target="_blank">AHadjiefstathiou@ironfx.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">After we restart the server all fine.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">But I want to know the root of the problem.. why we got this error???<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">Recently I have enable mod_xml_rpc is this relate with our issue?<u></u><u></u></span></p><span class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11.5pt;font-family:"Calibri",sans-serif;color:black">Andri</span></b><span style="font-size:11.5pt;font-family:"Calibri",sans-serif;color:black"> <b>Hadjiefstathiou</b> |
Network and Security Engineer<br>
<b>t </b><a href="tel:%2B357%2025027607" value="+35725027607" target="_blank">+357 25027607</a> | <b>m </b><a href="tel:%2B357%2096860600" value="+35796860600" target="_blank">+357 96860600</a> | <b>e</b> </span><span style="font-size:11.5pt;font-family:"Calibri",sans-serif;color:blue"><a href="mailto:AHadjiefstathiou@IronFX.com" title="Click to send email to Andri Hadjiefstathiou [IronFX Global]" target="_blank">AHadjiefstathiou@IronFX.com</a></span><span style="font-size:11.5pt;font-family:"Calibri",sans-serif;color:black">
<u></u><u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11.5pt;font-family:"Calibri",sans-serif;color:black">IronFX Global Limited<br>
t</span></b><span style="font-size:11.5pt;font-family:"Calibri",sans-serif;color:black"> <a href="tel:%2B357%2025027000" value="+35725027000" target="_blank">+357 25027000</a> |
<b>f</b> <a href="tel:%2B357%2025027001" value="+35725027001" target="_blank">+357 25027001</a> | <b>w </b><a href="http://www.IronFX.com" title="www.IronFX.com" target="_blank">www.IronFX.com</a><u></u><u></u></span></p>
<p class="MsoNormal"><a href="https://www.facebook.com/IronFX" target="_blank"><b><span style="font-family:"Calibri",sans-serif;text-decoration:none"><img border="0" height="16" width="16"></span></b></a><b><span style="font-family:"Calibri",sans-serif;color:black"> </span></b><a href="https://twitter.com/ironfxglobal" target="_blank"><b><span style="font-family:"Calibri",sans-serif;text-decoration:none"><img border="0" height="16" width="16"></span></b></a><b><span style="font-family:"Calibri",sans-serif;color:black">
</span></b><a href="http://www.youtube.com/ironfxmarketing" target="_blank"><b><span style="font-family:"Calibri",sans-serif;text-decoration:none"><img border="0" height="16" width="16"></span></b></a><b><span style="font-family:"Calibri",sans-serif;color:black"> </span></b><a href="http://blog.ironfx.com/" target="_blank"><b><span style="font-family:"Calibri",sans-serif;text-decoration:none"><img border="0" height="16" width="16"></span></b></a><b><span style="font-family:"Calibri",sans-serif;color:black"> </span></b><a href="http://www.linkedin.com/company/ironfxglobal" target="_blank"><b><span style="font-family:"Calibri",sans-serif;text-decoration:none"><img border="0" height="16" width="16"></span></b></a><span style="font-family:"Calibri",sans-serif;color:black"> </span><a href="https://plus.google.com/+Ironfxglobal" target="_blank"><span style="font-family:"Calibri",sans-serif;text-decoration:none"><img border="0" height="16" width="16"></span></a><b><span style="font-family:"Calibri",sans-serif;color:black">
</span></b><span style="color:black"><u></u><u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11.5pt;font-family:"Calibri",sans-serif;color:black">London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon
| Prague | Budapest | Bucharest | Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol</span></b><b><span style="color:black"><u></u><u></u></span></b></p>
<p class="MsoNormal"><b><span style="color:black"><img border="0" height="71" width="538"></span></b><span style="color:black"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:black">-----------------------------------------------------------------------------------------------------------------------</span><span style="font-size:10.5pt;font-family:"Verdana",sans-serif;color:black"><br>
</span><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:black">IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561)<br>
IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482)<br>
IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276)<br>
IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966)<br>
IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8)<br>
IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5)<br>
IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10)</span><span style="color:black"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:black" lang="EN-GB">IronFX Global Limited is a Member of Eurex Exchange</span><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:black"><br>
-----------------------------------------------------------------------------------------------------------------------</span><span style="color:black"><u></u><u></u></span></p>
<p class="MsoNormal"><b><i><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:#00b050">Consider the environment before printing this email.</span></i></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"><u></u><u></u></span></p>
</span><p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a> [mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a>]
<b>On Behalf Of </b>Christopher Rienzo<br>
<b>Sent:</b> Wednesday, December 03, 2014 6:00 PM<br>
<b>To:</b> FreeSWITCH Users Help<br>
<b>Subject:</b> Re: [Freeswitch-users] Freeswitch<u></u><u></u></span></p><span class="">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Check your sofia profile(s)- it has the database settings in there (dbname, odbc-dsn, db-*) . Then, verify your database is running and can accept connections.<u></u><u></u></p>
</div>
</div>
</span><div>
<p class="MsoNormal"><u></u> <u></u></p>
<div><span class="">
<p class="MsoNormal">On Wed, Dec 3, 2014 at 10:39 AM, Andri Hadjiefstathiou [IronFX Global] <<a href="mailto:AHadjiefstathiou@ironfx.com" target="_blank">AHadjiefstathiou@ironfx.com</a>> wrote:<u></u><u></u></p>
</span><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div><span class="">
<p class="MsoNormal"><span style="color:black">I got those errors recently from our freeswitch server</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black">2014-11-28 21:19:19.806910 [ERR] sofia_glue.c:6376 Error connecting</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black">2014-11-28 21:19:19.806910 [ERR] sofia_glue.c:6416 Error Opening DB</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black">2014-11-28 21:19:19.806910 [WARNING] sofia_glue.c:6376 Max handles 50 exceeded, blocking....</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black">2014-11-28 21:19:21.476882 [ERR] sofia_glue.c:6376 Error connecting</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black">2014-11-28 21:19:21.476882 [ERR] sofia_glue.c:6416 Error Opening DB</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black">2014-11-28 21:19:21.476882 [WARNING] sofia_glue.c:6376 Max handles 50 exceeded, blocking....</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black">What does this means?</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black">I have load recently the
</span><span style="font-size:9.5pt;font-family:"Calibri",sans-serif">mod_xml_rpc</span> is this relate with our issue?<u></u><u></u></p>
<p class="MsoNormal">Also how I can check the correct open DB open connections ?<u></u><u></u></p>
<p class="MsoNormal"><span style="color:black"> </span><u></u><u></u></p>
</span><div><span class="">
<p class="MsoNormal"><b><span style="font-size:11.5pt;color:black">Andri</span></b><span style="font-size:11.5pt;color:black"> <b>Hadjiefstathiou</b> | Network and Security Engineer<br>
<b>t </b><a href="tel:%2B357%2025027607" target="_blank">+357 25027607</a> | <b>
m </b><a href="tel:%2B357%2096860600" target="_blank">+357 96860600</a> | <b>e</b> </span><span style="font-size:11.5pt;color:blue"><a href="mailto:AHadjiefstathiou@IronFX.com" title="Click to send email to Andri Hadjiefstathiou [IronFX Global]" target="_blank">AHadjiefstathiou@IronFX.com</a></span><span style="font-size:11.5pt;color:black">
</span><u></u><u></u></p>
<p class="MsoNormal"><b><span style="font-size:11.5pt;color:black">IronFX Global Limited<br>
t</span></b><span style="font-size:11.5pt;color:black"> <a href="tel:%2B357%2025027000" target="_blank">
+357 25027000</a> | <b>f</b> <a href="tel:%2B357%2025027001" target="_blank">+357 25027001</a> | <b>w
</b><a href="http://www.IronFX.com" title="www.IronFX.com" target="_blank">www.IronFX.com</a></span><u></u><u></u></p>
<p class="MsoNormal"><a href="https://www.facebook.com/IronFX" target="_blank"><b><span style="color:black;text-decoration:none"> </span></b><span style="color:windowtext;text-decoration:none"><b><span style="color:black">
</span></b><b><span style="color:black"> </span></b><b><span style="color:black"> </span></b><span style="color:black"> </span><b><span style="color:black">
</span></b><u></u><u></u></span></a></p>
</span><p class="MsoNormal"><b><span style="font-size:11.5pt;color:black">London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest
| Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol</span></b><u></u><u></u></p>
<p class="MsoNormal"><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:black">-----------------------------------------------------------------------------------------------------------------------</span></p><div><div class="h5"><span style="font-size:10.5pt;font-family:"Verdana",sans-serif;color:black"><br>
</span><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:black">IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561)<br>
IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482)<br>
IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276)<br>
IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966)<br>
IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8)<br>
IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5)<br>
IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10)</span><u></u><u></u></div></div><p></p><div><div class="h5">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:black" lang="EN-GB">IronFX Global Limited is a Member of Eurex Exchange</span><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:black"><br>
-----------------------------------------------------------------------------------------------------------------------</span><u></u><u></u></p>
<p class="MsoNormal"><b><i><span style="font-size:10.5pt;color:#00b050">Consider the environment before printing this email.</span></i></b><u></u><u></u></p>
<div>
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Andri Hadjiefstathiou [IronFX Global]
<br>
<b>Sent:</b> Wednesday, December 03, 2014 5:11 PM<br>
<b>To:</b> '<u><span style="color:blue"><a href="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</a></span></u>'<br>
<b>Subject:</b> Freeswitch <u></u><u></u></p>
</div>
</div>
</div></div><div>
<div><div><div class="h5">
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"><span style="color:black">I got those errors recently from our freeswitch server</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black">[ERR] mod_commands.c:4063 Error connecting</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black">[ERR] sofia_glue.c:6464 Error connecting</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black">[ERR] sofia_glue.c:6504 Error Opening DB</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black">[WARNING] sofia_glue.c:6464 Max handles 50</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black">What does this means?</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black">I have load recently the
</span><span style="font-size:9.5pt;font-family:"Calibri",sans-serif">mod_xml_rpc</span> is this relate with our issue?<u></u><u></u></p>
<p class="MsoNormal">Also how I can check the correct open DB open connections ?<u></u><u></u></p>
<p class="MsoNormal"><span style="color:black"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black"> </span><u></u><u></u></p>
<p class="MsoNormal"><b><span style="font-size:11.5pt;color:black">Andri</span></b><span style="font-size:11.5pt;color:black"> <b>Hadjiefstathiou</b> | Network and Security Engineer<br>
<b>t </b><u><span style="color:blue">+357 25027607</span></u> | <b>m </b><u><span style="color:blue">+357 96860600</span></u> |
<b>e</b> </span><span style="font-size:11.5pt;color:blue"><u>AHadjiefstathiou@IronFX.com</u></span><span style="font-size:11.5pt;color:black">
</span><u></u><u></u></p>
<p class="MsoNormal"><b><span style="font-size:11.5pt;color:black">IronFX Global Limited<br>
t</span></b><span style="font-size:11.5pt;color:black"> <u><span style="color:blue">+357 25027000</span></u> |
<b>f</b> <u><span style="color:blue">+357 25027001</span></u> | <b>w </b><u><span style="color:blue"><a href="http://www.IronFX.com">www.IronFX.com</a></span></u></span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:black"> </span><span style="color:black">
</span><span style="color:black"> </span><span style="color:black"> </span><span style="color:black"> </span><u></u><u></u></p>
</div></div><p class="MsoNormal"><b><span style="font-size:11.5pt;color:black">London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest
| Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol</span></b><u></u><u></u></p>
<p class="MsoNormal"><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:black">-----------------------------------------------------------------------------------------------------------------------</span></p><div><div class="h5"><span style="font-size:10.5pt;font-family:"Verdana",sans-serif;color:black"><br>
</span><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:black">IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561)<br>
IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482)<br>
IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276)<br>
IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966)<br>
IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8)<br>
IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5)<br>
IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10)</span><u></u><u></u></div></div><p></p><div><div class="h5">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:black" lang="EN-GB">IronFX Global Limited is a Member of Eurex Exchange</span><span style="font-size:7.5pt;color:black"><br>
</span><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:black">-----------------------------------------------------------------------------------------------------------------------</span><u></u><u></u></p>
<p class="MsoNormal"><i><span style="font-size:8.5pt;color:#7d7d7d">This email has been sent from IronFX Global Limited. The information in this email is confidential and may be
<br>
legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not
<br>
the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is
<br>
prohibited and may be unlawful.</span></i><u></u><u></u></p>
<p class="MsoNormal"><b><i><span style="font-size:10.5pt;color:#00b050">Consider the environment before printing this email.</span></i></b><u></u><u></u></p>
<p class="MsoNormal"><b><i><span style="color:#00b050"> </span></i></b><u></u><u></u></p>
<p class="MsoNormal"><br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<u><span style="color:blue"><a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a></span></u><br>
<u><span style="color:blue"><a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a></span></u><br>
<br>
Official FreeSWITCH Sites<br>
<u><span style="color:blue"><a href="http://www.freeswitch.org">http://www.freeswitch.org</a></span></u><br>
<u><span style="color:blue"><a href="http://confluence.freeswitch.org">http://confluence.freeswitch.org</a></span></u><br>
<u><span style="color:blue"><a href="http://www.cluecon.com">http://www.cluecon.com</a></span></u><br>
<br>
FreeSWITCH-users mailing list<br>
<u><span style="color:blue"><a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a></span></u><br>
<u><span style="color:blue"><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a></span></u><br>
UNSUBSCRIBE:<u><span style="color:blue"><a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a></span></u><br>
<u><span style="color:blue"><a href="http://www.freeswitch.org">http://www.freeswitch.org</a></span></u><u></u><u></u></p>
<p></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div></div></div>
</div>
<p></p>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br></blockquote></div><br></div>