[asterisk-bugs] [Asterisk 0008260]: SIP module deadlocks when PostgreSQL cdr db is overloaded

[noreply at bugs.digium.com]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=8260 
====================================================================== 
Reported By:                fugitivo
Assigned To:                file
====================================================================== 
Project:                    Asterisk
Issue ID:                   8260
Category:                   Core/Configuration
Reproducibility:            random
Severity:                   block
Priority:                   normal
Status:                     feedback
Asterisk Version:            1.2.14 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             11-01-2006 08:27 CST
Last Modified:              07-26-2007 13:54 CDT
====================================================================== 
Summary:                    SIP module deadlocks when PostgreSQL cdr db is
overloaded
Description: 
I'm experiencing random freezes for the SIP module. A sip reload doesn't do
anything and the only way to "unlock" it is restarting asterisk.
Current calls keep working, but phones are loosing registrations and can't
register anymore with asterisk until restart.
Attached you will find a FULL sip debug trace.
======================================================================
Relationships       ID      Summary
----------------------------------------------------------------------
related to          0009275 heavy traffic in postgresql cdr databas...
====================================================================== 

---------------------------------------------------------------------- 
 eliel - 07-26-07 13:54  
---------------------------------------------------------------------- 
We are facing the same problem, our first thought was that chan_sip were
getting freez because of a dns resolution. But we changed every sip
registration host with the IP and it continues to happen at heavy traffic.
We have many clients running asterisk 1.2.22 and it only happens with the
'callcenter' clients (heavy queue traffic and call-limit=1). We made a
change in update_call_counter() to reproduce the limitonpeers parameter in
1.4:

---- update_call_counter() ----
- if (!outgoing && (u = find_user(name, 1))) {
+ if (0 && !outgoing && (u = find_user(name, 1))) {
-------------------------------

This "patch" is working fine, but at some point chan_sip locks and we
can't register or generate new calls (in chan_sip), all the currently
ongoing calls continue normaly until someone hangup.
chan_zap and other modules work without problems, if we made a "reload
chan_sip.so" it locks again, and if we repeat the command it says that a
reload is already in progress.
Please 'fugitivo' tell me if you are running queue members with
call-limit. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
07-26-07 13:54  eliel          Note Added: 0067939                          
======================================================================