[asterisk-bugs] [Asterisk 0018243]: Random segfault when querying MySQL via func_odbc

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=18243 
====================================================================== 
Reported By:                ks3
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   18243
Category:                   Functions/func_odbc
Reproducibility:            random
Severity:                   crash
Priority:                   normal
Status:                     new
Asterisk Version:           1.6.2.13 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-11-02 13:30 CDT
Last Modified:              2010-11-04 03:43 CDT
====================================================================== 
Summary:                    Random segfault when querying MySQL via func_odbc
Description: 
For the past couple months, our two Asterisk servers crash (at different
times) about once a week, and the last entries in the console log are calls
to some of our func_odbc functions. Within the last couple weeks, these
crashes have increased to about every day, sometimes 2-3 times per day.
====================================================================== 

---------------------------------------------------------------------- 
 (0128601) wdoekes (reporter) - 2010-11-04 03:43
 https://issues.asterisk.org/view.php?id=18243#c128601 
---------------------------------------------------------------------- 
I can confirm part of the problem. It is however not random. It exists in
both 1.4 and 1.6 (probably 1.8 too).

Whenever a query fails (in my case usually if I forget to add a view and
asterisk therefore cannot select on it), the asterisk odbc link thinks the
link may be down. It then attempts to reconnect.

However, if someone else does a query while it is reconnecting, the handle
is pointing to garbage and it crashes in libodbc.

Try setting pooling=no. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-11-04 03:43 wdoekes        Note Added: 0128601                          
======================================================================