[MDEV-31688] Corrupt MyISAM Index with certain myisam_sort_buffer_size Created: 2023-07-14 Updated: 2023-07-14 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - MyISAM |
| Affects Version/s: | 11.1.1, 10.10.2, 10.3.38 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | David McLaughlin | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | corruption | ||
| Environment: |
Docker, Ubuntu |
||
| Description |
|
MyISM table index becomes corrupted and table unusable. I have found that different myisam_sort_buffer_size causes different results where some are just find and others are corrupted. I have written a bash script that demonstrates the problem and can be run inside the official Docker MariaDB. I have not found a version of MariaDB where this works correctly, but I did not try very old versions. % cat a.bash
mkfifo /tmp/somefifo MARIADB='mariadb -u root -pmy-secret-pw'
lines=0 $MARIADB -e 'load data infile "/tmp/somefifo" into table a.a' rm /tmp/somefifo $MARIADB -e 'select count The output for the failure is:
----------
----------
----------
---------- real 48m48.884s To reproduce the problem you can run build/run a docker instance using this command: Then I connnect to the container using Please contact me if you have any questions. |