Bug #116627 innodb print tons of partial read in error log
Submitted: 12 Nov 2024 10:30 Modified: 12 Nov 2024 11:55
Reporter: Zihao Wang (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[12 Nov 2024 10:30] Zihao Wang 
Description:
This situation has been discussed before: https://bugs.mysql.com/bug.php?id=106280. Although the triggering reason is different, I encountered the same problem in https://bugs.mysql.com/bug.php?id=116626.

How to repeat:
Use the same way in https://bugs.mysql.com/bug.php?id=116626.

Suggested fix:
Fix the "for (;;)" loop in `os_file_read_page`. At least add a judgement of loop times. Also, reduce the error log output in this case (it can quickly full up the disk).
[12 Nov 2024 11:55] MySQL Verification Team 
Hello Zihao Wang,

Thank you for the report and feedback.

regards,
Umesh
[12 Nov 2024 18:57] MySQL Verification Team 
reminded me of https://bugs.mysql.com/bug.php?id=87222