[ERROR] Failed to open log (file './mysql-bin.000009', errno 13)

生产中遇到类似问题,就仔细查阅相关binlog文件的详情,这里是由于不能打开,原因是昨天下午我在做密码切换的时候直接使用root权限来修改相关数据了,导致发生了权限变更,今天早上启动的时候出现此类错误;如:

130125 09:28:20 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
130125  9:28:20 InnoDB: The InnoDB memory heap is disabled
130125  9:28:20 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
130125  9:28:20 InnoDB: Compressed tables use zlib 1.2.3
130125  9:28:20 InnoDB: Initializing buffer pool, size = 128.0M
130125  9:28:20 InnoDB: Completed initialization of buffer pool
130125  9:28:20 InnoDB: highest supported file format is Barracuda.
130125  9:28:20  InnoDB: Waiting for the background threads to start
130125  9:28:21 InnoDB: 1.1.7 started; log sequence number 893293355
/usr/local/mysql/bin/mysqld: File './mysql-bin.000009' not found (Errcode: 13)
130125  9:28:21 [ERROR] Failed to open log (file './mysql-bin.000009', errno 13)
130125  9:28:21 [ERROR] Could not open log file
130125  9:28:21 [ERROR] Can't init tc log
130125  9:28:21 [ERROR] Aborting

130125  9:28:21  InnoDB: Starting shutdown…
130125  9:28:22  InnoDB: Shutdown completed; log sequence number 893293355
130125  9:28:22 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

130125 09:28:22 mysqld_safe mysqld from pid file /usr/local/mysql/data/Slave02.pid ended
[root@Slave02 ~]#
以下进行check相关的文件;如;

[root@Slave02 ~]# cd /usr/local/mysql/data/
[root@Slave02 data]# ll -lh
total 994M
drwx------ 2 mysql mysql  4.0K Jan 24 17:04 book
-rw-rw---- 1 mysql mysql  458M Jan 25 09:28 ibdata1
-rw-rw---- 1 mysql mysql  5.0M Jan 25 09:28 ib_logfile0
-rw-rw---- 1 mysql mysql  5.0M Jan 24 17:04 ib_logfile1
drwxr-xr-x 2 mysql mysql  4.0K Dec 10 11:29 inno
-rw-r--r-- 1 mysql mysql   90K Nov 27 10:33 log.1
drwxr-xr-x 2 mysql mysql  4.0K Dec 10 11:29 mysql
-rw-rw---- 1 mysql mysql  255M Jan 22 18:02 mysql-bin.000001
-rw-rw---- 1 mysql mysql   126 Jan 23 09:39 mysql-bin.000002
-rw-rw---- 1 mysql mysql   126 Jan 23 09:45 mysql-bin.000003
-rw-rw---- 1 mysql mysql   126 Jan 23 09:54 mysql-bin.000004
-rw-rw---- 1 mysql mysql   107 Jan 23 09:54 mysql-bin.000005
-rw-rw---- 1 mysql mysql   107 Jan 23 11:29 mysql-bin.000006
-rw-rw---- 1 mysql mysql  214M Jan 23 15:27 mysql-bin.000007
-rw-rw---- 1 mysql mysql   56M Jan 24 17:57 mysql-bin.000008
-rw-rw---- 1 root  root    107 Jan 24 17:58 mysql-bin.000009
-rw-rw---- 1 mysql mysql   152 Jan 24 17:58 mysql-bin.index
-rw-r--r-- 1 mysql mysql   33K Nov 27 10:24 mysqld_multi.log
-rw-r--r-- 1 mysql mysql     5 Nov 27 10:28 mysql.pid
drwxr-xr-x 2 mysql mysql  4.0K Dec 10 11:29 performance_schema
drwx------ 2 mysql mysql  4.0K Jan 23 14:07 prod
-rw-rw---- 1 mysql root    56K Jan 25 09:28 Slave02.err
-rw-r--r-- 1 mysql mysql 1018K Jan 25 09:25 slow.log
drwxr-xr-x 2 mysql mysql  4.0K Jan 24 17:41 test
[root@Slave02 data]# 
然后进行权限修正即可;如;

[root@Slave02 data]# chmod  777 /usr/local/mysql/data/mysql-bin.000009
[root@Slave02 data]# ll
total 1017780
drwx------ 2 mysql mysql      4096 Jan 24 17:04 book
-rw-rw---- 1 mysql mysql 480247808 Jan 25 09:42 ibdata1
-rw-rw---- 1 mysql mysql   5242880 Jan 25 09:42 ib_logfile0
-rw-rw---- 1 mysql mysql   5242880 Jan 24 17:04 ib_logfile1
drwxr-xr-x 2 mysql mysql      4096 Dec 10 11:29 inno
-rw-r--r-- 1 mysql mysql     91820 Nov 27 10:33 log.1
drwxr-xr-x 2 mysql mysql      4096 Dec 10 11:29 mysql
-rw-rw---- 1 mysql mysql 266659867 Jan 22 18:02 mysql-bin.000001
-rw-rw---- 1 mysql mysql       126 Jan 23 09:39 mysql-bin.000002
-rw-rw---- 1 mysql mysql       126 Jan 23 09:45 mysql-bin.000003
-rw-rw---- 1 mysql mysql       126 Jan 23 09:54 mysql-bin.000004
-rw-rw---- 1 mysql mysql       107 Jan 23 09:54 mysql-bin.000005
-rw-rw---- 1 mysql mysql       107 Jan 23 11:29 mysql-bin.000006
-rw-rw---- 1 mysql mysql 223856963 Jan 23 15:27 mysql-bin.000007
-rw-rw---- 1 mysql mysql  58492833 Jan 24 17:57 mysql-bin.000008
-rwxrwxrwx 1 mysql mysql       107 Jan 24 17:58 mysql-bin.000009
-rw-rw---- 1 mysql mysql       152 Jan 24 17:58 mysql-bin.index
-rw-r--r-- 1 mysql mysql     33243 Nov 27 10:24 mysqld_multi.log
-rw-r--r-- 1 mysql mysql         5 Nov 27 10:28 mysql.pid
drwxr-xr-x 2 mysql mysql      4096 Dec 10 11:29 performance_schema
drwx------ 2 mysql mysql      4096 Jan 23 14:07 prod
-rw-rw---- 1 mysql mysql     57896 Jan 25 09:42 Slave02.err
-rw-r--r-- 1 mysql mysql   1041603 Jan 25 09:25 slow.log
drwxr-xr-x 2 mysql mysql      4096 Jan 24 17:41 test
[root@Slave02 data]#
启动数据库即可成功;如;

[root@Slave02 ~]# service mysqld restart
MySQL server PID file could not be found!                  [FAILED]
Starting MySQL..                                           [  OK  ]
[root@Slave02 ~]# 
注意:或者可以直接注释掉相关的binlog功能即可(谨记)!

未经允许不得转载:OZ分享-吉家大宝官方博客 » [ERROR] Failed to open log (file './mysql-bin.000009', errno 13)

评论 0

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

置顶文章