mirror of
https://github.com/MariaDB/server.git
synced 2025-09-13 13:47:59 +03:00
49 lines
1.3 KiB
Plaintext
49 lines
1.3 KiB
Plaintext
connection node_2;
|
|
connection node_1;
|
|
connection node_1;
|
|
connection node_2;
|
|
connection node_2;
|
|
call mtr.add_suppression("WSREP: Failed to scan the last segment to the end\\. Last events may be missing\\. Last recovered event: ");
|
|
connection node_1;
|
|
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE = InnoDB;
|
|
connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
|
|
connection node_1a;
|
|
SET AUTOCOMMIT=OFF;
|
|
SET SESSION wsrep_trx_fragment_size=1;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES (11),(12),(13);
|
|
connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1;
|
|
connection node_1b;
|
|
SET AUTOCOMMIT=OFF;
|
|
SET SESSION wsrep_trx_fragment_size=1;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES (21),(22),(23);
|
|
connection node_2;
|
|
connection node_1;
|
|
connection node_1a;
|
|
INSERT INTO t1 VALUES (14),(15),(16);
|
|
COMMIT;
|
|
connection node_2;
|
|
# restart
|
|
SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
|
|
COUNT(*) > 0
|
|
1
|
|
SELECT COUNT(*) AS EXPECT_6 FROM t1 WHERE f1 IN (11,12,13,14,15,16);
|
|
EXPECT_6
|
|
6
|
|
connection node_1b;
|
|
INSERT INTO t1 VALUES (24),(25),(26);
|
|
COMMIT;
|
|
connection node_2;
|
|
SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
|
|
EXPECT_0
|
|
0
|
|
SELECT COUNT(*) AS EXPECT_12 FROM t1;
|
|
EXPECT_12
|
|
12
|
|
connection node_1;
|
|
SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
|
|
EXPECT_0
|
|
0
|
|
DROP TABLE t1;
|