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

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
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 12:57 CDT
====================================================================== 
Summary:                    [patch] 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})}'



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

---------------------------------------------------------------------- 
 (0105439) ajohnson (reporter) - 2009-05-26 12:57
 https://issues.asterisk.org/view.php?id=15196#c105439 
---------------------------------------------------------------------- 
(gdb) p *obj
$3 = {lock = {__data = {__lock = 0, __count = 0, __owner = 0, __kind = -1,
__nusers = 0, {__spins = 0, __list = {__next = 0x0}}}, __size = '\0'
<repeats 12 times>, "ÿÿÿÿ\000\000\000\000\000\000\000",
    __align = 0}, con = 0x0, parent = 0x0, last_used = {tv_sec =
1243351070, tv_usec = 853497}, used = 1, up = 0, tx = 0, txf = 0x0, list =
{next = 0x0}}
(gdb)


(gdb) p *(obj->parent)
Cannot access memory at address 0x0
(gdb) 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-05-26 12:57 ajohnson       Note Added: 0105439                          
======================================================================