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

noreply at bugs.digium.com noreply at bugs.digium.com
Mon Jul 2 09:34:05 CDT 2007


email_notification_title_for_status_bug_feedback 
====================================================================== 
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?:         
Request Review:              
====================================================================== 
Date Submitted:             11-01-2006 08:27 CST
Last Modified:              07-02-2007 09:34 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...
====================================================================== 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
11-01-06 08:27  fugitivo       New Issue                                    
11-01-06 08:27  fugitivo       Issue Monitored: fugitivo                    
11-01-06 08:53  fugitivo       File Added: cli_debug.txt.gz                    
11-01-06 10:32  fugitivo       Note Added: 0053681                          
11-02-06 10:29  francesco_r    Note Added: 0053817                          
11-02-06 12:19  alamantia      Relationship added       related to 0008204  
11-03-06 11:13  alamantia      Note Added: 0053911                          
11-03-06 11:13  alamantia      Status                   new => closed       
11-03-06 11:13  alamantia      Resolution               open => duplicate   
12-05-06 15:25  fugitivo       Status                   closed => feedback  
12-05-06 15:25  fugitivo       Resolution               duplicate => reopened
12-05-06 15:25  fugitivo       Note Added: 0055927                          
12-05-06 15:29  serge-v        Note Added: 0055928                          
12-05-06 15:29  serge-v        Relationship deleted     related to 0008204  
12-05-06 16:09  fugitivo       Note Added: 0055931                          
12-05-06 16:13  serge-v        Note Added: 0055932                          
12-05-06 16:22  fugitivo       Note Added: 0055933                          
12-06-06 08:10  serge-v        Status                   feedback => new     
12-06-06 10:28  oej            Note Added: 0055980                          
12-06-06 10:37  fugitivo       Note Added: 0055982                          
12-06-06 11:42  serge-v        Note Added: 0055995                          
12-06-06 12:13  fugitivo       Note Added: 0055998                          
12-06-06 13:06  serge-v        Summary                  SIP module freezes =>
SIP module freezes (Agents and AMI involved)
12-06-06 13:56  oej            Note Added: 0056010                          
12-29-06 13:43  fugitivo       Note Added: 0057001                          
01-02-07 09:52  serge-v        Note Added: 0057080                          
02-13-07 15:02  ffs            Issue Monitored: ffs                         
02-15-07 11:48  oej            Note Added: 0059370                          
02-15-07 11:48  oej            Status                   new => feedback     
02-15-07 16:15  fugitivo       Note Added: 0059394                          
02-16-07 05:31  oej            Note Added: 0059433                          
02-16-07 05:32  oej            Summary                  SIP module freezes
(Agents and AMI involved) => SIP module freezes when realtime subsystem locks up
(postgres)
02-16-07 05:32  oej            Project                  Asterisk-GUI => @12@
02-16-07 05:33  oej            Category                 General => config   
02-16-07 05:49  fugitivo       Note Added: 0059437                          
02-19-07 09:48  serge-v        Note Added: 0059591                          
02-19-07 11:54  oej            Note Added: 0059618                          
02-19-07 12:04  fugitivo       Note Added: 0059625                          
03-06-07 09:56  serge-v        Note Added: 0060411                          
03-18-07 12:59  fugitivo       Note Added: 0061013                          
03-30-07 09:43  serge-v        Relationship added       related to 0009275  
03-30-07 09:48  serge-v        Asterisk Version          =>  1.2.14         
03-30-07 09:48  serge-v        Note Added: 0061722                          
03-30-07 09:48  serge-v        version                   => 1.2.14          
03-30-07 09:48  serge-v        Summary                  SIP module freezes when
realtime subsystem locks up (postgres) => SIP module deadlocks when PostgreSQL
cdr db is overloaded
04-25-07 12:41  fugitivo       Note Added: 0062663                          
05-26-07 14:05  cazimmy        Issue Monitored: cazimmy                     
05-26-07 14:14  cazimmy        Note Added: 0064031                          
05-27-07 14:51  festr          Issue Monitored: festr                       
06-07-07 13:18  russell        Status                   feedback => resolved
06-07-07 13:18  russell        Resolution               reopened => suspended
06-07-07 13:18  russell        Assigned To               => russell         
06-07-07 13:18  russell        Note Added: 0064741                          
06-07-07 13:18  russell        Status                   resolved => closed  
06-07-07 13:26  fugitivo       Status                   closed => feedback  
06-07-07 13:26  fugitivo       Resolution               suspended => reopened
06-07-07 13:26  fugitivo       Note Added: 0064742                          
06-07-07 13:41  russell        Note Added: 0064746                          
06-07-07 13:54  fugitivo       Note Added: 0064748                          
06-27-07 15:29  file           Note Added: 0065792                          
06-27-07 15:57  russell        Status                   feedback => assigned
======================================================================




More information about the Asterisk-bugs mailing list