[MDEV-704] LP:682967 - auto-increment-offset shouldn't be allowed to be greater than auto-increment-increment Created: 2010-11-30  Updated: 2022-09-08

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.30, 5.1.67, 5.2.14, 5.3.12
Fix Version/s: 5.5

Type: Bug Priority: Minor
Reporter: Arjen Lentz (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: Launchpad, verified

Attachments: XML File LPexportBug682967.xml    

 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.

 Comments   
Comment by Sergei Golubchik [ 2010-12-27 ]

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

Comment by Arjen Lentz (Inactive) [ 2010-12-29 ]

Re: auto-increment-offset shouldn't be allowed to be greater than auto-increment-increment
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.

Comment by Arjen Lentz (Inactive) [ 2011-07-08 ]

Re: auto-increment-offset shouldn't be allowed to be greater than auto-increment-increment
can this request please get triaged and classified? as in, accepted as a bug report or feature request? thanks

Comment by Rasmus Johansson (Inactive) [ 2011-07-09 ]

Launchpad bug id: 682967

Comment by Elena Stepanova [ 2013-03-27 ]

>> Re: auto-increment-offset shouldn't be allowed to be greater than auto-increment-increment
>> 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?

I'm not sure how much danger is there in reality, since "If the value of auto_increment_offset is greater than that of auto_increment_increment, the value of auto_increment_offset is ignored." (http://dev.mysql.com/doc/refman/5.1/en/replication-options-master.html#sysvar_auto_increment_offset)

Anyway, valid or not, it's a FR, not a bug, moving to Tasks.

Generated at Thu Feb 08 06:30:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.