[MDEV-17638] Improve error message about corruption of encrypted page Created: 2018-11-07 Updated: 2019-08-01 Resolved: 2019-08-01 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Encryption, Storage Engine - InnoDB |
| Affects Version/s: | 10.2.12, 10.3.10, 10.1.37 |
| Fix Version/s: | 10.2.27, 10.1.42, 10.3.18, 10.4.8 |
| Type: | Bug | Priority: | Major |
| Reporter: | Geoff Montee (Inactive) | Assignee: | Eugene Kosov (Inactive) |
| Resolution: | Fixed | Votes: | 2 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||||||||||||||||||
| Description |
|
See the following error message:
This is printed here: A lot of people seem to think that 227027 in the above message would refer to the page number, but it actually refers to the tablespace ID. I think we should improve this message. Maybe something like?:
|
| Comments |
| Comment by Marko Mäkelä [ 2018-11-08 ] | |||||||||||||
|
| |||||||||||||
| Comment by Marko Mäkelä [ 2018-11-08 ] | |||||||||||||
|
I think that it would be better in these messages to display the file name. I would still keep the tablespace ID in the output.
which produces more verbose output. | |||||||||||||
| Comment by Marko Mäkelä [ 2019-01-31 ] | |||||||||||||
|
The message was originally introduced in Ultimately, the message and the code path leading to it was removed in The presence of this message in an error log spells big trouble. The logic that was introduced in To make matters worse, there are several checksum algorithm implementations in InnoDB. It sufficed for one of the various algorithms to produce a matching checksum. In the case of one customer, an encrypted page had the exact same CRC-32C checksum both for the before-encryption and after-encryption checksums.
| |||||||||||||
| Comment by Geoff Montee (Inactive) [ 2019-01-31 ] | |||||||||||||
|
Ah, OK. It's good to know that the code path was removed. Thanks for the analysis! It looks like innochecksum still prints a similar message about corruption in the "Page $space_id:$page_num" format that has confused some people if you'd want to change that one too: | |||||||||||||
| Comment by Marko Mäkelä [ 2019-02-05 ] | |||||||||||||
|
Thanks for the clarification. I am lowering the priority from Critical. I would keep the terse format in messages that are only present in instrumented debug builds, but I agree that a more verbose format could be easier for users. | |||||||||||||
| Comment by Eugene Kosov (Inactive) [ 2019-08-01 ] | |||||||||||||
|
Diagnostics from topic message was removed in https://github.com/mariadb/server/commit/8c43f963882a9d5ac4e4289c8dd3dbcaeb40a0ce |