I have installed PXC software from Percona-XtraDB-Cluster-5.7.17-29.20.tar.gz, the first node is running correct, when adding the second node to the cluster, there comes some error. the log is :
[TABLE=“border: 1, cellpadding: 1, width: 1095, height: 25”]
[TR]
[TD]2017-07-28T16:41:59.875737Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2017-07-28T16:41:58.429082Z 0 [Warning] ‘NO_ZERO_DATE’, ‘NO_ZERO_IN_DATE’ and ‘ERROR_FOR_DIVISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-07-28T16:41:58.429163Z 0 [Warning] ‘NO_AUTO_CREATE_USER’ sql mode was not set.
2017-07-28T16:41:58.429210Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-07-28T16:41:58.429239Z 0 [Note] mysqld (mysqld 5.7.17-1329.20-log) starting as process 19686 …
…
…
2017-07-28T16:41:58.463831Z 0 [Note] WSREP: Preparing to initiate SST/IST
2017-07-28T16:41:58.463838Z 0 [Note] WSREP: Starting replication
2017-07-28T16:41:58.463853Z 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
2017-07-28T16:41:58.464077Z 0 [Note] WSREP: Using CRC-32C for message checksums.
2017-07-28T16:41:58.464188Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2017-07-28T16:41:58.464311Z 0 [Warning] WSREP: Fail to access the file (/usr/local/mysql/data//gvwstate.dat) error (No such file or directory). It is possible if node is booting for first time or re-booting after a graceful shutdown
2017-07-28T16:41:58.464321Z 0 [Note] WSREP: Restoring primary-component from disk failed. Either node is booting for first time or re-booting after a graceful shutdown
2017-07-28T16:41:58.465297Z 0 [Note] WSREP: GMCast version 0
2017-07-28T16:41:58.465628Z 0 [Note] WSREP: (ac4529b1, ‘tcp://192.168.2.47:4567’) listening at tcp://192.168.2.47:4567
2017-07-28T16:41:58.465642Z 0 [Note] WSREP: (ac4529b1, ‘tcp://192.168.2.47:4567’) multicast: , ttl: 1
2017-07-28T16:41:58.466073Z 0 [Note] WSREP: EVS version 0
2017-07-28T16:41:58.466210Z 0 [Note] WSREP: gcomm: connecting to group ‘ycpxc’, peer ‘192.168.2.48:,192.168.2.47:’
2017-07-28T16:41:58.467767Z 0 [Note] WSREP: (ac4529b1, ‘tcp://192.168.2.47:4567’) connection established to 8e9daabd tcp://192.168.2.48:4567
2017-07-28T16:41:58.467823Z 0 [Note] WSREP: (ac4529b1, ‘tcp://192.168.2.47:4567’) turning message relay requesting on, nonlive peers:
2017-07-28T16:41:58.967489Z 0 [Note] WSREP: declaring 8e9daabd at tcp://192.168.2.48:4567 stable
2017-07-28T16:41:58.967753Z 0 [Note] WSREP: Node 8e9daabd state primary
2017-07-28T16:41:58.968431Z 0 [Note] WSREP: Current view of cluster as seen by this node
view (view_id(PRIM,8e9daabd,62)
memb {
8e9daabd,0
ac4529b1,0
}
joined {
}
left {
}
partitioned {
}
)
2017-07-28T16:41:58.968446Z 0 [Note] WSREP: Save the discovered primary-component to disk
2017-07-28T16:41:59.466802Z 0 [Note] WSREP: gcomm: connected
2017-07-28T16:41:59.466980Z 0 [Note] WSREP: Shifting CLOSED → OPEN (TO: 0)
2017-07-28T16:41:59.467152Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2
2017-07-28T16:41:59.467206Z 0 [Note] WSREP: Waiting for SST/IST to complete.
2017-07-28T16:41:59.467316Z 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2017-07-28T16:41:59.467377Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: ac929fac-73b3-11e7-a3f3-1fa36e02794e
2017-07-28T16:41:59.467389Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: ac929fac-73b3-11e7-a3f3-1fa36e02794e from 0 (bj06)
2017-07-28T16:41:59.467729Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: ac929fac-73b3-11e7-a3f3-1fa36e02794e from 1 (bj02)
2017-07-28T16:41:59.467749Z 0 [Note] WSREP: Quorum results:
version = 4,
component = PRIMARY,
conf_id = 61,
members = 1/2 (primary/total),
act_id = 288286,
last_appl. = -1,
protocols = 0/7/3 (gcs/repl/appl),
group UUID = 9137d1b9-7219-11e7-8807-b61e541e1ba8
2017-07-28T16:41:59.467761Z 0 [Note] WSREP: Flow-control interval: [141, 141]
2017-07-28T16:41:59.467767Z 0 [Note] WSREP: Shifting OPEN → PRIMARY (TO: 288286)
2017-07-28T16:41:59.467840Z 1 [Note] WSREP: State transfer required:
Group state: 9137d1b9-7219-11e7-8807-b61e541e1ba8:288286
Local state: 00000000-0000-0000-0000-000000000000:-1
2017-07-28T16:41:59.467857Z 1 [Note] WSREP: New cluster view: global state: 9137d1b9-7219-11e7-8807-b61e541e1ba8:288286, view# 62: Primary, number of nodes: 2, my index: 1, protocol version 3
2017-07-28T16:41:59.467863Z 1 [Warning] WSREP: Gap in state sequence. Need state transfer.
2017-07-28T16:41:59.467952Z 0 [Note] WSREP: Initiating SST/IST transfer on JOINER side (wsrep_sst_xtrabackup-v2 --role ‘joiner’ --address ‘192.168.2.47:6615’ --datadir ‘/usr/local/mysql/data/’ --defaults-file ‘/data/mysql/my.cnf’ --defaults-group-suffix ‘’ --parent ‘19686’ ‘’ )
20170729 00:41:59.649 WSREP_SST: [WARNING] Found a stale sst_in_progress file: /usr/local/mysql/data//sst_in_progress
2017-07-28T16:41:59.875693Z 1 [Note] WSREP: Prepared SST/IST request: xtrabackup-v2|192.168.2.47:6615/xtrabackup_sst//1
2017-07-28T16:41:59.875737Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2017-07-28T16:41:59.875773Z 1 [Note] WSREP: REPL Protocols: 7 (3, 2)
2017-07-28T16:41:59.875788Z 1 [Note] WSREP: Assign initial position for certification: 288286, protocol version: 3
2017-07-28T16:41:59.875849Z 0 [Note] WSREP: Service thread queue flushed.
2017-07-28T16:41:59.875911Z 1 [Note] WSREP: Check if state gap can be serviced using IST
2017-07-28T16:41:59.875935Z 1 [Note] WSREP: Local UUID: 00000000-0000-0000-0000-000000000000 != Group UUID: 9137d1b9-7219-11e7-8807-b61e541e1ba8
2017-07-28T16:41:59.875989Z 1 [Note] WSREP: State gap can’t be serviced using IST. Switching to SST
2017-07-28T16:41:59.876388Z 0 [Note] WSREP: Member 1.0 (bj02) requested state transfer from ‘any’. Selected 0.0 (bj06)(SYNCED) as donor.
2017-07-28T16:41:59.876404Z 0 [Note] WSREP: Shifting PRIMARY → JOINER (TO: 288286)
2017-07-28T16:41:59.876432Z 1 [Note] WSREP: Requesting state transfer: success, donor: 0
2017-07-28T16:41:59.876446Z 1 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) → new(9137d1b9-7219-11e7-8807-b61e541e1ba8:288286)
[COLOR=#B22222]2017-07-28T16:42:00.126414Z 0 [Warning] WSREP: 0.0 (bj06): State transfer to 1.0 (bj02) failed: -1 (Operation not permitted)
2017-07-28T16:42:00.126472Z 0 [ERROR] WSREP: gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():765: Will never receive state. Need to abort.
2017-07-28T16:42:00.126502Z 0 [Note] WSREP: gcomm: terminating thread
2017-07-28T16:42:00.126537Z 0 [Note] WSREP: gcomm: joining thread
2017-07-28T16:42:00.126699Z 0 [Note] WSREP: gcomm: closing backend
2017-07-28T16:42:01.966807Z 0 [Note] WSREP: (ac4529b1, ‘tcp://192.168.2.47:4567’) turning message relay requesting off
2017-07-28T16:42:03.466815Z 0 [Note] WSREP: (ac4529b1, ‘tcp://192.168.2.47:4567’) connection to peer 8e9daabd with addr tcp://192.168.2.48:4567 timed out, no messages seen in PT3S
2017-07-28T16:42:03.466932Z 0 [Note] WSREP: (ac4529b1, ‘tcp://192.168.2.47:4567’) turning message relay requesting on, nonlive peers: tcp://192.168.2.48:4567
2017-07-28T16:42:04.966816Z 0 [Note] WSREP: (ac4529b1, ‘tcp://192.168.2.47:4567’) reconnecting to 8e9daabd (tcp://192.168.2.48:4567), attempt 0
2017-07-28T16:42:05.626913Z 0 [Note] WSREP: evs::proto(ac4529b1, LEAVING, view_id(REG,8e9daabd,62)) suspecting node: 8e9daabd
2017-07-28T16:42:05.627979Z 0 [Note] WSREP: evs::proto(ac4529b1, LEAVING, view_id(REG,8e9daabd,62)) suspected node without join message, declaring inactive
2017-07-28T16:42:05.628015Z 0 [Note] WSREP: Current view of cluster as seen by this node
view (view_id(NON_PRIM,8e9daabd,62)
memb {
ac4529b1,0
}
joined {
}
left {
}
partitioned {
8e9daabd,0
}
)
2017-07-28T16:42:05.628063Z 0 [Note] WSREP: Current view of cluster as seen by this node
view ((empty))
2017-07-28T16:42:05.628210Z 0 [Note] WSREP: gcomm: closed
2017-07-28T16:42:05.628229Z 0 [Note] WSREP: mysqld: Terminated.
20170729 00:43:39.690 WSREP_SST: [ERROR] ******************* FATAL ERROR **********************
20170729 00:43:39.692 WSREP_SST: [ERROR] Error while getting data from donor node: exit codes: 137 0
20170729 00:43:39.695 WSREP_SST: [ERROR] ******************************************************
20170729 00:43:39.697 WSREP_SST: [ERROR] Cleanup after exit with status:32[/TD]
[/TR]
[/TABLE]
[Warning] WSREP: 0.0 (bj06): State transfer to 1.0 (bj02) failed: -1 (Operation not permitted)
The config is
wsrep_sst_method=xtrabackup-v2
wsrep_sst_auth=“sst:sst”
The user sst and password is correct. I have succeed installed the PXC with the same tar.gz, but I don’t know why there is error here, can somebody help me ?