MySQL Forums
Forum List  »  InnoDB

innochecksum doesn't rewrite checksums
Posted by: Christos Chatzaras
Date: August 31, 2021 12:05AM

I run innochecksum to rewrite the crc32 checksums but it doesn't work.

----

innochecksum --log=/tmp/log.txt ./test.ibd

Fail: page 879 invalid
Exceeded the maximum allowed checksum mismatch count::0

/tmp/log.txt shows:

InnoDB File Checksum Utility.
Filename = ./wp_actionscheduler_actions.ibd
Innochecksum: checking pages in range 0 to 5119
page::0; log sequence number:first = 254643106; second = 254643106
page::0; old style: calculated = 1912029061; recorded = 85334617
page::0; new style: calculated = 644652002; crc32 = 85334617; recorded = 85334617
...
page::879; log sequence number:first = 4184146375; second = 1835363957
Fail; page 879 invalid (fails log sequence number check)
...

----

innochecksum --log=/tmp/log2.txt --no-check --write crc32 ./test.ibd

/tmp/log2.txt shows:

InnoDB File Checksum Utility.
Filename = ./wp_actionscheduler_actions.ibd
Innochecksum: checking pages in range 0 to 5119
page::0; Updated checksum field1 = 85334617
page::0; Updated checksum field2 = 85334617
...
page::879; Updated checksum field1 = 3607082240
page::879; Updated checksum field2 = 3607082240
...

Options: ReplyQuote


Subject
Views
Written By
Posted
innochecksum doesn't rewrite checksums
1035
August 31, 2021 12:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.