Debian Codegraph @

mysql-test/suite/galera/r/MW-329F.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER, f2 CHAR(20) DEFAULT 'abc') ENGINE=InnoDB;
4 INSERT INTO t1 (f1) VALUES (1),(65535);
5 CREATE PROCEDURE proc_insert (repeat_count int)
6 BEGIN
7 DECLARE current_num int;
8 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
9 SET current_num = 0;
10 SET SESSION wsrep_sync_wait = 0;
11 WHILE current_num < repeat_count do
12 INSERT INTO t1 (f1) VALUES (FLOOR( 1 + RAND( ) * 65535 ));
13 SELECT SLEEP(0.1);
14 SET current_num = current_num + 1;
15 END WHILE;
16 END|
17 connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1;
18 connection node_1b;
19 connection node_1b;
20 connection node_1;
21 DROP PROCEDURE proc_insert;
22 DROP TABLE t1;
23 disconnect node_1b;
24 CALL mtr.add_suppression("WSREP: .* conflict state after post commit ");
25 set global innodb_status_output=Default;