Hi there
when starting the node 3 i.e adding to cluster ,facing the below error.
let me know how to proceed.
Note : node 1,2 are online.
root@node3:/etc/mysql/mysql.conf.d# service mysql start
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
root@node3:/etc/mysql/mysql.conf.d# systemctl status mysql.service
● mysql.service - Percona XtraDB Cluster
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Wed 2021-02-24 00:57:30 IST; 1min 33s ago
Process: 12897 ExecStopPost=/usr/bin/mysql-systemd stop-post (code=exited, status=0/SUCCESS)
Process: 12889 ExecStart=/usr/sbin/mysqld $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 12840 ExecStartPre=/bin/sh -c VAR=`bash /usr/bin/mysql-systemd galera-recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION
Process: 12835 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 12804 ExecStartPre=/usr/bin/mysql-systemd check-grastate (code=exited, status=0/SUCCESS)
Process: 12755 ExecStartPre=/usr/bin/mysql-systemd start-pre (code=exited, status=0/SUCCESS)
Main PID: 12889 (code=exited, status=1/FAILURE)
Status: "Server startup in progress"
Feb 24 00:56:57 node3 systemd[1]: Starting Percona XtraDB Cluster...
Feb 24 00:57:30 node3 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 24 00:57:30 node3 mysql-systemd[12897]: WARNING: mysql pid file /var/run/mysqld/mysqld.pid empty or not readable
Feb 24 00:57:30 node3 mysql-systemd[12897]: WARNING: mysql may be already dead
Feb 24 00:57:30 node3 systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 24 00:57:30 node3 systemd[1]: Failed to start Percona XtraDB Cluster.
lines 1-18/18 (END)
[6]+ Stopped systemctl status mysql.service