| 1 |
# Set the environmental variables |
| 2 |
call mtr.add_suppression("Unable to read tablespace .* page no .* into the buffer pool after 100 attempts"); |
| 3 |
call mtr.add_suppression("Warning: database page corruption or a failed"); |
| 4 |
SET GLOBAL innodb_file_per_table=on; |
| 5 |
CREATE TABLE tab1(c1 INT PRIMARY KEY,c2 VARCHAR(20)) ENGINE=InnoDB; |
| 6 |
CREATE INDEX idx1 ON tab1(c2(10)); |
| 7 |
INSERT INTO tab1 VALUES(1, 'Innochecksum InnoDB1'); |
| 8 |
CREATE TABLE t1(id INT AUTO_INCREMENT PRIMARY KEY, msg VARCHAR(255)) ENGINE=INNODB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4; |
| 9 |
insert into t1 values(1,"i"); |
| 10 |
insert into t1 values(2,"am"); |
| 11 |
insert into t1 values(3,"compressed table"); |
| 12 |
# Shutdown the Server |
| 13 |
# Server Default checksum = innodb |
| 14 |
[1a]: check the innochecksum when file doesn't exists |
| 15 |
Pattern "Error: MYSQLD_DATADIR/test/aa.ibd cannot be found" found |
| 16 |
[1b]: check the innochecksum without --strict-check |
| 17 |
[2]: check the innochecksum with full form --strict-check=crc32 |
| 18 |
[3]: check the innochecksum with short form -C crc32 |
| 19 |
[4]: check the innochecksum with --no-check ignores algorithm check, warning is expected |
| 20 |
Pattern "Error: --no-check must be associated with --write option." found |
| 21 |
[5]: check the innochecksum with short form --no-check ignores algorithm check, warning is expected |
| 22 |
Pattern "Error: --no-check must be associated with --write option." found |
| 23 |
[6]: check the innochecksum with full form strict-check & no-check , an error is expected |
| 24 |
Pattern "Error: --strict-check option cannot be used together with --no-check option." found |
| 25 |
[7]: check the innochecksum with short form strict-check & no-check , an error is expected |
| 26 |
Pattern "Error: --strict-check option cannot be used together with --no-check option." found |
| 27 |
[8]: check the innochecksum with short & full form combination |
| 28 |
# strict-check & no-check, an error is expected |
| 29 |
Pattern "Error: --strict-check option cannot be used together with --no-check option." found |
| 30 |
[9]: check the innochecksum with full form --strict-check=innodb |
| 31 |
[10]: check the innochecksum with full form --strict-check=none |
| 32 |
# when server Default checksum=crc32 |
| 33 |
[11]: check the innochecksum with short form -C innodb |
| 34 |
# when server Default checksum=crc32 |
| 35 |
[12]: check the innochecksum with short form -C none |
| 36 |
# when server Default checksum=crc32 |
| 37 |
[13]: check strict-check with invalid values |
| 38 |
Pattern "Error while setting value \'strict_innodb\' to \'strict-check\'" found |
| 39 |
Pattern "Error while setting value \'strict_innodb\' to \'strict-check\'" found |
| 40 |
Pattern "Error while setting value \'strict_crc32\' to \'strict-check\'" found |
| 41 |
Pattern "Error while setting value \'strict_crc32\' to \'strict-check\'" found |
| 42 |
Pattern "Error while setting value \'strict_none\' to \'strict-check\'" found |
| 43 |
Pattern "Error while setting value \'strict_none\' to \'strict-check\'" found |
| 44 |
Pattern "Error while setting value \'InnoBD\' to \'strict-check\'" found |
| 45 |
Pattern "Error while setting value \'InnoBD\' to \'strict-check\'" found |
| 46 |
Pattern "Error while setting value \'crc\' to \'strict-check\'" found |
| 47 |
Pattern "Error while setting value \'no\' to \'strict-check\'" found |
| 48 |
[14a]: when server default checksum=crc32 rewrite new checksum=crc32 with innochecksum |
| 49 |
# Also check the long form of write option. |
| 50 |
[14b]: when server default checksum=crc32 rewrite new checksum=innodb with innochecksum |
| 51 |
# Also check the long form of write option. |
| 52 |
# start the server with innodb_checksum_algorithm=InnoDB |
| 53 |
# restart: --innodb_checksum_algorithm=innodb |
| 54 |
INSERT INTO tab1 VALUES(2, 'Innochecksum CRC32'); |
| 55 |
SELECT c1,c2 FROM tab1 order by c1,c2; |
| 56 |
c1 c2 |
| 57 |
1 Innochecksum InnoDB1 |
| 58 |
2 Innochecksum CRC32 |
| 59 |
# Stop the server |
| 60 |
[15]: when server default checksum=crc32 rewrite new checksum=none with innochecksum |
| 61 |
# Also check the short form of write option. |
| 62 |
# Start the server with checksum algorithm=none |
| 63 |
# restart: --innodb_checksum_algorithm=none |
| 64 |
INSERT INTO tab1 VALUES(3, 'Innochecksum None'); |
| 65 |
SELECT c1,c2 FROM tab1 order by c1,c2; |
| 66 |
c1 c2 |
| 67 |
1 Innochecksum InnoDB1 |
| 68 |
2 Innochecksum CRC32 |
| 69 |
3 Innochecksum None |
| 70 |
DROP TABLE t1; |
| 71 |
# Stop the server |
| 72 |
[16]: rewrite into new checksum=crc32 with innochecksum |
| 73 |
# Restart the DB server with innodb_checksum_algorithm=crc32 |
| 74 |
# restart: --innodb_checksum_algorithm=crc32 --innodb_file_per_table=on |
| 75 |
SELECT * FROM tab1; |
| 76 |
c1 c2 |
| 77 |
1 Innochecksum InnoDB1 |
| 78 |
2 Innochecksum CRC32 |
| 79 |
3 Innochecksum None |
| 80 |
DELETE FROM tab1 where c1=3; |
| 81 |
SELECT c1,c2 FROM tab1 order by c1,c2; |
| 82 |
c1 c2 |
| 83 |
1 Innochecksum InnoDB1 |
| 84 |
2 Innochecksum CRC32 |
| 85 |
# Stop server |
| 86 |
[17]: rewrite into new checksum=InnoDB |
| 87 |
# Restart the DB server with innodb_checksum_algorithm=InnoDB |
| 88 |
# restart: --innodb_checksum_algorithm=innodb --innodb_file_per_table=on |
| 89 |
DELETE FROM tab1 where c1=2; |
| 90 |
SELECT * FROM tab1; |
| 91 |
c1 c2 |
| 92 |
1 Innochecksum InnoDB1 |
| 93 |
# Stop server |
| 94 |
[18]:check Innochecksum with invalid write options |
| 95 |
Pattern "Error while setting value \'strict_crc32\' to \'write\'" found |
| 96 |
Pattern "Error while setting value \'strict_innodb\' to \'write\'" found |
| 97 |
Pattern "Error while setting value \'crc23\' to \'write\'" found |
| 98 |
# Restart the server |
| 99 |
# restart |
| 100 |
DROP TABLE tab1; |
| 101 |
SET GLOBAL innodb_file_per_table=default; |