[asterisk-bugs] [Asterisk 0010341]: Blocking Asterisk is connection to server disappears

[noreply at bugs.digium.com]

The following issue has been RESOLVED. 
====================================================================== 
http://bugs.digium.com/view.php?id=10341 
====================================================================== 
Reported By:                cpina
Assigned To:                qwell
====================================================================== 
Project:                    Asterisk
Issue ID:                   10341
Category:                   Addons/app_addon_sql_mysql
Reproducibility:            always
Severity:                   crash
Priority:                   normal
Status:                     resolved
Asterisk Version:            1.2.23  
SVN Branch (only for SVN checkouts, not tarball releases): N/A  
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
Resolution:                 suspended
Fixed in Version:           
====================================================================== 
Date Submitted:             07-31-2007 02:16 CDT
Last Modified:              08-17-2007 14:34 CDT
====================================================================== 
Summary:                    Blocking Asterisk is connection to server disappears
Description: 
mysql_ping function is used in cdr_addon_mysql.c. This function blocks the
module if connection is dropped "in some ways" (when network doesn't return
any ICMP notification). It is a known problem with mysql_ping. 

Way to reproduce: setup an Asterisk and configure the CDRs to Mysql server
using cdr_addon_mysql, then execute:
route add -host MYSQL_IP_SERVER gw 127.0.0.1
And try to do some more calls.

This Asterisk will not be able to do any more call, stop now will not stop
Asterisk, killall asterisk will not kill (only killall -9 asterisk).

It has mainly happened to us when we had a connectivity problem in Mysql
server network.

Patch is in Additional Information.

Note: we are using cdr_mysql_addon with this patch:
http://www.uglyboxindustries.com/cdr_addon_mysql.patch
Anyway, original cdr_mysql_addon is using mysql_ping in the same way with
the same problem.
====================================================================== 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
08-17-07 14:34  qwell          Status                   new => resolved     
08-17-07 14:34  qwell          Resolution               open => suspended   
08-17-07 14:34  qwell          Assigned To               => qwell           
======================================================================