Debian Codegraph @

mysql-test/suite/galera/t/MW-329.test

raw
1 #
2 # MW-329 Fix incorrect affected rows count after replay.
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE t1 (f1 INTEGER, f2 CHAR(20) DEFAULT 'abc') ENGINE=InnoDB;
9
10 # We start with a populated table
11 INSERT INTO t1 (f1) VALUES (1),(65535);
12
13 #
14 # Run concurrent INSERTs
15 #
16
17 DELIMITER |;
18 CREATE PROCEDURE proc_insert ()
19 BEGIN
20 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
21 SET SESSION wsrep_sync_wait = 0;
22 WHILE 1 DO
23 INSERT INTO t1 (f1) VALUES (FLOOR( 1 + RAND( ) * 65535 ));
24 SELECT SLEEP(0.1);
25 END WHILE;
26 END|
27 DELIMITER ;|
28
29 --connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1
30 --connection node_1b
31 --let $connection_id = `SELECT CONNECTION_ID()`
32 --disable_query_log
33 --disable_result_log
34 --send CALL proc_insert();
35
36 #
37 # Run concurrent UPDATEs. We expect that each UPDATE will report that
38 # some rows were matched and updated
39 #
40
41 --connection node_2
42 --let $count = 10
43 --let $wsrep_local_replays_old = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_replays'`
44
45 while ($count)
46 {
47 --let $signature = `SELECT LEFT(MD5(RAND()), 10)`
48 --disable_query_log
49 --error 0,ER_LOCK_DEADLOCK
50 --eval UPDATE t1 SET f2 = '$signature'
51 --enable_query_log
52 --let $row_count = `SELECT ROW_COUNT()`
53 if (`SELECT @@error_count = 0`) {
54 if (`SELECT $row_count = 0`) {
55 --die ROW_COUNT() = 0
56 }
57 }
58
59 #
60 # Ensure at least one replay happens
61 #
62
63 --let $wsrep_replays = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_replays'`
64 --disable_query_log
65 if (`SELECT $wsrep_replays - $wsrep_local_replays_old > 0`) {
66 --dec $count
67 }
68 --enable_query_log
69 }
70
71 #
72 # Confirm that some transaction replays occurred
73 #
74
75 --let $wsrep_local_replays_new = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_replays'`
76 --disable_query_log
77 --eval SELECT $wsrep_local_replays_new - $wsrep_local_replays_old > 0 AS wsrep_local_replays;
78 --enable_query_log
79
80 #
81 # Terminate the stored procedure
82 #
83
84 --connection node_1
85 --disable_query_log
86 --eval KILL HARD CONNECTION $connection_id
87 --enable_query_log
88 --connect node_1c, 127.0.0.1, root, , test, $NODE_MYPORT_1
89 --connection node_1c
90
91 --disable_query_log
92 # Make sure connection is killed
93 while (`SELECT COUNT(*) > 0 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE ID = $connection_id`)
94 {
95 SELECT SLEEP(1);
96 --error 0,ER_NO_SUCH_THREAD,ER_QUERY_INTERRUPTED,ER_CONNECTION_KILLED
97 --eval KILL HARD CONNECTION $connection_id
98 }
99 --enable_query_log
100
101 #
102 # getting execution results for --send
103 #
104
105 --connection node_1b
106 --error 0,1317,2013,2026
107 --reap
108 --enable_query_log
109 --enable_result_log
110
111 --connection node_1
112 DROP PROCEDURE proc_insert;
113 DROP TABLE t1;
114
115 --disconnect node_1b
116 --disconnect node_1c