duplicate key violates unique constraint

Discussion in '3CX Phone System - General' started by 5qg4, Jun 22, 2007.

Thread Status:
Not open for further replies.
  1. 5qg4

    5qg4 Active Member

    Joined:
    Jan 31, 2007
    Messages:
    643
    Likes Received:
    0
    I got this error after upgraded to Version 3.1-BETA Build 2295 17th June 2007. Please advice.

    22:06:47.953 DBPostgressAccessor::putHistory ERROR: duplicate key violates unique constraint "history_pkey"
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. 3CXsupport

    3CXsupport New Member
    3CX Support

    Joined:
    Aug 21, 2006
    Messages:
    193
    Likes Received:
    0
    Hi what version did you upgrade from ?

    It seems someting is amiss in your history table. You may need to fix your database or a more simple solution would be to install over your old database and restore a backup (if you posses one)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. 5qg4

    5qg4 Active Member

    Joined:
    Jan 31, 2007
    Messages:
    643
    Likes Received:
    0
    It upgraded from Build v3.0.1928.0 - 27th April 2007

    The problem seems fixed by restore a backup config file.

    The error message seems not found again.

    I would like to know that error will cause any impact to the phone system. Since the phone system working fine even the error appear.

    Thanks.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. 3CXsupport

    3CXsupport New Member
    3CX Support

    Joined:
    Aug 21, 2006
    Messages:
    193
    Likes Received:
    0
    That error is pointing towards trouble in your history table.

    Try generating call logs and see what happens. If a restore fixed it and you call logs are fine I would say that you can rest assured that the issue is resolved.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. 5qg4

    5qg4 Active Member

    Joined:
    Jan 31, 2007
    Messages:
    643
    Likes Received:
    0
    Yes. The issue should be resolved. There is no abnormal transition at call log, it seems normal.

    Thanks.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Thread Status:
Not open for further replies.