Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.7(EOL)
Description
The innodb_checksum_algorithm=full_crc32 that was introduced in 10.4 and made the default in 10.5 (MDEV-19534) was not fully implemented in the innochecksum tool.
- Apparently, no checksum mismatch will be noticed for page_compressed tables, except for uncompressed pages (such as page 0).
- The page type summary will report all full_crc32 pages as being of "other" type.
In the full_crc32 format, we can validate the page checksum without decrypting or decompressing the page. Therefore, we can (and should) validate all full_crc32 checksums, even if the table is encrypted or compressed.
Note: There is no full_crc32 format for ROW_FORMAT=COMPRESSED tables. They always use an Adler32 checksum or an exclusive OR of two CRC-32C checksums.
Attachments
Issue Links
- relates to
-
MDEV-12933 sort out the compression library chaos
- Closed