Debian Codegraph @

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

raw
1 set global aria_log_file_size=4294959104;
2 drop database if exists mysqltest;
3 create database mysqltest;
4 connect admin, 127.0.0.1, root,,mysqltest,,;
5 connection default;
6 use mysqltest;
7 connection default;
8 connection admin;
9 * shut down mysqld, removed logs, restarted it
10 connection default;
11 * TEST of Checkpoint between writing the commit log record and committing in trnman
12 create table t1(a int primary key) engine=aria;
13 insert into t1 values(1);
14 connection admin;
15 flush table t1;
16 * copied t1 for comparison
17 connection default;
18 set session debug_dbug="+d,maria_sleep_in_commit";
19 insert into t1 values(2);
20 connection admin;
21 set global aria_checkpoint_interval=1000;
22 connection default;
23 delete from t1 where a=2;
24 connection admin;
25 SET SESSION debug_dbug="+d,maria_flush_whole_log,maria_crash";
26 * crashing mysqld intentionally
27 set global aria_checkpoint_interval=1;
28 ERROR HY000: Lost connection to server during query
29 * recovery happens
30 check table t1 extended;
31 Table Op Msg_type Msg_text
32 mysqltest.t1 check status OK
33 * testing that checksum after recovery is as expected
34 Checksum-check
35 ok
36 connection default;
37 use mysqltest;
38 drop table t1;
39 * TEST of logging of BLOBs
40 CREATE TABLE `t1` (
41 `blob` blob,
42 `blob_key` blob
43 ) ENGINE=aria ROW_FORMAT=page
44 ;
45 connection admin;
46 * copied t1 for feeding_recovery
47 * compared t1 to old version
48 connection default;
49 set global aria_checkpoint_interval=0;
50 INSERT INTO `t1` VALUES (NULL,repeat('A',5198));
51 INSERT INTO `t1` VALUES (NULL,repeat('B',65535));
52 INSERT INTO `t1` VALUES (repeat('K',5198),repeat('L',2325));
53 INSERT INTO `t1` VALUES (repeat('C',65535),NULL);
54 INSERT INTO `t1` VALUES (NULL,repeat('D',65535));
55 INSERT INTO `t1` VALUES (repeat('E',65535),repeat('F',16111));
56 INSERT INTO `t1` VALUES (repeat('G',65535),repeat('H',65535));
57 INSERT INTO `t1` VALUES (repeat('I',5198),repeat('J',65535));
58 check table t1 extended;
59 Table Op Msg_type Msg_text
60 mysqltest.t1 check status OK
61 connection admin;
62 flush table t1;
63 * copied t1 for comparison
64 * compared t1 to old version
65 connection default;
66 connection admin;
67 SET SESSION debug_dbug="+d,maria_flush_whole_log,maria_crash";
68 * crashing mysqld intentionally
69 set global aria_checkpoint_interval=1;
70 ERROR HY000: Lost connection to server during query
71 * copied t1 back for feeding_recovery
72 * recovery happens
73 check table t1 extended;
74 Table Op Msg_type Msg_text
75 mysqltest.t1 check status OK
76 * testing that checksum after recovery is as expected
77 Checksum-check
78 ok
79 * compared t1 to old version
80 connection default;
81 use mysqltest;
82 drop table t1;
83 create table t1 engine=aria select 1;
84 connection admin;
85 * copied t1 for feeding_recovery
86 connection default;
87 set global aria_checkpoint_interval=0;
88 insert into t1 values(2);
89 truncate table t1;
90 connection admin;
91 flush table t1;
92 * copied t1 for comparison
93 connection default;
94 truncate table t1;
95 connection admin;
96 SET SESSION debug_dbug="+d,maria_flush_whole_log,maria_crash_create_table";
97 * crashing mysqld intentionally
98 truncate table t1;
99 ERROR HY000: Lost connection to server during query
100 * recovery happens
101 check table t1 extended;
102 Table Op Msg_type Msg_text
103 mysqltest.t1 check warning Size of indexfile is: <SIZE> Expected: 8192
104 mysqltest.t1 check status OK
105 * testing that checksum after recovery is as expected
106 Checksum-check
107 ok
108 connection default;
109 use mysqltest;
110 truncate table t1;
111 check table t1 extended;
112 Table Op Msg_type Msg_text
113 mysqltest.t1 check status OK
114 drop table t1;
115 CREATE TABLE t1 ( word VARCHAR(255) PRIMARY KEY ) ENGINE=Aria;
116 LOAD DATA INFILE '../../std_data/bug887051.txt' INTO TABLE t1;
117 SET AUTOCOMMIT=0;
118 DELETE FROM t1;
119 LOAD DATA INFILE '../../std_data/bug887051.txt' INTO TABLE t1 IGNORE 1 LINES;
120 COMMIT;
121 connection admin;
122 SET SESSION debug_dbug="+d,maria_flush_whole_log,maria_crash";
123 * crashing mysqld intentionally
124 set global aria_checkpoint_interval=1;
125 ERROR HY000: Lost connection to server during query
126 * recovery happens
127 check table t1 extended;
128 Table Op Msg_type Msg_text
129 mysqltest.t1 check status OK
130 * testing that checksum after recovery is as expected
131 Checksum-check
132 failure
133 connection default;
134 use mysqltest;
135 select * from t1;
136 word
137 saved2
138 drop table t1;
139 drop database mysqltest_for_feeding_recovery;
140 drop database mysqltest_for_comparison;
141 drop database mysqltest;