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

Inconsistency in Galera cluster while running add drop column

Details

    Description

      The load was running on a single node in a 3 node cluster. 3 threads were executing DML with only concurrent add and drop column causes inconsistency between the nodes.

      2023-11-08 7:16:13 0 [Note] WSREP: Votes over a52d165a-7e06-11ee-bede-afb796da4be7:33835:
      f99cf43909114ded: 1/3
      Waiting for more votes.
      2023-11-08 7:16:13 0 [Note] WSREP: Member 1(node2) initiates vote on a52d165a-7e06-11ee-bede-afb796da4be7:33835,f99cf43909114ded:
      2023-11-08 7:16:13 0 [Note] WSREP: Votes over a52d165a-7e06-11ee-bede-afb796da4be7:33835:
      f99cf43909114ded: 2/3
      Winner: f99cf43909114ded
      2023-11-08 7:16:13 7 [Note] WSREP: Got vote request for seqno a52d165a-7e06-11ee-bede-afb796da4be7:33835
      2023-11-08 7:16:13 0 [Note] WSREP: Recovering vote result from history: a52d165a-7e06-11ee-bede-afb796da4be7:33835,f99cf43909114ded

      To reproduce run pstress with below option. for compling refer pstress 

      pstress-md --address=127.0.0.1 --user=test --password=testpass --database=pstress  --pk-prob=100 --no-enc --threads=3 --no-tbs --undo-tbs-count=0 --no-virtual --no-table-compression --row-format=none --grammar-sql=0 --no-column-compression --only-cl-ddl --add-column=10 --drop-column=10 --no-temp-tables --no-partition-tables --port=$PORT_NODE1 --seconds=20 --seed=08112023

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33064 ALTER INPLACE running TOI doesn't abort a DML operation in InnoDB

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33064 ALTER INPLACE running TOI doesn't abort a DML operation in InnoDB

          • Major - Major loss of function.
          • Closed

          Activity

            Descending order - Click to sort in ascending order
            sysprg Julius Goryavsky added a comment -

            The fix has been merged with the head revision: https://github.com/MariaDB/server/commit/b7718a1c1cf40f4b15263c27861c3f712cf8a62a

            sysprg Julius Goryavsky added a comment - The fix has been merged with the head revision: https://github.com/MariaDB/server/commit/b7718a1c1cf40f4b15263c27861c3f712cf8a62a
            marko Marko Mäkelä added a comment -

            I would like to see a MariaDB Server 10.6 version of this, or to know if 10.6 is at all affected. In addition to some low-level locking changes (MDEV-20612, MDEV-24738), DDL operations in 10.6 should acquire exclusive table locks around FOREIGN KEY constraints, and previous work-arounds for insufficient locking (including MDEV-21175) were removed.

            marko Marko Mäkelä added a comment - I would like to see a MariaDB Server 10.6 version of this, or to know if 10.6 is at all affected. In addition to some low-level locking changes ( MDEV-20612 , MDEV-24738 ), DDL operations in 10.6 should acquire exclusive table locks around FOREIGN KEY constraints, and previous work-arounds for insufficient locking (including MDEV-21175 ) were removed.

            People

              sysprg Julius Goryavsky
              rahulmalik Rahul (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.