Debian Codegraph @

mysql-test/suite/galera/t/galera_sp_insert_parallel.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=InnoDB;
5
6
7 DELIMITER |;
8 CREATE PROCEDURE proc_insert()
9 BEGIN
10 DECLARE i INT;
11 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
12
13 SET i = 0;
14 WHILE i < 1000 DO
15 INSERT IGNORE INTO t1 (f1, f2)
16 VALUES (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15)),
17 (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15)),
18 (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15)),
19 (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15)),
20 (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15)),
21 (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15)),
22 (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15)),
23 (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15)),
24 (FLOOR(1 + RAND() * 65535), FLOOR(1 + RAND() * 15));
25 SET i = i + 1;
26
27 END WHILE;
28 END|
29 DELIMITER ;|
30
31 --connection node_1
32 SELECT 0;
33 SET SESSION wsrep_sync_wait = 0;
34 --send CALL proc_insert
35 --connection node_2
36 SELECT 0;
37 SET SESSION wsrep_sync_wait = 0;
38 --send CALL proc_insert
39
40 --connection node_1
41 --error 0,ER_LOCK_DEADLOCK,ER_QUERY_INTERRUPTED
42 --disable_warnings
43 --reap
44 --enable_warnings
45 SET SESSION wsrep_sync_wait = default;
46 --connection node_2
47 --error 0,ER_LOCK_DEADLOCK,ER_QUERY_INTERRUPTED
48 --disable_warnings
49 --reap
50 --enable_warnings
51 SET SESSION wsrep_sync_wait = default;
52
53 --connection node_1
54 DROP PROCEDURE proc_insert;
55 DROP TABLE t1;