[asterisk-bugs] [Asterisk 0016252]: ODBC Crash in 1.6.0.18-rc2

[Asterisk Bug Tracker]

The following issue requires your FEEDBACK. 
====================================================================== 
https://issues.asterisk.org/view.php?id=16252 
====================================================================== 
Reported By:                kobaz
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   16252
Category:                   Resources/res_odbc
Reproducibility:            always
Severity:                   crash
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.6.0.18-rc3 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-11-16 09:28 CST
Last Modified:              2009-11-18 10:36 CST
====================================================================== 
Summary:                    ODBC Crash in 1.6.0.18-rc2
Description: 
Doing a simple odbc query will crash asterisk

Error while executing the query (77)
[Nov 16 10:13:07] WARNING[17379]: func_odbc.c:191 generic_execute: SQL
Exec Direct failed (-1)![UPDATE asterisk.log_calls SET status = 'CALLEE
PICKUP', call_pickup_time = NOW(), caller_to_channel = 'SIP/201-00000004',
caller_to_uniqueid = '1258384379.23' WHERE call_log_id = '']
[Nov 16 10:13:07] WARNING[17379]: res_odbc.c:583 ast_odbc_direct_execute:
SQL Exec Direct failed.  Attempting a reconnect...
[Nov 16 10:13:07] DEBUG[17379]: res_odbc.c:1392 odbc_obj_disconnect:
Disconnected 0 from pbx [pbx]
[Nov 16 10:13:07] DEBUG[17379]: res_odbc.c:1400 odbc_obj_disconnect:
Database handle deallocated
[Nov 16 10:13:07] NOTICE[17379]: res_odbc.c:1427 odbc_obj_connect:
Connecting pbx
[Nov 16 10:13:07] NOTICE[17379]: res_odbc.c:1455 odbc_obj_connect:
res_odbc: Connected to pbx [pbx]
[Nov 16 10:13:07] DEBUG[17379]: res_odbc.c:1400 odbc_obj_disconnect:
Database handle deallocated
[Nov 16 10:13:07] ERROR[17379]: astobj2.c:279 __ao2_ref: refcount -1 on
object 0x81fa308
[Nov 16 10:13:07] ERROR[17379]: astobj2.c:110 INTERNAL_OBJ: user_data is
NULL

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

---------------------------------------------------------------------- 
 (0113935) lmadsen (administrator) - 2009-11-18 10:36
 https://issues.asterisk.org/view.php?id=16252#c113935 
---------------------------------------------------------------------- 
Could you describe the version of unixODBC you're using? Most of these
crashes tend to come from the systems packaged version of unixODBC which
tends to be a bit out of date. Most of the time I've seen that there is a
request for testing the latest unixODBC from unixodbc.org: 
http://www.unixodbc.org/

Would you mind giving that a shot? Thanks! 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-11-18 10:36 lmadsen        Note Added: 0113935                          
2009-11-18 10:36 lmadsen        Status                   assigned => feedback
======================================================================