[asterisk-bugs] [Asterisk 0017330]: Asterisk crash on ODBC /usr/lib/libodbc.so.1 and /lib/i686/cmov/libc.so.6

Asterisk Bug Tracker noreply at bugs.digium.com
Sun Jul 4 03:12:54 CDT 2010


A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=17330 
====================================================================== 
Reported By:                kowalma
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   17330
Category:                   Functions/func_odbc
Reproducibility:            random
Severity:                   crash
Priority:                   normal
Status:                     feedback
Asterisk Version:           SVN 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-05-13 04:06 CDT
Last Modified:              2010-07-04 03:12 CDT
====================================================================== 
Summary:                    Asterisk crash on ODBC /usr/lib/libodbc.so.1 and
/lib/i686/cmov/libc.so.6
Description: 
Hi,

 On quite heavy load I expirience Asterisk crash. 
Asterisk 1.6.1.19 + following ODBC version

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)


I'm using ODBC quite hard for dialplan (checking permissions, setting up
database variables for Queues, sip realtime, etc)
Same I saw in 1.6.1.18 - I upgraded yesterday to .19 and this did not
solve issue.


BT Full says:
(gdb) bt full
https://issues.asterisk.org/view.php?id=0  0xb7d5f872 in free () from
/lib/i686/cmov/libc.so.6
No symbol table info available.
https://issues.asterisk.org/view.php?id=1  0xb769ebe1 in ?? () from
/usr/lib/libodbc.so.1
No symbol table info available.
https://issues.asterisk.org/view.php?id=2  0x00000001 in ?? ()
No symbol table info available.
https://issues.asterisk.org/view.php?id=3  0xb76b9d2c in ?? () from
/usr/lib/libodbc.so.1
No symbol table info available.
https://issues.asterisk.org/view.php?id=4  0xad343658 in ?? ()
No symbol table info available.
https://issues.asterisk.org/view.php?id=5  0xb76b9d2c in ?? () from
/usr/lib/libodbc.so.1
No symbol table info available.
https://issues.asterisk.org/view.php?id=6  0x09f22968 in ?? ()
No symbol table info available.
https://issues.asterisk.org/view.php?id=7  0x00000003 in ?? ()
No symbol table info available.
https://issues.asterisk.org/view.php?id=8  0xad343718 in ?? ()
No symbol table info available.
https://issues.asterisk.org/view.php?id=9  0xb7662908 in ?? () from
/usr/lib/libodbc.so.1
No symbol table info available.
https://issues.asterisk.org/view.php?id=10 0xac202a20 in ?? ()
No symbol table info available.
https://issues.asterisk.org/view.php?id=11 0xac202a20 in ?? ()
No symbol table info available.
https://issues.asterisk.org/view.php?id=12 0x00007fb8 in ?? ()
No symbol table info available.
https://issues.asterisk.org/view.php?id=13 0x080808f2 in __ao2_ref
(user_data=0xac202a20, delta=-1407178208) at
astobj2.c:307
        obj = (struct astobj2 *) 0xb76b9d2c
        current_value = 166865256
        ret = 3
        __PRETTY_FUNCTION__ = "__ao2_ref"
Backtrace stopped: previous frame inner to this frame (corrupt stack?)
(gdb)

====================================================================== 

---------------------------------------------------------------------- 
 (0124209) kowalma (reporter) - 2010-07-04 03:12
 https://issues.asterisk.org/view.php?id=17330#c124209 
---------------------------------------------------------------------- 
I had MySQL connection idle (looks closed due to inactivity) and then call
came.

[Jul  4 10:08:02] WARNING[30385]: res_odbc.c:1300 ast_odbc_request_obj2:
SetConnectAttr (Txn isolation) returned an error: HY000: [MySQL][ODBC 5.1
Driver]MySQL server has gone away
[Jul  4 10:08:02] WARNING[30385]: res_odbc.c:1300 ast_odbc_request_obj2:
SetConnectAttr (Txn isolation) returned an error: HY000: [MySQL][ODBC 5.1
Driver]MySQL server has gone away
[Jul  4 10:08:02] WARNING[30386]: func_odbc.c:183 generic_execute: SQL
Execute returned an error -1: 08S01: [MySQL][ODBC 5.1
Driver][mysqld-5.0.51a-24+lenny1-log]MySQL server has gone away (80)
[Jul  4 10:08:02] WARNING[30386]: func_odbc.c:183 generic_execute: SQL
Execute returned an error -1: 08S01: [MySQL][ODBC 5.1
Driver][mysqld-5.0.51a-24+lenny1-log]MySQL server has gone away (80)
[Jul  4 10:08:02] WARNING[30385]: func_odbc.c:183 generic_execute: SQL
Execute returned an error -1: 08S01: [MySQL][ODBC 5.1
Driver][mysqld-5.0.51a-24+lenny1-log]MySQL server has gone away (80)
[Jul  4 10:08:02] WARNING[30385]: func_odbc.c:183 generic_execute: SQL
Execute returned an error -1: 08S01: [MySQL][ODBC 5.1
Driver][mysqld-5.0.51a-24+lenny1-log]MySQL server has gone away (80)
[Jul  4 10:08:02] WARNING[30386]: func_odbc.c:191 generic_execute: SQL
Exec Direct failed (-1)![select id from Now where host = "CC9373" limit
0,1]
[Jul  4 10:08:02] WARNING[30386]: func_odbc.c:191 generic_execute: SQL
Exec Direct failed (-1)![select id from Now where host = "CC9373" limit
0,1]
[Jul  4 10:08:02] WARNING[30385]: func_odbc.c:191 generic_execute: SQL
Exec Direct failed (-1)![select id from Now where host = "CC9374" limit
0,1]
[Jul  4 10:08:02] WARNING[30385]: func_odbc.c:191 generic_execute: SQL
Exec Direct failed (-1)![select id from Now where host = "CC9374" limit
0,1]
[Jul  4 10:08:02] WARNING[30385]: res_odbc.c:583 ast_odbc_direct_execute:
SQL Exec Direct failed.  Attempting a reconnect...
[Jul  4 10:08:02] WARNING[30385]: res_odbc.c:583 ast_odbc_direct_execute:
SQL Exec Direct failed.  Attempting a reconnect...
Asterisk-node0*CLI> 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-07-04 03:12 kowalma        Note Added: 0124209                          
======================================================================




More information about the asterisk-bugs mailing list