Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2.8
-
[jg4461@db2 ~]$ cat /etc/redhat-release
CentOS Linux release 7.4.1708 (Core)
[jg4461@db2 ~]$ uname -r
3.10.0-693.5.2.el7.x86_64
-
10.2.11
Description
Following an upgrade to MariaDB-server-10.2.10-1.el7.centos.x86_64 wsrep_sst_xtrabackup-v2 is unable to initiate an SST to join a node to the cluster.
It fails with the following errors:
2017-11-01 7:23:33 140136889161472 [Note] WSREP: Flow-control interval: [23, 23]
|
2017-11-01 7:23:33 140136889161472 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 4823208097)
|
2017-11-01 7:23:33 140136880768768 [Note] WSREP: State transfer required:
|
Group state: c37249ee-cc56-11e3-8839-da7603c8db1b:4823208097
|
Local state: c37249ee-cc56-11e3-8839-da7603c8db1b:4822595673
|
2017-11-01 7:23:33 140136880768768 [Note] WSREP: New cluster view: global state: c37249ee-cc56-11e3-8839-da7603c8db1b:4823208097, view# 1879: Primary, number of nodes: 2, my index: 0, protocol version 3
|
2017-11-01 7:23:33 140136880768768 [Warning] WSREP: Gap in state sequence. Need state transfer.
|
2017-11-01 7:23:33 140136880039680 [Note] WSREP: Running: 'wsrep_sst_xtrabackup-v2 --role 'joiner' --address '137.222.8.66' --datadir '/var/lib/mysql/data/' --parent '27765' '' '
|
/usr//bin/wsrep_sst_xtrabackup-v2: line 646: WSREP_SST_OPT_PORT: unbound variable
|
2017-11-01 7:23:34 140136880039680 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '137.222.8.66' --datadir '/var/lib/mysql/data/' --parent '27765' ''
|
Read: '(null)'
|
2017-11-01 7:23:34 140136880039680 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '137.222.8.66' --datadir '/var/lib/mysql/data/' --parent '27765' '' : 1 (Operation not permitted)
|
2017-11-01 7:23:34 140136880768768 [ERROR] WSREP: Failed to prepare for 'xtrabackup-v2' SST. Unrecoverable.
|
2017-11-01 7:23:34 140136880768768 [ERROR] Aborting
|
The root cause appears to be:
/usr/bin/wsrep_sst_xtrabackup-v2: line 646: WSREP_SST_OPT_PORT: unbound variable
|
The WSREP_SST_OPT_PORT doesn't have a default value set, either set in wsrep_sst_xtrabackup-v2 or in wsrep_sst_common
The following diff sets a default value for the WSREP_SST_OPT_PORT variable, and allows the SST to proceed.
--- wsrep_sst_common 2017-11-02 11:02:09.561266862 +0000
|
+++ wsrep_sst_common_modified 2017-11-02 11:02:00.473166368 +0000
|
@@ -27,6 +27,7 @@
|
WSREP_SST_OPT_PSWD=${WSREP_SST_OPT_PSWD:-}
|
WSREP_SST_OPT_DEFAULT="" |
WSREP_SST_OPT_EXTRA_DEFAULT="" |
+WSREP_SST_OPT_PORT=4444
|
 |
while [ $# -gt 0 ]; do |
case "$1" in |
Attachments
Issue Links
- is duplicated by
-
MDEV-14299 /usr//bin/wsrep_sst_xtrabackup-v2: line 646: WSREP_SST_OPT_PORT: unbound variable
- Closed
- relates to
-
MDEV-14305 Add smoke sst test
- Closed
-
MDEV-14030 Remove or Merge wsrep_sst_mariabackup
- Closed