duplicate key violates unique constraint "history_pkey"

Discussion in '3CX Phone System - General' started by jantoney, Feb 4, 2008.

Thread Status:
Not open for further replies.
  1. jantoney

    Joined:
    Nov 20, 2007
    Messages:
    60
    Likes Received:
    0
    Hey,
    since my upgrade to 3CX V5.0.3790.0 from an earlier version of V5 i have been getting these logs in the 'SERVER STATUS' screen....
    any clues on a resolution?

    DBPostgressAccessor::putHistory::ERROR duplicate key violates unique constraint "history_pkey"

    3CX might log up to 10 times during a short 5 second phone call....?

    FULL SHORT PHONE CALL LOG09:07:53.090 Call::Terminate :[CM503008]: Call(258): Call is terminated
    09:07:53.090 Call::Terminate :[CM503008]: Call(258): Call is terminated
    09:07:53.090 DBPostgressAccessor::putHistory::ERROR duplicate key violates unique constraint "history_pkey"

    09:07:53.090 DBPostgressAccessor::putHistory::ERROR duplicate key violates unique constraint "history_pkey"

    09:07:53.090 DBPostgressAccessor::putHistory::ERROR duplicate key violates unique constraint "history_pkey"

    09:07:53.090 DBPostgressAccessor::putHistory::ERROR duplicate key violates unique constraint "history_pkey"

    09:07:35.263 DBPostgressAccessor::putHistory::ERROR duplicate key violates unique constraint "history_pkey"

    09:07:35.263 CallCtrl::eek:nLegConnected :[CM503007]: Call(258): Device joined: sip:10002@192.168.1.59:5060
    09:07:35.263 DBPostgressAccessor::putHistory::ERROR duplicate key violates unique constraint "history_pkey"

    09:07:35.263 CallCtrl::eek:nLegConnected :[CM503007]: Call(258): Device joined: sip:400@192.168.1.53:5060
    09:07:35.263 Line::printEndpointInfo :[CM505002]: Gateway:[Line2] Device info: Device Not Identified: User Agent not matched; Capabilities:[reinvite, replaces, able-no-sdp, recvonly] UserAgent: [Linksys/SPA3102-5.1.5(GWa)] Transport: [sip:192.168.1.19:5060]
    09:07:35.169 CallCtrl::eek:nSelectRouteReq :[CM503004]: Call(258): Calling: PSTNline:10001@[Dev:sip:10001@192.168.1.55:5060]
    09:07:35.153 DBPostgressAccessor::putHistory::ERROR duplicate key violates unique constraint "history_pkey"

    09:07:35.153 CallCtrl::eek:nSelectRouteReq :[CM503004]: Call(258): Calling: PSTNline:10002@[Dev:sip:10002@192.168.1.59:5060]
    09:07:35.122 DBPostgressAccessor::putHistory::ERROR duplicate key violates unique constraint "history_pkey"

    09:07:35.122 DBPostgressAccessor::putHistory::ERROR duplicate key violates unique constraint "history_pkey"

    09:07:35.122 CallCtrl::eek:nIncomingCall :[CM503001]: Call(258): Incoming call from Ext.400 to [sip:00418603000@192.168.1.19]
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. karshah

    Joined:
    Dec 21, 2007
    Messages:
    5
    Likes Received:
    0
    Backup 3cx using backup/restore. Be sure to grab everthing. Restore and restart. Bingo...
     
  3. jantoney

    Joined:
    Nov 20, 2007
    Messages:
    60
    Likes Received:
    0
    Worked fine.. :p

    So for other users...
    go to BACKUP/RESTORE in the 3CX control pannel...
    Select ALL the tick boxes under BACKUP.
    Click backup and save the resulting file somewhere that you remember
    Once saved click BROWSE under the RESTORE headding
    Select the file
    Click Restore

    You shouldn't need to restart however it is advisable.

    any probs post back!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Thread Status:
Not open for further replies.