P4DTI issue job000345

TitleNew Bugzilla bugs don't get replicated for some users
Assigned userNick Barnes
DescriptionSeveral Bugzilla 2.12 users have reported to Perforce support that newly created Bugzilla bugs don't get replicated to Perforce, and that they need to touch new bugs to get the replicator to see them.
AnalysisWe couldn't reproduce this at Ravenbrook using MySQL 3.22.32. Installing MySQL 3.23.37 triggered it immediately. It is caused by a bug in MySQL version 3.23.37 (and possibly other versions, but that's the one we found it in) which causes MySQL to process LEFT JOIN queries incorrectly in some cases. See job000354 for the details.
The fact that everyone who saw this bug was using Bugzilla 2.12 was a red herring: it happened to be coincidence that Bugzilla 2.12 came out at the same time as the buggy MySQL release, so people using one would install the other.
How foundcustomer
Observed in1.1.1
Introduced in0.5.0
Created byNick Barnes
Created on2001-07-04 14:23:23
Last modified byGareth Rees
Last modified on2001-12-10 19:48:44
History2001-07-04 NB Created.
2001-07-10 NB Added debug instructions.
2001-07-16 GDR Added cause.
2001-07-18 NB Cleaned up analysis now that we understand this better.


Change Effect Date User Description
14183 closed 2001-07-16 18:12:12 Gareth Rees Replicate new bugs in Bugzilla even in buggy MySQL versions like 3.23.37.