docker第二节点无法启动报错xtrabackup_checkpoints missing. xtrabackup/SST failed on DONOR. Check DONOR log解决方案

今天搭建mysql集群遇到第二docker节点开启后闪退问题,报错如下:

2019-08-08T07:53:49.523877Z 0 [Note] WSREP: Member 1.0 (e46b8f62910a) requested state transfer from '*any*'. Selected 0.0 (5bbce62559f2)(SYNCED) as donor.
2019-08-08T07:53:49.523895Z 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0)
2019-08-08T07:53:49.523947Z 2 [Note] WSREP: Requesting state transfer: success, donor: 0
2019-08-08T07:53:49.524037Z 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> b421836e-b9ab-11e9-a833-f6ea56276023:0
	2019-08-08T07:53:50.188947Z WSREP_SST: [INFO] WARNING: Stale temporary SST directory: /var/lib/mysql//.sst from previous state transfer. Removing
	2019-08-08T07:53:50.195103Z WSREP_SST: [INFO] Proceeding with SST.........
	2019-08-08T07:53:50.211460Z WSREP_SST: [INFO] ............Waiting for SST streaming to complete!
2019-08-08T07:53:51.250017Z 0 [Note] WSREP: (a73a063b, 'tcp://0.0.0.0:4567') turning message relay requesting off
	2019-08-08T07:54:00.213743Z WSREP_SST: [ERROR] ******************* FATAL ERROR ********************** 
	2019-08-08T07:54:00.215962Z WSREP_SST: [ERROR] xtrabackup_checkpoints missing. xtrabackup/SST failed on DONOR. Check DONOR log
	2019-08-08T07:54:00.218063Z WSREP_SST: [ERROR] ****************************************************** 
	2019-08-08T07:54:00.220446Z WSREP_SST: [ERROR] Cleanup after exit with status:2
2019-08-08T07:54:00.229795Z 0 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '172.18.0.3' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --parent '1' --mysqld-version '5.7.26-29-57'   '' : 2 (No such file or directory)

进入第一节点查看日志

more /var/lib/mysql/innobackup.backup.log

发现第二节点在连接第一节点时密码错误,打开第一节点/etc/mysql/node.cnf查看集群通信密码没有问题
在这里插入图片描述
查看节点1下面的账户发现没有xtrabackup用户,于是添加了xtrabackup并设密码为配置文件中设置的密码,赋予全部权限 刷新:flush privileges 再次启动节点2
启动成功!
这里参考了阿里的一篇文章:https://yq.aliyun.com/articles/378335

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值