[asterisk-bugs] [Asterisk 0018071]: [patch] res_config_pgsql needs db reconnection support

[Asterisk Bug Tracker]

The following issue is now READY FOR TESTING. 
====================================================================== 
https://issues.asterisk.org/view.php?id=18071 
====================================================================== 
Reported By:                kobaz
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   18071
Category:                   Resources/res_config_pgsql
Reproducibility:            have not tried
Severity:                   feature
Priority:                   normal
Status:                     ready for testing
Asterisk Version:           SVN 
JIRA:                        
Regression:                 No 
Reviewboard Link:           https://reviewboard.asterisk.org/r/944/ 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!): 289174 
Request Review:              
====================================================================== 
Date Submitted:             2010-09-28 15:32 CDT
Last Modified:              2010-09-29 11:23 CDT
====================================================================== 
Summary:                    [patch] res_config_pgsql needs db reconnection
support
Description: 
If your postgres connection died suddenly in between res_config_pgsql
queries, the query will fail because the query is executed on a
disconnected/disconnecting handle.

Reviewboard patch adds support for reconnecting and retrying the failed
query if the connection was closed while executing the query.  The patch
also removes lots of checking and duplication for handling query errors.

Ideally there should be a centralized res module for postgres connections
that cdr_pgsql and res_config_pgsql (and any other pgsql dependent module)
can use for a centralized db abstraction module.

But I believe fixing up res_config_pgsql is the first step.
====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-09-29 11:23 lmadsen        Status                   new => ready for
testing
======================================================================