Debian Codegraph @

mysql-test/suite/parts/t/partition_debug.test

raw
1 # Partitioning test that require debug features
2 # including crashing tests.
3
4 --source include/have_debug.inc
5 --source include/have_partition.inc
6 # Don't test this under valgrind, memory leaks will occur
7 --source include/not_valgrind.inc
8 # Crash tests don't work with embedded
9 --source include/not_embedded.inc
10
11 # Make sure system tables are not open, as the test will kill the server
12 # and it will cause corruption errors in the log
13 FLUSH TABLES;
14
15 # Partitioning test that require debug features
16
17 --echo #
18 --echo # Bug#13737949: CRASH IN HA_PARTITION::INDEX_INIT
19 --echo # Bug#18694052: SERVER CRASH IN HA_PARTITION::INIT_RECORD_PRIORITY_QUEUE
20 --echo #
21 CREATE TABLE t1 (a INT, b VARCHAR(64), KEY(b,a))
22 PARTITION BY HASH (a) PARTITIONS 3;
23 INSERT INTO t1 VALUES (1, "1"), (2, "2"), (3, "3"), (4, "Four"), (5, "Five"),
24 (6, "Six"), (7, "Seven"), (8, "Eight"), (9, "Nine");
25 SET @saved_dbug=@@debug_dbug;
26 SET SESSION debug_dbug="+d,ha_partition_fail_index_init";
27 --error ER_NO_PARTITION_FOR_GIVEN_VALUE
28 SELECT * FROM t1 WHERE b = "Seven";
29 SET SESSION debug_dbug=@saved_dbug;
30 SELECT * FROM t1 WHERE b = "Seven";
31 DROP TABLE t1;
32
33
34 --let $DATADIR= `SELECT @@datadir;`
35
36 --echo #
37 --echo # WL#4445: EXCHANGE PARTITION WITH TABLE
38 --echo # Verify ddl_log in case of crashing.
39 call mtr.add_suppression("Attempting backtrace. You can use the following information to find out");
40 call mtr.add_suppression('InnoDB: The log sequence numbers [0-9]+ and [0-9]+ in ibdata files do not match the log sequence number [0-9]+ in the ib_logfiles!');
41
42 let $create_statement= CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
43 (PARTITION p0 VALUES LESS THAN (10),
44 PARTITION p1 VALUES LESS THAN MAXVALUE);
45 let $insert_statement= INSERT INTO t1 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
46
47 let $create_statement2= CREATE TABLE t2 (a INT, b VARCHAR(64));
48 let $insert_statement2= INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
49 let $crash_statement= ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
50 --source suite/parts/inc/partition_crash_exchange.inc
51 let $fail_statement= $crash_statement;
52 --source suite/parts/inc/partition_fail_exchange.inc
53
54 --echo #
55 --echo # MDEV-22165 CONVERT PARTITION: move in partition from existing table
56 --echo #
57 let $create_statement= create or replace table t1 (x int primary key)
58 partition by range(x) (
59 partition p1 values less than (10),
60 partition p2 values less than (20),
61 partition p3 values less than (30));
62
63 let $create_statement2= create or replace table t2 (x int primary key);
64 let $insert_statement= insert into t1 values (2), (12), (22);
65 let $insert_statement2= insert into t2 values (32), (42), (52);
66
67 let $fail_statement= alter table t1 convert table t2 to partition pn values less than maxvalue;
68
69 set @save_dbug=@@debug_dbug;
70 set session debug_dbug="+d,fail_convert_partition_1";
71 --source suite/parts/inc/partition_fail_t2.inc
72 set session debug_dbug=@save_dbug;
73 set session debug_dbug="+d,fail_convert_partition_2";
74 --source suite/parts/inc/partition_fail_t2.inc
75 set session debug_dbug=@save_dbug;
76 set session debug_dbug="+d,fail_convert_partition_3";
77 --source suite/parts/inc/partition_fail_t2.inc
78 set session debug_dbug=@save_dbug;
79 set session debug_dbug="+d,fail_convert_partition_4";
80 --source suite/parts/inc/partition_fail_t2.inc
81 set session debug_dbug=@save_dbug;
82 set session debug_dbug="+d,fail_convert_partition_5";
83 --source suite/parts/inc/partition_fail_t2.inc
84 set session debug_dbug=@save_dbug;
85 set session debug_dbug="+d,fail_convert_partition_6";
86 --source suite/parts/inc/partition_fail_t2.inc
87 set session debug_dbug=@save_dbug;
88 set session debug_dbug="+d,fail_convert_partition_7";
89 --source suite/parts/inc/partition_fail_t2.inc
90 set session debug_dbug=@save_dbug;
91 set session debug_dbug="+d,fail_convert_partition_8";
92 --source suite/parts/inc/partition_fail_t2.inc
93 set session debug_dbug=@save_dbug;
94 set session debug_dbug="+d,fail_convert_partition_9";
95 --source suite/parts/inc/partition_fail_t2.inc
96 set session debug_dbug=@save_dbug;
97 set session debug_dbug="+d,fail_convert_partition_11";
98 --source suite/parts/inc/partition_fail_t2.inc
99 set session debug_dbug=@save_dbug;
100
101
102 --echo #
103 --echo # MDEV-22166 CONVERT PARTITION: move out partition into a table
104 --echo #
105 let $create_statement= create or replace table t1 (x int primary key)
106 partition by range(x) (
107 partition p1 values less than (10),
108 partition p2 values less than (20),
109 partition p3 values less than (30),
110 partition p4 values less than (40),
111 partition p5 values less than (50),
112 partition pn values less than maxvalue);
113
114 let $insert_statement= insert into t1 values (2), (12), (22), (32), (42), (52);
115 let $fail_statement= alter table t1 convert partition p2 to table tp2;
116
117 set @save_dbug=@@debug_dbug;
118 set session debug_dbug="+d,fail_create_before_create_frm";
119 --source suite/parts/inc/partition_fail.inc
120 set session debug_dbug=@save_dbug;
121 set session debug_dbug="+d,fail_alter_partition_after_write_frm";
122 --source suite/parts/inc/partition_fail.inc
123 set session debug_dbug=@save_dbug;
124 set session debug_dbug="+d,error_convert_partition_00";
125 --source suite/parts/inc/partition_fail.inc
126 #set session debug_dbug=@save_dbug;
127 #set session debug_dbug="+d,fail_convert_partition_01";
128 #--source suite/parts/inc/partition_fail.inc
129 set session debug_dbug=@save_dbug;
130 set session debug_dbug="+d,fail_convert_partition_1";
131 --source suite/parts/inc/partition_fail.inc
132 set session debug_dbug=@save_dbug;
133 set session debug_dbug="+d,fail_convert_partition_2";
134 --source suite/parts/inc/partition_fail.inc
135 set session debug_dbug=@save_dbug;
136 set session debug_dbug="+d,fail_convert_partition_3";
137 --source suite/parts/inc/partition_fail.inc
138 set session debug_dbug=@save_dbug;
139 set session debug_dbug="+d,fail_convert_partition_4";
140 --source suite/parts/inc/partition_fail.inc
141 set session debug_dbug=@save_dbug;
142 set session debug_dbug="+d,fail_convert_partition_5";
143 --source suite/parts/inc/partition_fail.inc
144 set session debug_dbug=@save_dbug;
145 set session debug_dbug="+d,fail_convert_partition_6";
146 --source suite/parts/inc/partition_fail.inc
147 set session debug_dbug=@save_dbug;
148 set session debug_dbug="+d,fail_convert_partition_7";
149 --source suite/parts/inc/partition_fail.inc
150 set session debug_dbug=@save_dbug;
151 set session debug_dbug="+d,fail_convert_partition_8";
152 --source suite/parts/inc/partition_fail.inc
153 set session debug_dbug=@save_dbug;
154 set session debug_dbug="+d,fail_convert_partition_9";
155 --source suite/parts/inc/partition_fail.inc
156 set session debug_dbug=@save_dbug;
157 set session debug_dbug="+d,fail_convert_partition_11";
158 --echo # Already finished DDL logging, so tp2 now exists:
159 --source suite/parts/inc/partition_fail.inc
160 set session debug_dbug=@save_dbug;
161 show create table tp2;
162 select * from tp2;
163 drop table tp2;