| Title | New Bugzilla bugs don't get replicated for some users |
| Status | closed |
| Priority | critical |
| Assigned user | Nick Barnes |
| Organization | Ravenbrook |
| Description | Several 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. |
| Analysis | We 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 found | customer |
| Evidence | <http://info.ravenbrook.com/mail/2001/07/03/19-24-01/0.txt> |
| Observed in | 1.1.1 |
| Introduced in | 0.5.0 |
| Created by | Nick Barnes |
| Created on | 2001-07-04 14:23:23 |
| Last modified by | Gareth Rees |
| Last modified on | 2001-12-10 19:48:44 |
| History | 2001-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. |