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 夏青 <xiaq...@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-boun...@lists.freeswitch.org [mailto:
> freeswitch-dev-boun...@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.miness...@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_li...@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
> >> mr...@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_miness...@hotmail.com <msn%3aanthony_miness...@hotmail.com>
> > GTALK/JABBER/PAYPAL:anthony.miness...@gmail.com<paypal%3aanthony.miness...@gmail.com>
> > IRC: irc.freenode.net #freeswitch
> >
> > FreeSWITCH Developer Conference
> > sip:8...@conference.freeswitch.org <sip%3a...@conference.freeswitch.org>
> > googletalk:conf+...@conference.freeswitch.org<googletalk%3aconf%2b...@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_miness...@hotmail.com <msn%3aanthony_miness...@hotmail.com>
GTALK/JABBER/PAYPAL:anthony.miness...@gmail.com<paypal%3aanthony.miness...@gmail.com>
IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference
sip:8...@conference.freeswitch.org <sip%3a...@conference.freeswitch.org>
googletalk:conf+...@conference.freeswitch.org<googletalk%3aconf%2b...@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
