[asterisk-bugs] [Asterisk 0019250]: Asterisk res_odbc causes SEGFAULT's if unable to connect to server.

[Asterisk Bug Tracker]

The following issue requires your FEEDBACK. 
====================================================================== 
https://issues.asterisk.org/view.php?id=19250 
====================================================================== 
Reported By:                seadweller
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   19250
Category:                   Resources/res_odbc
Reproducibility:            always
Severity:                   crash
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.6.2.18 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2011-05-08 09:38 CDT
Last Modified:              2011-05-09 08:47 CDT
====================================================================== 
Summary:                    Asterisk res_odbc causes SEGFAULT's if unable to
connect to server.
Description: 
I have res_odbc.conf configured with both a local and remote DSN.  If
connectivity is lost to the either the local remote DSN, Asterisk
SEGFAULT's.

Was seeing this issue intermittently, but when I place an IPTABLES rule to
block outbound ODBC connections to the remote DSN or disable the local
MySQL server, Asterisk will crash each time I start it up.

I also only tested with the local MySQL DSN listed in res_odbc.conf and
odbc.ini and still had the same crashed with the local MySQL turned off.

A related bug is that it seems sometimes Asterisk loses contact with the
local MySQL connection (via /var/lib/mysql/mysql.sock) and that also
triggers this connection crash.

Desired outcome is that Asterisk should continue to run and periodically
attempt reconnects.

CentOS 5.6 x86_64
Asterisk 1.6.2.18
MySQL 5.5.11
MySQL ODBC Connector 5.1.8

Full BT's attached.
====================================================================== 

---------------------------------------------------------------------- 
 (0134646) lmadsen (administrator) - 2011-05-09 08:47
 https://issues.asterisk.org/view.php?id=19250#c134646 
---------------------------------------------------------------------- 
I am seeing some <value optimized out> which leads me to believe you don't
have DONT_OPTIMIZE enabled in the Compiler Flags of menuselect.

Could you enable that flag, recompile and reinstall Asterisk, then
reproduce the error, followed by providing the backtraces again? That may
help the developers further.

Thanks! 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-05-09 08:47 lmadsen        Note Added: 0134646                          
2011-05-09 08:47 lmadsen        Status                   new => feedback     
======================================================================