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

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
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:07 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>

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

---------------------------------------------------------------------- 
 (0119509) pk16208 (reporter) - 2010-03-17 10:07
 https://issues.asterisk.org/view.php?id=17038#c119509 
---------------------------------------------------------------------- 
The attached patch seems to work (at least the last days in our test
configuration), but is not a really well designed solution.
More something to show the problem and what has to be done to resolve it 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-03-17 10:07 pk16208        Note Added: 0119509                          
======================================================================