Many destroyed channels still present in channels and calls table when using odbc!
Hi I'm using odbc in the core with mysql on a remote machine in local lan, sometimes number of channels grows rapidly but many of them are not existing according to uuid_exists. Channels will persist in database till I delete them manually. How can I debug the problem? Thanks
are you referring to the channels table? First make sure you are using the most recent 1.4 release and that your odbc drive is using the threadsafe mysql drivers.
On Feb 1, 2015, at 6:02 AM, Babak Yakhchali <babak.freeswitch@gmail.com> wrote:
Hi I'm using odbc in the core with mysql on a remote machine in local lan, sometimes number of channels grows rapidly but many of them are not existing according to uuid_exists. Channels will persist in database till I delete them manually. How can I debug the problem?
Thanks for answering. Yes I'm referring to channels table. This is freeswitch version output: FreeSWITCH Version 1.4.15+git~20150103T120621Z~7fe60e45b7~64bit (git 7fe60e4 2015-01-03 12:06:21Z 64bit) this is unixodbc and mysql driver version: unixODBC-2.2.14-14.el6.x86_64 mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 and here is odbc configuration [MySQL] Description = ODBC for MySQL Driver = /usr/lib/libmyodbc5.so Setup = /usr/lib/libodbcmyS.so Driver64 = /usr/lib64/libmyodbc5.so Setup64 = /usr/lib64/libodbcmyS.so FileUsage = 1 Threading = 0 CPTimeout = 0 [freeswitch] Description = freeswitch core databses Driver = MySQL SERVER = 192.168.1.3 USER = freeswitch PASSWORD = freeswitch PORT = 3306 DATABASE = freeswitch OPTION = 67108864 and I should say that after reading freeswitch.log I see that sometimes channels never reach the line switch_core_session:1633 where it is printing session ended message. I think somehow it can not lock session in line switch_core_session:1631. May be there is something running on channel which is yet doing something. On Tue, Feb 3, 2015 at 9:21 PM, Michael Jerris <mike@jerris.com> wrote:
are you referring to the channels table? First make sure you are using the most recent 1.4 release and that your odbc drive is using the threadsafe mysql drivers.
On Feb 1, 2015, at 6:02 AM, Babak Yakhchali <babak.freeswitch@gmail.com> wrote:
Hi I'm using odbc in the core with mysql on a remote machine in local lan, sometimes number of channels grows rapidly but many of them are not existing according to uuid_exists. Channels will persist in database till I delete them manually. How can I debug the problem?
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (2)
-
Babak Yakhchali
-
Michael Jerris