mariadb/mysql-test/suite/galera_sr/r/MDEV-35281.result at 10.6-mdev-35765-st_overlaps-wrong-result - mirror/mariadb - May the force be without you: git.fucktheforce.de

mirror/mariadb

mirror of https://github.com/MariaDB/server.git synced 2025-02-05 13:22:17 +01:00

Daniele Sciascia e821c9fa7c MDEV-35281 SR transaction crashes with innodb_snapshot_isolation

Ignore snapshot isolation conflict during fragment removal, before
streaming transaction commits. This happens when a streaming
transaction creates a read view that precedes the INSERTion of
fragments into the streaming_log table. Fragments are INSERTed
using a different transaction. These fragment are then removed
as part of COMMIT of the streaming transaction. This fragment
removal operation could fail when the fragments were not part
the transaction's read view, thus violating snapshot isolation.

2024-11-29 08:06:32 +01:00

9 lines

255 B

Text

Raw Permalink Blame History

 connection node_2;
 connection node_1;
 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
 SET SESSION wsrep_trx_fragment_size=1;
 SET SESSION innodb_snapshot_isolation=ON;
 START TRANSACTION WITH CONSISTENT SNAPSHOT;
 INSERT INTO t1 VALUES (1);
 COMMIT;
 DROP TABLE t1;