it's wrong. That patch breaks things horribly I tested it. I forgot that the flag is only cleared when the thread who created it, exits. The point is to keep the db connection dedicated to that thread until it exits. if the total connections run out it may be due to mod_limit and postgres only having 100 connections as the default. 2010/6/28 夏青 <xiaqing@hundsun.com>
Following is the translation from Chinese:
We found a problem when testing Freeswitch version 1.0.19, it will create too many ODBC connections, and lead to unable create new connection. It should be caused by following function that flag was not removed.
SWITCH_DECLARE(void) switch_cache_db_release_db_handle(switch_cache_db_handle_t ** dbh) { if(dbh && *dbh) { switch_clear_flag(*dbh, CDF_INUSE); //remove INUSE flag switch_mutex_unlock((*dbh)->mutex); *dbh = NULL; } }
-----Original Message----- From: freeswitch-dev-bounces@lists.freeswitch.org [mailto: freeswitch-dev-bounces@lists.freeswitch.org] On Behalf Of Seven Du Sent: Tuesday, June 29, 2010 7:43 AM To: freeswitch-dev@lists.freeswitch.org Subject: Re: [Freeswitch-dev] odbc连接过多的问题
agree with mrene that the google translation is horrible in this case.
2010/6/29 Anthony Minessale <anthony.minessale@gmail.com>:
turns out that change is horrible. i think his problem is he needs more connections because that change really messes things up
2010/6/28 Mathieu Rene <mrene_lists@avgs.ca>
I guess the source was easier to read than the google translation anyways Mathieu Rene Avant-Garde Solutions Inc Office: + 1 (514) 664-1044 x100 Cell: +1 (514) 664-1044 x200 mrene@avgs.ca
On 2010-06-28, at 9:50 AM, EdPimentl wrote:
This is what he said:
In the test FREEESWITCH 1.0.19 version of the time found a problem, too much can cause odbc connection, leading to not create a new connection problem. Find the code found in the following function should be connected without removing the logo.
SWITCH_DECLARE (void) switch_cache_db_release_db_handle (switch_cache_db_handle_t ** dbh) ( if (dbh & & * dbh) ( switch_clear_flag (* dbh, CDF_INUSE); / / get rid of using the state flag switch_mutex_unlock ((* dbh) -> mutex); * Dbh = NULL; ) )
-E Gpro.ws
_______________________________________________ FreeSWITCH-dev mailing list FreeSWITCH-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-de v http://www.freeswitch.org
_______________________________________________ FreeSWITCH-dev mailing list FreeSWITCH-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-de v http://www.freeswitch.org
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire
AIM: anthm MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:+19193869900
_______________________________________________ FreeSWITCH-dev mailing list FreeSWITCH-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
-- Blog: http://www.dujinfang.com Proj: http://www.freeswitch.org.cn
_______________________________________________ FreeSWITCH-dev mailing list FreeSWITCH-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
_______________________________________________ FreeSWITCH-dev mailing list FreeSWITCH-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:+19193869900