[asterisk-dev] system completely hangs after executing an ODBC function

Theo Belder tbelder at gmail.com
Fri Nov 27 07:09:07 CST 2009


Hi,

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. No message will shown up. 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.


Can anyone point me out what causes the whole system hangs?



dialplan:
-------------
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,Set(PCMEXT=${ODBC_CST(SELECT nr FROM viewextensiondata WHERE nr
= '422' LIMIT 1)})
exten = h,n,Hangup

func_odbc.conf:
-----------------------
[CST]
dsn=cst
read=${ARG1}


Best regards,
Theo Belder
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-dev/attachments/20091127/f07e2de0/attachment.htm 


More information about the asterisk-dev mailing list