刷新binlog 日志报错，过程如下：http://www.cndba.cn/dave/article/2641

mysql> show master logs;
+------------------+-----------+
| Log_name         | File_size |
+------------------+-----------+
……
| mysql-bin.000011 |       432 |
| mysql-bin.000012 |       385 |
+------------------+-----------+
12 rows in set (0.00 sec)

mysql> flush logs;
ERROR 1105 (HY000): Unknown error
mysql> show master logs;
+------------------+-----------+
| Log_name         | File_size |
+------------------+-----------+
……
| mysql-bin.000011 |       432 |
| mysql-bin.000012 |       432 |
| mysql-bin.000013 |       385 |
+------------------+-----------+
13 rows in set (0.00 sec)

从结果看binlog是刷新成功了，但过程报错，查看MariaDB 错误日志：http://www.cndba.cn/dave/article/2641

mysql> show variables like '%log_error%';
+---------------+-----------------------------------+
| Variable_name | Value                             |
+---------------+-----------------------------------+
| log_error     | /mysql/log/www.cndba.cn-error.log |
+---------------+-----------------------------------+
1 row in set (0.00 sec)

[root@www.cndba.cn/dave data]# cat /mysql/log/www.cndba.cn-error.log
cat: /mysql/log/www.cndba.cn-error.log: No such file or directory
[root@www.cndba.cn/dave data]# cd /mysql/
 data  log
[root@www.cndba.cn/dave mysql]# ll
total 8
drwx------ 5 mysql mysql 4096 Feb  8 11:44 data
drwxr-xr-x 2 root  root  4096 Jan 31 03:33 log

由于日志所在目录只有root有权限新建文件，而MariaDB是用Mysql用户执行的，从mysql客户端执行flush logs其实是以mysql这个账号去执行的，所以会权限不足。

[root@www.cndba.cn/dave data]# ps -ef|grep mysql
root      1887     1  0 10:24 ?        00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/mysql/data --pid-file=/mysql/data/Dave.pid
mysql     2022  1887  0 10:24 ?        00:00:05 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/mysql/log/www.cndba.cn-error.log --pid-file=/mysql/data/Dave.pid --socket=/tmp/mysql.sock --port=3306
root      3089  2468  0 11:43 pts/0    00:00:00 mysql -uroot -p
root      3128  2496  0 11:55 pts/1    00:00:00 grep mysql

解决方法，修改log目录的权限为mysql即可：http://www.cndba.cn/dave/article/2641http://www.cndba.cn/dave/article/2641http://www.cndba.cn/dave/article/2641

[root@www.cndba.cn/dave mysql]# chown mysql:mysql log -R
[root@www.cndba.cn/dave mysql]# ll
total 8
drwx------ 5 mysql mysql 4096 Feb  8 11:47 data
drwxr-xr-x 2 mysql mysql 4096 Feb  8 11:47 log
[root@www.cndba.cn/dave mysql]#

mysql> flush logs;
Query OK, 0 rows affected (0.01 sec)

刷新成功。

版权声明：本文为博主原创文章，未经博主允许不得转载。