[asterisk-bugs] [Asterisk 0015864]: idle odbc connections are not cleaned up

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=15864 
====================================================================== 
Reported By:                kobaz
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   15864
Category:                   Resources/res_odbc
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.6.0.14 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-09-09 09:49 CDT
Last Modified:              2009-09-10 16:50 CDT
====================================================================== 
Summary:                    idle odbc connections are not cleaned up
Description: 
When using queries defined in func_odbc, asterisk will periodically
'forget' about connections it's already made, and will think it's
disconnected with the database.

The query will fail for some reason, even though a connection is already
present.  A new connection will be made.  The old connection is not cleaned
up.  And after a while the max connection limit on the server is hit and
asterisk can't make any more odbc connections.

I'm not sure if this is a problem with the unixodbc driver, or with
asterisk.  My short term fix is a script that runs around killing old idle
postgres connections from asterisk.
====================================================================== 

---------------------------------------------------------------------- 
 (0110538) tilghman (administrator) - 2009-09-10 16:50
 https://issues.asterisk.org/view.php?id=15864#c110538 
---------------------------------------------------------------------- 
Perhaps we should start with the statement "The query will fail for some
reason,".  Let's see the messages output when the query fails for some
reason. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-09-10 16:50 tilghman       Note Added: 0110538                          
======================================================================