--connection node_1

CREATE TABLE parent (id INT AUTO_INCREMENT PRIMARY KEY, v INT) ENGINE=InnoDB;

INSERT INTO parent VALUES (1, 1),(2, 2),(3, 3);

CREATE TABLE child (id INT AUTO_INCREMENT PRIMARY KEY, parent_id INT, CONSTRAINT parent_fk

    FOREIGN KEY (parent_id) REFERENCES parent (id)) ENGINE=InnoDB;

--connection node_2

# Start SR transaction and make it lock both parent and child tales.

SET SESSION wsrep_trx_fragment_size = 1;

START TRANSACTION;

INSERT INTO child (parent_id) VALUES (1),(2),(3);

--connection node_1

# Sync wait for SR transaction to replicate and apply fragments, thus

# locking parent table as well.

SET SESSION wsrep_sync_wait = 15;

SELECT COUNT(*) FROM child;

# Now run TOI on the parent, which BF-aborts the SR-transaction in progress.

ALTER TABLE parent AUTO_INCREMENT = 100;

2024-08-29 13:57:16 11 [Note] InnoDB: WSREP: BF lock wait long for trx:0x32 query: ALTER TABLE parent AUTO_INCREMENT = 100