pxc 启动报错 The server quit without updating PID file

?

1 2 3 4

/etc/init.d/mysql start Starting MySQL (Percona XtraDB Cluster)................................................................................................................................................................................................................................................................................................................................../usr/bin/mysqld_safe: line 203:  7028 Killed                  nohup /usr/sbin/mysqld --basedir=/usr --datadir=/home --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --wsrep-provider=/usr/lib64/libgalera_smm.so --log-error=/data/logs/mysql/mysql_error.log --open-files-limit=65535 --pid-file=/home/mysql.pid --socket=/home/mysql.sock --port=3306 --wsrep_start_position=***********:85906395 < /dev/null > /dev/null 2>&1  ERROR! The server quit without updating PID file (/home/mysql.pid).  ERROR! MySQL (Percona XtraDB Cluster) server startup failed!

　　查看日志

?

1 2 3

2022-09-05 03:54:12 22485 [Note] WSREP: Full re-merge of primary cf7f1677-2c8e-11ed-a43f-67082de5e598 found: 1 of 1. 2022-09-05 03:54:12 22485 [ERROR] WSREP: gcs/src/gcs_group.cpp:group_post_state_exchange():322: Reversing history: 395 -> 866, this member has applied 529 more events than the primary component.Data loss is possible. Aborting. 2022-09-05 03:54:12 22485 [Note] WSREP: /usr/sbin/mysqld: Terminated.

　　解决删除 /home/data/grastate.dat 文件并重新启动它，参考https://m.blog.naver.com/PostView.naver?isHttpsRedirect=true&blogId=hanajava&logNo=220795689922

第一个节点启动
/etc/init.d/mysqld bootstrap-pxc

第二个节点启动，同步时会重新用xtrbackup恢复数据
/etc/init.d/mysql start