Hi, what’s the default connection pool size for ODBC/Postgres is defined? -- Sent with Airmail
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> <mike@jerris.com> Reply: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> <freeswitch-users@lists.freeswitch.org> Date: November 9, 2016 at 6:27:31 PM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> <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
sounds like mysql is terminating active connections?
On 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> <mailto:mike@jerris.com> Reply: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> <mailto:freeswitch-users@lists.freeswitch.org> Date: November 9, 2016 at 6:27:31 PM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> <mailto: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 <mailto:nbhatti@gmail.com>> wrote:
Hi, what’s the default connection pool size for ODBC/Postgres is defined?
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. -- Sent with Airmail From: Michael Jerris <mike@jerris.com> <mike@jerris.com> Reply: Michael Jerris <mike@jerris.com> <mike@jerris.com> Date: November 9, 2016 at 10:12:33 PM To: Muhammad Naseer Bhatti <nbhatti@gmail.com> <nbhatti@gmail.com> Cc: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> <freeswitch-users@lists.freeswitch.org> Subject: Re: [Freeswitch-users] Default connection pool size for ODBC sounds like mysql is terminating active connections? On 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> <mike@jerris.com> Reply: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> <freeswitch-users@lists.freeswitch.org> Date: November 9, 2016 at 6:27:31 PM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> <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?
That's reminds me a similar problem I had ages ago. As far as I remember it was idle timeout of the SQL server (MySQL in my case). Is this on a busy system, or does it happens during long idle periods? Regards, __Yehavi: 2016-11-09 20:58 GMT+02:00 Muhammad Naseer Bhatti <nbhatti@gmail.com>:
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> <mike@jerris.com> Reply: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> <freeswitch-users@lists.freeswitch.org> Date: November 9, 2016 at 6:27:31 PM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> <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
are you maybe talking about this https://freeswitch.org/fisheye/browse/~br=master/freeswitch/conf/vanilla/aut... 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> <mike@jerris.com> Reply: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> <freeswitch-users@lists.freeswitch.org> Date: November 9, 2016 at 6:27:31 PM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> <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
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_fo...] On Wed, Nov 9, 2016 at 10:18 PM, Abaci B <abaci64@gmail.com> wrote: are you maybe talking about this https://freeswitch.org/fisheye/browse/~br=master/freeswitch/conf/vanilla/aut... [https://freeswitch.org/fisheye/browse/~br=master/freeswitch/conf/vanilla/aut...] On Wed, Nov 9, 2016 at 1:58 PM, Muhammad Naseer Bhatti < nbhatti@gmail.com [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> [mike@jerris.com] Reply: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> [freeswitch-users@lists.freeswitch.org] Date: November 9, 2016 at 6:27:31 PM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> [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 [nbhatti@gmail.com] > wrote: Hi, what’s the default connection pool size for ODBC/Postgres is defined? _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org [consulting@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@lists.freeswitch.org [FreeSWITCH-users@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@freeswitch.org [consulting@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@lists.freeswitch.org [FreeSWITCH-users@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]
participants (4)
-
Abaci B
-
Michael Jerris
-
Muhammad Naseer Bhatti
-
Yehavi Bourvine