<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap:break-word"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">It is possible, but highly doubt since it’s s busy system. That’s why I am trying to figure out if I can change the limit of connections FreeSWITCH keeps for use or somehow see what is pool’s status and see if I can gracefully replicate this to find the root cause.</div> <br> <div id="bloop_sign_1478718810559403776" class="bloop_sign"><div style="font-family:helvetica,arial;font-size:13px">-- <br><br>Sent with Airmail</div>
</div> <div class="airmail_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">Michael Jerris</span> <a href="mailto:mike@jerris.com"><mike@jerris.com></a><br>Date: <span style="color:black">November 9, 2016 at 10:12:33 PM</span><br>To: <span style="color:black">Muhammad Naseer Bhatti</span> <a href="mailto:nbhatti@gmail.com"><nbhatti@gmail.com></a><br>Cc: <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 type="cite" class="clean_bq"><span><div style="word-wrap:break-word" class=""><div></div><div>
<title></title>
sounds like mysql is terminating active connections?
<div class=""><br class="">
<div>
<blockquote type="cite" class="">
<div class="">On Nov 9, 2016, at 1:58 PM, Muhammad Naseer Bhatti
<<a href="mailto:nbhatti@gmail.com" class="">nbhatti@gmail.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div id="bloop_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" class="">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 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" class="">
<div id="bloop_sign_1478717643152202240" class="bloop_sign" 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">
<div style="font-family:helvetica,arial;font-size:13px" class="">-- <br class="">
<br class="">
Sent with Airmail</div>
</div>
<div class="airmail_ext_on" 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">
<br class="">
From: <span style="" class="">Michael
Jerris</span><span class="Apple-converted-space"> </span><a href="mailto:mike@jerris.com" class=""><mike@jerris.com></a><br class="">
Reply: <span style="" class="">FreeSWITCH Users
Help</span><span class="Apple-converted-space"> </span><a href="mailto:freeswitch-users@lists.freeswitch.org" class=""><freeswitch-users@lists.freeswitch.org></a><br class="">
Date: <span style="" class="">November 9, 2016 at 6:27:31
PM</span><br class="">
To: <span style="" class="">FreeSWITCH Users
Help</span><span class="Apple-converted-space"> </span><a href="mailto:freeswitch-users@lists.freeswitch.org" class=""><freeswitch-users@lists.freeswitch.org></a><br class="">
Subject: <span style="" class=""><span class="Apple-converted-space"> </span>Re: [Freeswitch-users] Default
connection pool size for ODBC<span class="Apple-converted-space"> </span><br class=""></span></div>
<br 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" class="">
<blockquote type="cite" class="clean_bq" 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">
<div class="" style="word-wrap:break-word">
<div class=""></div>
<div class=""><span class="">Freeswitch does not have a traditional
connection pool with a size. What exactly are you referring
to?</span>
<div class=""><span class=""><br class=""></span>
<div class="">
<blockquote type="cite" class="">
<div class=""><span class="">On Nov 8, 2016, at 9:03 AM, Muhammad
Naseer Bhatti <<a href="mailto:nbhatti@gmail.com" class="">nbhatti@gmail.com</a>> wrote:</span></div>
<span class=""><br class="Apple-interchange-newline"></span>
<div class="">
<div id="bloop_customfont" class="" 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">
<span class=""><br class="Apple-interchange-newline">
Hi, what’s the default connection pool size for ODBC/Postgres is
defined?</span></div>
<div id="bloop_customfont" class="" 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">
<span class=""><br class=""></span></div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
<br class=""></div>
</div></div></span></blockquote></body></html>