[asterisk-bugs] [Asterisk 0014748]: [patch] SQL Error makes res_odbc reconnect to odbc dsn
Asterisk Bug Tracker
noreply at bugs.digium.com
Fri May 15 10:37:30 CDT 2009
The following issue requires your FEEDBACK.
======================================================================
https://issues.asterisk.org/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-05-15 10:37 CDT
======================================================================
Summary: [patch] 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.
======================================================================
----------------------------------------------------------------------
(0104833) tilghman (administrator) - 2009-05-15 10:37
https://issues.asterisk.org/view.php?id=14748#c104833
----------------------------------------------------------------------
Unfortunately, this patch fails with MySQL, a very popular choice, because
MySQL actually DOES return SQL_ERROR when a reconnect is needed:
[May 8 11:11:04] WARNING[13130]: res_odbc.c:616
ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000:
[MySQL][ODBC 3.51 Driver][mysqld-5.0.51a-3ubuntu5.4]MySQL server has gone
away (78)
So this patch won't work.
Issue History
Date Modified Username Field Change
======================================================================
2009-05-15 10:37 tilghman Note Added: 0104833
2009-05-15 10:37 tilghman Status assigned => feedback
======================================================================
More information about the asterisk-bugs
mailing list