R 4061 (HY000): Sequence 'test.t1' values are conflicting

ALTER SEQUENCE s1 MINVALUE 10 RESTART 10;
ERROR 4061 (HY000): Sequence 'test.t1' values are conflicting

ALTER SEQUENCE s1 MINVALUE 10 START 10 RESTART 10;

INSERT
------

To allow SEQUENCE objects to be backed up by old tools, like mariadb-dump, one
can use SELECT to read the current state of a SEQUENCE object and use an
INSERT to update the SEQUENCE object. INSERT is only allowed if all fields are
specified:

CREATE SEQUENCE s1;
INSERT INTO s1 VALUES(1000,10,2000,1005,1,1000,0,0);
SELECT * FROM s1;

+------------+-----------+-----------+-------+-----------+-------+-------+-----
-+
| next_value | min_value | max_value | start | increment | cache | cycle |
round |
+------------+-----------+-----------+-------+-----------+-------+-------+-----
-+
|       1000 |        10 |      2000 |  1005 |         1 |  1000 |     0 |    
0 |
+------------+-----------+-----------+-------+-----------+-------+-------+-----
-+

SHOW CREATE SEQUENCE s1;
+-------+----------------------------------------------------------------------
---------------------------------------+
| Table | Create Table                                                        
                    |
+-------+----------------------------------------------------------------------
---------------------------------------+
| s1    | CREATE SEQUENCE `s1` start with 1005 minvalue 10 maxvalue 2000
increment by 1 cache 1000 nocycle ENGINE=Aria |
+-------+----------------------------------------------------------------------
---------------------------------------+

Notes
-----

ALTER SEQUENCE will instantly affect all future SEQUENCE operations. This is
in contrast to some other databases where the changes requested by ALTER
SEQUENCE will not be seen until the sequence cache has run out.

ALTER SEQUENCE will take a full table lock of the sequence object during its
(brief) operation. This ensures that ALTER SEQUENCE is replicated correctly.
If you only want to set the next sequence value to a higher value than
current, then you should use SETVAL() instead, as this is not blocking.

If you want to change storage engine, sequence comment or rename the sequence,
you can use ALTER TABLE for this.

URL: https://mariadb.com/kb/en/alter-sequence/https://mariadb.com/kb/en/alter-sequence/