[Freeswitch-users] Many destroyed channels still present in channels and calls table when using odbc!

[Babak Yakhchali]

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 at 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 at 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 at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150204/6e759d9f/attachment.html