Bug 400761 - Bug number increased by 10, not one?
Summary: Bug number increased by 10, not one?
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Bugzilla
Classification: Community
Component: Creating/Changing Bugs
Version: devel
Hardware: All
OS: Linux
low
low
Target Milestone: ---
Assignee: PnT DevOps Devs
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2007-11-27 11:25 UTC by Mamoru TASAKA
Modified: 2013-06-24 02:13 UTC (History)
0 users

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2007-11-27 13:22:03 UTC
Embargoed:


Attachments (Terms of Use)

Description Mamoru TASAKA 2007-11-27 11:25:25 UTC
Description of problem:
It seems recently when we create new bug report, bug number
seems to increase by 10, not one?

Example A:
bug 380081 and bug 380091 .
Bug reports says that I created the latter bug 0 seconds after
the former...

Example B.
I checked bug 400001 - 400011 and bug 400002 through 400010
does not exist, however 400011 exists.

Additional info:
Around bug 200000, bug number seems to increase by one.

Comment 1 Noura El hawary 2007-11-27 13:22:03 UTC
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.

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.


Note You need to log in before you can comment on or make changes to this bug.