Details
Description
Wsrep system threads (schema and appliers) should be able to run in a transaction read-only context.
Such MTR test should pass:
--source include/galera_cluster.inc
|
--source include/have_innodb.inc
|
--source include/big_test.inc
|
|
|
# Restart the node 2 in transaction_read_only mode.
|
--connection node_2
|
--source include/shutdown_mysqld.inc
|
--let $start_mysqld_params=--transaction_read_only=TRUE
|
--source include/start_mysqld.inc
|
|
|
--connection node_1
|
CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
|
INSERT INTO t1 VALUES (1);
|
|
|
--connection node_2
|
SELECT COUNT(*) = 1 AS EXPECT_1 FROM t1;
|
|
|
# Restart the node 2 in normal mode.
|
--connection node_2
|
--source include/shutdown_mysqld.inc
|
--let $start_mysqld_params=
|
--source include/start_mysqld.inc
|
|
|
# Cleanup
|
--connection node_1
|
DROP TABLE t1;
|