1
set global aria_log_file_size=4294959104;
2
drop database if exists mysqltest;
3
create database mysqltest;
5
* TEST of recovery with blobs
6
* shut down mysqld, removed logs, restarted it
7
create table t1 (a int, b longtext) engine=aria table_checksum=1;
8
* copied t1 for feeding_recovery
9
insert into t1 values (1,"123456789012345678901234567890"),(2,"09876543210987654321");
11
* copied t1 for comparison
13
update t1 set b=CONCAT(b,b);
14
update t1 set b=CONCAT(b,b);
15
update t1 set b=CONCAT(b,b);
16
update t1 set b=CONCAT(b,b);
17
update t1 set b=CONCAT(b,b);
18
update t1 set b=CONCAT(b,b);
19
update t1 set b=CONCAT(b,b);
20
update t1 set b=CONCAT(b,b);
21
update t1 set b=CONCAT(b,b);
22
update t1 set b=CONCAT(b,b);
23
update t1 set b=CONCAT(b,b);
24
update t1 set b=CONCAT(b,b);
25
update t1 set b=CONCAT(b,b);
26
update t1 set b=CONCAT(b,b);
27
update t1 set b=CONCAT(b,b);
28
update t1 set b=CONCAT(b,b);
29
update t1 set b=CONCAT(b,b);
30
update t1 set b=CONCAT(b,b);
31
update t1 set b=CONCAT(b,b);
32
update t1 set b=CONCAT(b,b);
33
select a,length(b) from t1;
37
update t1 set b=mid(b,1,length(b)/2);
38
update t1 set b=mid(b,1,length(b)/2);
39
update t1 set b=mid(b,1,length(b)/2);
40
update t1 set b=mid(b,1,length(b)/2);
41
update t1 set b=mid(b,1,length(b)/2);
42
update t1 set b=mid(b,1,length(b)/2);
43
update t1 set b=mid(b,1,length(b)/2);
44
update t1 set b=mid(b,1,length(b)/2);
45
update t1 set b=mid(b,1,length(b)/2);
46
update t1 set b=mid(b,1,length(b)/2);
47
update t1 set b=mid(b,1,length(b)/2);
48
update t1 set b=mid(b,1,length(b)/2);
49
update t1 set b=mid(b,1,length(b)/2);
50
update t1 set b=mid(b,1,length(b)/2);
51
update t1 set b=mid(b,1,length(b)/2);
52
update t1 set b=mid(b,1,length(b)/2);
53
update t1 set b=mid(b,1,length(b)/2);
54
update t1 set b=mid(b,1,length(b)/2);
55
update t1 set b=mid(b,1,length(b)/2);
56
update t1 set b=mid(b,1,length(b)/2);
57
update t1 set b=mid(b,1,length(b)/2);
58
update t1 set b=mid(b,1,length(b)/2);
59
select a,length(b) from t1;
63
SET SESSION debug_dbug="+d,maria_flush_whole_log,maria_crash";
64
* crashing mysqld intentionally
65
set global aria_checkpoint_interval=1;
66
ERROR HY000: Lost connection to MySQL server during query
67
* copied t1 back for feeding_recovery
69
check table t1 extended;
70
Table Op Msg_type Msg_text
71
mysqltest.t1 check status OK
72
* testing that checksum after recovery is as expected
77
drop database mysqltest_for_feeding_recovery;
78
drop database mysqltest_for_comparison;
79
drop database mysqltest;