connection node_2;
connection node_1;
connection node_2;
SELECT COUNT(*) = 0 FROM wsrep_schema.SR;
COUNT(*) = 0
1
connection node_1;
SELECT COUNT(*) = 0 FROM wsrep_schema.SR;
COUNT(*) = 0
1
CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
SET SESSION wsrep_trx_fragment_size = 1;
SET AUTOCOMMIT=OFF;
START TRANSACTION;
INSERT INTO t1 VALUES (1);
INSERT INTO t1 VALUES (2);
INSERT INTO t1 VALUES (3);
INSERT INTO t1 VALUES (4);
INSERT INTO t1 VALUES (5);
SELECT COUNT(*) > 0 FROM wsrep_schema.SR;
COUNT(*) > 0
1
connection node_2;
SELECT COUNT(*) > 0 FROM wsrep_schema.SR;
COUNT(*) > 0
1
connection node_2;
SET GLOBAL wsrep_cluster_address = '';
connection node_1;
INSERT INTO t1 VALUES (6);
INSERT INTO t1 VALUES (7);
INSERT INTO t1 VALUES (8);
INSERT INTO t1 VALUES (9);
INSERT INTO t1 VALUES (10);
SELECT COUNT(*) > 0 FROM wsrep_schema.SR;
COUNT(*) > 0
1
connection node_2;
SELECT COUNT(*) > 0 FROM wsrep_schema.SR;
COUNT(*) > 0
1
connection node_1;
INSERT INTO t1 VALUES (11);
INSERT INTO t1 VALUES (12);
INSERT INTO t1 VALUES (13);
INSERT INTO t1 VALUES (14);
INSERT INTO t1 VALUES (16);
COMMIT;
SELECT COUNT(*) = 0 FROM wsrep_schema.SR;
COUNT(*) = 0
1
connection node_2;
Timeout in wait_condition.inc for SELECT COUNT(*) = 15 FROM t1;
Id	User	Host	db	Command	Time	State	Info	Progress
5	system user		NULL	Daemon	NULL	InnoDB purge coordinator	NULL	0.000
6	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
7	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
8	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
9	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000
30	root	localhost:51116	test	Query	0	Init	show full processlist	0.000
36	system user		NULL	Sleep	32	wsrep aborter idle	NULL	0.000
34	system user		NULL	Sleep	32	Waiting on cond	NULL	0.000
35	system user		NULL	Sleep	32	Closing tables	NULL	0.000
SELECT COUNT(*) = 0 FROM wsrep_schema.SR;
COUNT(*) = 0
0
DROP TABLE t1;