summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/maria/maria-autozerofill.test
blob: 8459e27a8a8c29d1ddeb0c786eef9b1b9478cbdc (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
# Test to verify that auto-zerofilling happens when a table is
# imported from a different Aria instance

# can't restart in embedded
--source include/not_embedded.inc
--source include/have_maria.inc

call mtr.add_suppression("Table 't1' is marked as crashed and should be repaired");

let $MARIA_LOG=.;

--disable_warnings
drop database if exists mysqltest;
--enable_warnings
create database mysqltest;
let $mms_tname=t;

connect (admin, localhost, root,,mysqltest,,);
--enable_reconnect

connection default;
use mysqltest;
--enable_reconnect

# Create some tables for future tests
create table t1(a int) engine=aria;
insert into t1 values(1);
create table t2 (a int) engine=aria;
INSERT INTO t2 VALUES (1),(2);
create table t3 (a int) engine=aria;
INSERT INTO t3 VALUES (1),(2);
create table t4 (a int) engine=aria;
INSERT INTO t4 VALUES (1),(2);
create table t5 (a int) engine=aria;
INSERT INTO t5 VALUES (1),(2);
create table t6 (a int) engine=aria;
INSERT INTO t6 VALUES (1),(2);
flush tables;

# Check that table is not zerofilled, not movable
let $MYSQLD_DATADIR= `select @@datadir`;
--exec $MARIA_CHK -dv --ignore-control-file $MYSQLD_DATADIR/mysqltest/t1 >$MYSQLTEST_VARDIR/tmp/autozerofill.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/autozerofill.txt";
    open(FILE, "<", $fname) or die;
    my @content= <FILE>;
    print grep(/Status:.*(zerofilled|movable)/, @content);
    print "create_rename_lsn has non-magic value\n" if grep(/create_rename \([0-9]+/, @content);
    close FILE;
EOF

# this will remove control file, so change the uuid of the Aria
# instance, thus t1 will appear as imported from elsewhere.

-- source include/maria_empty_logs.inc

disable_ps_protocol; # see aria-recover.test
replace_regex /Table.*t1/t1/ ;
replace_result \\ /;
select * from t1;
enable_ps_protocol;
flush table t1;

# Check that table is auto-zerofilled, movable
--exec $MARIA_CHK -dv --ignore-control-file $MYSQLD_DATADIR/mysqltest/t1 >$MYSQLTEST_VARDIR/tmp/autozerofill.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/autozerofill.txt";
    open(FILE, "<", $fname) or die;
    my @content= <FILE>;
    print grep(/Status:.*/, @content);
    print "create_rename_lsn has magic value\n" if grep(/create_rename \(0,0x2\)/, @content);
    close FILE;
EOF

# this will attach t1 to the current Aria instance
insert into t1 values(2);
flush table t1;

# Check that table is not zerofilled, not movable
--exec $MARIA_CHK -dv --ignore-control-file $MYSQLD_DATADIR/mysqltest/t1 >$MYSQLTEST_VARDIR/tmp/autozerofill.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/autozerofill.txt";
    open(FILE, "<", $fname) or die;
    my @content= <FILE>;
    print grep(/Status:.*(zerofilled|movable)/, @content);
    print "create_rename_lsn has non-magic value\n" if grep(/create_rename \([0-9]+/, @content);
    close FILE;
EOF

--echo #
--echo # BUG#44422 "mysql_upgrade destroys Maria tables?"
--echo # Check repair and optimize of moved table
--echo #

# Table t2 is regarded as it would be from another server as we removed
# the aria control file earlier
check table t2;
check table t2;
repair table t2;
check table t2;
replace_result \\ /;
optimize table t3;
replace_result \\ /;
analyze table t4;
repair table t5;
check table t5;
repair table t5;
check table t5;

# Check that if we zerofill with aria_chk, we should not get any warnings when
# accessing the table
--error 0,1,11,139
--exec $MARIA_CHK --ignore-control-file --zerofill $MYSQLD_DATADIR/mysqltest/t6 >$MYSQLTEST_VARDIR/tmp/autozerofill.txt 2>&1
if ($sys_errno != 0)
{
--cat_file $MYSQLTEST_VARDIR/tmp/autozerofill.txt
--die
}

select * from t6;
check table t6;

drop database mysqltest;