Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6, 10.11, 11.2(EOL), 11.4
-
None
Description
Innochecksum wrongly reports the freed undo log as exisitng undo log pages. This gives wrong sense about undo log pages
are not being freed. To fix this issue, we introduce a new command line option
innochecksum --skip-freed-pages
|
or short option -r which makes innochecksum consult extent descriptor page and skip further analysis of pages that are marked as freed.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
Innochecksum wrongly reports the freed undo log as exisitng undo log pages. This gives wrong sense about undo log pages are not being freed. To fix this issue, innochecksum
should consult extent descriptor page before assuming the page is undo log page or freed one. |
Innochecksum wrongly reports the freed undo log as exisitng undo log pages. This gives wrong sense about undo log pages
are not being freed. To fix this issue, innochecksum should consult extent descriptor page before assuming the page is undo log page or freed one. |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Assignee | Thirunarayanan Balathandayuthapani [ thiru ] | Marko Mäkelä [ marko ] |
| Status | Confirmed [ 10101 ] | In Review [ 10002 ] |
| Assignee | Marko Mäkelä [ marko ] | Thirunarayanan Balathandayuthapani [ thiru ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Fix Version/s | 11.2(EOL) [ 28603 ] |
| issue.field.resolutiondate | 2024-11-27 08:01:33.0 | 2024-11-27 08:01:33.282 |
| Fix Version/s | 10.6.21 [ 29953 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Fix Version/s | 10.11 [ 27614 ] | |
| Fix Version/s | 11.4 [ 29301 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Fix Version/s | 10.11.11 [ 29954 ] | |
| Fix Version/s | 11.4.5 [ 29956 ] | |
| Fix Version/s | 11.7.2 [ 29914 ] |
| Link | This issue relates to TODO-5029 [ TODO-5029 ] |
| Link | This issue blocks MENT-2183 [ MENT-2183 ] |
| Description |
Innochecksum wrongly reports the freed undo log as exisitng undo log pages. This gives wrong sense about undo log pages
are not being freed. To fix this issue, innochecksum should consult extent descriptor page before assuming the page is undo log page or freed one. |
Innochecksum wrongly reports the freed undo log as exisitng undo log pages. This gives wrong sense about undo log pages
are not being freed. To fix this issue, we introduce a new command line option {code:sh} innochecksum --skip-freed-pages {code} or short option {{-r}} which makes {{innochecksum}} consult extent descriptor page and skip further analysis of pages that are marked as freed. |
Because we can’t trust the contents of FIL_PAGE_TYPE in old InnoDB system tablespaces, I think that this logic needs to be enabled for all pages, enabled by some command line option of innochecksum, which instructs it to not report page statistics for pages that have been marked as freed.
I would also suggest another option for validating the page number and tablespace ID inside those data pages that are not filled with NUL bytes, unless such logic already exists.