Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
Description
Generally ALTER SEQUENCE allows one to change any values for a SEQUENCE created with CREATE SEQUENCE.
https://mariadb.com/kb/en/library/alter-sequence/
While within Galera Cluster , ALTER SEQUENCE is only effective on Master node where it got executed , doesn't get replicated to another node of Galera cluster.
On Node-01 :
|
|
MariaDB [test]> SHOW CREATE SEQUENCE seq;
|
+-------+----------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+----------------------------------------------------------------------------------------------------------------+
|
| seq | CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 1000000 increment by 0 cache 1000 nocycle ENGINE=InnoDB |
|
+-------+----------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.001 sec)
|
|
On Node-01
|
|
MariaDB [test]> ALTER SEQUENCE seq MAXVALUE = 10000 ;
|
Query OK, 0 rows affected (0.001 sec)
|
|
|
|
|
MariaDB [test]> SHOW CREATE SEQUENCE seq;
|
+-------+--------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+--------------------------------------------------------------------------------------------------------------+
|
| seq | CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 10000 increment by 0 cache 1000 nocycle ENGINE=InnoDB |
|
+-------+--------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
On Node-02
|
|
MariaDB [test]> SHOW CREATE SEQUENCE seq;
|
+-------+----------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+----------------------------------------------------------------------------------------------------------------+
|
| seq | CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 1000000 increment by 0 cache 1000 nocycle ENGINE=InnoDB |
|
+-------+----------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.001 sec)
|
|
On Node-03
|
|
MariaDB [test]> SHOW CREATE SEQUENCE seq;
|
+-------+----------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+----------------------------------------------------------------------------------------------------------------+
|
| seq | CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 1000000 increment by 0 cache 1000 nocycle ENGINE=InnoDB |
|
+-------+----------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
While DROP SEQUENCE is working fine, gets replicated across the nodes with in Galera Cluster.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
Generally ALTER SEQUENCE allows one to change any values for a SEQUENCE created with CREATE SEQUENCE.
https://mariadb.com/kb/en/library/alter-sequence/ While within Galera Cluster , ALTER SEQUENCE is only effective on Master node where it got executed , doesn't get replicated to another node of Galera cluster. On Node-01 : {code} MariaDB [test]> SHOW CREATE SEQUENCE seq; +-------+----------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+----------------------------------------------------------------------------------------------------------------+ | seq | CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 1000000 increment by 0 cache 1000 nocycle ENGINE=InnoDB | +-------+----------------------------------------------------------------------------------------------------------------+ 1 row in set (0.001 sec) On Node-01 {code} MariaDB [test]> ALTER SEQUENCE seq MAXVALUE = 10000 ; Query OK, 0 rows affected (0.001 sec) MariaDB [test]> SHOW CREATE SEQUENCE seq; +-------+--------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+--------------------------------------------------------------------------------------------------------------+ | seq | CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 10000 increment by 0 cache 1000 nocycle ENGINE=InnoDB | +-------+--------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) On Node-02 {code} MariaDB [test]> SHOW CREATE SEQUENCE seq; +-------+----------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+----------------------------------------------------------------------------------------------------------------+ | seq | CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 1000000 increment by 0 cache 1000 nocycle ENGINE=InnoDB | +-------+----------------------------------------------------------------------------------------------------------------+ 1 row in set (0.001 sec) On Node-03 {code} MariaDB [test]> SHOW CREATE SEQUENCE seq; +-------+----------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+----------------------------------------------------------------------------------------------------------------+ | seq | CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 1000000 increment by 0 cache 1000 nocycle ENGINE=InnoDB | +-------+----------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) While DROP SEQUENCE is working fine gets replicated across the nodes with in Galera Cluster. |
Generally ALTER SEQUENCE allows one to change any values for a SEQUENCE created with CREATE SEQUENCE.
https://mariadb.com/kb/en/library/alter-sequence/ While within Galera Cluster , ALTER SEQUENCE is only effective on Master node where it got executed , doesn't get replicated to another node of Galera cluster. On Node-01 : {code} MariaDB [test]> SHOW CREATE SEQUENCE seq; +-------+----------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+----------------------------------------------------------------------------------------------------------------+ | seq | CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 1000000 increment by 0 cache 1000 nocycle ENGINE=InnoDB | +-------+----------------------------------------------------------------------------------------------------------------+ 1 row in set (0.001 sec) {code} On Node-01 {code} MariaDB [test]> ALTER SEQUENCE seq MAXVALUE = 10000 ; Query OK, 0 rows affected (0.001 sec) MariaDB [test]> SHOW CREATE SEQUENCE seq; +-------+--------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+--------------------------------------------------------------------------------------------------------------+ | seq | CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 10000 increment by 0 cache 1000 nocycle ENGINE=InnoDB | +-------+--------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) {code} On Node-02 {code} MariaDB [test]> SHOW CREATE SEQUENCE seq; +-------+----------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+----------------------------------------------------------------------------------------------------------------+ | seq | CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 1000000 increment by 0 cache 1000 nocycle ENGINE=InnoDB | +-------+----------------------------------------------------------------------------------------------------------------+ 1 row in set (0.001 sec) {code} On Node-03 {code} MariaDB [test]> SHOW CREATE SEQUENCE seq; +-------+----------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+----------------------------------------------------------------------------------------------------------------+ | seq | CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 1000000 increment by 0 cache 1000 nocycle ENGINE=InnoDB | +-------+----------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) {code} While DROP SEQUENCE is working fine, gets replicated across the nodes with in Galera Cluster. |
| Fix Version/s | 10.3 [ 22126 ] | |
| Assignee | Jan Lindström [ jplindst ] |
| Assignee | Jan Lindström [ jplindst ] | Julius Goryavsky [ sysprg ] |
| Priority | Minor [ 4 ] | Major [ 3 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Julius Goryavsky [ sysprg ] | Stepan Patryshev [ stepan.patryshev ] |
| Assignee | Stepan Patryshev [ stepan.patryshev ] | Jan Lindström [ jplindst ] |
| Labels | need_feedback |
| Priority | Critical [ 2 ] | Major [ 3 ] |
| Affects Version/s | 10.3.10 [ 23140 ] | |
| Affects Version/s | 10.3.12 [ 23214 ] | |
| Issue Type | Bug [ 1 ] | Task [ 3 ] |
| Labels | need_feedback |
| Labels | feature_request |
| Assignee | Jan Lindström [ jplindst ] | Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] |
| Assignee | Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] | Jan Lindström [ jplindst ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Assignee | Jan Lindström [ jplindst ] | Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] |
jplindst, a sequence object can very well be stored in InnoDB. It is a special kind of table, which does not support locking or undo logging, but only crash safety via the redo log. The persistent state of the sequence is stored in the single row of the special table.
| Assignee | Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] | Jan Lindström [ jplindst ] |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.3 [ 22126 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Issue Type | Task [ 3 ] | Bug [ 1 ] |
| Workflow | MariaDB v3 [ 96393 ] | MariaDB v4 [ 144505 ] |
| issue.field.resolutiondate | 2022-01-10 11:52:16.0 | 2022-01-10 11:52:16.599 |
| Fix Version/s | 10.4.23 [ 26807 ] | |
| Fix Version/s | 10.5.14 [ 26809 ] | |
| Fix Version/s | 10.6.6 [ 26811 ] | |
| Fix Version/s | 10.7.2 [ 26813 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Zendesk Related Tickets | 122138 162340 |
I want more clarity to this issue as sequence object is not InnoDB object, this means that some operations do not replicate on Galera. If we want them to replicate I think we need a new feature development. Actual first DDL i.e. create should replicate already but after that depends.