[asterisk-bugs] [JIRA] (ASTERISK-25891) Crash using ODBC in mysql with heavy usage

[Carlos Oliva (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-25891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=230157#comment-230157 ] 

Carlos Oliva commented on ASTERISK-25891:
-----------------------------------------

I'm using unixODBC 2.3.1. In the changelog they says that the default thread protection changed to 0 in 2.3.1 release ( http://www.unixodbc.org/unixODBC.html ) and this value asume the driver is threadsafe. Many thanks Ross for pointing me to this.

Probably (I'm just gessing) default libmyodbc in debian 8 (5.1.10) is not compiled with thread-safe and this is causing the problem. I have not seen any crashes in last two hours using mysql provided libmyodbc. Probably mysql provided binaries are compiled with thread-safe option.

I'll test for some days more and if everything is OK I'll close the issue.

Thanks Ross and Michael for the help.

Here is a little howto install last binary odbc mysql connector in debian8:

download last odbc connector from:
https://dev.mysql.com/downloads/connector/odbc/

decompress and copy files to a logic location for example:
tar -zxvf mysql-connector-odbc-5.3.6-linux-debian8-x86-64bit.tar.gz
cd mysql-connector-odbc-5.3.6-linux-debian8-x86-64bit
mkdir /usr/local/lib/mysql-connector-odbc-5.3.6
cp lib/*.so /usr/local/lib/mysql-connector-odbc-5.3.6/

modify /etc/odbcinst.ini with the new libraries:
Driver = /usr/local/lib/mysql-connector-odbc-5.3.6/libmyodbc5a.so
Setup  = /usr/local/lib/mysql-connector-odbc-5.3.6/libmyodbc5S.so


> Crash using ODBC in mysql with heavy usage
> ------------------------------------------
>
>                 Key: ASTERISK-25891
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-25891
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_odbc
>    Affects Versions: 13.8.0
>         Environment: debian jessie 8.4 (KVM virtual machine)
>            Reporter: Carlos Oliva
>            Assignee: Unassigned
>         Attachments: backtrace1.txt, backtrace2.txt, backtrace3.txt, bt_libmysql5_7.txt
>
>
> testing release 13.8.0 I found crashes making heavy use of ODBC with mysql. This issue seems to not happen in 13.7.2 release.
> We make a heavy usage of mysql using ODBC, dialplan functions and CEL. The isse seems to happen with 4 or 5 calls using queues, cel logging to mysql and lots of database calls in the dialplan.
>  I think maybe related to Change-Id: I37a84def5ea4ddf93868ce8105f39de078297fbf (res_odbc: Remove connection management) because it directly affects to odbc connection settings. 
> I will attach some backtraces where you can see clearly the issue is related to odbc and libmysqlclient.so.18



--
This message was sent by Atlassian JIRA
(v6.2#6252)