Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
4 CREATE TABLE t2 (id INT PRIMARY KEY) ENGINE=InnoDB;
5 connection node_2;
6 SET GLOBAL wsrep_slave_threads = 2;
7 LOCK TABLE t1 READ;
8 connection node_1;
9 INSERT INTO t1 VALUES (1);
10 INSERT INTO t2 VALUES (1);
11 connection node_2a;
12 SET SESSION wsrep_sync_wait=0;
13 SELECT COUNT(*) AS EXPECT_1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE LIKE '%committing%' OR STATE LIKE 'Commit' OR STATE LIKE 'Waiting for certification');
14 EXPECT_1
15 1
16 SELECT COUNT(*) AS EXPECT_1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE LIKE 'Waiting for table metadata lock%' OR STATE LIKE 'Waiting to execute in isolation%');
17 EXPECT_1
18 1
19 SELECT COUNT(*) AS EXPECT_0 FROM t1;
20 EXPECT_0
21 0
22 SELECT COUNT(*) AS EXPECT_0 FROM t2;
23 EXPECT_0
24 0
25 connection node_2;
26 UNLOCK TABLES;
27 connection node_2a;
28 SET SESSION wsrep_sync_wait = 15;;
29 SELECT COUNT(*) AS EXPECT_1 FROM t1;
30 EXPECT_1
31 1
32 SELECT COUNT(*) AS EXPECT_1 FROM t2;
33 EXPECT_1
34 1
35 SELECT COUNT(*) AS EXPECT_2 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE LIKE '%committed%' OR STATE LIKE 'Waiting for certification');
36 EXPECT_2
37 2
38 DROP TABLE t1;
39 DROP TABLE t2;