P4DTI issue job000283

TitleBugzilla integration may fail on startup on a fast server
Statusclosed
Prioritycritical
Assigned userNick Barnes
OrganizationRavenbrook
DescriptionIf a Bugzilla replicator starts up in under a second, it can fail due to a MySQL consistency check (because we have two identical entries in a "unique" index).
The error message looks like this:
IntegrityError: (1062, "Duplicate entry '2001-03-28 15:26:47-replicator0-perforce0' for key 1")
AnalysisMake the "unique" index (of the p4dti_replications table) non-unique.
How foundcustomer
Evidence<URL: http://info.ravenbrook.com/mail/2001/03/28/23-31-03/0.txt>
Observed in1.0.5
Introduced in0.5.0
Created byNick Barnes
Created on2001-03-29 10:57:47
Last modified byGareth Rees
Last modified on2001-12-10 19:36:35
History2001-03-29 NB Created.

Fixes

Change Effect Date User Description
10804 closed 2001-03-29 13:47:30 Nick Barnes Add restriction on value of 'end' field when finishing a replication (job000283).
10791 open 2001-03-29 11:02:57 Nick Barnes Make p4dti_replications index non-unique (job000283).