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 夏青 <[email protected]> > 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: [email protected] [mailto: > [email protected]] On Behalf Of Seven Du > Sent: Tuesday, June 29, 2010 7:43 AM > To: [email protected] > Subject: Re: [Freeswitch-dev] odbc连接过多的问题 > > agree with mrene that the google translation is horrible in this case. > > 2010/6/29 Anthony Minessale <[email protected]>: > > 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 <[email protected]> > >> > >> 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 > >> [email protected] > >> > >> > >> > >> 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 > >> [email protected] > >> 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 > >> [email protected] > >> 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:[email protected] <msn%[email protected]> > > GTALK/JABBER/PAYPAL:[email protected]<paypal%[email protected]> > > IRC: irc.freenode.net #freeswitch > > > > FreeSWITCH Developer Conference > > sip:[email protected] <sip%[email protected]> > > googletalk:[email protected]<googletalk%3aconf%[email protected]> > > pstn:+19193869900 > > > > _______________________________________________ > > FreeSWITCH-dev mailing list > > [email protected] > > 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 > [email protected] > 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 > [email protected] > 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:[email protected] <msn%[email protected]> GTALK/JABBER/PAYPAL:[email protected]<paypal%[email protected]> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:[email protected] <sip%[email protected]> googletalk:[email protected]<googletalk%3aconf%[email protected]> pstn:+19193869900
_______________________________________________ FreeSWITCH-dev mailing list [email protected] http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
