Debian Codegraph @

mysql-test/suite/galera_sr/r/galera_sr_kill_query.result

raw
1 connection node_2;
2 connection node_1;
3 SET SESSION wsrep_trx_fragment_size = 1;
4 CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
5 INSERT INTO ten VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
6 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
7 INSERT INTO t1 SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5, ten AS a6;;
8 connection node_2;
9 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
10 connection node_1;
11 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
12 Killing query ...
13 connection node_1;
14 ERROR 70100: Query execution was interrupted
15 connection node_2;
16 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
17 SELECT COUNT(*) AS EXPECT_0 FROM t1;
18 EXPECT_0
19 0
20 INSERT INTO t1 SELECT 1 FROM ten AS t1, ten AS t2, ten AS t3;
21 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
22 EXPECT_1000
23 1000
24 connection node_1;
25 SET GLOBAL wsrep_sync_wait=15;
26 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
27 EXPECT_1000
28 1000
29 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
30 EXPECT_0
31 0
32 connection node_2;
33 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
34 EXPECT_1000
35 1000
36 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
37 EXPECT_0
38 0
39 connection node_1;
40 DROP TABLE t1;
41 DROP TABLE ten;