[Freeswitch-dev] FS ODBC connections

[Juan Antonio Ibañez Santorum]

Ok, I'll try it and post my feedback

Regards

2010/7/20 Anthony Minessale <anthony.minessale at gmail.com>

> 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
>
> _______________________________________________
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-dev/attachments/20100720/46d3c375/attachment.html