Debian Codegraph @

mysql-test/suite/parts/inc/partition_mgm_crash.inc

raw
1 # collection of tests which crashes the server and checks recovery.
2 # also using error injection to test recovery of failures.
3 # uses $DATADIR and $engine
4
5 --echo #
6 --echo # Bug#53676: Unexpected errors and possible table corruption on
7 --echo # ADD PARTITION and LOCK TABLE
8 --echo # Bug#53770: Server crash at handler.cc:2076 on LOAD DATA
9 --echo # after timed out COALESCE PARTITION
10 --echo # Extended crash recovery testing of fast_alter_partition_table.
11 call mtr.add_suppression("Attempting backtrace. You can use the following information to find out");
12
13 let $create_statement= CREATE TABLE `t1/a\b#2` (a INT, b VARCHAR(64))
14 ENGINE = $engine
15 PARTITION BY LIST (a)
16 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
17 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
18 let $insert_statement= INSERT INTO `t1/a\b#2` VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
19
20 let $crash_statement= ALTER TABLE `t1/a\b#2` ADD PARTITION
21 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
22
23 --echo #
24 --echo # Test without crash/failure injection
25 --echo #
26 --eval $create_statement
27 --eval $insert_statement
28 --echo # State before statement
29 --replace_result #p# #P# #sp# #SP#
30 --list_files $DATADIR/test
31 SHOW CREATE TABLE `t1/a\b#2`;
32 --sorted_result
33 SELECT * FROM `t1/a\b#2`;
34 --eval $crash_statement
35 --echo # State after statement
36 --replace_result #p# #P# #sp# #SP#
37 --list_files $DATADIR/test
38 SHOW CREATE TABLE `t1/a\b#2`;
39 --sorted_result
40 SELECT * FROM `t1/a\b#2`;
41 DROP TABLE `t1/a\b#2`;
42
43 --source suite/parts/inc/partition_crash_add.inc
44 let $fail_statement= $crash_statement;
45 --source suite/parts/inc/partition_fail_add.inc
46 let $crash_statement= ALTER TABLE `t1/a\b#2` DROP PARTITION p10;
47 --source suite/parts/inc/partition_crash_drop.inc
48 let $fail_statement= $crash_statement;
49 --source suite/parts/inc/partition_fail_drop.inc
50 let $crash_statement= ALTER TABLE `t1/a\b#2` REORGANIZE PARTITION p10 INTO
51 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
52 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
53
54 --echo #
55 --echo # Test without crash/failure injection
56 --echo #
57 --eval $create_statement
58 --eval $insert_statement
59 --echo # State before statement
60 --replace_result #p# #P# #sp# #SP#
61 --list_files $DATADIR/test
62 SHOW CREATE TABLE `t1/a\b#2`;
63 --sorted_result
64 SELECT * FROM `t1/a\b#2`;
65 --eval $crash_statement
66 --echo # State after statement
67 --replace_result #p# #P# #sp# #SP#
68 --list_files $DATADIR/test
69 SHOW CREATE TABLE `t1/a\b#2`;
70 --sorted_result
71 SELECT * FROM `t1/a\b#2`;
72 DROP TABLE `t1/a\b#2`;
73
74 --source suite/parts/inc/partition_crash_change.inc
75 let $fail_statement= $crash_statement;
76 --source suite/parts/inc/partition_fail_change.inc