| 1 |
connection node_2; |
| 2 |
connection node_1; |
| 3 |
connection node_1; |
| 4 |
connection node_2; |
| 5 |
connection node_3; |
| 6 |
connection node_1; |
| 7 |
SET GLOBAL innodb_max_dirty_pages_pct=0.0; |
| 8 |
SET GLOBAL innodb_max_dirty_pages_pct_lwm=0.0; |
| 9 |
SET GLOBAL innodb_max_dirty_pages_pct=99; |
| 10 |
SET GLOBAL innodb_max_dirty_pages_pct_lwm=99; |
| 11 |
CREATE TABLE t1 (f1 INTEGER, f2 varchar(1024)) Engine=InnoDB; |
| 12 |
CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB; |
| 13 |
INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10); |
| 14 |
INSERT INTO t1 (f2) SELECT REPEAT('x', 1024) FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4; |
| 15 |
FLUSH TABLES WITH READ LOCK; |
| 16 |
UNLOCK TABLES; |
| 17 |
connection node_2; |
| 18 |
SELECT COUNT(*) FROM t1; |
| 19 |
COUNT(*) |
| 20 |
10000 |
| 21 |
SELECT COUNT(*) FROM ten; |
| 22 |
COUNT(*) |
| 23 |
10 |
| 24 |
Killing node #3 to free ports for garbd ... |
| 25 |
connection node_3; |
| 26 |
connection node_1; |
| 27 |
SET GLOBAL debug_dbug = "+d,sync.wsrep_donor_state"; |
| 28 |
Starting garbd ... |
| 29 |
SET SESSION debug_sync = "now WAIT_FOR sync.wsrep_donor_state_reached"; |
| 30 |
SET GLOBAL innodb_max_dirty_pages_pct_lwm=0.0; |
| 31 |
SET GLOBAL innodb_max_dirty_pages_pct=0.0; |
| 32 |
SET SESSION debug_sync = "now SIGNAL signal.wsrep_donor_state"; |
| 33 |
SET GLOBAL debug_dbug = ""; |
| 34 |
SET debug_sync='RESET'; |
| 35 |
connection node_1; |
| 36 |
Killing garbd ... |
| 37 |
connection node_1; |
| 38 |
connection node_2; |
| 39 |
DROP TABLE t1; |
| 40 |
DROP TABLE ten; |
| 41 |
Restarting node #3 to satisfy MTR's end-of-test checks |
| 42 |
connection node_3; |
| 43 |
connection node_1; |