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

Problems getting into the cluster

bdelmedicobdelmedico ContributorCurrent User Role Beginner
I can do the replication normally, but after disconnecting and connecting the server, it does not join the cluster ...

Can someone give me a light?

2017-08-02T17:53:52.369513Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-08-02T17:53:52.370503Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-15-57-log) starting as process 18316 ...
2017-08-02T17:53:52.372473Z 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization.
2017-08-02T17:53:52.372491Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm.so'
2017-08-02T17:53:52.374751Z 0 [Note] WSREP: wsrep_load(): Galera 3.20(r7e383f7) by Codership Oy <[email protected]> loaded successfully.
2017-08-02T17:53:52.374808Z 0 [Note] WSREP: CRC-32C: using hardware acceleration.
2017-08-02T17:53:52.375110Z 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootsrap: 0
2017-08-02T17:53:52.387809Z 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 172.31.44.195; base_port = 4567; cert.log_conflicts = no; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT90S; evs.install_timeout = PT60S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT3S; evs.max_install_timeouts = 8; evs.send_window = 512; evs.stats_report_period = PT1M; evs.suspect_timeout = PT30S; evs.user_send_window = 512; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 100; gcs.fc_master_slave = no; gcs.max_packet_size = 1048576; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.recovery = 1; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 1; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 7; socket.checksum = 2; socket.recv_buf_size = 212992;
2017-08-02T17:53:52.398750Z 0 [Note] WSREP: GCache history reset: old(a8d37d7e-5c3b-11e7-9fbf-36d50cc17d69:0) -> new(00000000-0000-0000-0000-000000000000:-1)
2017-08-02T17:53:52.399403Z 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
2017-08-02T17:53:52.399422Z 0 [Note] WSREP: Preparing to initiate SST/IST
2017-08-02T17:53:52.399426Z 0 [Note] WSREP: Starting replication
2017-08-02T17:53:52.399435Z 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
2017-08-02T17:53:52.399582Z 0 [Note] WSREP: Using CRC-32C for message checksums.
2017-08-02T17:53:52.399656Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2017-08-02T17:53:52.399738Z 0 [Warning] WSREP: Fail to access the file (/var/lib/mysql//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-08-02T17:53:52.399752Z 0 [Note] WSREP: Restoring primary-component from disk failed. Either node is booting for first time or re-booting after a graceful shutdown
2017-08-02T17:53:52.400202Z 0 [Note] WSREP: GMCast version 0
2017-08-02T17:53:52.400371Z 0 [Note] WSREP: (8ba437fc, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2017-08-02T17:53:52.400387Z 0 [Note] WSREP: (8ba437fc, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2017-08-02T17:53:52.400652Z 0 [Note] WSREP: EVS version 0
2017-08-02T17:53:52.400732Z 0 [Note] WSREP: gcomm: connecting to group 'ev-cluster-teste', peer '10.10.10.101:,172.31.44.195:'
2017-08-02T17:53:52.401523Z 0 [Note] WSREP: (8ba437fc, 'tcp://0.0.0.0:4567') connection established to 8ba437fc tcp://172.31.44.195:4567
2017-08-02T17:53:52.401547Z 0 [Warning] WSREP: (8ba437fc, 'tcp://0.0.0.0:4567') address 'tcp://172.31.44.195:4567' points to own listening address, blacklisting
2017-08-02T17:53:52.410809Z 0 [Note] WSREP: (8ba437fc, 'tcp://0.0.0.0:4567') connection established to 1e73c129 tcp://10.10.10.101:4567
2017-08-02T17:53:52.410977Z 0 [Note] WSREP: (8ba437fc, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
2017-08-02T17:53:52.912008Z 0 [Note] WSREP: declaring 1e73c129 at tcp://10.10.10.101:4567 stable
2017-08-02T17:53:52.915450Z 0 [Note] WSREP: Node 1e73c129 state primary
2017-08-02T17:53:52.919104Z 0 [Note] WSREP: Current view of cluster as seen by this node
2017-08-02T17:53:52.919134Z 0 [Note] WSREP: Save the discovered primary-component to disk
2017-08-02T17:53:53.401235Z 0 [Note] WSREP: gcomm: connected
2017-08-02T17:53:53.401742Z 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2017-08-02T17:53:53.401839Z 0 [Note] WSREP: Waiting for SST/IST to complete.
2017-08-02T17:53:53.401924Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2
2017-08-02T17:53:53.401980Z 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2017-08-02T17:53:53.402047Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 8beec3cb-77ab-11e7-a7e9-f7133d9c259b
2017-08-02T17:53:53.402094Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 8beec3cb-77ab-11e7-a7e9-f7133d9c259b from 0 (teste-mha-01)
2017-08-02T17:53:53.405167Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 8beec3cb-77ab-11e7-a7e9-f7133d9c259b from 1 (ip-172-31-44-195)
2017-08-02T17:53:53.405256Z 2 [Note] WSREP: New cluster view: global state: a8d37d7e-5c3b-11e7-9fbf-36d50cc17d69:163765, view# 7: Primary, number of nodes: 2, my index: 1, protocol version 3
2017-08-02T17:53:53.405270Z 2 [Warning] WSREP: Gap in state sequence. Need state transfer.
2017-08-02T17:53:53.405351Z 0 [Note] WSREP: Initiating SST/IST transfer on JOINER side (wsrep_sst_rsync --role 'joiner' --address '172.31.44.195' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --defaults-group-suffix '' --parent '18316' '' )
2017-08-02T17:53:53.460638Z WSREP_SST: [INFO] Waiting for data-dir through rsync................
2017-08-02T17:53:53.480449Z 2 [Note] WSREP: Prepared SST/IST request: rsync|172.31.44.195:4444/rsync_sst
2017-08-02T17:53:53.480508Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2017-08-02T17:53:53.480540Z 2 [Note] WSREP: REPL Protocols: 7 (3, 2)
2017-08-02T17:53:53.480559Z 2 [Note] WSREP: Assign initial position for certification: 163765, protocol version: 3
2017-08-02T17:53:53.480598Z 0 [Note] WSREP: Service thread queue flushed.
2017-08-02T17:53:53.480627Z 2 [Note] WSREP: Check if state gap can be serviced using IST
2017-08-02T17:53:53.480652Z 2 [Note] WSREP: Local UUID: 00000000-0000-0000-0000-000000000000 != Group UUID: a8d37d7e-5c3b-11e7-9fbf-36d50cc17d69
2017-08-02T17:53:53.480700Z 2 [Note] WSREP: State gap can't be serviced using IST. Switching to SST
2017-08-02T17:53:53.484059Z 0 [Note] WSREP: Member 1.0 (ip-172-31-44-195) requested state transfer from '*any*'. Selected 0.0 (teste-mha-01)(SYNCED) as donor.
2017-08-02T17:53:53.484124Z 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 163765)
2017-08-02T17:53:53.484178Z 2 [Note] WSREP: Requesting state transfer: success, donor: 0
2017-08-02T17:53:53.484228Z 2 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(a8d37d7e-5c3b-11e7-9fbf-36d50cc17d69:163765)
2017-08-02T17:53:53.783247Z 0 [Warning] WSREP: 0.0 (teste-mha-01): State transfer to 1.0 (ip-172-31-44-195) failed: -1 (Operation not permitted)
2017-08-02T17:53:53.783285Z 0 [ERROR] WSREP: gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():765: Will never receive state. Need to abort.
2017-08-02T17:53:53.783311Z 0 [Note] WSREP: gcomm: terminating thread
2017-08-02T17:53:53.783322Z 0 [Note] WSREP: gcomm: joining thread
2017-08-02T17:53:53.783427Z 0 [Note] WSREP: gcomm: closing backend
2017-08-02T17:53:55.901258Z 0 [Note] WSREP: (8ba437fc, 'tcp://0.0.0.0:4567') connection to peer 8ba437fc with addr tcp://172.31.44.195:4567 timed out, no messages seen in PT3S
2017-08-02T17:53:55.901359Z 0 [Note] WSREP: (8ba437fc, 'tcp://0.0.0.0:4567') turning message relay requesting off
2017-08-02T17:53:56.901252Z 0 [Note] WSREP: (8ba437fc, 'tcp://0.0.0.0:4567') connection to peer 1e73c129 with addr tcp://10.10.10.101:4567 timed out, no messages seen in PT3S
2017-08-02T17:53:56.901380Z 0 [Note] WSREP: (8ba437fc, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.10.10.101:4567
2017-08-02T17:53:58.401257Z 0 [Note] WSREP: (8ba437fc, 'tcp://0.0.0.0:4567') reconnecting to 1e73c129 (tcp://10.10.10.101:4567), attempt 0
2017-08-02T17:54:01.901275Z 0 [Note] WSREP: (8ba437fc, 'tcp://0.0.0.0:4567') connection to peer 1e73c129 with addr tcp://10.10.10.101:4567 timed out, no messages seen in PT3S
2017-08-02T17:54:03.416832Z 0 [Note] WSREP: (8ba437fc, 'tcp://0.0.0.0:4567') connection established to 1e73c129 tcp://10.10.10.101:4567
2017-08-02T17:54:06.901292Z 0 [Note] WSREP: (8ba437fc, 'tcp://0.0.0.0:4567') turning message relay requesting off
2017-08-02T17:54:13.783506Z 0 [Note] WSREP: Current view of cluster as seen by this node
view (view_id(NON_PRIM,1e73c129,10)

2017-08-02T17:54:13.783559Z 0 [Note] WSREP: Current view of cluster as seen by this node
view ((empty))
2017-08-02T17:54:13.783710Z 0 [Note] WSREP: gcomm: closed
2017-08-02T17:54:13.783729Z 0 [Note] WSREP: /usr/sbin/mysqld: Terminated.
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
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.