Debian Codegraph @

mysql-test/suite/storage_engine/parts/repair_table.result

raw
1 call mtr.add_suppression("Table '.*t1.*' is marked as crashed and should be repaired");
2 DROP TABLE IF EXISTS t1, t2;
3 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
4 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(2,'d'),(4,'e'),(100,'f'),(101,'g');
5 CREATE TABLE t2 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY RANGE(a) (
6 PARTITION p0 VALUES LESS THAN (100),
7 PARTITION p1 VALUES LESS THAN MAXVALUE
8 );
9 INSERT INTO t2 (a,b) SELECT a, b FROM t1;
10 ALTER TABLE t1 REPAIR PARTITION p0;
11 Table Op Msg_type Msg_text
12 test.t1 repair status OK
13 INSERT INTO t1 (a,b) VALUES (3,'c');
14 ALTER TABLE t1 REPAIR PARTITION NO_WRITE_TO_BINLOG p0, p1;
15 Table Op Msg_type Msg_text
16 test.t1 repair status OK
17 INSERT INTO t2 (a,b) VALUES (5,'e'),(6,'f');
18 ALTER TABLE t2 REPAIR PARTITION LOCAL p1;
19 Table Op Msg_type Msg_text
20 test.t2 repair status OK
21 INSERT INTO t1 (a,b) VALUES (7,'g'),(8,'h');
22 ALTER TABLE t1 REPAIR PARTITION LOCAL ALL EXTENDED;
23 Table Op Msg_type Msg_text
24 test.t1 repair status OK
25 INSERT INTO t1 (a,b) VALUES (10,'j');
26 ALTER TABLE t1 REPAIR PARTITION p1 QUICK USE_FRM;
27 Table Op Msg_type Msg_text
28 test.t1 repair status OK
29 INSERT INTO t2 (a,b) VALUES (12,'l');
30 ALTER TABLE t2 REPAIR PARTITION NO_WRITE_TO_BINLOG ALL QUICK EXTENDED USE_FRM;
31 Table Op Msg_type Msg_text
32 test.t2 repair status OK
33 DROP TABLE t1, t2;
34 DROP TABLE IF EXISTS t1,t2;
35 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
36 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
37 CREATE TABLE t2 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
38 REPAIR TABLE t1;
39 Table Op Msg_type Msg_text
40 test.t1 repair status OK
41 INSERT INTO t1 (a,b) VALUES (3,'c');
42 INSERT INTO t2 (a,b) VALUES (4,'d');
43 REPAIR NO_WRITE_TO_BINLOG TABLE t1, t2;
44 Table Op Msg_type Msg_text
45 test.t1 repair status OK
46 test.t2 repair status OK
47 INSERT INTO t2 (a,b) VALUES (5,'e'),(6,'f');
48 REPAIR LOCAL TABLE t2;
49 Table Op Msg_type Msg_text
50 test.t2 repair status OK
51 INSERT INTO t1 (a,b) VALUES (7,'g'),(8,'h');
52 INSERT INTO t2 (a,b) VALUES (9,'i');
53 REPAIR LOCAL TABLE t2, t1 EXTENDED;
54 Table Op Msg_type Msg_text
55 test.t2 repair status OK
56 test.t1 repair status OK
57 INSERT INTO t1 (a,b) VALUES (10,'j');
58 INSERT INTO t2 (a,b) VALUES (11,'k');
59 REPAIR TABLE t1, t2 QUICK USE_FRM;
60 Table Op Msg_type Msg_text
61 test.t1 repair status OK
62 test.t2 repair status OK
63 INSERT INTO t1 (a,b) VALUES (12,'l');
64 INSERT INTO t2 (a,b) VALUES (13,'m');
65 REPAIR NO_WRITE_TO_BINLOG TABLE t1, t2 QUICK EXTENDED USE_FRM;
66 Table Op Msg_type Msg_text
67 test.t1 repair status OK
68 test.t2 repair status OK
69 FLUSH TABLE t1;
70 INSERT INTO t1 (a,b) VALUES (14,'n');
71 ERROR HY000: Failed to read from the .par file
72 # Statement ended with one of expected results (0,130,ER_FAILED_READ_FROM_PAR_FILE,ER_OPEN_AS_READONLY).
73 # If you got a difference in error message, just add it to rdiff file
74 CHECK TABLE t1;
75 Table Op Msg_type Msg_text
76 test.t1 check Error Failed to read from the .par file
77 test.t1 check error Corrupt
78 SELECT a,b FROM t1;
79 ERROR HY000: Failed to read from the .par file
80 # Statement ended with one of expected results (0,130,ER_FAILED_READ_FROM_PAR_FILE,ER_OPEN_AS_READONLY).
81 # If you got a difference in error message, just add it to rdiff file
82 REPAIR TABLE t1;
83 Table Op Msg_type Msg_text
84 test.t1 repair Error Failed to read from the .par file
85 test.t1 repair error Corrupt
86 DROP TABLE t1, t2;
87 call mtr.add_suppression("Got an error from thread_id=.*");
88 call mtr.add_suppression("MySQL thread id .*, query id .* localhost.*root Checking table");
89 call mtr.add_suppression(" '\..test.t1'");
90 call mtr.add_suppression("Couldn't repair table: test.t1");
91 call mtr.add_suppression("Table 't1' is marked as crashed.*");
92 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>, <CUSTOM_INDEX> (a)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
93 REPAIR TABLE t1;
94 Table Op Msg_type Msg_text
95 test.t1 repair status OK
96 INSERT INTO t1 (a,b) VALUES (7,'g'),(8,'h');
97 REPAIR TABLE t1 EXTENDED;
98 Table Op Msg_type Msg_text
99 test.t1 repair status OK
100 INSERT INTO t1 (a,b) VALUES (10,'j');
101 REPAIR TABLE t1 USE_FRM;
102 Table Op Msg_type Msg_text
103 test.t1 repair status OK
104 db.opt
105 t1#P#p0.MYD
106 t1#P#p0.MYI
107 t1#P#p1.MYD
108 t1#P#p1.MYI
109 t1.frm
110 t1.par
111 INSERT INTO t1 (a,b) VALUES (14,'n'),(15,'o');
112 # Statement ended with one of expected results (0,144).
113 # If you got a difference in error message, just add it to rdiff file
114 FLUSH TABLE t1;
115 Restoring <DATADIR>/test/t1#P#p0.MYD
116 CHECK TABLE t1;
117 Table Op Msg_type Msg_text
118 test.t1 check error Size of datafile is: 26 Should be: 39
119 test.t1 check error Partition p0 returned error
120 test.t1 check error Corrupt
121 SELECT a,b FROM t1;
122 a b
123 8 h
124 10 j
125 7 g
126 15 o
127 Warnings:
128 Error 145 Table './test/t1#P#p0' is marked as crashed and should be repaired
129 Error 1034 Number of rows changed from 3 to 2
130 # Statement ended with one of expected results (0,ER_NOT_KEYFILE,144).
131 # If you got a difference in error message, just add it to rdiff file
132 INSERT INTO t1 (a,b) VALUES (14,'n'),(15,'o');
133 # Statement ended with one of expected results (0,144).
134 # If you got a difference in error message, just add it to rdiff file
135 FLUSH TABLE t1;
136 Restoring <DATADIR>/test/t1#P#p0.MYI
137 CHECK TABLE t1;
138 Table Op Msg_type Msg_text
139 test.t1 check warning Size of datafile is: 39 Should be: 26
140 test.t1 check error Record-count is not ok; is 3 Should be: 2
141 test.t1 check warning Found 3 key parts. Should be: 2
142 test.t1 check error Partition p0 returned error
143 test.t1 check error Corrupt
144 SELECT a,b FROM t1;
145 a b
146 8 h
147 10 j
148 14 n
149 7 g
150 15 o
151 15 o
152 Warnings:
153 Error 145 Table './test/t1#P#p0' is marked as crashed and should be repaired
154 Error 1034 Number of rows changed from 2 to 3
155 # Statement ended with one of expected results (0,ER_NOT_KEYFILE,144).
156 # If you got a difference in error message, just add it to rdiff file
157 INSERT INTO t1 (a,b) VALUES (14,'n'),(15,'o');
158 # Statement ended with one of expected results (0,144).
159 # If you got a difference in error message, just add it to rdiff file
160 FLUSH TABLE t1;
161 Restoring <DATADIR>/test/t1#P#p1.MYD
162 CHECK TABLE t1;
163 Table Op Msg_type Msg_text
164 test.t1 check error Size of datafile is: 39 Should be: 52
165 test.t1 check error Partition p1 returned error
166 test.t1 check error Corrupt
167 SELECT a,b FROM t1;
168 a b
169 8 h
170 10 j
171 14 n
172 14 n
173 7 g
174 15 o
175 15 o
176 Warnings:
177 Error 145 Table './test/t1#P#p1' is marked as crashed and should be repaired
178 Error 1034 Number of rows changed from 4 to 3
179 # Statement ended with one of expected results (0,ER_NOT_KEYFILE,144).
180 # If you got a difference in error message, just add it to rdiff file
181 INSERT INTO t1 (a,b) VALUES (14,'n'),(15,'o');
182 # Statement ended with one of expected results (0,144).
183 # If you got a difference in error message, just add it to rdiff file
184 FLUSH TABLE t1;
185 Restoring <DATADIR>/test/t1#P#p1.MYI
186 CHECK TABLE t1;
187 Table Op Msg_type Msg_text
188 test.t1 check warning Size of datafile is: 52 Should be: 39
189 test.t1 check error Record-count is not ok; is 4 Should be: 3
190 test.t1 check warning Found 4 key parts. Should be: 3
191 test.t1 check error Partition p1 returned error
192 test.t1 check error Corrupt
193 SELECT a,b FROM t1;
194 a b
195 8 h
196 10 j
197 14 n
198 14 n
199 14 n
200 7 g
201 15 o
202 15 o
203 15 o
204 Warnings:
205 Error 145 Table './test/t1#P#p1' is marked as crashed and should be repaired
206 Error 1034 Number of rows changed from 3 to 4
207 # Statement ended with one of expected results (0,ER_NOT_KEYFILE,144).
208 # If you got a difference in error message, just add it to rdiff file
209 INSERT INTO t1 (a,b) VALUES (14,'n'),(15,'o');
210 # Statement ended with one of expected results (0,144).
211 # If you got a difference in error message, just add it to rdiff file
212 FLUSH TABLE t1;
213 Restoring <DATADIR>/test/t1.par
214 CHECK TABLE t1;
215 Table Op Msg_type Msg_text
216 test.t1 check status OK
217 SELECT a,b FROM t1;
218 a b
219 8 h
220 10 j
221 14 n
222 14 n
223 14 n
224 14 n
225 7 g
226 15 o
227 15 o
228 15 o
229 15 o
230 # Statement ended with one of expected results (0,ER_NOT_KEYFILE,144).
231 # If you got a difference in error message, just add it to rdiff file
232 DROP TABLE t1;