[asterisk-bugs] [Asterisk 0015196]: Asterisk crash when using ODBC to insert record on table that does not exist

[Asterisk Bug Tracker]

The following issue has been SUBMITTED. 
====================================================================== 
https://issues.asterisk.org/view.php?id=15196 
====================================================================== 
Reported By:                ajohnson
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   15196
Category:                   Functions/func_odbc
Reproducibility:            always
Severity:                   crash
Priority:                   normal
Status:                     assigned
Asterisk Version:           1.6.2.0-beta2 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-05-26 10:35 CDT
Last Modified:              2009-05-26 10:35 CDT
====================================================================== 
Summary:                    Asterisk crash when using ODBC to insert record on
table that does not exist
Description: 
When using func_odbc to insert a record into a table that does not exist,
asterisk will crash after attempting to reconnect to the database.  I have
not tested this in other error scenarios.

MySQL Server version: mysql-server.x86_64 5.0.45-7.el5

unixODBC.i386       2.2.11-7.1
unixODBC-devel.i386 2.2.11-7.1

func_odbc.conf
[SET]
prefix=DB
dsn=mysql
writesql = INSERT INTO asterisk.CallVariables (uid,name,value) VALUES
('${SQL_ESC(${ARG1})}','${SQL_ESC(${VAL1})}','${SQL_ESC(${VAL2})}')
writesql += ON DUPLICATE KEY UPDATE value='${SQL_ESC(${VAL2})}'



====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-05-26 10:35 ajohnson       New Issue                                    
2009-05-26 10:35 ajohnson       Status                   new => assigned     
2009-05-26 10:35 ajohnson       Assigned To               => tilghman        
2009-05-26 10:35 ajohnson       Asterisk Version          => 1.6.2.0-beta2   
2009-05-26 10:35 ajohnson       Regression                => No              
2009-05-26 10:35 ajohnson       SVN Branch (only for SVN checkouts, not tarball
releases) => N/A             
======================================================================