刷新binlog 日志报错，过程如下：
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 错误日志：
https://www.cndba.cn/dave/article/2641https://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这个账号去执行的，所以会权限不足。https://www.cndba.cn/dave/article/2641https://www.cndba.cn/dave/article/2641
https://www.cndba.cn/dave/article/2641
[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
[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)
刷新成功。
https://www.cndba.cn/dave/article/2641
https://www.cndba.cn/dave/article/2641
版权声明：本文为博主原创文章，未经博主允许不得转载。