[asterisk-bugs] [Asterisk 0012704]: ODBC connections are not being pooled or reused.

[noreply at bugs.digium.com]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=12704 
====================================================================== 
Reported By:                falves11
Assigned To:                Corydon76
====================================================================== 
Project:                    Asterisk
Issue ID:                   12704
Category:                   Resources/res_odbc
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     feedback
Asterisk Version:           SVN 
SVN Branch (only for SVN checkouts, not tarball releases):  trunk 
SVN Revision (number only!): 117297 
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             05-21-2008 16:15 CDT
Last Modified:              05-21-2008 17:36 CDT
====================================================================== 
Summary:                    ODBC connections are not being pooled or reused.
Description: 
This is what I observe after using version 117297 in production: the number
of connections grow about 60 a day, but I have just a few calls open on the
server. If they were reused, the max amount of connections should not grow
to more tha maybe 20 or less, since I don't need to hit the database at the
same time. So there is a loose end here somewhere. The pool does not reuse
the connections properly or cannnot tell if they are idle. 
====================================================================== 

---------------------------------------------------------------------- 
 Corydon76 - 05-21-08 17:36  
---------------------------------------------------------------------- 
For that crash, let's try this patch. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
05-21-08 17:36  Corydon76      Note Added: 0087186                          
======================================================================