[Freeswitch-dev] odbc连接过多的问题

[Anthony Minessale]

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 at 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 at lists.freeswitch.org [mailto:
> freeswitch-dev-bounces at lists.freeswitch.org] On Behalf Of Seven Du
> Sent: Tuesday, June 29, 2010 7:43 AM
> To: freeswitch-dev at 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 at 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 at 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 at 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 at 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 at 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 at hotmail.com <MSN%3Aanthony_minessale at hotmail.com>
> > GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
> > IRC: irc.freenode.net #freeswitch
> >
> > FreeSWITCH Developer Conference
> > sip:888 at conference.freeswitch.org <sip%3A888 at conference.freeswitch.org>
> > googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
> > pstn:+19193869900
> >
> > _______________________________________________
> > FreeSWITCH-dev mailing list
> > FreeSWITCH-dev at 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 at 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 at 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 at hotmail.com <MSN%3Aanthony_minessale at hotmail.com>
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org <sip%3A888 at conference.freeswitch.org>
googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
pstn:+19193869900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-dev/attachments/20100629/21b95b06/attachment-0001.html