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

[Matt Jordan (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-17689?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Matt Jordan closed ASTERISK-17689.
----------------------------------

    Resolution: Duplicate
    
> 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