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

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?

On Mon, May 24, 2010 at 7:31 AM, Marcin J. Kowalczyk
<marcin.kowalczyk at ccig.pl> wrote:
> Medium load system (~300 simultaneous calls) crases few times a day.
> 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?
I've three times had unexplained crashes of asterisk 1.6.2.6, and they
seemed to be load related.

I'm doing heavy Perl AGI.

I've had other things in my todo list so I haven't circled back to
investigate.

I know there's a way to rebuild asterisk in a way that the coredumps
are actually useful.

http://www.voip-info.org/wiki/view/Asterisk+debugging
if the make valgrind thing is invalid advice to build a useful
debuggable version of core dumps, please somebody point to the correct
directions.

I have not rebuilt, again because I haven't found proper time to devote to
this.

I have a previous iteration of my systems where I ran with about
double the number of calls with 1.6.0.5 with no crashes, and if I
continue to have a tight schedule I'll back up to that version.