[MDEV-20617] InnoDB Failed to read file at offset Page read from tablespace is corrupted Created: 2019-09-18 Updated: 2023-05-12 Resolved: 2023-05-12 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.3.14 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | sysdljr | Assignee: | Marko Mäkelä |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | None | ||
| Environment: |
CentOS Linux release 7.3.1611 |
||
| Description |
|
Hi, 2019-09-18 2:42:43 0 [Note] InnoDB: Uncompressed page, stored checksum in field1 0, calculated checksums for field1: crc32 0, innodb 250018845, page type 17855 == INDEX.none 3735928559, stored checksum in field2 0, calculated check |
| Comments |
| Comment by Geoff Montee (Inactive) [ 2019-09-19 ] |
|
This looks like it might be a duplicate of |
| Comment by Marko Mäkelä [ 2023-04-14 ] |
|
There are many reasons why a page could be corrupted. One possible reason is that the files were incorrectly copied. There have been bugs in the default Galera snapshot transfer (SST) method rsync that were mostly fixed in Handling of corrupted pages was improved in Often, but not always, corrupted tables can be fixed by OPTIMIZE TABLE. Because according to the output, this corruption occurs in a secondary index, OPTIMIZE TABLE should be able to fix it. |