[Freeswitch-dev] FS ODBC connections

[Juan Antonio Ibañez Santorum]

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