Debian Codegraph @

mysql-test/suite/ndb/t/ndb_truncate_fail.test

raw
1 --source include/have_ndb.inc
2 --source include/have_debug.inc
3
4 connect(server1,127.0.0.1,root,,test,$MASTER_MYPORT,);
5 connect(server2,127.0.0.1,root,,test,$MASTER_MYPORT1,);
6 --echo # [connection default]
7 --connection default
8
9 --disable_query_log
10 DELIMITER //;
11 CREATE PROCEDURE create_tables (IN ntables INT)
12 BEGIN
13 SET @idx = 1;
14 WHILE @idx <= ntables DO
15 SET @pstmt = CONCAT('CREATE TABLE t', @idx, ' (a INT PRIMARY KEY AUTO_INCREMENT, c CHAR(3)) ENGINE = NDB');
16 PREPARE stmt FROM @pstmt;
17 EXECUTE stmt;
18 DEALLOCATE PREPARE stmt;
19 SET @idx = @idx + 1;
20 END WHILE;
21 END //
22
23 CREATE PROCEDURE drop_tables (IN ntables INT)
24 BEGIN
25 SET @idx = 1;
26 WHILE @idx <= ntables DO
27 SET @pstmt = CONCAT('DROP TABLE t', @idx);
28 PREPARE stmt FROM @pstmt;
29 EXECUTE stmt;
30 DEALLOCATE PREPARE stmt;
31 SET @idx = @idx + 1;
32 END WHILE;
33 END //
34
35 CREATE PROCEDURE insert_row (IN ntables INT)
36 BEGIN
37 SET @idx = 1;
38 WHILE @idx <= ntables DO
39 SET @pstmt = CONCAT('INSERT INTO t', @idx, ' (c) VALUES (\'val\')');
40 PREPARE stmt FROM @pstmt;
41 EXECUTE stmt;
42 DEALLOCATE PREPARE stmt;
43 SET @idx = @idx + 1;
44 END WHILE;
45 END //
46
47 CREATE PROCEDURE truncate_list(IN first_tab_idx INT, IN last_tab_idx INT)
48 BEGIN
49 SET @idx = first_tab_idx;
50 WHILE @idx <= last_tab_idx DO
51 SET @pstmt = CONCAT('TRUNCATE TABLE t', @idx);
52 PREPARE stmt FROM @pstmt;
53 EXECUTE stmt;
54 DEALLOCATE PREPARE stmt;
55 SET @idx = @idx + 1;
56 END WHILE;
57 END //
58
59 --connection server2
60 CREATE PROCEDURE truncate_list(IN first_tab_idx INT, IN last_tab_idx INT)
61 BEGIN
62 SET @idx = first_tab_idx;
63 WHILE @idx <= last_tab_idx DO
64 SET @pstmt = CONCAT('TRUNCATE TABLE t', @idx);
65 PREPARE stmt FROM @pstmt;
66 EXECUTE stmt;
67 DEALLOCATE PREPARE stmt;
68 SET @idx = @idx + 1;
69 END WHILE;
70 END //
71
72 --connection default
73 DELIMITER ;//
74 --enable_query_log
75
76 CALL create_tables(20);
77 CALL insert_row(20);
78
79 # Data at t1
80 SELECT COUNT(*) FROM t1;
81 # Data at t20
82 SELECT COUNT(*) FROM t20;
83 SET GLOBAL ndb_metadata_sync = 'ON';
84
85 --echo # Start truncating
86 CALL truncate_list(1,10);
87
88 --echo # Now fail all drops (1st phase of truncate)
89 SET @saved_debug = @@GLOBAL.debug;
90 SET @@GLOBAL.debug = '+d,ndb_fail_drop';
91 --error 1296
92 CALL truncate_list(11, 20);
93 # repeat once again to stress out share locks
94 --error 1296
95 CALL truncate_list(11, 20);
96
97 --echo # t1->t10 must have been truncated
98 SELECT COUNT(*) FROM t1;
99 SELECT COUNT(*) FROM t10;
100 --echo # t11->t20 must have failed
101 SELECT COUNT(*) FROM t11;
102 SELECT COUNT(*) FROM t20;
103
104 # Do the same with two connections. Server1 fails all but server2 queues and is successful
105 --let $iter=2
106 while($iter)
107 {
108 --echo # [connection server1]
109 --connection server1
110 SET DEBUG_SYNC='truncate_stop_after_execute SIGNAL signal1 WAIT_FOR go_signal1';
111 --send CALL truncate_list(1,20)
112
113 --echo # [connection server2]
114 --connection server2
115 --send CALL truncate_list(1,20)
116
117 --echo # [connection default]
118 --connection default
119 SET DEBUG_SYNC='now SIGNAL go_signal1';
120
121 --echo # [connection server1]
122 --connection server1
123 --error 1296
124 --reap
125 --echo # [connection server2]
126 --connection server2
127 --reap
128
129 --dec $iter
130 }
131
132 --echo # [connection default]
133 --connection default
134 --echo # Re-insert data to assess that share locks were properly cleaned
135 CALL insert_row(20);
136 --echo # All tables should have data (t1->t20 1 row, by server2)
137 SELECT COUNT(*) FROM t1;
138 SELECT COUNT(*) FROM t20;
139
140 --echo # Cleanup
141 --connection server2
142 DROP PROCEDURE truncate_list;
143 --connection default
144 SET GLOBAL debug = @saved_debug;
145 CALL drop_tables(20);
146 DROP PROCEDURE create_tables;
147 DROP PROCEDURE drop_tables;
148 DROP PROCEDURE insert_row;
149 DROP PROCEDURE truncate_list;
150 --disconnect server1
151 --disconnect server2