Not the answer you need?
Register and ask your own question!

Percona PXC 5.7 cluster , Operation not permitted

foolcatjrfoolcatjr EntrantLegacy User Role Beginner
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 :


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)
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




[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 ?

Comments

  • krunalbauskarkrunalbauskar Advisor Inactive User Role Novice
    Wondering if you are still facing this problem.

    If yes, can you share DONOR log files.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.