[MDEV-32738] Inconsistency in Galera cluster while running add drop column Created: 2023-11-09  Updated: 2023-12-27

Status: In Testing
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.4.32
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Rahul Assignee: Julius Goryavsky
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MDEV-33064 ALTER INPLACE running TOI doesn't abo... In Testing
Relates
relates to MDEV-33064 ALTER INPLACE running TOI doesn't abo... In Testing

 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



 Comments   
Comment by Marko Mäkelä [ 2023-12-07 ]

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.

Generated at Thu Feb 08 10:33:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.