Production:
Mysql Server
Sysptom:
2021-11-18T02:41:00.473687Z 0 [Note] InnoDB: Buffer pool(s) load completed at 211118 10:41:00
mysqld: File '/mysqllogs/logs/****' not found (Errcode: 2 - No such file or directory)
2021-11-18T02:41:00.473953Z 0 [ERROR] Failed to open log (file '/mysqllogs/logs/*****', errno 2)
2021-11-18T02:41:00.473958Z 0 [ERROR] Could not open log file
2021-11-18T02:41:00.473967Z 0 [ERROR] Can't init tc log
2021-11-18T02:41:00.473970Z 0 [ERROR] Aborting
Solution:
Please check your bin logs on the disks.
Probably go to /mysqllogs/logs/, find index file, remove the bin logs entries from the index file don't exist on disk anymore.
Check the binlog.index
# less binlog.index
Audit the file, will remove the entry at almost cases