Debian Codegraph @

mysql-test/suite/innodb/r/strict_checksum.result

raw
1 #
2 # Bug #20031570 INNODB_CHECKSUM_ALGORITHM VARIABLE LEADS TO CRASHING
3 #
4 call mtr.add_suppression("Plugin \'InnoDB\'");
5 set global innodb_checksum_algorithm=crc32;
6 create table t1(f1 int not null primary key)engine=innodb;
7 SET GLOBAL innodb_buffer_pool_dump_at_shutdown=OFF;
8 # Restart the server with --log-error
9 # restart: --log-error=SEARCH_FILE --no-console
10 set global innodb_checksum_algorithm=strict_innodb;
11 set global innodb_limit_optimistic_insert_debug = 2;
12 select count(*) from t1;
13 count(*)
14 0
15 Pattern "\[Warning\] .*MY-\d+.* innodb_checksum_algorithm is set to "strict_innodb" but the page \[page id: space=\d+, page number=\d+\] contains a valid checksum .*. Accepting the page as valid. Change innodb_checksum_algorithm to .* to silently accept such pages or rewrite all pages so that they contain .* checksum." found
16 insert into t1 values(4),(5),(6);
17 SET GLOBAL innodb_buffer_pool_dump_at_shutdown=OFF;
18 # Restart the server with --log-error
19 # restart: --log-error=SEARCH_FILE --no-console
20 set global innodb_checksum_algorithm=strict_none;
21 set global innodb_limit_optimistic_insert_debug = 2;
22 select count(*) from t1;
23 count(*)
24 3
25 insert into t1 values(7),(8),(9);
26 Pattern "\[Warning\] .*MY-\d+.* innodb_checksum_algorithm is set to "strict_none" but the page \[page id: space=\d+, page number=\d+\] contains a valid checksum .*. Accepting the page as valid. Change innodb_checksum_algorithm to .* to silently accept such pages or rewrite all pages so that they contain .* checksum." found
27 SET GLOBAL innodb_buffer_pool_dump_at_shutdown=OFF;
28 # Restart the server with --log-error
29 # restart: --log-error=SEARCH_FILE --no-console
30 set global innodb_checksum_algorithm=strict_crc32;
31 select count(*) from t1;
32 count(*)
33 6
34 Pattern "\[Warning\] .*MY-\d+.* innodb_checksum_algorithm is set to "strict_crc32" but the page \[page id: space=\d+, page number=\d+\] contains a valid checksum .*. Accepting the page as valid. Change innodb_checksum_algorithm to .* to silently accept such pages or rewrite all pages so that they contain .* checksum." found
35 drop table t1;
36 # restart: