Debian Codegraph @

mysql-test/suite/maria/maria-recover.result

raw
1 select @@global.aria_recover_options;
2 @@global.aria_recover_options
3 BACKUP
4 set global aria_recover_options=off;
5 select @@global.aria_recover_options;
6 @@global.aria_recover_options
7 OFF
8 set global aria_recover_options=default;
9 select @@global.aria_recover_options;
10 @@global.aria_recover_options
11 BACKUP,QUICK
12 set global aria_recover_options=normal;
13 select @@global.aria_recover_options;
14 @@global.aria_recover_options
15 NORMAL
16 drop database if exists mysqltest;
17 create database mysqltest;
18 use mysqltest;
19 create table t1 (a varchar(1000), index(a)) engine=aria;
20 Warnings:
21 Note 1071 Specified key was too long; max key length is 2300 bytes
22 insert into t1 values("ThursdayMorningsMarket");
23 flush table t1;
24 insert into t1 select concat(a,'b') from t1 limit 1;
25 set global aria_checkpoint_interval=1000;
26 select * from t_corrupted2;
27 a
28 ThursdayMorningsMarket
29 ThursdayMorningsMarketb
30 Warnings:
31 Error 145 Got error '145 "Table was marked as crashed and should be repaired"' for 't_corrupted2'
32 Warning 1034 1 client is using or hasn't closed the table properly
33 Error 176 Got error '176 "Read page with wrong checksum"' for 't_corrupted2.MAI'
34 Error 1034 Can't read indexpage from page: 1, error: 176
35 select * from t_corrupted2;
36 a
37 ThursdayMorningsMarket
38 ThursdayMorningsMarketb
39 drop database mysqltest;
40 set global aria_recover_options=backup;
41 set global aria_checkpoint_interval=30;