[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-04 02:07 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.

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

---------------------------------------------------------------------- 
 (0114718) tbelder (reporter) - 2009-12-04 02:07
 https://issues.asterisk.org/view.php?id=16349#c114718 
---------------------------------------------------------------------- 
This dialplan works fine:
exten = 422,1,Noop(MAKE A CALL)
exten = 422,n,Set(PCMEXT=${ODBC_CST(SELECT nr FROM viewextensiondata
WHERE
nr = '422' LIMIT 1)})
exten = 422,n,Dial(SIP/422)

exten = h,1,Noop(HANGUP)
exten = h,n,Hangup


This will hang your system:
exten = 422,1,Noop(MAKE A CALL)
exten = 422,n,Dial(SIP/422)

exten = h,1,Noop(HANGUP)
exten = h,n,Set(PCMEXT=${ODBC_CST(SELECT nr FROM viewextensiondata WHERE
nr
= '422' LIMIT 1)})
exten = h,n,Hangup


Only when executing an ODBC function in the h extension fails.
This problem is introduced in version 1.4.22, in version 1.4.21 this
problem did not occured. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-12-04 02:07 tbelder        Note Added: 0114718                          
======================================================================