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

[Asterisk Bug Tracker]

The following issue has been UPDATED. 
====================================================================== 
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:                     new
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-16 12:59 CDT
====================================================================== 
Summary:                    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>

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

---------------------------------------------------------------------- 
 (0119447) lmadsen (administrator) - 2010-03-16 12:59
 https://issues.asterisk.org/view.php?id=17038#c119447 
---------------------------------------------------------------------- 
Inline patches can not be accepted on the issue tracker. Please attach your
unified diff as an attachment to this issue for inclusion in Asterisk. If
you have not already done so, please sign the electronic license agreement
which would appear as a link at the top of the page.

When doing your diff, please use 'diff -u' for the proper patch format.
Thanks! 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-03-16 12:59 lmadsen        Note Added: 0119447                          
2010-03-16 12:59 lmadsen        Description Updated                          
======================================================================