Not the answer you need?
Register and ask your own question!

Unable to bootstrap Node 1 of Pecona XtraDB cluster 8.0

salman253salman253 Current User Role Contributor


I have installed PXC 8.0 on 2 nodes (Ubuntu 20). After sufficient configuration to my.cnf file I am trying to bootstrap Node 1 as below:

systemctl start [email protected]

The command stuck for 1-2 mins and while looking into logs from another terminal it shows that node is now synced and ready for connection. But after 2-3 mins the command gets failed with below error:

Job for [email protected] failed because a timeout was exceeded.

See "systemctl status [email protected]" and "journalctl -xe" for details.

And log shows "Received shutdown signal" and then it shutdown completely.

I tried disabling MySQL Apparmor profile also, but no luck. I am not getting where is the issue.

Please help!

Below is the status check for failed service command:

systemctl status [email protected]

* [email protected] - Percona XtraDB Cluster with config /etc/default/mysql.bootstrap

   Loaded: loaded (/lib/systemd/system/[email protected]; disabled; vendor preset: enabled)

   Active: failed (Result: timeout) since Tue 2020-10-13 17:05:41 EDT; 3min 42s ago

  Process: 430436 ExecStartPre=/usr/bin/mysql-systemd start-pre (code=exited, status=0/SUCCESS)

  Process: 430483 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)

  Process: 430485 ExecStartPre=/bin/sh -c VAR=`bash /usr/bin/mysql-systemd galera-recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, >

  Process: 430533 ExecStart=/usr/sbin/mysqld $EXTRA_ARGS $_WSREP_START_POSITION (code=exited, status=0/SUCCESS)

  Process: 430666 ExecStopPost=/usr/bin/mysql-systemd stop-post (code=exited, status=0/SUCCESS)

  Main PID: 430533 (code=exited, status=0/SUCCESS)

Oct 13 17:03:55 systemd[1]: Starting Percona XtraDB Cluster with config /etc/default/mysql.bootstrap...

Oct 13 17:05:26 systemd[1]: [email protected]: start operation timed out. Terminating.

Oct 13 17:05:41 mysql-systemd[430666]: WARNING: mysql pid file /var/lib/mysql/ empty or not readable

Oct 13 17:05:41 mysql-systemd[430666]: WARNING: mysql may be already dead

Oct 13 17:05:41 systemd[1]: [email protected]: Failed with result 'timeout'.

Oct 13 17:05:41 systemd[1]: Failed to start Percona XtraDB Cluster with config /etc/default/mysql.bootstrap.

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.