Debian Codegraph @

mysql-test/suite/memcached/include/sdi_corrupt_table.inc

raw
1 SET GLOBAL innodb_limit_optimistic_insert_debug = 2;
2
3 let TABLE_NAME = t1;
4 let MEMCACHED_TABLE_MAPPING = desc_t1;
5 --source ../include/sdi_insert_get_row.inc
6
7 let SDI_ID = 10;
8 let SDI_TYPE = 10;
9 let TABLE_METADATA = 'abcd10';
10 --source ../include/sdi_insert_row.inc
11
12 let SDI_ID = 11;
13 let SDI_TYPE = 11;
14 let TABLE_METADATA = 'abcd11';
15 --source ../include/sdi_insert_row.inc
16
17 let SDI_ID = 12;
18 let SDI_TYPE = 12;
19 let TABLE_METADATA = 'abcd12';
20 --source ../include/sdi_insert_row.inc
21
22 let SDI_ID = 13;
23 let SDI_TYPE = 13;
24 let TABLE_METADATA = 'abcd13';
25 --source ../include/sdi_insert_row.inc
26
27 let SDI_ID = 14;
28 let SDI_TYPE = 14;
29 let TABLE_METADATA = 'abcd14';
30 --source ../include/sdi_insert_row.inc
31
32 let SDI_ID = 15;
33 let SDI_TYPE = 15;
34 let TABLE_METADATA = 'abcd15';
35 --source ../include/sdi_insert_row.inc
36
37 # Ensure that dirty pages of table are flushed
38 SET GLOBAL innodb_buf_flush_list_now = 1;
39
40 --source include/shutdown_mysqld.inc
41
42 # Corrupt SDI page
43
44 perl;
45 my $fname= "$ENV{'MYSQLD_DATADIR'}test/t1.ibd";
46 open(FILE, "+<", $fname) or die;
47 binmode FILE;
48 seek(FILE, $ENV{'INNODB_PAGE_SIZE'} * $ENV{'SDI_PAGE_NUM'}, SEEK_SET);
49 print FILE chr(0) x 4;
50 close FILE;
51 EOF
52
53 --error 1
54 --exec $INNOCHECKSUM $MYSQLD_DATADIR/test/t1.ibd
55
56 let $restart_parameters = restart: --innodb_buffer_pool_load_at_startup=OFF;
57 --source include/start_mysqld.inc
58
59 --let $memcached_check_attempts=20
60 --let $memcached_expect=success
61 --source ../include/check_daemon_memcached.inc
62
63 # SDI Page Corrupted. Re-create indexes
64
65 --source ../include/sdi_drop_index.inc
66 --source ../include/sdi_create_index.inc
67
68 let TABLE_NAME = t1;
69 let MEMCACHED_TABLE_MAPPING = desc_t1;
70 --source ../include/sdi_insert_get_row.inc