auto-increment-offset shouldn't be allowed to be greater than auto-increment-increment

Bug #682967 reported by Arjen Lentz
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
New
Undecided
Unassigned

Bug Description

Apart from both of these variables not allowed to be 0, auto-increment-offset should not be allowed to be greater than auto-increment-increment as that would by definition create an invalid scenario.

For startup, this could be checked after the config/cmdline params are all processed - this to prevent chucking an error in case they're specified with offset first and increment second.
For live changes, it could be checked on the spot - although I'd question the sense/need of changing such params live.

Tags: replication
description: updated
Revision history for this message
Sergei Golubchik (sergii) wrote : Re: [Bug 682967] [NEW] auto-increment-offset shouldn't be allowed to be greater than auto-increment-increment

Hi, Arjen!
>
> auto-increment-offset should not be allowed to be greater than
> auto-increment-increment as that would by definition create an invalid
> scenario.

It is not at all obvious to me that this situation "should not" be
allowed, and that it creates "by definition an invalid scenario".

Somehow I cannot derive A < B from the formula X = A + N*B.

Regards,
Sergei

Revision history for this message
Arjen Lentz (arjen-lentz) wrote :

I'd reckon you can get duplicates, as the # you get at is no longer within the safe bounds that can't be touched by another master?

Not sure about your formula re how auto-inc-offset/increment work.

Revision history for this message
Arjen Lentz (arjen-lentz) wrote :

can this request please get triaged and classified? as in, accepted as a bug report or feature request? thanks

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.