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
|
INSERT INTO cache_policies VALUES('cache_policy', 'innodb_only',
'innodb_only', 'innodb_only', 'innodb_only');
INSERT INTO config_options VALUES('separator', '|');
INSERT INTO containers VALUES ('desc_t1', 'test', 't1',
'c1', 'c2', '0', '0', '0', 'PRIMARY');
USE test;
CREATE TABLE t1 (c1 INT PRIMARY KEY,
c2 VARCHAR(30),
c3 FLOAT,
KEY idx1(c3),
KEY idx2(c2(20)))
ENGINE = INNODB;
INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
Warnings:
Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
# 1. Corrupt SDI Leaf Page
SET GLOBAL innodb_limit_optimistic_insert_debug = 2;
Get rec(type:id) is t1 CREATE TABLE `t1` (
`c1` int NOT NULL,
`c2` varchar(30) DEFAULT NULL,
`c3` float DEFAULT NULL,
PRIMARY KEY (`c1`),
KEY `idx1` (`c3`),
KEY `idx2` (`c2`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
SET GLOBAL innodb_buf_flush_list_now = 1;
# restart: --innodb_buffer_pool_load_at_startup=OFF
Get rec(type:id) is t1 CREATE TABLE `t1` (
`c1` int NOT NULL,
`c2` varchar(30) DEFAULT NULL,
`c3` float DEFAULT NULL,
PRIMARY KEY (`c1`),
KEY `idx1` (`c3`),
KEY `idx2` (`c2`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
DROP TABLE t1;
CREATE TABLE t1 (c1 INT PRIMARY KEY,
c2 VARCHAR(30),
c3 FLOAT,
KEY idx1(c3),
KEY idx2(c2(20)))
ENGINE = INNODB;
# 2. Corrupt SDI Non-Leaf Page
SET GLOBAL innodb_limit_optimistic_insert_debug = 2;
Get rec(type:id) is t1 CREATE TABLE `t1` (
`c1` int NOT NULL,
`c2` varchar(30) DEFAULT NULL,
`c3` float DEFAULT NULL,
PRIMARY KEY (`c1`),
KEY `idx1` (`c3`),
KEY `idx2` (`c2`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
SET GLOBAL innodb_buf_flush_list_now = 1;
# restart: --innodb_buffer_pool_load_at_startup=OFF
Get rec(type:id) is t1 CREATE TABLE `t1` (
`c1` int NOT NULL,
`c2` varchar(30) DEFAULT NULL,
`c3` float DEFAULT NULL,
PRIMARY KEY (`c1`),
KEY `idx1` (`c3`),
KEY `idx2` (`c2`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
DROP TABLE t1;
CREATE TABLE t1 (c1 INT PRIMARY KEY,
c2 VARCHAR(30),
c3 FLOAT,
KEY idx1(c3),
KEY idx2(c2(20)))
ENGINE = INNODB;
# 3. Corrupt SDI Root Page. We cannot drop and create SDI Indexes
# We expect crash when dropping SDI indexes.
SET GLOBAL innodb_limit_optimistic_insert_debug = 2;
Get rec(type:id) is t1 CREATE TABLE `t1` (
`c1` int NOT NULL,
`c2` varchar(30) DEFAULT NULL,
`c3` float DEFAULT NULL,
PRIMARY KEY (`c1`),
KEY `idx1` (`c3`),
KEY `idx2` (`c2`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
# restart: --log-error=MYSQLTEST_VARDIR/tmp/crash.log --innodb_buffer_pool_load_at_startup=OFF
# restart: --innodb_buffer_pool_load_at_startup=OFF
Pattern "Unable to read page \[page id: space=\d+, page number=\d+\] into the buffer pool after \d+ attempts" found
DROP TABLE t1;
DROP DATABASE innodb_memcache;
UNINSTALL PLUGIN daemon_memcached;
|
