Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.2.10
-
None
-
CentOS 7, RPMs from MariaDB repository.
Description
Overview
If SELinux is enabled and the SST method is set to rsync, all attempts at an SST will fail and the following message is logged.
2017-11-27 14:48:55 139686027196160 [Note] WSREP: New cluster view: global state: 6177046c-d350-11e7-b2cb-6345311792db:63, view# 14: Primary, number of nodes: 2, my index: 1, protocol version 3
|
2017-11-27 14:48:55 139686027196160 [Warning] WSREP: Gap in state sequence. Need state transfer.
|
2017-11-27 14:48:55 139685768206080 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '192.168.124.50' --datadir '/var/lib/mysql/' --parent '13921' --binlog 'galera1-bin' '
|
which: no rsync in (/usr/sbin:/sbin:/usr//bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin)
|
2017-11-27 14:48:55 139685768206080 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_rsync --role 'joiner' --address '192.168.124.50' --datadir '/var/lib/mysql/' --parent '13921' --binlog 'galera1-
|
bin'
|
Read: ''rsync' not found in PATH'
|
2017-11-27 14:48:55 139685768206080 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'joiner' --address '192.168.124.50' --datadir '/var/lib/mysql/' --parent '13921' --binlog 'galera1-bin' :
|
2 (No such file or directory)
|
2017-11-27 14:48:55 139686027196160 [ERROR] WSREP: Failed to prepare for 'rsync' SST. Unrecoverable.
|
2017-11-27 14:48:55 139686027196160 [ERROR] Aborting
|
Configuration
|
# this is only for the mysqld standalone daemon
|
[mysqld]
|
log_error=/var/lib/mysql/mysqld.err
|
|
#
|
# * Galera-related settings
|
#
|
[galera]
|
# Mandatory settings
|
wsrep_on=ON
|
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
|
wsrep_cluster_address=gcomm://galera1,galera2
|
log-bin
|
binlog_format=row
|
default_storage_engine=InnoDB
|
innodb_autoinc_lock_mode=2
|
Steps to Reproduce
- Install MariaDB 10.2.10 on two servers (hostnames are galera1 and galera2)
- Use the provided configuration for both servers
- Start a new cluster
- Stop galera1
- Force an SST to be performed (insert data etc.)
- Start galera1 via systemctl start mysql