[asterisk-bugs] [Asterisk 0017038]: [patch] Insert fails when database initialized during connection outage to postgres server

[Asterisk Bug Tracker]

The following issue NEEDS LICENSE. 
====================================================================== 
https://issues.asterisk.org/view.php?id=17038 
====================================================================== 
Reported By:                pk16208
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   17038
Category:                   CDR/cdr_pgsql
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     needs license
Asterisk Version:           1.6.0.26 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-03-16 08:00 CDT
Last Modified:              2010-03-17 10:04 CDT
====================================================================== 
Summary:                    [patch] Insert fails when database initialized
during connection outage to postgres server
Description: 
When asterisk starts up or reload the cdr_pgsql does not work properly when
the database connection fails during startup.
These results in a empty server record list and no cdr's are logged and
reconnect does not resolve the problem

In the case of AST_RWLIST_EMPTY(&psql_columns) 
the databse connection has to be closed completely and a complete
reinitialization is necessery.
The following patch will do the job:

<inline patch removed by lmadsen>

====================================================================== 

---------------------------------------------------------------------- 
 (0119508) lmadsen (administrator) - 2010-03-17 10:04
 https://issues.asterisk.org/view.php?id=17038#c119508 
---------------------------------------------------------------------- 
Just waiting on license approval. Thanks! 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-03-17 10:04 lmadsen        Note Added: 0119508                          
2010-03-17 10:04 lmadsen        Status                   feedback => needs
license
======================================================================