Debian Codegraph @

mysql-test/suite/memcached/r/memc287_sdi_corruption.result

raw
1 INSERT INTO cache_policies VALUES('cache_policy', 'innodb_only',
2 'innodb_only', 'innodb_only', 'innodb_only');
3 INSERT INTO config_options VALUES('separator', '|');
4 INSERT INTO containers VALUES ('desc_t1', 'test', 't1',
5 'c1', 'c2', '0', '0', '0', 'PRIMARY');
6 USE test;
7 CREATE TABLE t1 (c1 INT PRIMARY KEY,
8 c2 VARCHAR(30),
9 c3 FLOAT,
10 KEY idx1(c3),
11 KEY idx2(c2(20)))
12 ENGINE = INNODB;
13 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
14 Warnings:
15 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
16 # 1. Corrupt SDI Leaf Page
17 SET GLOBAL innodb_limit_optimistic_insert_debug = 2;
18 Get rec(type:id) is t1 CREATE TABLE `t1` (
19 `c1` int NOT NULL,
20 `c2` varchar(30) DEFAULT NULL,
21 `c3` float DEFAULT NULL,
22 PRIMARY KEY (`c1`),
23 KEY `idx1` (`c3`),
24 KEY `idx2` (`c2`(20))
25 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
26 SET GLOBAL innodb_buf_flush_list_now = 1;
27 # restart: --innodb_buffer_pool_load_at_startup=OFF
28 Get rec(type:id) is t1 CREATE TABLE `t1` (
29 `c1` int NOT NULL,
30 `c2` varchar(30) DEFAULT NULL,
31 `c3` float DEFAULT NULL,
32 PRIMARY KEY (`c1`),
33 KEY `idx1` (`c3`),
34 KEY `idx2` (`c2`(20))
35 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
36 DROP TABLE t1;
37 CREATE TABLE t1 (c1 INT PRIMARY KEY,
38 c2 VARCHAR(30),
39 c3 FLOAT,
40 KEY idx1(c3),
41 KEY idx2(c2(20)))
42 ENGINE = INNODB;
43 # 2. Corrupt SDI Non-Leaf Page
44 SET GLOBAL innodb_limit_optimistic_insert_debug = 2;
45 Get rec(type:id) is t1 CREATE TABLE `t1` (
46 `c1` int NOT NULL,
47 `c2` varchar(30) DEFAULT NULL,
48 `c3` float DEFAULT NULL,
49 PRIMARY KEY (`c1`),
50 KEY `idx1` (`c3`),
51 KEY `idx2` (`c2`(20))
52 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
53 SET GLOBAL innodb_buf_flush_list_now = 1;
54 # restart: --innodb_buffer_pool_load_at_startup=OFF
55 Get rec(type:id) is t1 CREATE TABLE `t1` (
56 `c1` int NOT NULL,
57 `c2` varchar(30) DEFAULT NULL,
58 `c3` float DEFAULT NULL,
59 PRIMARY KEY (`c1`),
60 KEY `idx1` (`c3`),
61 KEY `idx2` (`c2`(20))
62 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
63 DROP TABLE t1;
64 CREATE TABLE t1 (c1 INT PRIMARY KEY,
65 c2 VARCHAR(30),
66 c3 FLOAT,
67 KEY idx1(c3),
68 KEY idx2(c2(20)))
69 ENGINE = INNODB;
70 # 3. Corrupt SDI Root Page. We cannot drop and create SDI Indexes
71 # We expect crash when dropping SDI indexes.
72 SET GLOBAL innodb_limit_optimistic_insert_debug = 2;
73 Get rec(type:id) is t1 CREATE TABLE `t1` (
74 `c1` int NOT NULL,
75 `c2` varchar(30) DEFAULT NULL,
76 `c3` float DEFAULT NULL,
77 PRIMARY KEY (`c1`),
78 KEY `idx1` (`c3`),
79 KEY `idx2` (`c2`(20))
80 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
81 # restart: --log-error=MYSQLTEST_VARDIR/tmp/crash.log --innodb_buffer_pool_load_at_startup=OFF
82 # restart: --innodb_buffer_pool_load_at_startup=OFF
83 Pattern "Unable to read page \[page id: space=\d+, page number=\d+\] into the buffer pool after \d+ attempts" found
84 DROP TABLE t1;
85 DROP DATABASE innodb_memcache;
86 UNINSTALL PLUGIN daemon_memcached;