Summary:ASTERISK-09586: segfault with voicemail and ODBC
Reporter:Corey Edwards (tensai)Labels:
Date Opened:2007-06-04 21:39:12Date Closed:2011-06-07 14:00:30
Versions:Frequency of
Environment:Attachments:( 0) ast-bt.txt
( 1) bt.txt
Description:Segfault with 1.4.2, 1.4.4 and svn 1.4 branch. The backtrace indicates it's a problem with ODBC. We are using ODBC voicemail so that correlates with the fact that the crashes seem to occur when a user hits voicemail.

Periodically (seems to be usually in the morning) I get this error on the console:

res_odbc.c:147 ast_odbc_smart_execute: SQL Execute returned an error -1: HYT00: [MySQL][ODBC 3.51 Driver][mysqld-5.0.32-Debian_7etch1-log]MySQL server has gone away (84)

I sometimes get a segfault after that. I found bug 9389 which is similar, but doesn't cause segfaults. I also see the segfaults without the error message, so I'm not sure they're actually related.
Comments:By: Clod Patry (junky) 2007-06-05 17:24:00

Could you also add a thread apply all bt, like requested in the backtrace.txt?
Thanks for this report.

By: Corey Edwards (tensai) 2007-06-05 18:04:08

New backtrace added with bt full and thread apply all bt. Apologies for missing this the first time.

By: Tilghman Lesher (tilghman) 2007-06-06 11:55:46

What is the dot-release of the mysql-odbc-connector driver that you're using?  The current version is 3.51.15, and a previous version had a very major crash issue on reconnect.

By: Corey Edwards (tensai) 2007-06-06 14:37:09

It is Debian package libmyodbc 3.51.11-6.1 from Etch/4.0. Do you recall which version had the crash? I will grab the tarball from mysql.com and give 3.51.15 a try, I suppose. Can't hurt.

By: Corey Edwards (tensai) 2007-06-08 09:43:32

No crashes since the upgrade. That sounds promising. I will watch it for a few more days and report back.

By: Corey Edwards (tensai) 2007-06-12 09:36:22

still no crashes. I believe the upgrade has resolved the segfault.