MySQL Error log Duplicate entry

[Iz3k34l]

This is the error from the log

Code: Select all

2014-07-26 12:48:36|agi-VDAD_ALL_outbound.agi|01103||1062|Duplicate entry '1406396902.151335' for key 'PRIMARY'|INSERT INTO vicidial_log (uniqueid,lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed,alt_dial,list_id) values('1406396902.151335','10950158','ZCIN','2014-07-26 12:48:36','1406396916','LRERR','1','3364752851','VDAD','N','NONE','629834')|V7261248220010950158|10950158|


What causes this other than the obvious 'duplicate entry', how can this be fixed or should i 'silence' the error to output.

Thanks

[williamconley]

Find the cause of the error. I note that the status is LRERR. What was the situation with this call? This may represent an actual problem (agent closed his browser ...) that should be addressed. Or it may merely represent the system being careful to close out a call without dropping any information (which may result in duplication in situations that are abnormal, such as an agent workstation crashing).

Or upgrade to a more recent Vicidial (which may resolve the error).

You may find that this entry actually is a duplicate but may be necessary to avoid missing data in some circumstances. In which case, you can avoid the error by modifying the "insert" into an insert with "on duplicate ..." to allow completion without an error.

But I'd start with an upgrade.

[Iz3k34l]

Thanks william, i found this in the error logs while looking for solutions to particular problems and didn't know the relevance of this error. Your response however leads to a topic i have been wondering about, since i have clustered servers is there a process for upgrading to the latest version, IE: the database first and if upgrading what about custom work done to the various pages will that be overwritten?

[geoff3dmg]

Upgrade the database first then the web/telephony servers. If you have customisations you should maintain your own patch files (if they are useful to everyone I'd suggest you submit them as enhancements in the bug tracker).