[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-23-2008 13:03 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. 
====================================================================== 

---------------------------------------------------------------------- 
 svnbot - 05-23-08 13:03  
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 118129

U   trunk/res/res_odbc.c

------------------------------------------------------------------------
r118129 | tilghman | 2008-05-23 13:03:09 -0500 (Fri, 23 May 2008) | 3
lines

Protect the object from changing while the 'odbc show' CLI command is
running
(Closes issue http://bugs.digium.com/view.php?id=12704)

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=118129 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
05-23-08 13:03  svnbot         Checkin                                      
05-23-08 13:03  svnbot         Note Added: 0087268                          
======================================================================