duplicate key violates unique constraint "history_pkey"

[jantoney]

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:utHistory::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:utHistory::ERROR duplicate key violates unique constraint "history_pkey"

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

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

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

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

09:07:35.263 CallCtrl:nLegConnected :[CM503007]: Call(258): Device joined: sip:[email protected]:5060
09:07:35.263 DBPostgressAccessor:utHistory::ERROR duplicate key violates unique constraint "history_pkey"

09:07:35.263 CallCtrl:nLegConnected :[CM503007]: Call(258): Device joined: sip:[email protected]:5060
09:07:35.263 Line:rintEndpointInfo :[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:nSelectRouteReq :[CM503004]: Call(258): Calling: PSTNline:10001@[Dev:sip:[email protected]:5060]
09:07:35.153 DBPostgressAccessor:utHistory::ERROR duplicate key violates unique constraint "history_pkey"

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

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

09:07:35.122 CallCtrl:nIncomingCall :[CM503001]: Call(258): Incoming call from Ext.400 to [sip:[email protected]]

 

[karshah]

Backup 3cx using backup/restore. Be sure to grab everthing. Restore and restart. Bingo...

 

[jantoney]

Worked fine..

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!