[asterisk-bugs] [Asterisk 0011427]: Asterisk crashes when using ODBC connected to Sybase

[noreply at bugs.digium.com]

The following issue has been CLOSED 
====================================================================== 
http://bugs.digium.com/view.php?id=11427 
====================================================================== 
Reported By:                blitzrage
Assigned To:                Corydon76
====================================================================== 
Project:                    Asterisk
Issue ID:                   11427
Category:                   Resources/res_odbc
Reproducibility:            random
Severity:                   crash
Priority:                   normal
Status:                     closed
Asterisk Version:            1.4.14  
SVN Branch (only for SVN checkouts, not tarball releases): N/A  
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
Resolution:                 no change required
Fixed in Version:           
====================================================================== 
Date Submitted:             11-30-2007 10:38 CST
Last Modified:              11-30-2007 11:19 CST
====================================================================== 
Summary:                    Asterisk crashes when using ODBC connected to Sybase
Description: 
Asterisk appears to crash at various times throughout the day when using
ODBC connected to a Sybase database. It seems to be when it tries to
reconnect to the database, but fails, then causes a crash(?)

I've attached a backtrace from the machine in question.

Here is a copy of the configuration files:

res_odbc.conf:
;; odbc setup file
[asterisk]
enabled => yes
dsn => Sybase-cl
username => xxxxxxx
password => xxxxxxx
pre-connect => yes

odbc.ini
[Sybase-cl]
Description     = Sybase ODBC Data Source
UserID          = xxxxxx
Password        = xxxxxx
Driver          = Adaptive Server Enterprise
Server          = 10.1.1.1
Port            = 4300
Database        = xxxxxx
UseCursor       = 1

odbcinst.ini
[Adaptive Server Enterprise]
Description             = Sybase ODBC Driver
Driver                  =
/usr/local/sybase/DataAccess/ODBC/lib/libsybdrvodb.so
FileUsage               = 1
====================================================================== 

---------------------------------------------------------------------- 
 Corydon76 - 11-30-07 11:19  
---------------------------------------------------------------------- 
Config error.  "pooling => yes" needs to be turned on.  Sybase is just like
MS SQL Server (same codebase). 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
11-30-07 11:19  Corydon76      Note Added: 0074607                          
11-30-07 11:19  Corydon76      Status                   assigned => closed  
11-30-07 11:19  Corydon76      Resolution               open => no change
required
======================================================================