I’m setting up a cluster as a PoC to test some performance and resilience stuff as part of developing a roadmap.
I have bootstrapped the primary node, and have set up the second node in line with the documentation, but starting the second node it fails with these errors in the log.
2020-09-04T12:08:33.195018Z 2 [Note] [MY-000000] [Galera] State transfer required:
Group state: 0bfa5e83-ee9a-11ea-87c7-bef4ee9147f0:11
Local state: 00000000-0000-0000-0000-000000000000:-1
2020-09-04T12:08:33.195032Z 2 [Note] [MY-000000] [WSREP] Server status change connected → joiner
2020-09-04T12:08:33.195044Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notifi
cation.
2020-09-04T12:08:33.195139Z 0 [Note] [MY-000000] [WSREP] Initiating SST/IST transfer on JOINER side (wsrep_sst_xtrabackup-v2 --role ‘joiner’ --address ‘x.x.x.x’ --datadir ‘/var/lib/mysql/’ --basedir ‘/usr/’ --plugindir ‘/usr/lib64/mysql/plugin/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘11943’ --mysqld-version ‘8.0.19-10’ ‘’ )
2020-09-04T12:08:33.195431Z 0 [ERROR] [MY-000000] [WSREP] posix_spawnp() failed: 13 (Permission denied)
2020-09-04T12:08:33.195492Z 0 [ERROR] [MY-000000] [WSREP] Failed to execute: wsrep_sst_xtrabackup-v2 --role ‘joiner’ --address ‘x.x.x.x’ --datadir ‘/var/lib/mysql/’ --basedir ‘/usr/’ --plugindir ‘/usr/lib64/mysql/plugin/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘11943’ --mysqld-version ‘8.0.19-10’ ‘’ : 13 (Permission denied)
2020-09-04T12:08:33.195592Z 2 [ERROR] [MY-000000] [WSREP] Failed to prepare for ‘xtrabackup-v2’ SST. Unrecoverable.
2020-09-04T12:08:33.195686Z 2 [ERROR] [MY-000000] [Galera] SST request callback failed. This is unrecoverable, restart required.
2020-09-04T12:08:33.195703Z 2 [Note] [MY-000000] [Galera] ReplicatorSMM::abort()
2020-09-04T12:08:33.195718Z 2 [Note] [MY-000000] [Galera] Closing send monitor…
2020-09-04T12:08:33.195732Z 2 [Note] [MY-000000] [Galera] Closed send monitor.
2020-09-04T12:08:33.195746Z 2 [Note] [MY-000000] [Galera] gcomm: terminating thread
2020-09-04T12:08:33.195762Z 2 [Note] [MY-000000] [Galera] gcomm: joining thread
2020-09-04T12:08:33.195838Z 2 [Note] [MY-000000] [Galera] gcomm: closing backend
2020-09-04T12:08:33.206299Z 0 [Note] [MY-000000] [WSREP] Initiating SST cancellation
12:08:33 UTC - mysqld got signal 11 ;
Failed 13 obviously suggests a permissions issue, but I’m unclear as to whether it’s permissions on the local file system, or something reported from the primary node. I can see entries in the log of the primary node to acknowledge the connection from the second node, but nothing that reports any errors in there.
Any pointers as to where the permissions issue lies? Or is it something I’ve missed?