[asterisk-bugs] [Asterisk 0016349]: System completely hangs after executing an ODBC function

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=16349 
====================================================================== 
Reported By:                tbelder
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   16349
Category:                   Functions/func_odbc
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     acknowledged
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:             2009-11-30 03:26 CST
Last Modified:              2009-12-09 08:57 CST
====================================================================== 
Summary:                    System completely hangs after executing an ODBC
function
Description: 
Currently I am working to upgrade asterisk 1.4.21 to 1.4.27. During testing
of my dialplan I discovered that the system will completely hangs after
executing an ODBC query in the h extension. The CLI shows no verbosity and
debug messages. Also the SSH connection is dropped and no new SSH
connection can be made. The only reaction of the system is a ping reply.
The system has to be turned off and on to make the system work again!!

This problem is introduced in asterisk 1.4.22. However, I cannot find out
which change causes this problem. I have searched in the changelog for a
possible cause, but I cannot find out.

Below you can find the steps to reproduce. When the dialplan executes the
odbc query in the h extension, the whole system hangs.

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

---------------------------------------------------------------------- 
 (0114978) tbelder (reporter) - 2009-12-09 08:57
 https://issues.asterisk.org/view.php?id=16349#c114978 
---------------------------------------------------------------------- 
My logfile of asterisk reports the following warnings:

[Dec  9 10:52:40] WARNING[20591] channel.c: Fixup failed on channel
SIP/1121-0a4b8f80, strange things may happen.
[Dec  9 10:52:40] WARNING[20591] channel.c: Hangup failed!  Strange things
may happen!
[Dec  9 10:52:40] WARNING[20591] channel.c: Masquerade failed
[Dec  9 10:52:40] WARNING[20591] channel.c: Channel 'SIP/1121-0a4b8f80'
may not have been hung up properly

At 10:53:15 my SIP provider reports an UNREACHABLE notice to me. 
I've checked immediately the customer's site and chan_sip wasn't
responding anymore.

Possible this has something to do with each other. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-12-09 08:57 tbelder        Note Added: 0114978                          
======================================================================