mariadb/mysql-test/suite/galera/r/MDEV-38073.result
Denis Protivensky 48f04bba78 MDEV-38073: Always use tx_read_only=false for Wsrep system threads
Apparently, there was a separate issue with applier thread variables:
wsrep_plugins_post_init() would overwrite thd->variables for every
applier thread and forget to restore proper read only context.
Then, upon every server transaction termination,
trans_reset_one_shot_statistics() would set thread's read only context
to the one stored in thd->variables, thus spoiling the read only
context value for appliers.
2025-11-18 11:10:59 +02:00

17 lines
364 B
Text

connection node_2;
connection node_1;
connection node_2;
connection node_1;
CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
SET SESSION wsrep_trx_fragment_size=1;
START TRANSACTION;
INSERT INTO t1 VALUES (1);
INSERT INTO t1 VALUES (2);
COMMIT;
connection node_2;
SELECT COUNT(*) = 2 FROM t1;
COUNT(*) = 2
1
connection node_2;
connection node_1;
DROP TABLE t1;