<img class="cloudmagic-smart-beacon" src="https://tr.cloudmagic.com/h/v6/emailtag/tag/1478719670/73154a264d7158e3599b823299ce3695/3f7124c27aa68ef9d0c2429b27f37ca9/4ec7a3d5882a9105c63aa4f1eaccd434/9efab2399c7c560b34de477b9aa0a465/ufo.gif" style="border:0; width:0; height:0; overflow:hidden;" width="0" height="0"><div dir="auto"><span>I am not sure if this is </span><span style="color: rgb(0, 128, 0); font-weight: bold; background-color: transparent; orphans: 2; white-space: pre-wrap; widows: 2;">max-db-handles</span> because I never saw Max handles exceeded or Error connecting message which should be when exceeding the limits. If I can somehow figure out the current usage of the connections pool, that may help to see what’s going on. <div><br></div><div>At what stage FreeSWITCH will report the server has gone away, the moment when the connection actually drops, even if it’s not used by the active script or when the script tries to use it and see’s there is nothing in the pool available? And I suppose there is no auto-reconnection here either.</div><div><br></div><div><div id="cm_footer" class="cm_footer"><div id="cm_sent_from">via <a href="https://cloudmagic.com/k/d/mailapp?ct=dx&cv=9.2.6&pv=10.12.1&source=email_footer_2">Newton Mail</a></div></div><span><br></span><div id="cm_replymail_content_wrap"><div class="cm_replymail_content_1478719406_wrapper">On Wed, Nov 9, 2016 at 10:18 PM, Abaci B <abaci64@gmail.com> wrote:<br><div id="cm_replymail_content_1478719406" style="overflow: visible;"><blockquote style="margin:0;border-left: #D6D6D6 1px solid;padding-left: 10px;"><div dir="ltr"><div>are you maybe talking about this</div><div><br></div><div><a href="https://freeswitch.org/fisheye/browse/~br=master/freeswitch/conf/vanilla/autoload_configs/switch.conf.xml?hb=true#to43">https://freeswitch.org/fisheye/browse/~br=master/freeswitch/conf/vanilla/autoload_configs/switch.conf.xml?hb=true#to43</a></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Nov 9, 2016 at 1:58 PM, Muhammad Naseer Bhatti <span dir="ltr"><<a href="mailto:nbhatti@gmail.com">nbhatti@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div id="m_3776921500676200218bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">As I understand from the documentation, when using ODBC it makes use of connection pooling provided by FreeSWITCH. So I understand there must be a pool where the connections are stored. I am trying to figure out why I keep on getting occasional messages like switch_odbc.c:283 The sql server is not responding for DSN andres [STATE: 08S01 CODE 2006 ERROR: [MySQL][ODBC 5.1 Driver][mysqld-5.6.33-79.0-log]MySQL server has gone away. MySQL is free at this moment and do not have any connections limitation or excessive connection limitations.</div> <br> <div class="m_3776921500676200218bloop_sign" id="m_3776921500676200218bloop_sign_1478717643152202240"><div style="font-family:helvetica,arial;font-size:13px">-- <br><br>Sent with Airmail</div>
</div> <div class="m_3776921500676200218airmail_ext_on" style="color:black"><br>From: <span style="color:black">Michael Jerris</span> <a href="mailto:mike@jerris.com"><mike@jerris.com></a><br>Reply: <span style="color:black">FreeSWITCH Users Help</span> <a href="mailto:freeswitch-users@lists.freeswitch.org"><freeswitch-users@lists.freeswitch.org></a><br>Date: <span style="color:black">November 9, 2016 at 6:27:31 PM</span><br>To: <span style="color:black">FreeSWITCH Users Help</span> <a href="mailto:freeswitch-users@lists.freeswitch.org"><freeswitch-users@lists.freeswitch.org></a><br>Subject: <span style="color:black"> Re: [Freeswitch-users] Default connection pool size for ODBC <br></span></div><br> <blockquote class="m_3776921500676200218clean_bq"><span><div style="word-wrap:break-word"><div></div><div><span>
Freeswitch does not have a traditional connection pool with a size.
What exactly are you referring to?
<div><br>
<div>
<blockquote>
<div>On Nov 8, 2016, at 9:03 AM, Muhammad Naseer Bhatti
<<a href="mailto:nbhatti@gmail.com">nbhatti@gmail.com</a>> wrote:</div>
<br class="m_3776921500676200218Apple-interchange-newline">
<div>
<div id="m_3776921500676200218bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;margin:0px"><br class="m_3776921500676200218Apple-interchange-newline">
Hi, what’s the default connection pool size for ODBC/Postgres is
defined?</div>
<div id="m_3776921500676200218bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;margin:0px"><br></div>
</div>
</blockquote>
</div>
<br></div></span>
_________________________________________________________________________
<br>Professional FreeSWITCH Consulting Services:
<br><a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<br><a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a>
<br>
<br>Official FreeSWITCH Sites
<br><a href="http://www.freeswitch.org">http://www.freeswitch.org</a>
<br><a href="http://confluence.freeswitch.org">http://confluence.freeswitch.org</a>
<br><a href="http://www.cluecon.com">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">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
<br>UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<br><a href="http://www.freeswitch.org">http://www.freeswitch.org</a></div></div></span></blockquote></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" rel="noreferrer">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" rel="noreferrer">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" rel="noreferrer">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" rel="noreferrer">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" rel="noreferrer">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" rel="noreferrer">http://www.freeswitch.org</a><br></blockquote></div><br></div>
</blockquote></div></div></div></div></div>