[asterisk-bugs] [Asterisk 0016110]: slow ODBC database completely LOCK chan_sip

[Asterisk Bug Tracker]

The following issue has been CLOSED 
====================================================================== 
https://issues.asterisk.org/view.php?id=16110 
====================================================================== 
Reported By:                vrban
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   16110
Category:                   Applications/app_voicemail/ODBC
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     closed
Asterisk Version:           1.4.27-rc2 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
Resolution:                 open
Fixed in Version:           
====================================================================== 
Date Submitted:             2009-10-21 11:30 CDT
Last Modified:              2009-10-22 08:46 CDT
====================================================================== 
Summary:                    slow ODBC database completely LOCK chan_sip
Description: 
Hi,

Perform regular at "do_monitor" takes a bad
Connection to the voice mail to an ODBC database LOCK, while taking the
Asterisk SIP packets to any other. Provoke can do that with
increased duration to connect to the database, permission to load the
Database (import SQL dump)
====================================================================== 

---------------------------------------------------------------------- 
 (0112611) lmadsen (administrator) - 2009-10-22 08:46
 https://issues.asterisk.org/view.php?id=16110#c112611 
---------------------------------------------------------------------- 
Based on the IRC discussion here, I believe this will only be resolved in
1.6.1.0+ and not fixable in 1.6.0 and 1.4.

<wildzero-cw> hello, when sip_send_mwi_to_peer in chan_sip (*1.4-svn) is
called and i use odbc voicemail, and the odbc SELECT is slow (let's say
1000ms) then _entire_ chan_sip goes to sleep 1000ms, and the  Recv-Q gets
crowded, also see issue 16110, that's dump

<file> same goes for realtime when querying the DB.

<kpfleming> wildzero-cw: you won't have that problem in 1.6.1.0 and later,
because SIP MWI no longer polls the database each time, it's event based

<kpfleming> it's not likely to be fixable in 1.4 and 1.6.0, without moving
the MWI sending operations of chan_sip into their own thread

<kpfleming> and of course, an ODBC database that takes 1+ seconds to
respond is going to cause problems all over the place 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-10-22 08:46 lmadsen        Note Added: 0112611                          
2009-10-22 08:46 lmadsen        Status                   new => closed       
======================================================================