2022-09-21T16:41:13.328251Z 52 [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=ip-10-168-139-49-relay-bin' to avoid this problem. 2022-09-21T16:41:13.329420Z 52 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'clusterset_replication' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='10.160.132.135', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. 2022-09-21T16:41:16.421788Z 52 [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=''. 2022-09-21T16:41:16.547992Z 52 [System] [MY-013587] [Repl] Plugin group_replication reported: 'Plugin 'group_replication' is starting.' 2022-09-21T16:41:16.551118Z 56 [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='', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. 2022-09-21T16:41:18.850256Z 52 [System] [MY-011511] [Repl] Plugin group_replication reported: 'This server is working as secondary member with primary member address 10.168.138.178:3306.' 2022-09-21T16:41:19.850588Z 0 [Warning] [MY-013469] [Repl] Plugin group_replication reported: 'This member will start distributed recovery using clone. It is due to the number of missing transactions being higher than the configured threshold of 1.' 2022-09-21T16:41:20.851373Z 0 [System] [MY-013471] [Repl] Plugin group_replication reported: 'Distributed recovery will transfer data using: Cloning from a remote group donor.' 2022-09-21T16:41:20.851563Z 0 [System] [MY-011503] [Repl] Plugin group_replication reported: 'Group membership changed to 10.168.138.178:3306, 10.168.139.49:3306 on view 16637784509851723:2.' 2022-09-21T16:41:20.851745Z 72 [System] [MY-011566] [Repl] Plugin group_replication reported: 'Setting super_read_only=OFF.' 2022-09-21T16:41:20.944423Z 72 [Warning] [MY-013460] [InnoDB] Clone removing all user data for provisioning: Started 2022-09-21T16:41:20.998302Z 72 [Warning] [MY-013460] [InnoDB] Clone removing all user data for provisioning: Finished 2022-09-21T16:41:24.676792Z 0 [System] [MY-011504] [Repl] Plugin group_replication reported: 'Group membership changed: This member has left the group.' 2022-09-21T16:41:26.679190Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 52 user: 'config'. 2022-09-21T16:41:26.679806Z 0 [System] [MY-011651] [Repl] Plugin group_replication reported: 'Plugin 'group_replication' has been stopped.' 2022-09-21T16:41:27.799142Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.30) MySQL Community Server - GPL. 2022-09-21T16:41:28.185737Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30) starting as process 4400 2022-09-21T16:41:28.188981Z 0 [Warning] [MY-012358] [InnoDB] Option innodb_dedicated_server is ignored for innodb_buffer_pool_size because innodb_buffer_pool_size=2014314496 is specified explicitly. 2022-09-21T16:41:28.190337Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-09-21T16:41:29.040319Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2022-09-21T16:41:29.258013Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2022-09-21T16:41:29.258035Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2022-09-21T16:41:29.276357Z 0 [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=ip-10-168-139-49-relay-bin' to avoid this problem. 2022-09-21T16:41:29.277033Z 0 [Warning] [MY-013529] [Repl] Relay log information for channel 'clusterset_replication' was found after a clone operation. Relay log recovery will be executed to adjust positions and file information for this new server. Should that automatic procedure fail please adjust the positions through 'CHANGE MASTER TO' 2022-09-21T16:41:29.277047Z 0 [Warning] [MY-010539] [Repl] Recovery from master pos 221589 and file binlog.000002 for channel 'clusterset_replication'. Previous relay log pos and relay log file had been set to 411, ./ip-10-168-138-178-relay-bin-clusterset_replication.000002 respectively. 2022-09-21T16:41:29.287173Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock 2022-09-21T16:41:29.287215Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.30' socket: '/data/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL. 2022-09-21T16:42:05.294210Z 12 [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=''. 2022-09-21T16:42:30.654391Z 19 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'clusterset_replication' executed'. Previous state master_host='10.160.132.135', master_port= 3306, master_log_file='binlog.000002', master_log_pos= 221589, master_bind=''. New state master_host='10.160.132.135', master_port= 3306, master_log_file='binlog.000002', master_log_pos= 221589, master_bind=''. ~~~~ start group_replication here---- 2022-09-21T16:54:25.059043Z 123 [System] [MY-013587] [Repl] Plugin group_replication reported: 'Plugin 'group_replication' is starting.' 2022-09-21T16:54:25.062206Z 127 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. 2022-09-21T16:54:55.194905Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Timeout while waiting for the group communication engine to be ready!' 2022-09-21T16:54:55.194960Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The group communication engine is not ready for the member to join. Local port: 3306' 2022-09-21T16:54:55.235736Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 3306' 2022-09-21T16:55:01.236242Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 3306' 2022-09-21T16:55:01.284914Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 3306' 2022-09-21T16:55:07.306681Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 3306' 2022-09-21T16:55:07.355233Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 3306' 2022-09-21T16:55:13.377592Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 3306' 2022-09-21T16:55:13.423489Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 3306' 2022-09-21T16:55:19.450373Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 3306' 2022-09-21T16:55:19.497221Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 3306' 2022-09-21T16:55:25.067438Z 123 [ERROR] [MY-011640] [Repl] Plugin group_replication reported: 'Timeout on wait for view after joining group' 2022-09-21T16:55:25.067510Z 123 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member is already leaving or joining a group.' 2022-09-21T16:55:25.522017Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 3306' 2022-09-21T16:55:25.567383Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 3306'