Debian Codegraph @

mysql-test/suite/galera/r/galera_bf_lock_wait.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_2;
4 call mtr.add_suppression("InnoDB: Transaction was aborted due to ");
5 call mtr.add_suppression("WSREP: Trying to continue unpaused monitor");
6 connection node_1;
7 call mtr.add_suppression("InnoDB: Transaction was aborted due to ");
8 call mtr.add_suppression("WSREP: Trying to continue unpaused monitor");
9 CREATE TABLE t1 ENGINE=InnoDB select 1 as a, 1 as b union select 2, 2;
10 ALTER TABLE t1 add primary key(a);
11 CREATE PROCEDURE p1(repeat_count INT)
12 BEGIN
13 DECLARE current_num int;
14 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION rollback;
15 SET current_num = 0;
16 WHILE current_num < repeat_count DO
17 start transaction;
18 update t1 set b=connection_id() where a=1;
19 commit;
20 SET current_num = current_num + 1;
21 END WHILE;
22 END|
23 connection node_2;
24 connect node_1_p1, 127.0.0.1, root, , test, $NODE_MYPORT_1;
25 SET SESSION wsrep_sync_wait=0;
26 call p1(1000);
27 connect node_1_p2, 127.0.0.1, root, , test, $NODE_MYPORT_1;
28 SET SESSION wsrep_sync_wait=0;
29 call p1(1000);
30 connect node_2_p1, 127.0.0.1, root, , test, $NODE_MYPORT_2;
31 SET SESSION wsrep_sync_wait=0;
32 call p1(1000);
33 connect node_2_p2, 127.0.0.1, root, , test, $NODE_MYPORT_2;
34 SET SESSION wsrep_sync_wait=0;
35 call p1(1000);
36 connection node_1;
37 checking error log for 'BF lock wait long' message for 10 times every 10 seconds ...
38 include/assert_grep.inc [BF lock wait long]
39 include/assert_grep.inc [BF lock wait long]
40 include/assert_grep.inc [BF lock wait long]
41 include/assert_grep.inc [BF lock wait long]
42 include/assert_grep.inc [BF lock wait long]
43 include/assert_grep.inc [BF lock wait long]
44 include/assert_grep.inc [BF lock wait long]
45 include/assert_grep.inc [BF lock wait long]
46 include/assert_grep.inc [BF lock wait long]
47 include/assert_grep.inc [BF lock wait long]
48 include/assert_grep.inc [BF lock wait long]
49 include/assert_grep.inc [BF lock wait long]
50 include/assert_grep.inc [BF lock wait long]
51 include/assert_grep.inc [BF lock wait long]
52 include/assert_grep.inc [BF lock wait long]
53 include/assert_grep.inc [BF lock wait long]
54 include/assert_grep.inc [BF lock wait long]
55 include/assert_grep.inc [BF lock wait long]
56 include/assert_grep.inc [BF lock wait long]
57 include/assert_grep.inc [BF lock wait long]
58 connection node_1_p1;
59 connection node_1_p2;
60 connection node_2_p1;
61 connection node_2_p2;
62 connection node_1;
63 drop table t1;
64 drop procedure p1;
65 disconnect node_1_p1;
66 disconnect node_1_p2;
67 disconnect node_2_p1;
68 disconnect node_2_p2;