1
call mtr.add_suppression("Table 't1' is marked as crashed and should be repaired");
2
drop database if exists mysqltest;
3
create database mysqltest;
5
create table t1(a int) engine=aria;
6
insert into t1 values(1);
7
create table t2 (a int) engine=aria;
8
INSERT INTO t2 VALUES (1),(2);
9
create table t3 (a int) engine=aria;
10
INSERT INTO t3 VALUES (1),(2);
11
create table t4 (a int) engine=aria;
12
INSERT INTO t4 VALUES (1),(2);
13
create table t5 (a int) engine=aria;
14
INSERT INTO t5 VALUES (1),(2);
15
create table t6 (a int) engine=aria;
16
INSERT INTO t6 VALUES (1),(2);
18
create_rename_lsn has non-magic value
19
* shut down mysqld, removed logs, restarted it
24
Note 1194 Zerofilling moved table ./mysqltest/t1
26
Status: changed,sorted index pages,zerofilled
27
insert into t1 values(2);
29
create_rename_lsn has non-magic value
31
# BUG#44422 "mysql_upgrade destroys Maria tables?"
32
# Check repair and optimize of moved table
35
Table Op Msg_type Msg_text
36
mysqltest.t2 check error Table is from another system and must be zerofilled or repaired to be usable on this system
37
mysqltest.t2 check error Corrupt
39
Table Op Msg_type Msg_text
40
mysqltest.t2 check error Table is from another system and must be zerofilled or repaired to be usable on this system
41
mysqltest.t2 check error Corrupt
43
Table Op Msg_type Msg_text
44
mysqltest.t2 repair status OK
46
Table Op Msg_type Msg_text
47
mysqltest.t2 check status OK
49
Table Op Msg_type Msg_text
50
mysqltest.t3 optimize Note Zerofilling moved table ./mysqltest/t3
51
mysqltest.t3 optimize status OK
53
Table Op Msg_type Msg_text
54
mysqltest.t4 analyze Note Zerofilling moved table ./mysqltest/t4
55
mysqltest.t4 analyze status OK
57
Table Op Msg_type Msg_text
58
mysqltest.t5 repair status OK
60
Table Op Msg_type Msg_text
61
mysqltest.t5 check status OK
63
Table Op Msg_type Msg_text
64
mysqltest.t5 repair status OK
66
Table Op Msg_type Msg_text
67
mysqltest.t5 check status OK
73
Table Op Msg_type Msg_text
74
mysqltest.t6 check status OK
75
drop database mysqltest;