|
升级secondary 节点由8.0.25 至 8.0.32 cs.rejoinInstance('192.168.56.74:3306') 出现 Error。该节点无法加入到集群： [Error] [MY-049501] 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.' 报错如下： MySQL localhost JS > 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 [System] [MY-013587] Plugin group_replication reported: 'Plugin 'group_replication' is starting.' 2024-03-26 14:49:18.917968 [Note] [MY-011716] Plugin group_replication reported: 'Current debug options are: 'GCS_DEBUG_NONE'.' 2024-03-26 14:49:18.922284 [System] [MY-011565] Plugin group_replication reported: 'Setting super_read_only=ON.' 2024-03-26 14:49:18.922469 [Note] [MY-011671] 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 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Debug messages will be sent to: asynchronous::/data/GreatSQL/GCS_DEBUG_TRACE' 2024-03-26 14:49:18.924009 [Note] [MY-011735] Plugin group_replication reported: '[GCS] 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 [Note] [MY-011694] 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 [Note] [MY-011643] 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 [Note] [MY-011071] Plugin group_replication reported: 'Init certifier broadcast thread' 2024-03-26 14:49:18.930236 [System] [MY-010597] '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 [Note] [MY-011670] Plugin group_replication reported: 'Group Replication applier module successfully initialized!' 2024-03-26 14:49:18.998888 [Note] [MY-010581] 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 [Note] [MY-011735] Plugin group_replication reported: '[GCS] buckets:2000000, dec_threshold_length:1000000' 2024-03-26 14:49:19.000916 [Note] [MY-011735] Plugin group_replication reported: '[GCS] 1711435759.000776 pid 10435 xcom_id a55f8e3c state xcom_fsm_start action x_fsm_init' 2024-03-26 14:49:20.755769 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Do start xcom_taskmain2' 2024-03-26 14:49:20.755815 [Note] [MY-011735] Plugin group_replication reported: '[GCS] enter taskmain' 2024-03-26 14:49:20.755853 [Note] [MY-011735] Plugin group_replication reported: '[GCS] start_active_network_provider calls configure' 2024-03-26 14:49:20.755861 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Using XCom as Communication Stack for XCom' 2024-03-26 14:49:20.758000 [Note] [MY-011735] Plugin group_replication reported: '[GCS] XCom initialized and ready to accept incoming connections on port 33061' 2024-03-26 14:49:20.758252 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Creating tcp_server task' 2024-03-26 14:49:20.758310 [Note] [MY-011735] Plugin group_replication reported: '[GCS] enter task loop' 2024-03-26 14:49:20.758405 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Successfully connected to the local XCom via anonymous pipe' 2024-03-26 14:49:20.804361 [Note] [MY-011735] Plugin group_replication reported: '[GCS] TCP_NODELAY already set' 2024-03-26 14:49:20.804397 [Note] [MY-011735] Plugin group_replication reported: '[GCS] 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 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Sending add_node request to a peer XCom node' 2024-03-26 14:49:20.807225 [Note] [MY-011735] Plugin group_replication reported: '[GCS] xcom_send_client_app_data sets CON_PROTO for fd:62' 2024-03-26 14:49:20.857594 [Note] [MY-011735] Plugin group_replication reported: '[GCS] set fd:56 connected' 2024-03-26 14:49:20.857663 [Note] [MY-011735] Plugin group_replication reported: '[GCS] set CON_NULL for fd:56 in close_connection' 2024-03-26 14:49:20.857774 [Note] [MY-011735] Plugin group_replication reported: '[GCS] set fd:63 connected' 2024-03-26 14:49:20.857787 [Note] [MY-011735] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:63' 2024-03-26 14:49:21.197746 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Node has not booted. Requesting an XCom snapshot from node number 0 in the current configuration' 2024-03-26 14:49:21.201105 [Note] [MY-011735] Plugin group_replication reported: '[GCS] 1711435761.201071 pid 10435 xcom_id a55f8e3c state xcom_fsm_start action x_fsm_snapshot' 2024-03-26 14:49:21.201173 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Installing requested snapshot. Importing all incoming configurations.' 2024-03-26 14:49:21.201247 [Note] [MY-011735] Plugin group_replication reported: '[GCS] import_config calls site_install_action' 2024-03-26 14:49:21.201487 [Note] [MY-011735] Plugin group_replication reported: '[GCS] update_servers is called, max nodes:1' 2024-03-26 14:49:21.201534 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Updating physical connections to other servers' 2024-03-26 14:49:21.201552 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Creating new server node 0 host 192.168.56.73:33061' 2024-03-26 14:49:21.201645 [Note] [MY-011735] Plugin group_replication reported: '[GCS] 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 [Note] [MY-011735] Plugin group_replication reported: '[GCS] import_config calls site_install_action' 2024-03-26 14:49:21.201777 [Note] [MY-011735] Plugin group_replication reported: '[GCS] update_servers is called, max nodes:2' 2024-03-26 14:49:21.201790 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Updating physical connections to other servers' 2024-03-26 14:49:21.201801 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Using existing server node 0 host 192.168.56.73:33061' 2024-03-26 14:49:21.201810 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Creating new server node 1 host 192.168.56.74:33061' 2024-03-26 14:49:21.201890 [Note] [MY-011735] Plugin group_replication reported: '[GCS] 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 [Note] [MY-011735] Plugin group_replication reported: '[GCS] import_config calls site_install_action' 2024-03-26 14:49:21.201979 [Note] [MY-011735] Plugin group_replication reported: '[GCS] update_servers is called, max nodes:1' 2024-03-26 14:49:21.201988 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Updating physical connections to other servers' 2024-03-26 14:49:21.201996 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Using existing server node 0 host 192.168.56.73:33061' 2024-03-26 14:49:21.202004 [Note] [MY-011735] Plugin group_replication reported: '[GCS] 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 [Note] [MY-011735] Plugin group_replication reported: '[GCS] import_config calls site_install_action' 2024-03-26 14:49:21.202092 [Note] [MY-011735] Plugin group_replication reported: '[GCS] update_servers is called, max nodes:2' 2024-03-26 14:49:21.202105 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Updating physical connections to other servers' 2024-03-26 14:49:21.202116 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Using existing server node 0 host 192.168.56.73:33061' 2024-03-26 14:49:21.202127 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Using existing server node 1 host 192.168.56.74:33061' 2024-03-26 14:49:21.202139 [Note] [MY-011735] Plugin group_replication reported: '[GCS] 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 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Finished snapshot installation. My node number is 1' 2024-03-26 14:49:21.202156 [Note] [MY-011735] Plugin group_replication reported: '[GCS] handle_fsm_snapshot calls xcom_fsm_run_enter' 2024-03-26 14:49:21.202498 [Note] [MY-011735] Plugin group_replication reported: '[GCS] set client_boot_done true' 2024-03-26 14:49:21.202511 [Note] [MY-011735] Plugin group_replication reported: '[GCS] The member has joined the group. Local port: 33061' 2024-03-26 14:49:21.202664 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Connecting to 192.168.56.73:33061' 2024-03-26 14:49:21.235043 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Connected to 192.168.56.73:33061' 2024-03-26 14:49:21.235084 [Note] [MY-011735] Plugin group_replication reported: '[GCS] sender_task sets CON_PROTO for fd:56' 2024-03-26 14:49:21.235249 [Note] [MY-011735] Plugin group_replication reported: '[GCS] sent negotiation request for protocol 10 fd 56' 2024-03-26 14:49:21.235334 [Note] [MY-011735] Plugin group_replication reported: '[GCS] enter detector_task' 2024-03-26 14:49:21.235342 [Note] [MY-011735] Plugin group_replication reported: '[GCS] set local notify true when site is different' 2024-03-26 14:49:21.235346 [Note] [MY-011735] Plugin group_replication reported: '[GCS] notify is set true in check_local_node_set' 2024-03-26 14:49:21.235350 [Note] [MY-011735] Plugin group_replication reported: '[GCS] call deliver_view_msg in detector' 2024-03-26 14:49:21.235503 [Note] [MY-011735] Plugin group_replication reported: '[GCS] xcom_receive_local_view is called' 2024-03-26 14:49:21.238960 [Note] [MY-011735] Plugin group_replication reported: '[GCS] read_msg sets CON_PROTO for fd:56 in mark, tag:313' 2024-03-26 14:49:21.314477 [Note] [MY-011735] Plugin group_replication reported: '[GCS] notify is set true in check_local_node_set' 2024-03-26 14:49:21.314530 [Note] [MY-011735] Plugin group_replication reported: '[GCS] call deliver_view_msg in detector' 2024-03-26 14:49:21.315008 [Note] [MY-011735] Plugin group_replication reported: '[GCS] xcom_receive_local_view is called' 2024-03-26 14:49:21.334766 [Note] [MY-011735] Plugin group_replication reported: '[GCS] proto is done for fd:56' 2024-03-26 14:49:21.341681 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Rejecting this message. The member is not in a view yet.' 2024-03-26 14:49:21.343683 [Note] [MY-011735] Plugin group_replication reported: '[GCS] before deliver_global_view_msg is called' 2024-03-26 14:49:21.343742 [Note] [MY-011735] Plugin group_replication reported: '[GCS] after deliver_global_view_msg is called' 2024-03-26 14:49:21.343957 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Rejecting this message. The member is not in a view yet.' 2024-03-26 14:49:21.344153 [Note] [MY-011735] Plugin group_replication reported: '[GCS] ::xcom_receive_global_view() is called' 2024-03-26 14:49:21.345337 [Note] [MY-011735] Plugin group_replication reported: '[GCS] before deliver_global_view_msg is called' 2024-03-26 14:49:21.345396 [Note] [MY-011735] Plugin group_replication reported: '[GCS] after deliver_global_view_msg is called' 2024-03-26 14:49:21.345649 [Note] [MY-011735] Plugin group_replication reported: '[GCS] ::xcom_receive_global_view() is called' 2024-03-26 14:49:21.345867 [Note] [MY-011735] Plugin group_replication reported: '[GCS] xcom_communication do_send_message CT_INTERNAL_STATE_EXCHANGE' 2024-03-26 14:49:21.345948 [Note] [MY-011735] Plugin group_replication reported: '[GCS] ::xcom_receive_global_view():: state exchange started.' 2024-03-26 14:49:21.363510 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Do receive CT_INTERNAL_STATE_EXCHANGE message from xcom' 2024-03-26 14:49:21.363570 [Note] [MY-011735] Plugin group_replication reported: '[GCS] ::process_control_message():: Received a control message' 2024-03-26 14:49:22.467532 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Do receive CT_INTERNAL_STATE_EXCHANGE message from xcom' 2024-03-26 14:49:22.467582 [Note] [MY-011735] Plugin group_replication reported: '[GCS] ::process_control_message():: Received a control message' 2024-03-26 14:49:22.467648 [Note] [MY-011735] Plugin group_replication reported: '[GCS] This server adjusted its communication protocol to 8.0.16 in order to join the group.' 2024-03-26 14:49:22.467655 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Group is able to support up to communication protocol version 8.0.16' 2024-03-26 14:49:22.467660 [Note] [MY-011735] Plugin group_replication reported: '[GCS] ::process_control_message()::Install new view' 2024-03-26 14:49:22.467686 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Processing exchanged data while installing the new view' 2024-03-26 14:49:22.467692 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Processing exchanged data while installing the new view' 2024-03-26 14:49:22.467716 [Note] [MY-011071] Plugin group_replication reported: 'on_view_changed is called' 2024-03-26 14:49:22.467791 [Warning] [MY-013737] 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 [Warning] [MY-013783] 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 [Warning] [MY-013426] Plugin group_replication reported: 'Member version is read compatible with the group.' 2024-03-26 14:49:22.475878 [Error] [MY-049501] 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 [Note] [MY-000000] Plugin group_replication reported: 'Set cancelled_view_change true' 2024-03-26 14:49:22.476206 [Note] [MY-011071] Plugin group_replication reported: 'handle_leader_election_if_needed is activated,suggested_primary:' 2024-03-26 14:49:22.476242 [System] [MY-011503] 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 [Note] [MY-011647] Plugin group_replication reported: 'Going to wait for view modification' 2024-03-26 14:49:22.476499 [Note] [MY-011735] Plugin group_replication reported: '[GCS] xcom_client_remove_node: Try to push xcom_client_remove_node to XCom' 2024-03-26 14:49:22.492275 [Note] [MY-011735] Plugin group_replication reported: '[GCS] handle_remove_node calls site_install_action' 2024-03-26 14:49:22.492425 [Note] [MY-011735] Plugin group_replication reported: '[GCS] update_servers is called, max nodes:1' 2024-03-26 14:49:22.492435 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Updating physical connections to other servers' 2024-03-26 14:49:22.492441 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Using existing server node 0 host 192.168.56.73:33061' 2024-03-26 14:49:22.492448 [Note] [MY-011735] Plugin group_replication reported: '[GCS] 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 [Note] [MY-011735] Plugin group_replication reported: '[GCS] 1711435765.569610 pid 10435 xcom_id a55f8e3c state xcom_fsm_run action x_fsm_terminate' 2024-03-26 14:49:25.569742 [Note] [MY-011735] Plugin group_replication reported: '[GCS] set CON_NULL for fd:56 in close_connection' 2024-03-26 14:49:25.570140 [Note] [MY-011735] Plugin group_replication reported: '[GCS] 1711435765.570116 pid 10435 xcom_id dacf5b24 state xcom_fsm_start action x_fsm_exit' 2024-03-26 14:49:25.570177 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Exiting xcom thread' 2024-03-26 14:49:25.570213 [Note] [MY-011735] Plugin group_replication reported: '[GCS] set CON_NULL for fd:63 in close_connection' 2024-03-26 14:49:25.879557 [Note] [MY-011735] Plugin group_replication reported: '[GCS] Installing leave view.' 2024-03-26 14:49:25.879656 [Note] [MY-011735] Plugin group_replication reported: '[GCS] ::install_view():: No exchanged data' 2024-03-26 14:49:25.879762 [Note] [MY-011071] Plugin group_replication reported: 'on_view_changed is called' 2024-03-26 14:49:25.880619 [System] [MY-011504] Plugin group_replication reported: 'Group membership changed: This member has left the group.' 2024-03-26 14:49:25.890280 [Note] [MY-010596] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed 2024-03-26 14:49:25.891844 [Note] [MY-010587] Slave SQL thread for channel 'group_replication_applier' exiting, replication stopped in log 'INVALID' at position 0 2024-03-26 14:49:25.892275 [Note] [MY-011444] Plugin group_replication reported: 'The group replication applier thread was killed.' 2024-03-26 14:49:25.892865 [Note] [MY-011071] 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) |
|
|
yejr
2024-3-28 20:44:42
| |
合作电话：010-64087828
社区邮箱：greatsql@greatdb.com
