mariadb-galera集群宕机节点重启失败

最新推荐文章于 2024-09-11 15:20:59 发布

原创最新推荐文章于 2024-09-11 15:20:59 发布 · 4.7k 阅读

0 ·

CC 4.0 BY-SA版权

openstack 专栏收录该内容

11 篇文章

订阅专栏

本文记录了一次在虚拟机环境中搭建Galera集群时遇到的问题。当节点宕机并尝试重启后，节点无法加入集群，错误日志显示GSSAPI错误和PID文件权限问题。通过修改PID文件权限并启动mariadb服务，成功恢复了节点的正常运行。

搭建galera集群的时候，在虚拟机测试搭建，电脑关机重启后，发现宕机后的节点无法加入集群。
查看/var/log/mariadb/mariadb.log发现报错如下：
[root@controller1 ~]# tail -300f /var/log/mariadb/mariadb.log

2019-05-28 2:09:41 139686358980800 [ERROR] mysqld: Server GSSAPI error (major 851968, minor 2529639093) : gss_acquire_cred failed -Unspecified GSS failure. Minor code may provide more information. Keytab FILE:/etc/krb5.keytab is nonexistent or empty.
2019-05-28 2:09:41 139686358980800 [ERROR] Plugin ‘gssapi’ init function returned error.
2019-05-28 2:09:41 139686358980800 [Note] Server socket created on IP: ‘192.168.1.73’.
2019-05-28 2:09:41 139685977000704 [ERROR] mysqld: Can’t create/write to file ‘/var/run/mariadb/mariadb.pid’ (Errcode: 13 “Permission denied”)
2019-05-28 2:09:41 139685977000704 [ERROR] Can’t start server: can’t create PID file: Permission denied

原来是pid文件权限不够。更改文件权限
[root@controller1 ~]#chown mysql:mysql /var/run/mariadb/mariadb.pid

启动mariadb服务
[root@controller1 ~]# systemctl start mariadb

查看服务状态恢复正常
[root@controller1 ~]# systemctl status mariadb -l

● mariadb.service - MariaDB 10.1 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Active: active (running) since Tue 2019-05-28 02:10:53 CST; 5min ago
Process: 27566 ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, status=0/SUCCESS)
Process: 27271 ExecStartPre=/usr/libexec/mysql-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Process: 27248 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
Main PID: 27431 (mysqld)
Status: “Taking your SQL requests now…”
Tasks: 34
CGroup: /system.slice/mariadb.service
└─27431 /usr/libexec/mysqld --basedir=/usr

May 28 02:10:51 controller1 rsyncd[27509]: connect from controller3 (192.168.1.143)
May 28 02:10:51 controller1 rsyncd[27508]: rsync to rsync_sst/./glance from controller3 (192.168.1.143)
May 28 02:10:51 controller1 rsyncd[27509]: rsync to rsync_sst/./keystone from controller3 (192.168.1.143)
May 28 02:10:51 controller1 rsyncd[27509]: receiving file list
May 28 02:10:51 controller1 rsyncd[27516]: connect from controller3 (192.168.1.143)
May 28 02:10:51 controller1 rsyncd[27516]: rsync to rsync_sst/ from controller3 (192.168.1.143)
May 28 02:10:51 controller1 rsyncd[27516]: receiving file list
May 28 02:10:52 controller1 rsyncd[27473]: sent 0 bytes received 0 bytes total size 0
May 28 02:10:53 controller1 systemd[1]: Started MariaDB 10.1 database server.