Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.6.14, (13)
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
Description
When using
/usr/bin/innochecksum Ver 10.6.14, for debian-linux-gnu (x86_64)
I get "Floating point exception" error at end of output for the command
/usr/bin/innochecksum -S ./ibdata1
|
...
|
Undo page type: 459
|
Undo page state: 0 active, 285 cached, 0 to_purge, 0 prepared, 174 other
|
index_id #pages #leaf_pages #recs_per_page #bytes_per_page
|
1 1 1 171 15368
|
2 10 9 138 9213
|
3 5 4 91 7322
|
4 4 3 145 6528
|
5 1 1 171 7673
|
11 3 2 58 6882
|
12 1 1 174 12921
|
13 1 1 174 11773
|
14 1 1 184 14895
|
Floating point exception
|
|
Testing against the same ibdata1 file against innochecksum that is provided with mysql 5.7.42 I do not get any error.
I have seen this on two recent cases. ibdata1 file is attached.
Attachments
Issue Links
- is caused by
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Attachment | ibdata1.gz [ 70873 ] |
| Labels | Papercut beginner-friendly |
| Component/s | Storage Engine - InnoDB [ 10129 ] |
| Affects Version/s | 10.6.14 [ 28914 ] |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.6 [ 24028 ] |
| Assignee | Marko Mäkelä [ marko ] |
This was caused by MDEV-25361. If an index or a table has been dropped and the page is marked as freed, we should not report anything. The floating point exception is being reported for entries that are all 0, except for the freed_pages member:
/* update per-index statistics */ |
{
|
per_index_stats &index = index_ids[id];
|
if (is_page_free(xdes, physical_page_size, |
page_no)) {
|
index.free_pages++;
|
return; |
}
|
|
|
index.pages++;
|
The invocation of std::map::operator[] will allocate and default-initialize an element.
| Link |
This issue is caused by |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.9 [ 26905 ] | |
| Fix Version/s | 10.10 [ 27530 ] | |
| Fix Version/s | 10.11 [ 27614 ] | |
| Fix Version/s | 11.0 [ 28320 ] | |
| Fix Version/s | 11.1 [ 28549 ] | |
| Fix Version/s | 11.2 [ 28603 ] | |
| Affects Version/s | 10.2 [ 14601 ] | |
| Affects Version/s | 10.3 [ 22126 ] | |
| Affects Version/s | 10.4 [ 22408 ] | |
| Affects Version/s | 10.5 [ 23123 ] | |
| Affects Version/s | 10.6 [ 24028 ] | |
| Affects Version/s | 10.7 [ 24805 ] | |
| Affects Version/s | 10.8 [ 26121 ] | |
| Affects Version/s | 10.9 [ 26905 ] | |
| Affects Version/s | 10.10 [ 27530 ] | |
| Affects Version/s | 10.11 [ 27614 ] | |
| Affects Version/s | 11.0 [ 28320 ] | |
| Affects Version/s | 11.1 [ 28549 ] | |
| Affects Version/s | 11.2 [ 28603 ] |
| issue.field.resolutiondate | 2023-07-10 11:09:31.0 | 2023-07-10 11:09:31.53 |
| Fix Version/s | 10.4.31 [ 29010 ] | |
| Fix Version/s | 10.5.22 [ 29011 ] | |
| Fix Version/s | 10.6.15 [ 29013 ] | |
| Fix Version/s | 10.9.8 [ 29015 ] | |
| Fix Version/s | 10.10.6 [ 29017 ] | |
| Fix Version/s | 10.11.5 [ 29019 ] | |
| Fix Version/s | 11.0.3 [ 28920 ] | |
| Fix Version/s | 11.1.2 [ 28921 ] | |
| Fix Version/s | 11.2.1 [ 29034 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Fix Version/s | 10.9 [ 26905 ] | |
| Fix Version/s | 10.10 [ 27530 ] | |
| Fix Version/s | 10.11 [ 27614 ] | |
| Fix Version/s | 11.0 [ 28320 ] | |
| Fix Version/s | 11.1 [ 28549 ] | |
| Fix Version/s | 11.2 [ 28603 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Zendesk Related Tickets | 183494 |
The n_leaf_pages is 0 for a particular index it seems (bottom of defrag_analysis function in ./extra/innochecksum.cc).