Bug #96244 [GCS] The member was unable to join the group. Local port: 33061
Submitted: 18 Jul 7:25 Modified: 23 Jul 12:38
Reporter: Dilip Padmanabhan Email Updates:
Status: Need Feedback Impact on me:
None 
Category:MySQL Server: Group Replication Severity:S3 (Non-critical)
Version:8.0.16 OS:Ubuntu (Ubuntu 18.04 in Digital Ocean)
Assigned to: Bogdan Kecman CPU Architecture:Any
Tags: group replication, MySQL

[18 Jul 7:25] Dilip Padmanabhan
Description:
Error Log:

2019-07-17T09:28:22.128204Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-07-17T09:28:22.133538Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2019-07-17T09:28:22.173617Z 6 [System] [MY-013172] [Server] Received SHUTDOWN from user boot. Shutting down mysqld (Version: 8.0.13).
2019-07-17T09:28:22.174160Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.13'  socket: '/tmp/tmp.OaTgB84drZ/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2019-07-17T09:28:24.135111Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.13)  MySQL Community Server - GPL.
2019-07-17T09:28:25.436085Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.13) starting as process 17794
2019-07-17T09:28:28.451968Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-07-17T09:28:28.485203Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.13'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2019-07-17T09:28:28.579208Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2019-07-17T09:44:37.112317Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.13)  MySQL Community Server - GPL.
2019-07-17T09:44:37.589690Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.13) starting as process 17984
2019-07-17T09:44:38.711230Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-07-17T09:44:38.719004Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_bootstrap_group=OFF'.
2019-07-17T09:44:38.719057Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_start_on_boot=OFF'.
2019-07-17T09:44:38.719079Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_ssl_mode=REQUIRED'.
2019-07-17T09:44:38.719099Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_recovery_use_ssl=1'.
2019-07-17T09:44:38.719120Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_group_name=4eb49235-0673-4125-8eee-5bd117774bb4'.
2019-07-17T09:44:38.719139Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_ip_whitelist=139.59.10.92,139.59.30.212'.
2019-07-17T09:44:38.719159Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_group_seeds=139.59.10.92:33061,139.59.30.212:33061'.
2019-07-17T09:44:38.719178Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_single_primary_mode=OFF'.
2019-07-17T09:44:38.719198Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_enforce_update_everywhere_checks=ON'.
2019-07-17T09:44:38.719215Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_local_address=139.59.10.92:33061'.
2019-07-17T09:44:38.738841Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.13'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2019-07-17T09:44:38.851186Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2019-07-17T09:46:34.876003Z 8 [Warning] [MY-010604] [Repl] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=mysql-02-relay-bin' to avoid this problem.
2019-07-17T09:46:34.893200Z 8 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2019-07-17T09:47:59.650509Z 8 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.'
2019-07-17T09:47:59.970289Z 10 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='', master_port= 3306, 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=''.
2019-07-17T09:48:00.074005Z 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] read failed'
2019-07-17T09:48:00.083921Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 33061'
2019-07-17T09:49:00.012908Z 8 [ERROR] [MY-011640] [Repl] Plugin group_replication reported: 'Timeout on wait for view after joining group'
2019-07-17T09:49:00.012979Z 8 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
2019-07-17T09:50:49.638533Z 14 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.'
2019-07-17T09:50:49.641806Z 16 [System] [MY-010597] [Repl] '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=''.
2019-07-17T09:50:49.727011Z 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] read failed'
2019-07-17T09:50:49.753651Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 33061'
2019-07-17T09:51:49.700996Z 14 [ERROR] [MY-011640] [Repl] Plugin group_replication reported: 'Timeout on wait for view after joining group'
2019-07-17T09:51:49.701108Z 14 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'

How to repeat:
Steps: https://www.digitalocean.com/community/tutorials/how-to-configure-mysql-group-replication-...
Ubuntu VERSION="18.04.2 LTS (Bionic Beaver)"
Mysql: 8.0.16
Cloud Digital Ocean
[23 Jul 12:38] Bogdan Kecman
Hi,

Can you reproduce this with 8.0.17, I'm not able to reproduce this with 8.0.17

thanks