| Summary: | ASTERISK-18753: Asterisk crash when using cdr_adaptive_odbc and sql server isn't reacheable | ||
| Reporter: | Matija Turk (johnny2211) | Labels: | |
| Date Opened: | 2011-10-25 08:35:13 | Date Closed: | 2011-11-21 14:08:05.000-0600 |
| Priority: | Critical | Regression? | |
| Status: | Closed/Complete | Components: | CDR/cdr_adaptive_odbc |
| Versions: | 1.8.5.0 | Frequency of Occurrence | Frequent |
| Related Issues: | |||
| Environment: | debian 6.0, asterisk compiled from source 64 bit | Attachments: | |
| Description: | Asterisk runs normaly, cca 20 active calls 24/7, pure extensions.conf dialplan. When mysql server 5.1.49 crashes or is restarted, asterisk crashes, and needs to be started again. Mysql server is on another machine. *****************/var/log/asterisk/full [Oct 25 14:49:40] DEBUG[5130] res_odbc.c: Disconnected 0 from cdr1 [mysql1] [Oct 25 14:49:40] WARNING[5134] cdr_adaptive_odbc.c: SQL Alloc Handle failed! [Oct 25 14:49:40] WARNING[5134] res_odbc.c: Connection is down attempting to reconnect... [Oct 25 14:49:40] WARNING[5127] cdr_adaptive_odbc.c: SQL Alloc Handle failed! [Oct 25 14:49:40] WARNING[5127] res_odbc.c: Connection is down attempting to reconnect... [Oct 25 14:49:40] WARNING[5123] cdr_adaptive_odbc.c: SQL Alloc Handle failed! [Oct 25 14:49:40] WARNING[5123] res_odbc.c: Connection is down attempting to reconnect... [Oct 25 14:49:40] WARNING[4881] cdr_adaptive_odbc.c: SQL Alloc Handle failed! [Oct 25 14:49:40] WARNING[4881] res_odbc.c: Connection is down attempting to reconnect... [Oct 25 14:49:40] WARNING[5142] cdr_adaptive_odbc.c: SQL Alloc Handle failed! [Oct 25 14:49:40] WARNING[5138] cdr_adaptive_odbc.c: SQL Alloc Handle failed! | ||
| Comments: | By: Leif Madsen (lmadsen) 2011-10-31 13:35:46.746-0500 What version of UnixODBC are you using? You should be using the latest version from the unixodbc.org website as those versions packaged with distributions are often very old. If this is a crash, you'll need to provide a backtrace information. Also provide your configuration so the issue could potentially be reproduced. By: Leif Madsen (lmadsen) 2011-10-31 13:36:00.916-0500 Debugging deadlocks: Please select DEBUG_THREADS and DONT_OPTIMIZE in the Compiler Flags section of menuselect. Recompile and install Asterisk (i.e. make install). This will then give you the console command "core show locks." When the symptoms of the deadlock present themselves again, please provide output of the deadlock via: # asterisk -rx "core show locks" | tee /tmp/core-show-locks.txt # gdb -se "asterisk" <pid of asterisk> | tee /tmp/backtrace.txt gdb> bt gdb> bt full gdb> thread apply all bt Then attach the core-show-locks.txt and backtrace.txt files to this issue. Thanks! By: Leif Madsen (lmadsen) 2011-11-21 14:07:59.997-0600 Suspended due to lack of activity. Please request a bug marshal in #asterisk-bugs on the IRC network irc.freenode.net to reopen the issue should you have the additional information requested. Further information can be found at http://www.asterisk.org/developers/bug-guidelines | ||