Description of problem: It looks to me like the ID for new bug reports is always +10 increased and not +1. A good example for this is bug #274481 and the right away after created bug #274491 - the bugs between them don't seem to exist. If I am right, this bug report will be ID #274501 or #274511. Version-Release number of selected component (if applicable): Bugzilla Version 2.18-rh How reproducible: For me everytime currently. Actual results: Bugzilla increases ID always +10 and not +1 Expected results: Normal behaviour like in the past?!
With our new move to a replicated MySQL server environment, we had to change the increment value to 20. This allows future growth when dealing with master to master server replication. So this would explain what you are seeing.
mysql can't actually keep the sequence ID in sync across multiple masters?
This link explains some of the reason it must be configured this way. http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html It is also well documented in the MySQL documentation but I can't find the link at the moment. We plan to have multiple masters spread around geographically in the future. The gaps you have in your primary keys determine how many masters you can have so currently this would limit us to 10. We used to have this set to 20 and since lowered it to 10. Dave