[asterisk-bugs] [Asterisk 0014748]: SQL Error makes res_odbc reconnect to odbc dsn

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=14748 
====================================================================== 
Reported By:                aurs
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   14748
Category:                   Resources/res_odbc
Reproducibility:            unable to reproduce
Severity:                   crash
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.4.23 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-03-25 08:09 CDT
Last Modified:              2009-03-25 17:58 CDT
====================================================================== 
Summary:                    SQL Error makes res_odbc reconnect to odbc dsn
Description: 
In res_odbc.c, lines 98-133, there is a section that disconnects, and
reconnects to the database. This *might* have caused a crash... More info
in additional info. Not sure how to reproduce/debug this.
====================================================================== 

---------------------------------------------------------------------- 
 (0102197) aurs (reporter) - 2009-03-25 17:58
 http://bugs.digium.com/view.php?id=14748#c102197 
---------------------------------------------------------------------- 
Steps used to reproduce:
1. create a dialplan (example in extensions.conf uploaded here)with a sql
that fails (insert a string to a integer field), and several SQLs that is
ok (just a SELECT on a row that exists)
2. copy 10-20 sample call files (like the one attached) to
/var/spool/asterisk/outbound
3. hammer the server with asterisk -rx "dial s at bugfinder"
4. Got 2 core files after a while 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-03-25 17:58 aurs           Note Added: 0102197                          
======================================================================