| Summary: | ASTERISK-12280: Asterisk can not insert CDRs into cd table due to incorrect column name quoting... | ||
| Reporter: | Oleksandr Panchuk (panolex) | Labels: | |
| Date Opened: | 2008-06-30 07:01:11 | Date Closed: | 2008-06-30 08:05:42 |
| Priority: | Major | Regression? | No |
| Status: | Closed/Complete | Components: | CDR/cdr_pgsql |
| Versions: | Frequency of Occurrence | ||
| Related Issues: | |||
| Environment: | Attachments: | ||
| 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. ****** ADDITIONAL INFORMATION ****** Asterisk: SVN-trunk-r126511 System: Gentoo Linux, latest Database postgresql-8.3.3 | ||
| Comments: | By: Sean Bright (seanbright) 2008-06-30 07:22:14 Could you run the following command and report back the results: asterisk -rx "core show version" By: Oleksandr Panchuk (panolex) 2008-06-30 07:55:55 Rechecked on r126516 - works without errors. | ||