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
-
-
- Closed
-
- relates to
-
-
- Closed
-
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Andrii Nikitin [ anikitin ] |
| Link |
This issue relates to |
| Link |
This issue duplicates |
| Comment | [ Christ... Thank you for reporting this and posting the diff. This caused a production outage for me ] |
| Link |
This issue duplicates |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Link |
This issue relates to |
| Fix Version/s | 10.2 [ 14601 ] |
| Link |
This issue is duplicated by |
| Sprint | 10.2.11 [ 203 ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Andrii Nikitin [ anikitin ] | Sachin Setiya [ sachin.setiya.007 ] |
| Assignee | Sachin Setiya [ sachin.setiya.007 ] | Sergei Golubchik [ serg ] |
| Assignee | Sergei Golubchik [ serg ] | Andrii Nikitin [ anikitin ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Assignee | Andrii Nikitin [ anikitin ] | Sergei Golubchik [ serg ] |
| Assignee | Sergei Golubchik [ serg ] | Andrii Nikitin [ anikitin ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Assignee | Andrii Nikitin [ anikitin ] | Sergei Golubchik [ serg ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Sergei Golubchik [ serg ] | Andrii Nikitin [ anikitin ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Assignee | Andrii Nikitin [ anikitin ] | Sergei Golubchik [ serg ] |
| Status | Stalled [ 10000 ] | In Review [ 10002 ] |
| Assignee | Sergei Golubchik [ serg ] | Andrii Nikitin [ anikitin ] |
| Assignee | Andrii Nikitin [ anikitin ] | Sergei Golubchik [ serg ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.2.11 [ 22634 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 83408 ] | MariaDB v4 [ 153103 ] |
| Zendesk Related Tickets | 201342 |