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

[noreply at bugs.digium.com]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=10341 
====================================================================== 
Reported By:                cpina
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   10341
Category:                   Addons/app_addon_sql_mysql
Reproducibility:            always
Severity:                   crash
Priority:                   normal
Status:                     new
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:              
====================================================================== 
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.
====================================================================== 

---------------------------------------------------------------------- 
 qwell - 08-17-07 14:34  
---------------------------------------------------------------------- 
According to the mysql documentation at
http://dev.mysql.com/doc/refman/5.0/en/mysql-options.html, this option only
exists in version 5.0.13 and higher.  It defaults to off in 5.0.3 and
higher.

Additionally, we use mysql_ping as a way to force a reconnect.

I expect that Asterisk will not stop new calls from being made in 1.4. 
Please test 1.4, and reopen if you can still reproduce the call blocking
aspect of this. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
08-17-07 14:34  qwell          Note Added: 0069011                          
======================================================================