[asterisk-bugs] [JIRA] (ASTERISK-17689) Duplicate columns retireved for CEL/PostgreSQL & multiple schemas

Tue Jan 15 10:19:45 CST 2013

    [ https://issues.asterisk.org/jira/browse/ASTERISK-17689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=201525#comment-201525 ] 

Matt Jordan commented on ASTERISK-17689:
----------------------------------------

Per the Asterisk maintenance timeline page at http://www.asterisk.org/asterisk-versions maintenance (bug) support for the 1.4 and 1.6.x branches has ended. For continued maintenance support please move to the 1.8 branch which is a long term support (LTS) branch. For more information about branch support, please see https://wiki.asterisk.org/wiki/display/AST/Asterisk+Versions.  After testing with Asterisk 1.8, if you find this problem has not been resolved, please open a new issue against Asterisk 1.8.

This appears to be a duplicate of ASTERISK-15475, which was fixed in 1.6.2. If this issue persists in 1.8+, please let a bug marshal know in #asterisk-bugs and we can reopen this issue. Thanks!

> Duplicate columns retireved for CEL/PostgreSQL & multiple schemas
> -----------------------------------------------------------------
>
>                 Key: ASTERISK-17689
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-17689
>             Project: Asterisk
>          Issue Type: Bug
>          Components: CEL/cel_pgsql
>            Reporter: Anthony Messina
>            Severity: Minor
>
> When connecting to PostgreSQL which has separate schemas (one per asterisk host, in my case), but identical CEL tables, the following duplication of columns occurs in Asterisk 1.8.3.2:
> [Apr 12 13:44:50] ERROR[26844] cel_pgsql.c: Connection may have been lost... attempting to reconnect.
> [Apr 12 13:44:50] ERROR[26844] cel_pgsql.c: Connection reestablished.
> [Apr 12 13:44:50] ERROR[26844] cel_pgsql.c: HARD ERROR!  Attempted reconnection failed.  DROPPING CALL RECORD!
> [Apr 12 13:44:50] ERROR[26844] cel_pgsql.c: Reason: ERROR:  column "id" specified more than once
> LINE 1: INSERT INTO chicago.cel ("id","id","eventtype","eventtype","...
> ****** ADDITIONAL INFORMATION ******
> This seems similar to what was described here: https://issues.asterisk.org/view.php?id=16655

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira