升级8.0.25 至 8.0.32后，secondary节点无法加入集群
升级secondary 节点由8.0.25 至 8.0.32cs.rejoinInstance('192.168.56.74:3306')
出现 Error。该节点无法加入到集群：
Plugin group_replication reported: 'The member is configured with a single_primary_fast_mode option value '1' not compatible from the group '0'. The member will now exit the group.'
报错如下：
MySQLlocalhostJS > cs.rejoinInstance('192.168.56.74:3306')
WARNING: The instance '192.168.56.74:3306' is only read compatible with the cluster, thus it will join the cluster in R/O mode.
Validating instance configuration at 192.168.56.74:3306...
This instance reports its own address as 192.168.56.74:3306
Instance configuration is suitable.
Rejoining instance '192.168.56.74:3306' to cluster 'nanjingCluster'...
ERROR: Unable to start Group Replication for instance '192.168.56.74:3306'.
The MySQL error_log contains the following messages:
2024-03-26 14:49:18.917678 Plugin group_replication reported: 'Plugin 'group_replication' is starting.'
2024-03-26 14:49:18.917968 Plugin group_replication reported: 'Current debug options are: 'GCS_DEBUG_NONE'.'
2024-03-26 14:49:18.922284 Plugin group_replication reported: 'Setting super_read_only=ON.'
2024-03-26 14:49:18.922469 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.2"; tls_ciphersuites: "NOT_SET"; crl_file: ""; crl_path: ""; ssl_fips_mode: "OFF"'
2024-03-26 14:49:18.923736 Plugin group_replication reported: ' Debug messages will be sent to: asynchronous::/data/GreatSQL/GCS_DEBUG_TRACE'
2024-03-26 14:49:18.924009 Plugin group_replication reported: ' Added automatically IP ranges 10.0.2.15/24,127.0.0.1/8,192.168.56.74/24,::1/128,fe80::a00:27ff:fea7:2fa/64,fe80::b55:3317:15a6:4eb0/64 to the allowlist'
2024-03-26 14:49:18.927797 Plugin group_replication reported: 'Initialized group communication with configuration: group_replication_group_name: '7dd9a253-eb6b-11ee-84a9-080027ad5a69'; group_replication_local_address: '192.168.56.74:33061'; group_replication_group_seeds: '192.168.56.73:33061'; group_replication_bootstrap_group: 'false'; group_replication_poll_spin_loops: 0; group_replication_compression_threshold: 1000000; group_replication_ip_allowlist: 'AUTOMATIC'; group_replication_communication_debug_options: 'GCS_DEBUG_NONE'; group_replication_member_expel_timeout: '5'; group_replication_communication_max_message_size: 1048576; group_replication_message_cache_size: '1073741824u; group_replication_communication_stack: '0''
2024-03-26 14:49:18.928006 Plugin group_replication reported: 'Member configuration: member_id: 3306965; member_uuid: "a4102bb6-eb37-11ee-b25f-080027a16b1c"; single-primary mode: "true"; group_replication_auto_increment_increment: 7; group_replication_view_change_uuid: "AUTOMATIC";'
2024-03-26 14:49:18.928268 Plugin group_replication reported: 'Init certifier broadcast thread'
2024-03-26 14:49:18.930236 '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=''.
2024-03-26 14:49:18.998802 Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
2024-03-26 14:49:18.998888 Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'INVALID' at position 0, relay log './s274-relay-bin-group_replication_applier.000003' position: 4
2024-03-26 14:49:19.000345 Plugin group_replication reported: ' buckets:2000000, dec_threshold_length:1000000'
2024-03-26 14:49:19.000916 Plugin group_replication reported: ' 1711435759.000776 pid 10435 xcom_id a55f8e3c state xcom_fsm_start action x_fsm_init'
2024-03-26 14:49:20.755769 Plugin group_replication reported: ' Do start xcom_taskmain2'
2024-03-26 14:49:20.755815 Plugin group_replication reported: ' enter taskmain'
2024-03-26 14:49:20.755853 Plugin group_replication reported: ' start_active_network_provider calls configure'
2024-03-26 14:49:20.755861 Plugin group_replication reported: ' Using XCom as Communication Stack for XCom'
2024-03-26 14:49:20.758000 Plugin group_replication reported: ' XCom initialized and ready to accept incoming connections on port 33061'
2024-03-26 14:49:20.758252 Plugin group_replication reported: ' Creating tcp_server task'
2024-03-26 14:49:20.758310 Plugin group_replication reported: ' enter task loop'
2024-03-26 14:49:20.758405 Plugin group_replication reported: ' Successfully connected to the local XCom via anonymous pipe'
2024-03-26 14:49:20.804361 Plugin group_replication reported: ' TCP_NODELAY already set'
2024-03-26 14:49:20.804397 Plugin group_replication reported: ' Sucessfully connected to peer 192.168.56.73:33061. Sending a request to be added to the group'
2024-03-26 14:49:20.804446 Plugin group_replication reported: ' Sending add_node request to a peer XCom node'
2024-03-26 14:49:20.807225 Plugin group_replication reported: ' xcom_send_client_app_data sets CON_PROTO for fd:62'
2024-03-26 14:49:20.857594 Plugin group_replication reported: ' set fd:56 connected'
2024-03-26 14:49:20.857663 Plugin group_replication reported: ' set CON_NULL for fd:56 in close_connection'
2024-03-26 14:49:20.857774 Plugin group_replication reported: ' set fd:63 connected'
2024-03-26 14:49:20.857787 Plugin group_replication reported: ' buffered_read_msg sets CON_PROTO for fd:63'
2024-03-26 14:49:21.197746 Plugin group_replication reported: ' Node has not booted. Requesting an XCom snapshot from node number 0 in the current configuration'
2024-03-26 14:49:21.201105 Plugin group_replication reported: ' 1711435761.201071 pid 10435 xcom_id a55f8e3c state xcom_fsm_start action x_fsm_snapshot'
2024-03-26 14:49:21.201173 Plugin group_replication reported: ' Installing requested snapshot. Importing all incoming configurations.'
2024-03-26 14:49:21.201247 Plugin group_replication reported: ' import_config calls site_install_action'
2024-03-26 14:49:21.201487 Plugin group_replication reported: ' update_servers is called, max nodes:1'
2024-03-26 14:49:21.201534 Plugin group_replication reported: ' Updating physical connections to other servers'
2024-03-26 14:49:21.201552 Plugin group_replication reported: ' Creating new server node 0 host 192.168.56.73:33061'
2024-03-26 14:49:21.201645 Plugin group_replication reported: ' Sucessfully installed new site definition. Start synode for this configuration is {166cc7f 3582 1}, boot key synode is {166cc7f 3571 1}, configured event horizon=10, my node identifier is 4294967295'
2024-03-26 14:49:21.201686 Plugin group_replication reported: ' import_config calls site_install_action'
2024-03-26 14:49:21.201777 Plugin group_replication reported: ' update_servers is called, max nodes:2'
2024-03-26 14:49:21.201790 Plugin group_replication reported: ' Updating physical connections to other servers'
2024-03-26 14:49:21.201801 Plugin group_replication reported: ' Using existing server node 0 host 192.168.56.73:33061'
2024-03-26 14:49:21.201810 Plugin group_replication reported: ' Creating new server node 1 host 192.168.56.74:33061'
2024-03-26 14:49:21.201890 Plugin group_replication reported: ' Sucessfully installed new site definition. Start synode for this configuration is {166cc7f 3809 0}, boot key synode is {166cc7f 3798 0}, configured event horizon=10, my node identifier is 1'
2024-03-26 14:49:21.201901 Plugin group_replication reported: ' import_config calls site_install_action'
2024-03-26 14:49:21.201979 Plugin group_replication reported: ' update_servers is called, max nodes:1'
2024-03-26 14:49:21.201988 Plugin group_replication reported: ' Updating physical connections to other servers'
2024-03-26 14:49:21.201996 Plugin group_replication reported: ' Using existing server node 0 host 192.168.56.73:33061'
2024-03-26 14:49:21.202004 Plugin group_replication reported: ' Sucessfully installed new site definition. Start synode for this configuration is {166cc7f 3836 1}, boot key synode is {166cc7f 3825 1}, configured event horizon=10, my node identifier is 4294967295'
2024-03-26 14:49:21.202014 Plugin group_replication reported: ' import_config calls site_install_action'
2024-03-26 14:49:21.202092 Plugin group_replication reported: ' update_servers is called, max nodes:2'
2024-03-26 14:49:21.202105 Plugin group_replication reported: ' Updating physical connections to other servers'
2024-03-26 14:49:21.202116 Plugin group_replication reported: ' Using existing server node 0 host 192.168.56.73:33061'
2024-03-26 14:49:21.202127 Plugin group_replication reported: ' Using existing server node 1 host 192.168.56.74:33061'
2024-03-26 14:49:21.202139 Plugin group_replication reported: ' Sucessfully installed new site definition. Start synode for this configuration is {166cc7f 4977 0}, boot key synode is {166cc7f 4966 0}, configured event horizon=10, my node identifier is 1'
2024-03-26 14:49:21.202149 Plugin group_replication reported: ' Finished snapshot installation. My node number is 1'
2024-03-26 14:49:21.202156 Plugin group_replication reported: ' handle_fsm_snapshot calls xcom_fsm_run_enter'
2024-03-26 14:49:21.202498 Plugin group_replication reported: ' set client_boot_done true'
2024-03-26 14:49:21.202511 Plugin group_replication reported: ' The member has joined the group. Local port: 33061'
2024-03-26 14:49:21.202664 Plugin group_replication reported: ' Connecting to 192.168.56.73:33061'
2024-03-26 14:49:21.235043 Plugin group_replication reported: ' Connected to 192.168.56.73:33061'
2024-03-26 14:49:21.235084 Plugin group_replication reported: ' sender_task sets CON_PROTO for fd:56'
2024-03-26 14:49:21.235249 Plugin group_replication reported: ' sent negotiation request for protocol 10 fd 56'
2024-03-26 14:49:21.235334 Plugin group_replication reported: ' enter detector_task'
2024-03-26 14:49:21.235342 Plugin group_replication reported: ' set local notify true when site is different'
2024-03-26 14:49:21.235346 Plugin group_replication reported: ' notify is set true in check_local_node_set'
2024-03-26 14:49:21.235350 Plugin group_replication reported: ' call deliver_view_msg in detector'
2024-03-26 14:49:21.235503 Plugin group_replication reported: ' xcom_receive_local_view is called'
2024-03-26 14:49:21.238960 Plugin group_replication reported: ' read_msg sets CON_PROTO for fd:56 in mark, tag:313'
2024-03-26 14:49:21.314477 Plugin group_replication reported: ' notify is set true in check_local_node_set'
2024-03-26 14:49:21.314530 Plugin group_replication reported: ' call deliver_view_msg in detector'
2024-03-26 14:49:21.315008 Plugin group_replication reported: ' xcom_receive_local_view is called'
2024-03-26 14:49:21.334766 Plugin group_replication reported: ' proto is done for fd:56'
2024-03-26 14:49:21.341681 Plugin group_replication reported: ' Rejecting this message. The member is not in a view yet.'
2024-03-26 14:49:21.343683 Plugin group_replication reported: ' before deliver_global_view_msg is called'
2024-03-26 14:49:21.343742 Plugin group_replication reported: ' after deliver_global_view_msg is called'
2024-03-26 14:49:21.343957 Plugin group_replication reported: ' Rejecting this message. The member is not in a view yet.'
2024-03-26 14:49:21.344153 Plugin group_replication reported: ' ::xcom_receive_global_view() is called'
2024-03-26 14:49:21.345337 Plugin group_replication reported: ' before deliver_global_view_msg is called'
2024-03-26 14:49:21.345396 Plugin group_replication reported: ' after deliver_global_view_msg is called'
2024-03-26 14:49:21.345649 Plugin group_replication reported: ' ::xcom_receive_global_view() is called'
2024-03-26 14:49:21.345867 Plugin group_replication reported: ' xcom_communication do_send_message CT_INTERNAL_STATE_EXCHANGE'
2024-03-26 14:49:21.345948 Plugin group_replication reported: ' ::xcom_receive_global_view():: state exchange started.'
2024-03-26 14:49:21.363510 Plugin group_replication reported: ' Do receive CT_INTERNAL_STATE_EXCHANGE message from xcom'
2024-03-26 14:49:21.363570 Plugin group_replication reported: ' ::process_control_message():: Received a control message'
2024-03-26 14:49:22.467532 Plugin group_replication reported: ' Do receive CT_INTERNAL_STATE_EXCHANGE message from xcom'
2024-03-26 14:49:22.467582 Plugin group_replication reported: ' ::process_control_message():: Received a control message'
2024-03-26 14:49:22.467648 Plugin group_replication reported: ' This server adjusted its communication protocol to 8.0.16 in order to join the group.'
2024-03-26 14:49:22.467655 Plugin group_replication reported: ' Group is able to support up to communication protocol version 8.0.16'
2024-03-26 14:49:22.467660 Plugin group_replication reported: ' ::process_control_message()::Install new view'
2024-03-26 14:49:22.467686 Plugin group_replication reported: ' Processing exchanged data while installing the new view'
2024-03-26 14:49:22.467692 Plugin group_replication reported: ' Processing exchanged data while installing the new view'
2024-03-26 14:49:22.467716 Plugin group_replication reported: 'on_view_changed is called'
2024-03-26 14:49:22.467791 Plugin group_replication reported: 'This member joined a group on which all members do not support member actions, as such it did reset its member configuration to the default one.'
2024-03-26 14:49:22.474431 This member joined a group on which all members do not support replication failover channels integration on Group Replication, as such it did reset its replication failover channels configuration to the default one.
2024-03-26 14:49:22.475820 Plugin group_replication reported: 'Member version is read compatible with the group.'
2024-03-26 14:49:22.475878 Plugin group_replication reported: 'The member is configured with a single_primary_fast_mode option value '1' not compatible from the group '0'. The member will now exit the group.'
2024-03-26 14:49:22.476165 Plugin group_replication reported: 'Set cancelled_view_change true'
2024-03-26 14:49:22.476206 Plugin group_replication reported: 'handle_leader_election_if_needed is activated,suggested_primary:'
2024-03-26 14:49:22.476242 Plugin group_replication reported: 'Group membership changed to 192.168.56.73:3306, 192.168.56.74:3306 on view 17114557413671052:14.'
2024-03-26 14:49:22.476264 Plugin group_replication reported: 'Going to wait for view modification'
2024-03-26 14:49:22.476499 Plugin group_replication reported: ' xcom_client_remove_node: Try to push xcom_client_remove_node to XCom'
2024-03-26 14:49:22.492275 Plugin group_replication reported: ' handle_remove_node calls site_install_action'
2024-03-26 14:49:22.492425 Plugin group_replication reported: ' update_servers is called, max nodes:1'
2024-03-26 14:49:22.492435 Plugin group_replication reported: ' Updating physical connections to other servers'
2024-03-26 14:49:22.492441 Plugin group_replication reported: ' Using existing server node 0 host 192.168.56.73:33061'
2024-03-26 14:49:22.492448 Plugin group_replication reported: ' Sucessfully installed new site definition. Start synode for this configuration is {166cc7f 5004 1}, boot key synode is {166cc7f 4993 1}, configured event horizon=10, my node identifier is 4294967295'
2024-03-26 14:49:25.569652 Plugin group_replication reported: ' 1711435765.569610 pid 10435 xcom_id a55f8e3c state xcom_fsm_run action x_fsm_terminate'
2024-03-26 14:49:25.569742 Plugin group_replication reported: ' set CON_NULL for fd:56 in close_connection'
2024-03-26 14:49:25.570140 Plugin group_replication reported: ' 1711435765.570116 pid 10435 xcom_id dacf5b24 state xcom_fsm_start action x_fsm_exit'
2024-03-26 14:49:25.570177 Plugin group_replication reported: ' Exiting xcom thread'
2024-03-26 14:49:25.570213 Plugin group_replication reported: ' set CON_NULL for fd:63 in close_connection'
2024-03-26 14:49:25.879557 Plugin group_replication reported: ' Installing leave view.'
2024-03-26 14:49:25.879656 Plugin group_replication reported: ' ::install_view():: No exchanged data'
2024-03-26 14:49:25.879762 Plugin group_replication reported: 'on_view_changed is called'
2024-03-26 14:49:25.880619 Plugin group_replication reported: 'Group membership changed: This member has left the group.'
2024-03-26 14:49:25.890280 Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed
2024-03-26 14:49:25.891844 Slave SQL thread for channel 'group_replication_applier' exiting, replication stopped in log 'INVALID' at position 0
2024-03-26 14:49:25.892275 Plugin group_replication reported: 'The group replication applier thread was killed.'
2024-03-26 14:49:25.892865 Plugin group_replication reported: 'Destroy certifier broadcast thread'
ERROR: RuntimeError: Group Replication failed to start: MySQL Error 3092 (HY000): 192.168.56.74:3306: The server is not configured properly to be an active member of the group. Please see more details on error log.
Cluster.rejoinInstance: Group Replication failed to start: MySQL Error 3092 (HY000): 192.168.56.74:3306: The server is not configured properly to be an active member of the group. Please see more details on error log. (RuntimeError)
应该是不支持滚动升级，fast mode更不支持了 kaqiu 发表于 2024-3-28 16:53
应该是不支持滚动升级，fast mode更不支持了
再用户手册中有提到，从8.0.25升级到8.0.32不支持滚动升级，具体原因
提醒： 由于从MySQL 8.0.26开始新增选项 group_replication_view_change_uuid，因此不支持在一个MGR集群中，同时包含8.0.26以前及以后的版本。例如：在MGR集群中，不能并存8.0.25和8.0.26版本。这种情况下，版本号是8.0.25的MGR集群想要升级到8.0.32，就需要新建一个8.0.32版本的MGR集群，两个集群间再构建异步（或半同步）复制通道，采用这种方式才能实现平滑升级迁移，否则只能是安排离线停机维护时间，才能完成升级。
详情参考：https://greatsql.cn/docs/8032-25/user-manual/7-migrate-and-upgrade/1-upgrade-to-greatsql8.html
另外，要保证所有节点的 group_replication_single_primary_fast_mode 选项值一致才行。
页:
[1]