[Freeswitch-dev] FS ODBC connections

[Anthony Minessale]

I would try the latest git code.  I re-factored some of those
pooling behaviors recently.


2010/7/20 Juan Antonio Ibañez Santorum <juanito1982 at gmail.com>

> Hello!
>
>    I am working with a own module which accesses to a MySQL DB using core
> ODBC connections. For each query I call switch_cache_db_get_db_handle(&dbh,
> SCDB_TYPE_ODBC, &options) to get a DB handle and
> switch_cache_db_release_db_handle() for releasing it. I can see as FS opens
> one connection for each concurrent call but maintains them openned once
> hanged up. If you exceed higher number of concurrent calls in the past, new
> connections are openned. For example, doing 10 concurrent calls, 10
> connections to MySQL are created. If you wait these 10 calls to end and make
> 5 new calls, FS seems to use 5 of the connections already open, FS does not
> open 5 new connections. Is that the way it must work? Must DB connections
> maintained openned once hanged up the calls?
>
>    After some minutes, openned connections are closed but I can read by
> console "Error in my_thread_global_end(): XXX threads didn't exit" where XXX
> tells number of connections openned. Is there a real Error or may it be
> considered ok? I read It could be a problem with MySQL driver version but I
> tried to use newest (5.1.6) with the same result...
>
> Regards
>
> _______________________________________________
> 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/20100720/2e9ac8d8/attachment.html