Bug #92110 Errors when joining on start may lead to a stale view of the group

Description:
When joining a member on a server restart, if the join process fails because the server is incompatible with the group, we can have a situation where the state of group is:

SELECT * FROM performance_schema.replication_group_members;
CHANNEL_NAME MEMBER_HOST	MEMBER_PORT	MEMBER_STATE
group_replication_applier 127.0.0.1 13000 ONLINE 
group_replication_applier 127.0.0.1 13001 OFFLINE		

In the offline member we still see another member as being online.

How to repeat:
Go to

  group_replication.gr_lower_case_table_names_different

print the members after the member fails to join the group on boot

  

Suggested fix:
No suggestion

Posted by developer:
 
Thank you for your feedback, this has been fixed in upcoming versions and the following was added to the 8.0.16 changelog:
When a member joined a group on server start, if the join process failed, for example because the server was incompatible with the group, there was a possibility that the offline member could still see another member as being online. Now, in such a situation the information shown in the performance_schema.replication_group_members table is restricted to the local member when it is OFFLINE.