Bug #110780 correct ib::error when disk use 100%
Submitted: 24 Apr 2023 11:53 Modified: 24 Apr 2023 12:16
Reporter: bin wang (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[24 Apr 2023 11:53] bin wang 
Description:
when data_dir is full with 100%  
a error message
[ERROR] [MY-012144] [InnoDB] posix_fallocate(): Failed to preallocate data for file ./t1/sbtest16.ibd, desired size 4194304 bytes. Operating system error number 28. Check that the disk is not full or a disk quota exceeded. Make sure the file system supports this function. Refer to your operating system documentation for operating system error code information.

How to repeat:
  sysbench src/lua/oltp_read_write.lua     --mysql-port=3306 --mysql-user=test   --mysql-db=t1      --table-size=1000000 --report-interval=10 --threads=128  --tables=100  prepare  
 insert into data until  data directory  is 100%

/dev/sdb                 9.8G  9.6G     0  100% /data

Suggested fix:
at this time  disk is  full , so should change to  
Check that the disk is  full or a disk quota exceeded. Make sure the file system supports this function.
[24 Apr 2023 11:54] bin wang 
suggested add  patch

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: full.patch (application/octet-stream, text), 606 bytes.
[24 Apr 2023 12:16] MySQL Verification Team 
Hello bin wang,

Thank you for the report and contribution.

regards,
Umesh