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
|
SET GLOBAL innodb_limit_optimistic_insert_debug = 2;
let TABLE_NAME = t1;
let MEMCACHED_TABLE_MAPPING = desc_t1;
--source ../include/sdi_insert_get_row.inc
let SDI_ID = 10;
let SDI_TYPE = 10;
let TABLE_METADATA = 'abcd10';
--source ../include/sdi_insert_row.inc
let SDI_ID = 11;
let SDI_TYPE = 11;
let TABLE_METADATA = 'abcd11';
--source ../include/sdi_insert_row.inc
let SDI_ID = 12;
let SDI_TYPE = 12;
let TABLE_METADATA = 'abcd12';
--source ../include/sdi_insert_row.inc
let SDI_ID = 13;
let SDI_TYPE = 13;
let TABLE_METADATA = 'abcd13';
--source ../include/sdi_insert_row.inc
let SDI_ID = 14;
let SDI_TYPE = 14;
let TABLE_METADATA = 'abcd14';
--source ../include/sdi_insert_row.inc
let SDI_ID = 15;
let SDI_TYPE = 15;
let TABLE_METADATA = 'abcd15';
--source ../include/sdi_insert_row.inc
# Ensure that dirty pages of table are flushed
SET GLOBAL innodb_buf_flush_list_now = 1;
--source include/shutdown_mysqld.inc
# Corrupt SDI page
perl;
my $fname= "$ENV{'MYSQLD_DATADIR'}test/t1.ibd";
open(FILE, "+<", $fname) or die;
binmode FILE;
seek(FILE, $ENV{'INNODB_PAGE_SIZE'} * $ENV{'SDI_PAGE_NUM'}, SEEK_SET);
print FILE chr(0) x 4;
close FILE;
EOF
--error 1
--exec $INNOCHECKSUM $MYSQLD_DATADIR/test/t1.ibd
let $restart_parameters = restart: --innodb_buffer_pool_load_at_startup=OFF;
--source include/start_mysqld.inc
--let $memcached_check_attempts=20
--let $memcached_expect=success
--source ../include/check_daemon_memcached.inc
# SDI Page Corrupted. Re-create indexes
--source ../include/sdi_drop_index.inc
--source ../include/sdi_create_index.inc
let TABLE_NAME = t1;
let MEMCACHED_TABLE_MAPPING = desc_t1;
--source ../include/sdi_insert_get_row.inc
|
