mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
138 lines
4.3 KiB
Text
138 lines
4.3 KiB
Text
connection node_2;
|
|
connection node_1;
|
|
SET SESSION wsrep_sync_wait = 0;
|
|
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT, f2 LONGBLOB) ENGINE=InnoDB;
|
|
CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
|
|
INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
|
|
CREATE PROCEDURE insert_simple ()
|
|
BEGIN
|
|
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
|
|
SET SESSION wsrep_sync_wait = 0;
|
|
WHILE 1 DO
|
|
INSERT INTO t1 (f1, f2) VALUES (DEFAULT,'abcdef');
|
|
END WHILE;
|
|
END|
|
|
CREATE PROCEDURE insert_multi ()
|
|
BEGIN
|
|
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
|
|
SET SESSION wsrep_sync_wait = 0;
|
|
WHILE 1 DO
|
|
INSERT INTO t1 (f1) VALUES (DEFAULT),(DEFAULT),(DEFAULT),(DEFAULT),(DEFAULT),(DEFAULT),(DEFAULT),(DEFAULT),(DEFAULT),(DEFAULT);
|
|
END WHILE;
|
|
END|
|
|
CREATE PROCEDURE insert_transaction ()
|
|
BEGIN
|
|
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
|
|
SET SESSION wsrep_sync_wait = 0;
|
|
SET AUTOCOMMIT = OFF;
|
|
WHILE 1 DO
|
|
START TRANSACTION;
|
|
INSERT INTO t1 (f1) VALUES (DEFAULT);
|
|
INSERT INTO t1 (f1) VALUES (DEFAULT);
|
|
INSERT INTO t1 (f1) VALUES (DEFAULT);
|
|
INSERT INTO t1 (f1) VALUES (DEFAULT);
|
|
INSERT INTO t1 (f1) VALUES (DEFAULT);
|
|
INSERT INTO t1 (f1) VALUES (DEFAULT);
|
|
INSERT INTO t1 (f1) VALUES (DEFAULT);
|
|
INSERT INTO t1 (f1) VALUES (DEFAULT);
|
|
INSERT INTO t1 (f1) VALUES (DEFAULT);
|
|
INSERT INTO t1 (f1) VALUES (DEFAULT);
|
|
COMMIT;
|
|
END WHILE;
|
|
END|
|
|
CREATE PROCEDURE update_simple ()
|
|
BEGIN
|
|
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
|
|
SET SESSION wsrep_sync_wait = 0;
|
|
WHILE 1 DO
|
|
UPDATE t1 SET f2 = CONCAT(f2,f2);
|
|
END WHILE;
|
|
END|
|
|
CREATE PROCEDURE insert_1k ()
|
|
BEGIN
|
|
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
|
|
SET SESSION wsrep_sync_wait = 0;
|
|
WHILE 1 DO
|
|
INSERT INTO t1 (f2) VALUES (REPEAT('x', 1024));
|
|
END WHILE;
|
|
END|
|
|
CREATE PROCEDURE insert_1m ()
|
|
BEGIN
|
|
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
|
|
SET SESSION wsrep_sync_wait = 0;
|
|
WHILE 1 DO
|
|
INSERT INTO t1 (f2) VALUES (REPEAT('x', 1024 * 1024));
|
|
END WHILE;
|
|
END|
|
|
CREATE PROCEDURE insert_10m ()
|
|
BEGIN
|
|
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
|
|
SET SESSION wsrep_sync_wait = 0;
|
|
WHILE 1 DO
|
|
INSERT INTO t1 (f2) VALUES (REPEAT('x', 1024 * 1024 * 10));
|
|
END WHILE;
|
|
END|
|
|
connect node_1_insert_simple, 127.0.0.1, root, , test, $NODE_MYPORT_1;
|
|
connect node_1_insert_multi, 127.0.0.1, root, , test, $NODE_MYPORT_1;
|
|
connect node_1_insert_transaction, 127.0.0.1, root, , test, $NODE_MYPORT_1;
|
|
connect node_1_update_simple, 127.0.0.1, root, , test, $NODE_MYPORT_1;
|
|
connect node_1_insert_1k, 127.0.0.1, root, , test, $NODE_MYPORT_1;
|
|
connect node_1_insert_1m, 127.0.0.1, root, , test, $NODE_MYPORT_1;
|
|
connect node_1_insert_10m, 127.0.0.1, root, , test, $NODE_MYPORT_1;
|
|
connection node_1_insert_simple;
|
|
CALL insert_simple();;
|
|
connection node_1_insert_multi;
|
|
CALL insert_multi();;
|
|
connection node_1_insert_transaction;
|
|
CALL insert_transaction ();;
|
|
connection node_1_update_simple;
|
|
CALL update_simple ();;
|
|
connection node_1_insert_1k;
|
|
CALL insert_1k ();;
|
|
connection node_1_insert_1m;
|
|
CALL insert_1m ();;
|
|
connection node_1_insert_10m;
|
|
CALL insert_10m ();;
|
|
connection node_2;
|
|
SET SESSION wsrep_sync_wait = 0;
|
|
Killing server ...
|
|
connection node_1;
|
|
Killing server ...
|
|
connection node_1_insert_simple;
|
|
Got one of the listed errors
|
|
connection node_1_insert_multi;
|
|
Got one of the listed errors
|
|
connection node_1_insert_transaction;
|
|
Got one of the listed errors
|
|
connection node_1_update_simple;
|
|
Got one of the listed errors
|
|
connection node_1_insert_1k;
|
|
Got one of the listed errors
|
|
connection node_1_insert_1m;
|
|
Got one of the listed errors
|
|
connection node_1_insert_10m;
|
|
Got one of the listed errors
|
|
connection node_1;
|
|
Performing --wsrep-recover ...
|
|
Using --wsrep-start-position when starting mysqld ...
|
|
connection node_2;
|
|
Performing --wsrep-recover ...
|
|
Using --wsrep-start-position when starting mysqld ...
|
|
connection node_1;
|
|
include/diff_servers.inc [servers=1 2]
|
|
connection node_1;
|
|
DROP TABLE t1;
|
|
DROP TABLE ten;
|
|
DROP PROCEDURE insert_simple;
|
|
DROP PROCEDURE insert_multi;
|
|
DROP PROCEDURE insert_transaction;
|
|
DROP PROCEDURE update_simple;
|
|
DROP PROCEDURE insert_1k;
|
|
DROP PROCEDURE insert_1m;
|
|
connection node_1;
|
|
call mtr.add_suppression("Error in Log_event::read_log_event\\(\\)");
|
|
CALL mtr.add_suppression("conflict state 7 after post commit");
|
|
CALL mtr.add_suppression("Skipped GCache ring buffer recovery");
|
|
connection node_2;
|
|
call mtr.add_suppression("Error in Log_event::read_log_event\\(\\)");
|
|
CALL mtr.add_suppression("Skipped GCache ring buffer recovery");
|