Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.1.21
-
Debian Wheezy amd64
-
10.1.22, 10.2.6-2, 10.2.6-3
Description
innochecksum returns an error message when ran on ibdata1 on a server that is working fine (a check on all tables has been done without finding anything) :
# innochecksum -d /var/lib/mysql/ibdata1
|
InnoDB offline file checksum utility.
|
|
Variables (--variable-name=value)
|
and boolean options {FALSE|TRUE} Value (after reading options)
|
--------------------------------- ----------------------------------------
|
verbose TRUE
|
debug TRUE
|
skip-corrupt FALSE
|
count FALSE
|
start-page 0
|
end-page 0
|
page 0
|
per-page-details FALSE
|
leaf FALSE
|
merge 0
|
Table is uncompressed
|
Page size is 16384
|
file /var/lib/mysql/ibdata1 = 3844079616 bytes (234624 pages)...
|
InnoChecksum; checking pages in range 0 to 234623
|
Page 0 encrypted key_version 5 checksum 1135705172
|
page 0: log sequence number: first = 1136557346; second = 1136557346
|
page 0: old style: calculated = 2609070081; recorded = 2609070081
|
page 0: new style: calculated = 3631443077; crc32 = 286255075; recorded = 1135705172
|
Fail; page 0 invalid (fails innodb and crc32 checksum)
|
This server was previously running on 10.0 and was just upgraded to 10.1 and it is not using tablespace encryption.
Attachments
Issue Links
- blocks
-
MDEV-13443 Port innochecksum tests from 10.2 innodb_zip suite to 10.1
-
- Closed
-
- causes
-
MDEV-20583 innochecksum man pages seem to be inconsistent with the binary (10.2.25)
-
- Closed
-
- includes
-
MDEV-13279 innodb_zip.innochecksum_3 failed in buildbot (InnoDB warnings)
-
- Closed
-
- relates to
-
MDEV-11759 Encryption code in MariaDB 10.1/10.2 causes compatibility problems
-
- Closed
-
-
MDEV-12711 backup may show corruption with custom innodb_data_file_path
-
- Closed
-
-
MDEV-17638 Improve error message about corruption of encrypted page
-
- Closed
-
-
MDEV-18529 InnoDB wrongly skips decryption of encrypted page if unencrypted and post-encrypted checksums match
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Fix Version/s | 10.1 [ 16100 ] | |
Assignee | Marko Mäkelä [ marko ] |
Attachment | MDEV11939-page0.bin [ 43272 ] |
Link |
This issue relates to |
Assignee | Marko Mäkelä [ marko ] | Jan Lindström [ jplindst ] |
Summary | innochecksum is not working on 10.1 (page 0 invalid) | innochecksum mistakes a file for an encrypted one (page 0 invalid) |
Link |
This issue relates to |
Link |
This issue relates to |
Status | Open [ 1 ] | In Progress [ 3 ] |
Sprint | 10.1.22 [ 143 ] |
Rank | Ranked higher |
Assignee | Jan Lindström [ jplindst ] | Marko Mäkelä [ marko ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Sprint | 10.1.22 [ 143 ] | 10.1.22, 10.2.6-2 [ 143, 148 ] |
Rank | Ranked lower |
Sprint | 10.1.22, 10.2.6-2 [ 143, 148 ] | 10.1.22, 10.2.6-2, 10.2.6-3 [ 143, 148, 150 ] |
Link |
This issue relates to |
Assignee | Marko Mäkelä [ marko ] | Jan Lindström [ jplindst ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
Status | Stalled [ 10000 ] | In Progress [ 3 ] |
Link |
This issue blocks |
issue.field.resolutiondate | 2017-08-08 06:43:14.0 | 2017-08-08 06:43:14.322 |
Fix Version/s | 10.1.26 [ 22553 ] | |
Fix Version/s | 10.2.8 [ 22544 ] | |
Fix Version/s | 10.1 [ 16100 ] | |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Closed [ 6 ] |
Link |
This issue relates to |
Link |
This issue relates to |
Workflow | MariaDB v3 [ 79434 ] | MariaDB v4 [ 151626 ] |
Link |
This issue causes |
Link |
This issue includes |
jb-boin Which 10.1 version was the 10.0 server upgraded to, and which version of innochecksum was invoked?
I suspect that this is related to
MDEV-11623in some way.I cannot repeat this when invoking the latest 10.1 innochecksum on a freshly created ibdata1 file with the latest 10.1. I tried both the default innodb_page_size=16k and the non-default setting innodb_page_size=4k.