Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19353

Alter Sequence do not replicate to another nodes with in Galera Cluster

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 10.3.10, 10.3.12
    • Fix Version/s: 10.3
    • Component/s: Galera, Sequences
    • Labels:
      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

            People

            Assignee:
            sysprg Julius Goryavsky
            Reporter:
            pramod.mahto@mariadb.com Pramod Mahto
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated: