[asterisk-users] [0017330] 1.6.1 and 1.6.2 + MySQL crases on ODBC Query (via func_odbc or sip realtime)

[Marcin J. Kowalczyk]

Hi,

  I'm expiriencing very annoying  issue with Asterisk while using ODBC 
on Linux box running Debian with following packages:

Asterisk-node0:/tmp# dpkg -l | grep -i odbc
ii  libiodbc2                            3.52.6-2                   
iODBC Driver Manager
ii  libmyodbc                            3.51.15r409-4              the 
MySQL ODBC driver
ii  libodbcinstq1c2                      2.2.11-16                  
Qt-based ODBC configuration library
ii  odbcinst1debian1                     2.2.11-16                  
Support library and helper program for acces
ii  unixodbc                             2.2.11-16                  ODBC 
tools libraries
ii  unixodbc-bin                         2.2.11-16                  
Graphical tools for ODBC management and brow
ii  unixodbc-dev                         2.2.11-16                  ODBC 
libraries for UNIX (development files)
Asterisk-node0:/tmp# dpkg -l | grep -i mysql
ii  libdbd-mysql-perl                    4.007-1                    A 
Perl5 database interface to the MySQL data
ii  libmyodbc                            3.51.15r409-4              the 
MySQL ODBC driver
ii  libmysql5.0-cil                      5.2.1+dfsg-2               
MySQL database connector for CLI
ii  libmysqlclient15-dev                 5.0.51a-17                 
MySQL database development files
ii  libmysqlclient15off                  5.0.51a-17                 
MySQL database client library
ii  mysql-client-5.0                     5.0.51a-17                 
MySQL database client binaries
ii  mysql-common                         5.0.51a-17                 
MySQL database common files
ii  mysql-server                         5.0.51a-17                 
MySQL database server (metapackage depending
ii  mysql-server-5.0                     5.0.51a-17                 
MySQL database server binaries


Medium load system (~300 simultaneous calls) crases few times a day.

I'm not able to reproduce issue in lab conditions.

I've raised a bug https://issues.asterisk.org/view.php?id=17330 for 
1.6.1.19 but then upgraded to 1.6.2.7 but it's not solving issue.

Any idea what can be wrong/tunned?