myisam_recover.result 4.57 KB
Newer Older
Nirbhay Choubey's avatar
Nirbhay Choubey committed
1
call mtr.add_suppression("Table 't1' is marked as crashed and should be repaired");
2
#
3 4 5
# Tests for corrupted MyISAM tables and MyISAMMRG tables with corrupted
# children..
#
6 7 8 9 10 11 12
# Run with --myisam-recover=force option.
#
# Preparation: we need to make sure that the merge parent
# is never left in the table cache when closed, since this may
# have effect on merge children.
# For that, we set the table cache to minimal size and populate it
# in a concurrent connection.
13 14
connect con1,localhost,root,,test,,;
connection con1;
15 16 17 18 19 20
#
# Minimal values.
#
call mtr.add_suppression("Got an error from thread_id=.*ha_myisam.cc:");
call mtr.add_suppression("MySQL thread id .*, query id .* localhost.*root Checking table");
call mtr.add_suppression(" '\..test.t1'");
21
set @save_table_open_cache=@@table_open_cache;
22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
set global table_open_cache=256;
set global table_definition_cache=400;
drop procedure if exists p_create;
create procedure p_create()
begin
declare i int default 1;
set @lock_table_stmt="lock table ";
set @drop_table_stmt="drop table ";
while i < @@global.table_definition_cache + 1 do
set @table_name=concat("t_", i);
set @opt_comma=if(i=1, "", ", ");
set @lock_table_stmt=concat(@lock_table_stmt, @opt_comma,
@table_name, " read");
set @drop_table_stmt=concat(@drop_table_stmt, @opt_comma, @table_name);
set @create_table_stmt=concat("create table if not exists ",
@table_name, " (a int)");
prepare stmt from @create_table_stmt;
execute stmt;
deallocate prepare stmt;
set i= i+1;
end while;
end|
call p_create();
drop procedure p_create;
46
connection default;
47
#
48
# We have to disable the ps-protocol, to avoid
49 50
# "Prepared statement needs to be re-prepared" errors
# -- table def versions change all the time with full table cache.
51
#
52 53 54 55
drop table if exists t1, t1_mrg, t1_copy;
#
# Prepare a MERGE engine table, that refers to a corrupted
# child.
56
#
57 58 59 60
create table t1 (a int, key(a)) engine=myisam;
create table t1_mrg (a int) union (t1) engine=merge;
#
# Create a table with a corrupted index file:
61
# save an old index file, insert more rows,
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
# overwrite the new index file with the old one.
#
insert into  t1 (a) values (1), (2), (3);
flush table t1;
insert into  t1 (a) values (4), (5), (6);
flush table t1;
# check table is needed to mark the table as crashed.
check table t1;
Table	Op	Msg_type	Msg_text
test.t1	check	warning	Size of datafile is: 42       Should be: 21
test.t1	check	error	Record-count is not ok; is 6   Should be: 3
test.t1	check	warning	Found 6 key parts. Should be: 3
test.t1	check	error	Corrupt
#
# At this point we have a merge table t1_mrg pointing to t1,
# and t1 is corrupted, and will be auto-repaired at open.
# Check that this doesn't lead to memory corruption.
#
select * from t1_mrg;
a
1
2
3
4
5
6
Warnings:
Error	145	Table 't1' is marked as crashed and should be repaired
90
Warning	1034	Number of rows changed from 3 to 6
91 92 93 94
#
# Cleanup
#
drop table t1, t1_mrg;
95
connection con1;
96 97 98 99 100
unlock tables;
prepare stmt from @drop_table_stmt;
execute stmt;
deallocate prepare stmt;
set @@global.table_definition_cache=default;
101
set @@global.table_open_cache=@save_table_open_cache;
102 103
disconnect con1;
connection default;
104 105 106 107 108 109
#
# 18075170 - sql node restart required to avoid deadlock after
#            restore
#
# Check that auto-repair for MyISAM tables can now happen in the
# middle of transaction, without aborting it.
110
connection default;
111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140
create table t1 (a int, key(a)) engine=myisam;
create table t2 (a int);
insert into t2 values (1);
# Create a table with a corrupted index file:
# save an old index file, insert more rows,
# overwrite the new index file with the old one.
insert into  t1 (a) values (1);
flush table t1;
insert into  t1 (a) values (4);
flush table t1;
# Check table is needed to mark the table as crashed.
check table t1;
Table	Op	Msg_type	Msg_text
test.t1	check	warning	Size of datafile is: 14       Should be: 7
test.t1	check	error	Record-count is not ok; is 2   Should be: 1
test.t1	check	warning	Found 2 key parts. Should be: 1
test.t1	check	error	Corrupt
# At this point we have a corrupt t1
set autocommit = 0;
select * from t2;
a
1
# Without fix select from t1 will break the transaction. After the fix
# transaction should be active and should hold lock on table t2. Alter
# table from con2 will wait only if the transaction is not broken.
select * from t1;
a
1
4
Warnings:
141
Error	145	Table 't1' is marked as crashed and should be repaired
142
Warning	1034	Number of rows changed from 1 to 2
143
connect con2, localhost, root;
144
ALTER TABLE t2 ADD val INT;
145
connection default;
146 147 148
# With fix we should have alter table waiting for t2 lock here.
ROLLBACK;
SET autocommit = 1;
149 150 151
connection con2;
connection default;
disconnect con2;
152 153
# Cleanup
drop table t1, t2;