Debian Codegraph @

mysql-test/suite/galera_sr/t/galera_sr_kill_query.test

raw
1 --source include/galera_cluster.inc
2
3 #
4 # Test KILL QUERY on a statement that has already replicated some data via SR
5 #
6
7 SET SESSION wsrep_trx_fragment_size = 1;
8
9 CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
10 INSERT INTO ten VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
11
12 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
13
14 --let $connection_id = `SELECT CONNECTION_ID()`
15 --send INSERT INTO t1 SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5, ten AS a6;
16
17 # Wait for some SR to arrive on the slave.
18 --connection node_2
19 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
20 --let $wait_condition = SELECT TABLE_ROWS > 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
21 --source include/wait_condition.inc
22
23 --connection node_1
24 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
25 --echo Killing query ...
26 --disable_query_log
27 --eval KILL QUERY $connection_id
28 --enable_query_log
29
30 --connection node_1
31 --error ER_QUERY_INTERRUPTED
32 --reap
33
34 # Confirm that the kill caused the updates made so far to be removed
35 --connection node_2
36 --let $wait_condition = SELECT COUNT(*) = 0 FROM t1
37 --source include/wait_condition.inc
38 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
39 SELECT COUNT(*) AS EXPECT_0 FROM t1;
40
41 # Confirm that the transaction can be reissued in its entirety on the slave without a conflict
42
43 INSERT INTO t1 SELECT 1 FROM ten AS t1, ten AS t2, ten AS t3;
44 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
45
46 --connection node_1
47 SET GLOBAL wsrep_sync_wait=15;
48 --let $wait_condition = SELECT COUNT(*) = 1000 FROM t1;
49 --source include/wait_condition.inc
50 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
51 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
52
53 --connection node_2
54 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
55 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
56
57 --connection node_1
58 DROP TABLE t1;
59 DROP TABLE ten;