[Freeswitch-users] Default connection pool size for ODBC

[Muhammad Naseer Bhatti]

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.
via Newton Mail [https://cloudmagic.com/k/d/mailapp?ct=dx&cv=9.2.6&pv=10.12.1&source=email_footer_2]
On Wed, Nov 9, 2016 at 10:18 PM, Abaci B <abaci64 at gmail.com> wrote:
are you maybe talking about this
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]
On Wed, Nov 9, 2016 at 1:58 PM, Muhammad Naseer Bhatti < nbhatti at gmail.com [nbhatti at 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 at jerris.com> [mike at jerris.com]
Reply: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org> [freeswitch-users at lists.freeswitch.org]
Date: November 9, 2016 at 6:27:31 PM
To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org> [freeswitch-users at 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 at gmail.com [nbhatti at gmail.com] > wrote:

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

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting at freeswitch.org [consulting at freeswitch.org]
http://www.freeswitchsolutions.com [http://www.freeswitchsolutions.com]

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

FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org [FreeSWITCH-users at lists.freeswitch.org]
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users [http://lists.freeswitch.org/mailman/listinfo/freeswitch-users]
UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users [http://lists.freeswitch.org/mailman/options/freeswitch-users]
http://www.freeswitch.org [http://www.freeswitch.org]
_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting at freeswitch.org [consulting at freeswitch.org]
http://www.freeswitchsolutions.com [http://www.freeswitchsolutions.com]

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

FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org [FreeSWITCH-users at lists.freeswitch.org]
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users [http://lists.freeswitch.org/mailman/listinfo/freeswitch-users]
UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users [http://lists.freeswitch.org/mailman/options/freeswitch-users]
http://www.freeswitch.org [http://www.freeswitch.org]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20161109/da2afab6/attachment-0001.html