Red Hat Bugzilla – Bug 400761
Bug number increased by 10, not one?
Last modified: 2013-06-23 22:13:39 EDT
Description of problem:
It seems recently when we create new bug report, bug number
seems to increase by 10, not one?
bug 380081 and bug 380091 .
Bug reports says that I created the latter bug 0 seconds after
I checked bug 400001 - 400011 and bug 400002 through 400010
does not exist, however 400011 exists.
Around bug 200000, bug number seems to increase by one.
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.
This link explains some of the reason it must be configured this way.
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
since lowered it to 10.