[MDEV-16089] myisamchk gets Errcode: 175 "File too short; Expected more data in file" as number of rows in MyISAM table increases, unless buffer sizes are reduced Created: 2018-05-03  Updated: 2020-08-25  Resolved: 2018-06-28

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - MyISAM
Affects Version/s: 10.2.13
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Juan Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

CentOS 6.9 & CentOS 7.3


 Description   

myisamchk fails with the following error:

/bin/myisamchk: Unexpected end-of-file found when reading file '/STMWKoK5' (Errcode: 175 "File too short; Expected more data in file").

when rowcount exceeds 2.124 billion and key_buffer_size and sort_buffer_size under [myisamchk] tag is set to 4GB.

When these values are adjusted to 2GB, the command works.

As the table has grown to ~3 billion rows, buffer sizes must be lowered to 1GB for the command to work.

 Comments   
Comment by Elena Stepanova [ 2018-06-01 ]

I am not getting the error.

data/releases/10.2.13/data/test$ ../../bin/myisamchk --key_buffer_size=4G --sort_buffer_size=4G t
 
Checking MyISAM file: t
 
Data records: 2125000000   Deleted blocks:       0
 
- check file-size
 
- check record delete-chain
 
- check key delete-chain
 
- check index reference
 
- check data record references index: 1
 
- check data record references index: 2

Please provide the exact steps to reproduce (server config, data table structure, exact amount of data needed, the client config).

Generated at Thu Feb 08 08:26:17 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.