生产中遇到类似问题,就仔细查阅相关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)