Cannot add instance at cluster
Posted by: Rukeith Tseng
Date: November 01, 2018 12:25AM
Date: November 01, 2018 12:25AM
I use MySQL version 5.7.24 and I try to deploy cluster.
When I want to add instance I got a error, I don't know how to fix.
Please someone help me.
Here is the log at /var/log/mysqld.log
Master:
2018-11-01T05:25:35.913317Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.24-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
2018-11-01T05:25:35.913841Z 2 [Note] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "REQUIRED"; server_key_file: "server-key.pem"; server_cert_file: "server-cert.pem"; client_key_file: "server-key.pem"; client_cert_file: "server-cert.pem"; ca_file: "ca.pem"; ca_path: ""; cipher: ""; tls_version: "TLSv1,TLSv1.1"; crl_file: ""; crl_path: ""'
2018-11-01T05:25:35.913944Z 2 [Note] Plugin group_replication reported: '[GCS] Added automatically IP ranges 10.4.214.192/24,127.0.0.1/8,192.168.122.1/24 to the whitelist'
2018-11-01T05:25:35.914117Z 2 [Note] Plugin group_replication reported: '[GCS] Translated 'mysql-master' to 10.4.214.192'
2018-11-01T05:25:35.914199Z 2 [Warning] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.'
2018-11-01T05:25:35.914812Z 2 [Note] Plugin group_replication reported: 'Initialized group communication with configuration: group_replication_group_name: "fdda3fa7-dd77-11e8-aef5-000c292dfd1d"; group_replication_local_address: "mysql-master:33061"; group_replication_group_seeds: ""; group_replication_bootstrap_group: false; group_replication_poll_spin_loops: 0; group_replication_compression_threshold: 1000000; group_replication_ip_whitelist: "AUTOMATIC"'
2018-11-01T05:25:35.914861Z 2 [Note] Plugin group_replication reported: '[GCS] Configured number of attempts to join: 0'
2018-11-01T05:25:35.914872Z 2 [Note] Plugin group_replication reported: '[GCS] Configured time between attempts to join: 5 seconds'
2018-11-01T05:25:35.914893Z 2 [Note] Plugin group_replication reported: 'Member configuration: member_id: 1; member_uuid: "3e3efd93-dcee-11e8-a6cd-000c292dfd1d"; single-primary mode: "true"; group_replication_auto_increment_increment: 7; '
2018-11-01T05:25:35.915269Z 3 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
2018-11-01T05:25:35.918179Z 2 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
2018-11-01T05:25:35.918203Z 6 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log './twsr-wh2-mysql-garenanet-com-relay-bin-group_replication_applier.000011' position: 784
2018-11-01T05:25:35.918218Z 2 [ERROR] Plugin group_replication reported: '[GCS] Unable to join the group: peers not configured. '
2018-11-01T05:25:35.918226Z 2 [ERROR] Plugin group_replication reported: 'Error on group communication engine start'
2018-11-01T05:25:35.918231Z 2 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2018-11-01T05:25:35.918236Z 2 [ERROR] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
2018-11-01T05:25:35.921036Z 6 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed
2018-11-01T05:25:35.921055Z 6 [Note] Slave SQL thread for channel 'group_replication_applier' exiting, replication stopped in log 'FIRST' at position 0
2018-11-01T05:25:35.921360Z 3 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'
Slaveļ¼
018-11-01T05:23:07.849519Z 14 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
2018-11-01T05:23:07.861517Z 12 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
2018-11-01T05:23:07.861534Z 17 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log './TWSR-WH1-MySQL-relay-bin-group_replication_applier.000008' position: 4
2018-11-01T05:23:07.861874Z 0 [Note] Plugin group_replication reported: 'XCom protocol version: 3'
2018-11-01T05:23:07.861987Z 0 [Note] Plugin group_replication reported: 'XCom initialized and ready to accept incoming connections on port 33061'
2018-11-01T05:23:08.066725Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.066826Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.167016Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.167164Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.266873Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.267015Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.365971Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.366179Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.465505Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.465724Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.565534Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.565667Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.664104Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.664223Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.765709Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.765848Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.865850Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.866025Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.964266Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.964404Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.964427Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 33061'
2018-11-01T05:23:08.964882Z 0 [Warning] Plugin group_replication reported: 'read failed'
2018-11-01T05:23:09.009338Z 0 [ERROR] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 33061'
2018-11-01T05:24:07.861757Z 12 [ERROR] Plugin group_replication reported: 'Timeout on wait for view after joining group'
2018-11-01T05:24:07.861850Z 12 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2018-11-01T05:24:07.861886Z 12 [ERROR] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
2018-11-01T05:24:07.862517Z 17 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed
2018-11-01T05:24:07.862549Z 17 [Note] Slave SQL thread for channel 'group_replication_applier' exiting, replication stopped in log 'FIRST' at position 0
2018-11-01T05:24:07.863578Z 14 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'
When I want to add instance I got a error, I don't know how to fix.
Please someone help me.
Here is the log at /var/log/mysqld.log
Master:
2018-11-01T05:25:35.913317Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.24-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
2018-11-01T05:25:35.913841Z 2 [Note] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "REQUIRED"; server_key_file: "server-key.pem"; server_cert_file: "server-cert.pem"; client_key_file: "server-key.pem"; client_cert_file: "server-cert.pem"; ca_file: "ca.pem"; ca_path: ""; cipher: ""; tls_version: "TLSv1,TLSv1.1"; crl_file: ""; crl_path: ""'
2018-11-01T05:25:35.913944Z 2 [Note] Plugin group_replication reported: '[GCS] Added automatically IP ranges 10.4.214.192/24,127.0.0.1/8,192.168.122.1/24 to the whitelist'
2018-11-01T05:25:35.914117Z 2 [Note] Plugin group_replication reported: '[GCS] Translated 'mysql-master' to 10.4.214.192'
2018-11-01T05:25:35.914199Z 2 [Warning] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.'
2018-11-01T05:25:35.914812Z 2 [Note] Plugin group_replication reported: 'Initialized group communication with configuration: group_replication_group_name: "fdda3fa7-dd77-11e8-aef5-000c292dfd1d"; group_replication_local_address: "mysql-master:33061"; group_replication_group_seeds: ""; group_replication_bootstrap_group: false; group_replication_poll_spin_loops: 0; group_replication_compression_threshold: 1000000; group_replication_ip_whitelist: "AUTOMATIC"'
2018-11-01T05:25:35.914861Z 2 [Note] Plugin group_replication reported: '[GCS] Configured number of attempts to join: 0'
2018-11-01T05:25:35.914872Z 2 [Note] Plugin group_replication reported: '[GCS] Configured time between attempts to join: 5 seconds'
2018-11-01T05:25:35.914893Z 2 [Note] Plugin group_replication reported: 'Member configuration: member_id: 1; member_uuid: "3e3efd93-dcee-11e8-a6cd-000c292dfd1d"; single-primary mode: "true"; group_replication_auto_increment_increment: 7; '
2018-11-01T05:25:35.915269Z 3 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
2018-11-01T05:25:35.918179Z 2 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
2018-11-01T05:25:35.918203Z 6 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log './twsr-wh2-mysql-garenanet-com-relay-bin-group_replication_applier.000011' position: 784
2018-11-01T05:25:35.918218Z 2 [ERROR] Plugin group_replication reported: '[GCS] Unable to join the group: peers not configured. '
2018-11-01T05:25:35.918226Z 2 [ERROR] Plugin group_replication reported: 'Error on group communication engine start'
2018-11-01T05:25:35.918231Z 2 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2018-11-01T05:25:35.918236Z 2 [ERROR] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
2018-11-01T05:25:35.921036Z 6 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed
2018-11-01T05:25:35.921055Z 6 [Note] Slave SQL thread for channel 'group_replication_applier' exiting, replication stopped in log 'FIRST' at position 0
2018-11-01T05:25:35.921360Z 3 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'
Slaveļ¼
018-11-01T05:23:07.849519Z 14 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
2018-11-01T05:23:07.861517Z 12 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
2018-11-01T05:23:07.861534Z 17 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log './TWSR-WH1-MySQL-relay-bin-group_replication_applier.000008' position: 4
2018-11-01T05:23:07.861874Z 0 [Note] Plugin group_replication reported: 'XCom protocol version: 3'
2018-11-01T05:23:07.861987Z 0 [Note] Plugin group_replication reported: 'XCom initialized and ready to accept incoming connections on port 33061'
2018-11-01T05:23:08.066725Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.066826Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.167016Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.167164Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.266873Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.267015Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.365971Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.366179Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.465505Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.465724Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.565534Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.565667Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.664104Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.664223Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.765709Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.765848Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.865850Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.866025Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.964266Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2018-11-01T05:23:08.964404Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to mysql-master:33061 on local port: 33061.'
2018-11-01T05:23:08.964427Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 33061'
2018-11-01T05:23:08.964882Z 0 [Warning] Plugin group_replication reported: 'read failed'
2018-11-01T05:23:09.009338Z 0 [ERROR] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 33061'
2018-11-01T05:24:07.861757Z 12 [ERROR] Plugin group_replication reported: 'Timeout on wait for view after joining group'
2018-11-01T05:24:07.861850Z 12 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2018-11-01T05:24:07.861886Z 12 [ERROR] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
2018-11-01T05:24:07.862517Z 17 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed
2018-11-01T05:24:07.862549Z 17 [Note] Slave SQL thread for channel 'group_replication_applier' exiting, replication stopped in log 'FIRST' at position 0
2018-11-01T05:24:07.863578Z 14 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'
Subject
Views
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.