Failed to execute mysql_file_stat on file

来源:互联网 发布:银月网络手游 编辑:程序博客网 时间:2024/06/01 10:07

Version: MySQL 5.6.19
现象:mysql错误日志告警:
[Note] Failed to execute mysql_file_stat on file ‘./mysql-bin.024316’

原因:purge binlog时,由于有些binlog 文件不在mysql-bin.index 中导致。

起因
大数据的一台MySQL磁盘空间告警,经检查发现是binlog太多导致。
show variables like ‘expire_logs_days’;
+——————+——-+
| Variable_name | Value |
+——————+——-+
| expire_logs_days | 3 |
+——————+——-+
1 row in set (0.00 sec)

处理过程
这几天有大量的数据导入,导致binlog产生过多。于是用’PURGE BINARY LOGS TO’ 删除部分binlog。
PURGE BINARY LOGS TO ‘mysql-bin.020456’;

触发报警
删除后,收到邮件告警,错误如下:
2017-08-18 09:33:10 3314 [Note] Failed to execute mysql_file_stat on file ‘./mysql-bin.024316’
2017-08-18 09:33:10 3314 [Note] Failed to execute mysql_file_stat on file ‘./mysql-bin.024317’
2017-08-18 09:33:10 3314 [Note] Failed to execute mysql_file_stat on file ‘./mysql-bin.024318’
2017-08-18 09:33:10 3314 [Note] Failed to execute mysql_file_stat on file ‘./mysql-bin.024319’
2017-08-18 09:33:10 3314 [Note] Failed to execute mysql_file_stat on file ‘./mysql-bin.024320’
2017-08-18 09:33:10 3314 [Note] Failed to execute mysql_file_stat on file ‘./mysql-bin.024321’
2017-08-18 09:33:10 3314 [Note] Failed to execute mysql_file_stat on file ‘./mysql-bin.024322’
2017-08-18 09:33:10 3314 [Note] Failed to execute mysql_file_stat on file ‘./mysql-bin.024323’

root cause
已经配置了expire_logs_days,且没有人手动删除binlog,为什么会出现这个错误呢?
是不是定时任务导致的呢?
crontab -l 检查了mysql用户下的几个定时任务,没发现问题。
会不会是其它用户下的定时任务呢?
检查root用户下的定时任务发现有一个备份binlog的定时任务
关键的一条命令是:ls -d /data1/mysql-bin* | sort | head -nexpr $all_gm - $num | xargs gzip
好暴力的命令啊,直接压缩binlog。这就是binlog丢失的原因。

阅读全文
0 0
原创粉丝点击