[asterisk-bugs] [Asterisk 0011798]: [patch] Idle check for res_odbc

[noreply at bugs.digium.com]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=11798 
====================================================================== 
Reported By:                Corydon76
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   11798
Category:                   Resources/res_odbc
Reproducibility:            always
Severity:                   feature
Priority:                   normal
Status:                     new
Asterisk Version:           SVN 
SVN Branch (only for SVN checkouts, not tarball releases):  trunk 
SVN Revision (number only!): 98978 
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             01-19-2008 12:03 CST
Last Modified:              01-21-2008 01:16 CST
====================================================================== 
Summary:                    [patch] Idle check for res_odbc
Description: 
When a database connection remains idle for too long, it may sometimes
become stale.  This patch makes Asterisk more proactive in the approach, in
that we can set a max idle time, at which res_odbc will automatically
reconnect instead of waiting for a query to fail first.  This should
improve some performance, as well as eliminating ugly logs about the
database connection having timed out.
====================================================================== 

---------------------------------------------------------------------- 
 mvanbaak - 01-21-08 01:16  
---------------------------------------------------------------------- 
We can see this as a bug.
I know the bug is actually in the mysql driver for ODBC, but it's nice to
have a workaround in asterisk.

I wont be able to look at patching 1.4 for the next 12 hours, so I bet
you'll have it committed before I return to my pc. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
01-21-08 01:16  mvanbaak       Note Added: 0080926                          
======================================================================