I am not sure if this is max-db-handles 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. 

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.


On Wed, Nov 9, 2016 at 10:18 PM, Abaci B <abaci64@gmail.com> wrote:

On Wed, Nov 9, 2016 at 1:58 PM, Muhammad Naseer Bhatti <nbhatti@gmail.com> wrote:
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.

--

Sent with Airmail

From: Michael Jerris <mike@jerris.com>
Reply: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>
Date: November 9, 2016 at 6:27:31 PM
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>
Subject: Re: [Freeswitch-users] Default connection pool size for ODBC

Freeswitch does not have a traditional connection pool with a size. What exactly are you referring to?

On Nov 8, 2016, at 9:03 AM, Muhammad Naseer Bhatti <nbhatti@gmail.com> wrote:


Hi, what’s the default connection pool size for ODBC/Postgres is defined?


 _________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org