mirror of
https://github.com/MariaDB/server.git
synced 2025-12-04 19:35:43 +01:00
ab8b424c22
This contains test case changes only. 1) Make sure InnoDB buffer pool has no dirty pages at begining 2) Use FTWRL to ensure tables are flushed to disk 3) Add wait condition to ensure tables and rows are replicated in the cluster 4) Use sort to ensure same order of the files in the find
43 lines
1.3 KiB
Text
43 lines
1.3 KiB
Text
connection node_2;
|
|
connection node_1;
|
|
connection node_1;
|
|
connection node_2;
|
|
connection node_3;
|
|
connection node_1;
|
|
SET GLOBAL innodb_max_dirty_pages_pct=0.0;
|
|
SET GLOBAL innodb_max_dirty_pages_pct_lwm=0.0;
|
|
SET GLOBAL innodb_max_dirty_pages_pct=99;
|
|
SET GLOBAL innodb_max_dirty_pages_pct_lwm=99;
|
|
CREATE TABLE t1 (f1 INTEGER, f2 varchar(1024)) Engine=InnoDB;
|
|
CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
|
|
INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
|
|
INSERT INTO t1 (f2) SELECT REPEAT('x', 1024) FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
|
|
FLUSH TABLES WITH READ LOCK;
|
|
UNLOCK TABLES;
|
|
connection node_2;
|
|
SELECT COUNT(*) FROM t1;
|
|
COUNT(*)
|
|
10000
|
|
SELECT COUNT(*) FROM ten;
|
|
COUNT(*)
|
|
10
|
|
Killing node #3 to free ports for garbd ...
|
|
connection node_3;
|
|
connection node_1;
|
|
SET GLOBAL debug_dbug = "+d,sync.wsrep_donor_state";
|
|
Starting garbd ...
|
|
SET SESSION debug_sync = "now WAIT_FOR sync.wsrep_donor_state_reached";
|
|
SET GLOBAL innodb_max_dirty_pages_pct_lwm=0.0;
|
|
SET GLOBAL innodb_max_dirty_pages_pct=0.0;
|
|
SET SESSION debug_sync = "now SIGNAL signal.wsrep_donor_state";
|
|
SET GLOBAL debug_dbug = "";
|
|
SET debug_sync='RESET';
|
|
connection node_1;
|
|
Killing garbd ...
|
|
connection node_1;
|
|
connection node_2;
|
|
DROP TABLE t1;
|
|
DROP TABLE ten;
|
|
Restarting node #3 to satisfy MTR's end-of-test checks
|
|
connection node_3;
|
|
connection node_1;
|