[asterisk-bugs] [Asterisk 0012952]: Asterisk can not insert CDRs into cd table due to incorrect column name quoting...

[noreply at bugs.digium.com]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=12952 
====================================================================== 
Reported By:                panolex
Assigned To:                seanbright
====================================================================== 
Project:                    Asterisk
Issue ID:                   12952
Category:                   CDR/cdr_pgsql
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     assigned
Asterisk Version:           SVN 
SVN Branch (only for SVN checkouts, not tarball releases): 1.6.0 
SVN Revision (number only!): 126511 
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             06-30-2008 07:01 CDT
Last Modified:              06-30-2008 07:22 CDT
====================================================================== 
Summary:                    Asterisk can not insert CDRs into cd table due to
incorrect column name quoting...
Description: 
When Asterisk is trying to insert CDR, here is problem:
[Jun 30 14:51:24] ERROR[3669]: cdr_pgsql.c:297 pgsql_log: cdr_pgsql:
Failed to insert call detail record into database!
[Jun 30 14:51:24] ERROR[3669]: cdr_pgsql.c:298 pgsql_log: cdr_pgsql:
Reason: ERROR:  column "accountcode,"src" of relation "cdr" does not exist
LINE 1: INSERT INTO cdr ("accountcode,""src","dst","dcontext","clid"...
                         ^

[Jun 30 14:51:24] ERROR[3669]: cdr_pgsql.c:299 pgsql_log: cdr_pgsql:
Connection may have been lost... attempting to reconnect.
[Jun 30 14:51:24] ERROR[3669]: cdr_pgsql.c:302 pgsql_log: cdr_pgsql:
Connection reestablished.
[Jun 30 14:51:24] ERROR[3669]: cdr_pgsql.c:308 pgsql_log: cdr_pgsql: HARD
ERROR!  Attempted reconnection failed.  DROPPING CALL RECORD!
[Jun 30 14:51:24] ERROR[3669]: cdr_pgsql.c:309 pgsql_log: cdr_pgsql:
Reason: ERROR:  column "accountcode,"src" of relation "cdr" does not exist
LINE 1: INSERT INTO cdr ("accountcode,""src","dst","dcontext","clid"...
                         ^

[Jun 30 14:51:54] WARNING[3669]: app_macro.c:201 _macro_exec: No such
context 'macro-stdexten' for macro 'stdexten'
[Jun 30 14:51:54] ERROR[3669]: cdr_pgsql.c:297 pgsql_log: cdr_pgsql:
Failed to insert call detail record into database!
[Jun 30 14:51:54] ERROR[3669]: cdr_pgsql.c:298 pgsql_log: cdr_pgsql:
Reason: ERROR:  column "accountcode,"src" of relation "cdr" does not exist
LINE 1: INSERT INTO cdr ("accountcode,""src","dst","dcontext","clid"...
                         ^

[Jun 30 14:51:54] ERROR[3669]: cdr_pgsql.c:299 pgsql_log: cdr_pgsql:
Connection may have been lost... attempting to reconnect.
[Jun 30 14:51:54] ERROR[3669]: cdr_pgsql.c:302 pgsql_log: cdr_pgsql:
Connection reestablished.
[Jun 30 14:51:54] ERROR[3669]: cdr_pgsql.c:308 pgsql_log: cdr_pgsql: HARD
ERROR!  Attempted reconnection failed.  DROPPING CALL RECORD!
[Jun 30 14:51:54] ERROR[3669]: cdr_pgsql.c:309 pgsql_log: cdr_pgsql:
Reason: ERROR:  column "accountcode,"src" of relation "cdr" does not exist
LINE 1: INSERT INTO cdr ("accountcode,""src","dst","dcontext","clid"...


seems like column name "accountcode" does not quoted correctly.

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

---------------------------------------------------------------------- 
 seanbright - 06-30-08 07:22  
---------------------------------------------------------------------- 
Could you run the following command and report back the results:

asterisk -rx "core show version" 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
06-30-08 07:22  seanbright     Note Added: 0089426                          
======================================================================