Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.5.11, 10.5.12
-
debian unstable
Description
Hi
I have table corruption caught by check table.
I narrowed my ~400M rows table to a single integer column. The error happens after index creation if you run check table.
I managed to recreate it with a random set of 70K values distributed in 400M rows.
See the attached script. It completes in 32' in my system (oldish xeon with NVM) and it fails
with
--------------
|
CHECK TABLE bugtable
|
--------------
|
 |
+---------------+-------+-------+------------------------------------------+
|
| budb.bugtable | check | error | Key in wrong position at page 1023494144 | |
| budb.bugtable | check | error | Corrupt |
|
+---------------+-------+-------+------------------------------------------+
|
2 rows in set (38.701 sec) |
|
The script is easily run with:
time ./mysql-index-corruption-bug.sh bugdb bugtable;
|
Attachments
Issue Links
- relates to
-
-
- Confirmed
-