[MDEV-26552] MyISAM index corruption on 400M rows - Jira

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;

relates to

MDEV-16461 MyISAM creates defect indexes on varchar, if rowcount is above some threshold between 480,000,000 and 490,000,000

Transition	Time In Source Status	Execution Times

Alice Sherepa made transition - 2021-11-26 12:10

Open

Closed

80d 18h 38m

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server