mysql flush logs 1105_MariaDB 执行 flush logs 命令产生 ERROR 1105 (HY000)错误解决方法

刷新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

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