2010/7/20 Juan Antonio Ibañez Santorum <juanito1982@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@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@hotmail.com
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org
googletalk:conf+888@conference.freeswitch.org
pstn:+19193869900