2022-08-03 16:52:14: Debug2: Invoking helper 2022-08-03 16:52:14: Debug2: Command line: /usr/bin/mysql-secret-store-login-path get 2022-08-03 16:52:14: Debug2: Input: {"SecretType":"password","ServerURL":"ods.cluster.config@10.170.1.106"} 2022-08-03 16:52:14: Debug2: Output: {"SecretType":"password","ServerURL":"ods.cluster.config@10.170.1.106","Secret":"****"} 2022-08-03 16:52:14: Debug2: Exit code: 0 2022-08-03 16:52:14: Info: Connecting to MySQL at: ods.cluster.config@10.170.1.106 2022-08-03 16:52:15: Info: Shell.connect: tid=18353: CONNECTED: 10.170.1.106 2022-08-03 16:52:15: Debug: Closing session: mysqlx://ods.cluster.config@10.170.1.106:33060 2022-08-03 16:52:15: Info: Dba.getCluster: tid=18353: SQL: SELECT @@GLOBAL.port 2022-08-03 16:52:15: Info: Connecting to MySQL at: mysql://ods.cluster.config@10.170.1.106:3306?connect-timeout=5000 2022-08-03 16:52:15: Debug3: PLUGIN-TRACE-START: PluginEventHandler.CONNECTING 2022-08-03 16:52:15: Debug3: PLUGIN-EVENT: caching_sha2_password.AUTHENTICATE.AUTH_PLUGIN 2022-08-03 16:52:15: Info: Dba.getCluster: tid=18356: CONNECTED: 10.170.1.106:3306 2022-08-03 16:52:15: Info: Dba.getCluster: tid=18356: SQL: SET SESSION `autocommit` = 1 2022-08-03 16:52:15: Info: Dba.getCluster: tid=18356: SQL: SET SESSION `sql_mode` = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 2022-08-03 16:52:16: Info: Dba.getCluster: tid=18356: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' 2022-08-03 16:52:16: Info: Dba.getCluster: tid=18356: SQL: SELECT COALESCE(@@report_host, @@hostname), COALESCE(@@report_port, @@port) 2022-08-03 16:52:16: Info: Dba.getCluster: tid=18356: SQL: SELECT @@server_uuid 2022-08-03 16:52:16: Debug: Metadata operations will use 10.170.1.106:3306 2022-08-03 16:52:16: Info: Dba.getCluster: tid=18356: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata' 2022-08-03 16:52:16: Info: Dba.getCluster: tid=18356: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__' 2022-08-03 16:52:16: Info: Dba.getCluster: tid=18356: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp' 2022-08-03 16:52:16: Info: Dba.getCluster: tid=18356: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version` 2022-08-03 16:52:16: Debug: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null 2022-08-03 16:52:16: Info: Dba.getCluster: tid=18356: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version` 2022-08-03 16:52:16: Debug: Instance type check: 10.170.1.106:3306: Metadata version 2.1.0 found 2022-08-03 16:52:16: Info: Dba.getCluster: tid=18356: SQL: select cluster_type from `mysql_innodb_cluster_metadata`.v2_this_instance 2022-08-03 16:52:16: Debug: Instance type check: 10.170.1.106:3306: Cluster metadata record found (metadata 2.1.0) 2022-08-03 16:52:16: Debug: Instance c5e8984e-1334-11ed-9493-067bc1f7780d is managed for GROUP-REPLICATION 2022-08-03 16:52:16: Info: Dba.getCluster: tid=18356: SQL: select count(*) FROM performance_schema.replication_group_members WHERE MEMBER_ID = @@server_uuid AND MEMBER_STATE NOT IN ('OFFLINE', 'UNREACHABLE') 2022-08-03 16:52:16: Debug: Instance type check: 10.170.1.106:3306: GR is active 2022-08-03 16:52:16: Info: Dba.getCluster: tid=18356: SQL: SELECT COUNT(*) FROM performance_schema.threads WHERE NAME = 'thread/group_rpl/THD_delayed_initialization' 2022-08-03 16:52:16: Info: Dba.getCluster: tid=18356: SQL: SELECT @@group_replication_group_name group_name, NULLIF(CONCAT(''/*!80026, @@group_replication_view_change_uuid*/), '') group_view_change_uuid, @@group_replication_single_primary_mode single_primary, @@server_uuid, member_state, (SELECT sum(IF(member_state in ('ONLINE', 'RECOVERING'), 1, 0)) > sum(1)/2 FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR member_state <> 'ERROR' ) has_quorum, COALESCE(/*!80002 member_role = 'PRIMARY', NULL AND */ NOT @@group_replication_single_primary_mode OR member_id = (select variable_value from performance_schema.global_status where variable_name = 'group_replication_primary_member') ) is_primary FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid 2022-08-03 16:52:16: Info: Dba.getCluster: tid=18356: SQL: SELECT (SELECT COUNT(*) FROM `mysql_innodb_cluster_metadata`.instances WHERE cluster_id = (SELECT cluster_id FROM `mysql_innodb_cluster_metadata`.instances WHERE mysql_server_uuid = @@server_uuid)) = (SELECT count(*) FROM performance_schema.replication_group_members WHERE member_state = 'ONLINE') as all_online 2022-08-03 16:52:16: Info: Dba.getCluster: tid=18356: SQL: SELECT clusterset_id from mysql_innodb_cluster_metadata.clusters c, mysql_innodb_cluster_metadata.instances i WHERE c.cluster_id=i.cluster_id AND i.address = '10.170.1.106:3306' 2022-08-03 16:52:16: Debug: Metadata operations will use 10.170.1.106:3306 2022-08-03 16:52:16: Info: Dba.getCluster: tid=18356: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata' 2022-08-03 16:52:17: Info: Dba.getCluster: tid=18356: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__' 2022-08-03 16:52:17: Info: Dba.getCluster: tid=18356: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp' 2022-08-03 16:52:17: Info: Dba.getCluster: tid=18356: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version` 2022-08-03 16:52:17: Debug: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null 2022-08-03 16:52:17: Info: Dba.getCluster: tid=18356: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version` 2022-08-03 16:52:17: Info: Dba.getCluster: tid=18356: SQL: select cluster_type from `mysql_innodb_cluster_metadata`.v2_this_instance 2022-08-03 16:52:17: Debug: Instance type check: 10.170.1.106:3306: Cluster metadata record found (metadata 2.1.0) 2022-08-03 16:52:17: Info: Dba.getCluster: tid=18356: SQL: SELECT m.member_id, m.member_state, m.member_host, m.member_port, m.member_role, m.member_version, s.view_id FROM performance_schema.replication_group_members m LEFT JOIN performance_schema.replication_group_member_stats s ON m.member_id = s.member_id AND s.channel_name = 'group_replication_applier' WHERE m.member_id = @@server_uuid OR m.member_state <> 'ERROR' ORDER BY m.member_id 2022-08-03 16:52:17: Info: Dba.getCluster: tid=18356: SQL: SELECT c.* FROM ( SELECT cluster_type, primary_mode, cluster_id, cluster_name, description, NULL as group_name, async_topology_type, NULL as clusterset_id, 0 as invalidated FROM mysql_innodb_cluster_metadata.v2_ar_clusters UNION ALL SELECT c.cluster_type, c.primary_mode, c.cluster_id, c.cluster_name, c.description, c.group_name, NULL as async_topology_type, c.clusterset_id, coalesce(cv.invalidated, 0) as invalidated FROM mysql_innodb_cluster_metadata.v2_gr_clusters c LEFT JOIN mysql_innodb_cluster_metadata.v2_cs_members cv ON c.cluster_id = cv.cluster_id ) as c JOIN mysql_innodb_cluster_metadata.`v2_instances` i ON i.`cluster_id` = `c`.`cluster_id` WHERE i.mysql_server_uuid = 'c5e8984e-1334-11ed-9493-067bc1f7780d' 2022-08-03 16:52:17: Info: Dba.getCluster: tid=18356: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' 2022-08-03 16:52:17: Info: Dba.getCluster: tid=18356: SQL: SELECT c.*, m.view_id, m.member_role, m.master_cluster_id, m.invalidated, c.attributes->>'$.group_replication_view_change_uuid' as view_uuid FROM mysql_innodb_cluster_metadata.v2_cs_members m JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = m.cluster_id WHERE m.clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' AND m.invalidated = 0 2022-08-03 16:52:17: Info: Dba.getCluster: tid=18356: SQL: show GLOBAL variables where `variable_name` in ('group_replication_group_name') 2022-08-03 16:52:17: Debug: Refreshing metadata cache from 10.170.1.106:3306 2022-08-03 16:52:17: Info: Dba.getCluster: tid=18356: SQL: SELECT i.instance_id, i.cluster_id, c.group_name, am.master_instance_id, am.master_member_id, am.member_role, am.view_id, i.label, i.mysql_server_uuid, i.address, i.endpoint, i.xendpoint, ii.addresses->>'$.grLocal' as grendpoint, CAST(ii.attributes->'$.server_id' AS UNSIGNED) server_id FROM mysql_innodb_cluster_metadata.v2_instances i LEFT JOIN mysql_innodb_cluster_metadata.instances ii ON ii.instance_id = i.instance_id LEFT JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = i.cluster_id LEFT JOIN mysql_innodb_cluster_metadata.v2_ar_members am ON am.instance_id = i.instance_id 2022-08-03 16:52:17: Info: Dba.getCluster: tid=18356: SQL: SELECT c.* FROM ( SELECT cluster_type, primary_mode, cluster_id, cluster_name, description, NULL as group_name, async_topology_type, NULL as clusterset_id, 0 as invalidated FROM mysql_innodb_cluster_metadata.v2_ar_clusters UNION ALL SELECT c.cluster_type, c.primary_mode, c.cluster_id, c.cluster_name, c.description, c.group_name, NULL as async_topology_type, c.clusterset_id, coalesce(cv.invalidated, 0) as invalidated FROM mysql_innodb_cluster_metadata.v2_gr_clusters c LEFT JOIN mysql_innodb_cluster_metadata.v2_cs_members cv ON c.cluster_id = cv.cluster_id ) as c 2022-08-03 16:52:17: Debug: I) 10.162.0.219:3306 10.162.0.219:3306 2022-08-03 16:52:17: Debug: I) 10.162.0.229:3306 10.162.0.229:3306 2022-08-03 16:52:17: Debug: I) 10.162.0.248:3306 10.162.0.248:3306 2022-08-03 16:52:17: Debug: I) 10.170.1.106:3306 10.170.1.106:3306 2022-08-03 16:52:17: Debug: I) 10.170.1.122:3306 10.170.1.122:3306 2022-08-03 16:52:17: Debug: I) 10.170.1.142:3306 10.170.1.142:3306 2022-08-03 16:52:17: Debug: C) 1dac51e1-1336-11ed-ba25-067bc1f7780d jay-test2-west 2022-08-03 16:52:17: Debug: C) 4d5be7b6-119c-11ed-ac8b-0eaea3452381 jay-test2-east 2022-08-03 16:52:17: Debug: DONE! 2022-08-03 16:52:17: Debug: Instance type check: 10.170.1.106:3306: Metadata version 2.1.0 found 2022-08-03 16:52:17: Info: Dba.getCluster: tid=18356: SQL: select cluster_type from `mysql_innodb_cluster_metadata`.v2_this_instance 2022-08-03 16:52:17: Debug: Instance type check: 10.170.1.106:3306: Cluster metadata record found (metadata 2.1.0) 2022-08-03 16:52:17: Debug: Instance c5e8984e-1334-11ed-9493-067bc1f7780d is managed for GROUP-REPLICATION 2022-08-03 16:52:17: Info: Dba.getCluster: tid=18356: SQL: select count(*) FROM performance_schema.replication_group_members WHERE MEMBER_ID = @@server_uuid AND MEMBER_STATE NOT IN ('OFFLINE', 'UNREACHABLE') 2022-08-03 16:52:17: Debug: Instance type check: 10.170.1.106:3306: GR is active 2022-08-03 16:52:17: Info: Dba.getCluster: tid=18356: SQL: SELECT COUNT(*) FROM performance_schema.threads WHERE NAME = 'thread/group_rpl/THD_delayed_initialization' 2022-08-03 16:52:18: Info: Dba.getCluster: tid=18356: SQL: SELECT @@group_replication_group_name group_name, NULLIF(CONCAT(''/*!80026, @@group_replication_view_change_uuid*/), '') group_view_change_uuid, @@group_replication_single_primary_mode single_primary, @@server_uuid, member_state, (SELECT sum(IF(member_state in ('ONLINE', 'RECOVERING'), 1, 0)) > sum(1)/2 FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR member_state <> 'ERROR' ) has_quorum, COALESCE(/*!80002 member_role = 'PRIMARY', NULL AND */ NOT @@group_replication_single_primary_mode OR member_id = (select variable_value from performance_schema.global_status where variable_name = 'group_replication_primary_member') ) is_primary FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid 2022-08-03 16:52:18: Info: Dba.getCluster: tid=18356: SQL: SELECT (SELECT COUNT(*) FROM `mysql_innodb_cluster_metadata`.instances WHERE cluster_id = (SELECT cluster_id FROM `mysql_innodb_cluster_metadata`.instances WHERE mysql_server_uuid = @@server_uuid)) = (SELECT count(*) FROM performance_schema.replication_group_members WHERE member_state = 'ONLINE') as all_online 2022-08-03 16:52:18: Info: Dba.getCluster: tid=18356: SQL: SELECT clusterset_id from mysql_innodb_cluster_metadata.clusters c, mysql_innodb_cluster_metadata.instances i WHERE c.cluster_id=i.cluster_id AND i.address = '10.170.1.106:3306' 2022-08-03 16:52:18: Info: Dba.getCluster: tid=18356: SQL: SELECT c.* FROM ( SELECT cluster_type, primary_mode, cluster_id, cluster_name, description, NULL as group_name, async_topology_type, NULL as clusterset_id, 0 as invalidated FROM mysql_innodb_cluster_metadata.v2_ar_clusters UNION ALL SELECT c.cluster_type, c.primary_mode, c.cluster_id, c.cluster_name, c.description, c.group_name, NULL as async_topology_type, c.clusterset_id, coalesce(cv.invalidated, 0) as invalidated FROM mysql_innodb_cluster_metadata.v2_gr_clusters c LEFT JOIN mysql_innodb_cluster_metadata.v2_cs_members cv ON c.cluster_id = cv.cluster_id ) as c JOIN mysql_innodb_cluster_metadata.`v2_instances` i ON i.`cluster_id` = `c`.`cluster_id` WHERE i.mysql_server_uuid = 'c5e8984e-1334-11ed-9493-067bc1f7780d' 2022-08-03 16:52:18: Info: Dba.getCluster: tid=18356: SQL: SELECT @@group_replication_group_name 2022-08-03 16:52:18: Info: Group Replication 'group_name' value: 1dac51e1-1336-11ed-ba25-067bc1f7780d 2022-08-03 16:52:18: Info: Metadata 'group_name' value: 1dac51e1-1336-11ed-ba25-067bc1f7780d 2022-08-03 16:52:18: Info: Dba.getCluster: tid=18356: SQL: SELECT c.*, m.view_id, m.member_role, m.master_cluster_id, m.invalidated, c.attributes->>'$.group_replication_view_change_uuid' as view_uuid FROM mysql_innodb_cluster_metadata.v2_cs_members m JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = m.cluster_id WHERE c.cluster_id = '2110d454-1336-11ed-a301-02bf31f1104f' 2022-08-03 16:52:18: Info: Dba.getCluster: tid=18356: SQL: SELECT c.* FROM ( SELECT cluster_type, primary_mode, cluster_id, cluster_name, description, NULL as group_name, async_topology_type, NULL as clusterset_id, 0 as invalidated FROM mysql_innodb_cluster_metadata.v2_ar_clusters UNION ALL SELECT c.cluster_type, c.primary_mode, c.cluster_id, c.cluster_name, c.description, c.group_name, NULL as async_topology_type, c.clusterset_id, coalesce(cv.invalidated, 0) as invalidated FROM mysql_innodb_cluster_metadata.v2_gr_clusters c LEFT JOIN mysql_innodb_cluster_metadata.v2_cs_members cv ON c.cluster_id = cv.cluster_id ) as c WHERE c.cluster_id = '2110d454-1336-11ed-a301-02bf31f1104f' 2022-08-03 16:52:18: Info: Dba.getCluster: tid=18356: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' 2022-08-03 16:52:18: Info: Dba.getCluster: tid=18356: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' 2022-08-03 16:52:18: Info: Dba.getCluster: tid=18356: SQL: SELECT c.*, m.view_id, m.member_role, m.master_cluster_id, m.invalidated, c.attributes->>'$.group_replication_view_change_uuid' as view_uuid FROM mysql_innodb_cluster_metadata.v2_cs_members m JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = m.cluster_id WHERE m.clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' AND m.invalidated = 0 2022-08-03 16:52:18: Debug: Primary cluster is jay-test2-west 2022-08-03 16:52:18: Debug: Refreshing metadata cache from 10.170.1.106:3306 2022-08-03 16:52:18: Info: Dba.getCluster: tid=18356: SQL: SELECT i.instance_id, i.cluster_id, c.group_name, am.master_instance_id, am.master_member_id, am.member_role, am.view_id, i.label, i.mysql_server_uuid, i.address, i.endpoint, i.xendpoint, ii.addresses->>'$.grLocal' as grendpoint, CAST(ii.attributes->'$.server_id' AS UNSIGNED) server_id FROM mysql_innodb_cluster_metadata.v2_instances i LEFT JOIN mysql_innodb_cluster_metadata.instances ii ON ii.instance_id = i.instance_id LEFT JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = i.cluster_id LEFT JOIN mysql_innodb_cluster_metadata.v2_ar_members am ON am.instance_id = i.instance_id 2022-08-03 16:52:18: Info: Dba.getCluster: tid=18356: SQL: SELECT c.* FROM ( SELECT cluster_type, primary_mode, cluster_id, cluster_name, description, NULL as group_name, async_topology_type, NULL as clusterset_id, 0 as invalidated FROM mysql_innodb_cluster_metadata.v2_ar_clusters UNION ALL SELECT c.cluster_type, c.primary_mode, c.cluster_id, c.cluster_name, c.description, c.group_name, NULL as async_topology_type, c.clusterset_id, coalesce(cv.invalidated, 0) as invalidated FROM mysql_innodb_cluster_metadata.v2_gr_clusters c LEFT JOIN mysql_innodb_cluster_metadata.v2_cs_members cv ON c.cluster_id = cv.cluster_id ) as c 2022-08-03 16:52:18: Debug: I) 10.162.0.219:3306 10.162.0.219:3306 2022-08-03 16:52:18: Debug: I) 10.162.0.229:3306 10.162.0.229:3306 2022-08-03 16:52:18: Debug: I) 10.162.0.248:3306 10.162.0.248:3306 2022-08-03 16:52:18: Debug: I) 10.170.1.106:3306 10.170.1.106:3306 2022-08-03 16:52:18: Debug: I) 10.170.1.122:3306 10.170.1.122:3306 2022-08-03 16:52:18: Debug: I) 10.170.1.142:3306 10.170.1.142:3306 2022-08-03 16:52:18: Debug: C) 1dac51e1-1336-11ed-ba25-067bc1f7780d jay-test2-west 2022-08-03 16:52:18: Debug: C) 4d5be7b6-119c-11ed-ac8b-0eaea3452381 jay-test2-east 2022-08-03 16:52:18: Debug: DONE! 2022-08-03 16:52:18: Debug: Refreshing metadata cache from 10.170.1.106:3306 2022-08-03 16:52:18: Info: Dba.getCluster: tid=18356: SQL: SELECT i.instance_id, i.cluster_id, c.group_name, am.master_instance_id, am.master_member_id, am.member_role, am.view_id, i.label, i.mysql_server_uuid, i.address, i.endpoint, i.xendpoint, ii.addresses->>'$.grLocal' as grendpoint, CAST(ii.attributes->'$.server_id' AS UNSIGNED) server_id FROM mysql_innodb_cluster_metadata.v2_instances i LEFT JOIN mysql_innodb_cluster_metadata.instances ii ON ii.instance_id = i.instance_id LEFT JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = i.cluster_id LEFT JOIN mysql_innodb_cluster_metadata.v2_ar_members am ON am.instance_id = i.instance_id 2022-08-03 16:52:18: Info: Dba.getCluster: tid=18356: SQL: SELECT c.* FROM ( SELECT cluster_type, primary_mode, cluster_id, cluster_name, description, NULL as group_name, async_topology_type, NULL as clusterset_id, 0 as invalidated FROM mysql_innodb_cluster_metadata.v2_ar_clusters UNION ALL SELECT c.cluster_type, c.primary_mode, c.cluster_id, c.cluster_name, c.description, c.group_name, NULL as async_topology_type, c.clusterset_id, coalesce(cv.invalidated, 0) as invalidated FROM mysql_innodb_cluster_metadata.v2_gr_clusters c LEFT JOIN mysql_innodb_cluster_metadata.v2_cs_members cv ON c.cluster_id = cv.cluster_id ) as c 2022-08-03 16:52:18: Debug: I) 10.162.0.219:3306 10.162.0.219:3306 2022-08-03 16:52:18: Debug: I) 10.162.0.229:3306 10.162.0.229:3306 2022-08-03 16:52:18: Debug: I) 10.162.0.248:3306 10.162.0.248:3306 2022-08-03 16:52:18: Debug: I) 10.170.1.106:3306 10.170.1.106:3306 2022-08-03 16:52:18: Debug: I) 10.170.1.122:3306 10.170.1.122:3306 2022-08-03 16:52:18: Debug: I) 10.170.1.142:3306 10.170.1.142:3306 2022-08-03 16:52:18: Debug: C) 1dac51e1-1336-11ed-ba25-067bc1f7780d jay-test2-west 2022-08-03 16:52:18: Debug: C) 4d5be7b6-119c-11ed-ac8b-0eaea3452381 jay-test2-east 2022-08-03 16:52:18: Debug: DONE! 2022-08-03 16:52:18: Info: Connecting to MySQL at: mysql://ods.cluster.config@10.170.1.106:3306?connect-timeout=5000 2022-08-03 16:52:18: Debug3: PLUGIN-TRACE-START: PluginEventHandler.CONNECTING 2022-08-03 16:52:19: Debug3: PLUGIN-EVENT: caching_sha2_password.AUTHENTICATE.AUTH_PLUGIN 2022-08-03 16:52:19: Info: Dba.getCluster: tid=18360: CONNECTED: 10.170.1.106:3306 2022-08-03 16:52:19: Info: Dba.getCluster: tid=18360: SQL: SET SESSION `autocommit` = 1 2022-08-03 16:52:19: Info: Dba.getCluster: tid=18360: SQL: SET SESSION `sql_mode` = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 2022-08-03 16:52:19: Info: Dba.getCluster: tid=18360: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' 2022-08-03 16:52:19: Info: Dba.getCluster: tid=18360: SQL: SELECT COALESCE(@@report_host, @@hostname), COALESCE(@@report_port, @@port) 2022-08-03 16:52:19: Info: Dba.getCluster: tid=18360: SQL: SELECT @@server_uuid 2022-08-03 16:52:19: Info: Dba.getCluster: tid=18360: SQL: SELECT @@group_replication_group_name group_name, NULLIF(CONCAT(''/*!80026, @@group_replication_view_change_uuid*/), '') group_view_change_uuid, @@group_replication_single_primary_mode single_primary, @@server_uuid, member_state, (SELECT sum(IF(member_state in ('ONLINE', 'RECOVERING'), 1, 0)) > sum(1)/2 FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR member_state <> 'ERROR' ) has_quorum, COALESCE(/*!80002 member_role = 'PRIMARY', NULL AND */ NOT @@group_replication_single_primary_mode OR member_id = (select variable_value from performance_schema.global_status where variable_name = 'group_replication_primary_member') ) is_primary FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid 2022-08-03 16:52:19: Debug: Metadata operations will use 10.170.1.106:3306 2022-08-03 16:52:19: Info: Dba.getCluster: tid=18360: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata' 2022-08-03 16:52:19: Info: Dba.getCluster: tid=18360: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__' 2022-08-03 16:52:19: Info: Dba.getCluster: tid=18360: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp' 2022-08-03 16:52:19: Info: Dba.getCluster: tid=18360: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version` 2022-08-03 16:52:19: Debug: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null 2022-08-03 16:52:19: Info: Dba.getCluster: tid=18360: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version` 2022-08-03 16:52:20: Info: Dba.getCluster: tid=18360: SQL: SELECT c.*, m.view_id, m.member_role, m.master_cluster_id, m.invalidated, c.attributes->>'$.group_replication_view_change_uuid' as view_uuid FROM mysql_innodb_cluster_metadata.v2_cs_members m JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = m.cluster_id WHERE c.cluster_id = '2110d454-1336-11ed-a301-02bf31f1104f' 2022-08-03 16:52:20: Info: Dba.getCluster: tid=18360: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' 2022-08-03 16:52:20: Info: Dba.getCluster: tid=18360: SQL: SELECT c.*, m.view_id, m.member_role, m.master_cluster_id, m.invalidated, c.attributes->>'$.group_replication_view_change_uuid' as view_uuid FROM mysql_innodb_cluster_metadata.v2_cs_members m JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = m.cluster_id WHERE m.clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' AND m.invalidated = 0 2022-08-03 16:52:20: Debug: Primary cluster is jay-test2-west 2022-08-03 16:52:20: Debug: Refreshing metadata cache from 10.170.1.106:3306 2022-08-03 16:52:20: Info: Dba.getCluster: tid=18360: SQL: SELECT i.instance_id, i.cluster_id, c.group_name, am.master_instance_id, am.master_member_id, am.member_role, am.view_id, i.label, i.mysql_server_uuid, i.address, i.endpoint, i.xendpoint, ii.addresses->>'$.grLocal' as grendpoint, CAST(ii.attributes->'$.server_id' AS UNSIGNED) server_id FROM mysql_innodb_cluster_metadata.v2_instances i LEFT JOIN mysql_innodb_cluster_metadata.instances ii ON ii.instance_id = i.instance_id LEFT JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = i.cluster_id LEFT JOIN mysql_innodb_cluster_metadata.v2_ar_members am ON am.instance_id = i.instance_id 2022-08-03 16:52:20: Info: Dba.getCluster: tid=18360: SQL: SELECT c.* FROM ( SELECT cluster_type, primary_mode, cluster_id, cluster_name, description, NULL as group_name, async_topology_type, NULL as clusterset_id, 0 as invalidated FROM mysql_innodb_cluster_metadata.v2_ar_clusters UNION ALL SELECT c.cluster_type, c.primary_mode, c.cluster_id, c.cluster_name, c.description, c.group_name, NULL as async_topology_type, c.clusterset_id, coalesce(cv.invalidated, 0) as invalidated FROM mysql_innodb_cluster_metadata.v2_gr_clusters c LEFT JOIN mysql_innodb_cluster_metadata.v2_cs_members cv ON c.cluster_id = cv.cluster_id ) as c 2022-08-03 16:52:20: Debug: I) 10.162.0.219:3306 10.162.0.219:3306 2022-08-03 16:52:20: Debug: I) 10.162.0.229:3306 10.162.0.229:3306 2022-08-03 16:52:20: Debug: I) 10.162.0.248:3306 10.162.0.248:3306 2022-08-03 16:52:20: Debug: I) 10.170.1.106:3306 10.170.1.106:3306 2022-08-03 16:52:20: Debug: I) 10.170.1.122:3306 10.170.1.122:3306 2022-08-03 16:52:20: Debug: I) 10.170.1.142:3306 10.170.1.142:3306 2022-08-03 16:52:20: Debug: C) 1dac51e1-1336-11ed-ba25-067bc1f7780d jay-test2-west 2022-08-03 16:52:20: Debug: C) 4d5be7b6-119c-11ed-ac8b-0eaea3452381 jay-test2-east 2022-08-03 16:52:20: Debug: DONE! 2022-08-03 16:52:20: Debug: Refreshing metadata cache from 10.170.1.106:3306 2022-08-03 16:52:20: Info: Dba.getCluster: tid=18360: SQL: SELECT i.instance_id, i.cluster_id, c.group_name, am.master_instance_id, am.master_member_id, am.member_role, am.view_id, i.label, i.mysql_server_uuid, i.address, i.endpoint, i.xendpoint, ii.addresses->>'$.grLocal' as grendpoint, CAST(ii.attributes->'$.server_id' AS UNSIGNED) server_id FROM mysql_innodb_cluster_metadata.v2_instances i LEFT JOIN mysql_innodb_cluster_metadata.instances ii ON ii.instance_id = i.instance_id LEFT JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = i.cluster_id LEFT JOIN mysql_innodb_cluster_metadata.v2_ar_members am ON am.instance_id = i.instance_id 2022-08-03 16:52:20: Info: Dba.getCluster: tid=18360: SQL: SELECT c.* FROM ( SELECT cluster_type, primary_mode, cluster_id, cluster_name, description, NULL as group_name, async_topology_type, NULL as clusterset_id, 0 as invalidated FROM mysql_innodb_cluster_metadata.v2_ar_clusters UNION ALL SELECT c.cluster_type, c.primary_mode, c.cluster_id, c.cluster_name, c.description, c.group_name, NULL as async_topology_type, c.clusterset_id, coalesce(cv.invalidated, 0) as invalidated FROM mysql_innodb_cluster_metadata.v2_gr_clusters c LEFT JOIN mysql_innodb_cluster_metadata.v2_cs_members cv ON c.cluster_id = cv.cluster_id ) as c 2022-08-03 16:52:20: Debug: I) 10.162.0.219:3306 10.162.0.219:3306 2022-08-03 16:52:20: Debug: I) 10.162.0.229:3306 10.162.0.229:3306 2022-08-03 16:52:20: Debug: I) 10.162.0.248:3306 10.162.0.248:3306 2022-08-03 16:52:20: Debug: I) 10.170.1.106:3306 10.170.1.106:3306 2022-08-03 16:52:20: Debug: I) 10.170.1.122:3306 10.170.1.122:3306 2022-08-03 16:52:20: Debug: I) 10.170.1.142:3306 10.170.1.142:3306 2022-08-03 16:52:20: Debug: C) 1dac51e1-1336-11ed-ba25-067bc1f7780d jay-test2-west 2022-08-03 16:52:20: Debug: C) 4d5be7b6-119c-11ed-ac8b-0eaea3452381 jay-test2-east 2022-08-03 16:52:20: Debug: DONE! 2022-08-03 16:52:20: Info: Connecting to MySQL at: mysql://ods.cluster.config@10.170.1.106:3306?connect-timeout=5000 2022-08-03 16:52:20: Debug3: PLUGIN-TRACE-START: PluginEventHandler.CONNECTING 2022-08-03 16:52:20: Debug3: PLUGIN-EVENT: caching_sha2_password.AUTHENTICATE.AUTH_PLUGIN 2022-08-03 16:52:20: Info: Dba.getCluster: tid=18362: CONNECTED: 10.170.1.106:3306 2022-08-03 16:52:20: Info: Dba.getCluster: tid=18362: SQL: SET SESSION `autocommit` = 1 2022-08-03 16:52:20: Info: Dba.getCluster: tid=18362: SQL: SET SESSION `sql_mode` = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 2022-08-03 16:52:20: Info: Dba.getCluster: tid=18362: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' 2022-08-03 16:52:20: Info: Dba.getCluster: tid=18362: SQL: SELECT COALESCE(@@report_host, @@hostname), COALESCE(@@report_port, @@port) 2022-08-03 16:52:21: Info: Dba.getCluster: tid=18362: SQL: SELECT @@server_uuid 2022-08-03 16:52:21: Info: Dba.getCluster: tid=18362: SQL: SELECT @@group_replication_group_name group_name, NULLIF(CONCAT(''/*!80026, @@group_replication_view_change_uuid*/), '') group_view_change_uuid, @@group_replication_single_primary_mode single_primary, @@server_uuid, member_state, (SELECT sum(IF(member_state in ('ONLINE', 'RECOVERING'), 1, 0)) > sum(1)/2 FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR member_state <> 'ERROR' ) has_quorum, COALESCE(/*!80002 member_role = 'PRIMARY', NULL AND */ NOT @@group_replication_single_primary_mode OR member_id = (select variable_value from performance_schema.global_status where variable_name = 'group_replication_primary_member') ) is_primary FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid 2022-08-03 16:52:21: Debug: Metadata operations will use 10.170.1.106:3306 2022-08-03 16:52:21: Debug: Refreshing metadata cache from 10.170.1.106:3306 2022-08-03 16:52:21: Info: Dba.getCluster: tid=18362: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata' 2022-08-03 16:52:21: Info: Dba.getCluster: tid=18362: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__' 2022-08-03 16:52:21: Info: Dba.getCluster: tid=18362: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp' 2022-08-03 16:52:21: Info: Dba.getCluster: tid=18362: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version` 2022-08-03 16:52:21: Debug: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null 2022-08-03 16:52:21: Info: Dba.getCluster: tid=18362: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version` 2022-08-03 16:52:21: Info: Dba.getCluster: tid=18362: SQL: SELECT i.instance_id, i.cluster_id, c.group_name, am.master_instance_id, am.master_member_id, am.member_role, am.view_id, i.label, i.mysql_server_uuid, i.address, i.endpoint, i.xendpoint, ii.addresses->>'$.grLocal' as grendpoint, CAST(ii.attributes->'$.server_id' AS UNSIGNED) server_id FROM mysql_innodb_cluster_metadata.v2_instances i LEFT JOIN mysql_innodb_cluster_metadata.instances ii ON ii.instance_id = i.instance_id LEFT JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = i.cluster_id LEFT JOIN mysql_innodb_cluster_metadata.v2_ar_members am ON am.instance_id = i.instance_id 2022-08-03 16:52:21: Info: Dba.getCluster: tid=18362: SQL: SELECT c.* FROM ( SELECT cluster_type, primary_mode, cluster_id, cluster_name, description, NULL as group_name, async_topology_type, NULL as clusterset_id, 0 as invalidated FROM mysql_innodb_cluster_metadata.v2_ar_clusters UNION ALL SELECT c.cluster_type, c.primary_mode, c.cluster_id, c.cluster_name, c.description, c.group_name, NULL as async_topology_type, c.clusterset_id, coalesce(cv.invalidated, 0) as invalidated FROM mysql_innodb_cluster_metadata.v2_gr_clusters c LEFT JOIN mysql_innodb_cluster_metadata.v2_cs_members cv ON c.cluster_id = cv.cluster_id ) as c 2022-08-03 16:52:21: Debug: I) 10.162.0.219:3306 10.162.0.219:3306 2022-08-03 16:52:21: Debug: I) 10.162.0.229:3306 10.162.0.229:3306 2022-08-03 16:52:21: Debug: I) 10.162.0.248:3306 10.162.0.248:3306 2022-08-03 16:52:21: Debug: I) 10.170.1.106:3306 10.170.1.106:3306 2022-08-03 16:52:21: Debug: I) 10.170.1.122:3306 10.170.1.122:3306 2022-08-03 16:52:21: Debug: I) 10.170.1.142:3306 10.170.1.142:3306 2022-08-03 16:52:21: Debug: C) 1dac51e1-1336-11ed-ba25-067bc1f7780d jay-test2-west 2022-08-03 16:52:21: Debug: C) 4d5be7b6-119c-11ed-ac8b-0eaea3452381 jay-test2-east 2022-08-03 16:52:21: Debug: DONE! 2022-08-03 16:52:21: Info: Dba.getCluster: tid=18362: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' 2022-08-03 16:52:21: Info: Dba.getCluster: tid=18362: SQL: SELECT c.*, m.view_id, m.member_role, m.master_cluster_id, m.invalidated, c.attributes->>'$.group_replication_view_change_uuid' as view_uuid FROM mysql_innodb_cluster_metadata.v2_cs_members m JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = m.cluster_id WHERE m.clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' AND m.invalidated = 0 2022-08-03 16:52:21: Debug: Checking if primary cluster jay-test2-west (id=0fdb4c89-119c-11ed-ba1c-067bc1f7780d, view_id_generation=2) has the most recent clusterset metadata 2022-08-03 16:52:21: Debug3: PLUGIN-TRACE-STOP: PluginEventHandler 2022-08-03 16:52:21: Debug3: PLUGIN-TRACE-STOP: PluginEventHandler 2022-08-03 16:52:21: Debug: Checking 'getClusterSet' preconditions. 2022-08-03 16:52:21: Info: Cluster.getClusterSet: tid=18356: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata' 2022-08-03 16:52:21: Info: Cluster.getClusterSet: tid=18356: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__' 2022-08-03 16:52:21: Info: Cluster.getClusterSet: tid=18356: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp' 2022-08-03 16:52:21: Info: Cluster.getClusterSet: tid=18356: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version` 2022-08-03 16:52:21: Debug: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null 2022-08-03 16:52:21: Info: Cluster.getClusterSet: tid=18356: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version` 2022-08-03 16:52:22: Debug: Instance type check: 10.170.1.106:3306: Metadata version 2.1.0 found 2022-08-03 16:52:22: Info: Cluster.getClusterSet: tid=18356: SQL: select cluster_type from `mysql_innodb_cluster_metadata`.v2_this_instance 2022-08-03 16:52:22: Debug: Instance type check: 10.170.1.106:3306: Cluster metadata record found (metadata 2.1.0) 2022-08-03 16:52:22: Debug: Instance c5e8984e-1334-11ed-9493-067bc1f7780d is managed for GROUP-REPLICATION 2022-08-03 16:52:22: Info: Cluster.getClusterSet: tid=18356: SQL: select count(*) FROM performance_schema.replication_group_members WHERE MEMBER_ID = @@server_uuid AND MEMBER_STATE NOT IN ('OFFLINE', 'UNREACHABLE') 2022-08-03 16:52:22: Debug: Instance type check: 10.170.1.106:3306: GR is active 2022-08-03 16:52:22: Info: Cluster.getClusterSet: tid=18356: SQL: SELECT COUNT(*) FROM performance_schema.threads WHERE NAME = 'thread/group_rpl/THD_delayed_initialization' 2022-08-03 16:52:22: Info: Cluster.getClusterSet: tid=18356: SQL: SELECT @@group_replication_group_name group_name, NULLIF(CONCAT(''/*!80026, @@group_replication_view_change_uuid*/), '') group_view_change_uuid, @@group_replication_single_primary_mode single_primary, @@server_uuid, member_state, (SELECT sum(IF(member_state in ('ONLINE', 'RECOVERING'), 1, 0)) > sum(1)/2 FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR member_state <> 'ERROR' ) has_quorum, COALESCE(/*!80002 member_role = 'PRIMARY', NULL AND */ NOT @@group_replication_single_primary_mode OR member_id = (select variable_value from performance_schema.global_status where variable_name = 'group_replication_primary_member') ) is_primary FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid 2022-08-03 16:52:22: Info: Cluster.getClusterSet: tid=18356: SQL: SELECT (SELECT COUNT(*) FROM `mysql_innodb_cluster_metadata`.instances WHERE cluster_id = (SELECT cluster_id FROM `mysql_innodb_cluster_metadata`.instances WHERE mysql_server_uuid = @@server_uuid)) = (SELECT count(*) FROM performance_schema.replication_group_members WHERE member_state = 'ONLINE') as all_online 2022-08-03 16:52:22: Info: Cluster.getClusterSet: tid=18356: SQL: SELECT clusterset_id from mysql_innodb_cluster_metadata.clusters c, mysql_innodb_cluster_metadata.instances i WHERE c.cluster_id=i.cluster_id AND i.address = '10.170.1.106:3306' 2022-08-03 16:52:22: Info: Cluster.getClusterSet: tid=18356: SQL: SELECT c.* FROM ( SELECT cluster_type, primary_mode, cluster_id, cluster_name, description, NULL as group_name, async_topology_type, NULL as clusterset_id, 0 as invalidated FROM mysql_innodb_cluster_metadata.v2_ar_clusters UNION ALL SELECT c.cluster_type, c.primary_mode, c.cluster_id, c.cluster_name, c.description, c.group_name, NULL as async_topology_type, c.clusterset_id, coalesce(cv.invalidated, 0) as invalidated FROM mysql_innodb_cluster_metadata.v2_gr_clusters c LEFT JOIN mysql_innodb_cluster_metadata.v2_cs_members cv ON c.cluster_id = cv.cluster_id ) as c WHERE c.cluster_id = '2110d454-1336-11ed-a301-02bf31f1104f' 2022-08-03 16:52:22: Info: Cluster.getClusterSet: tid=18356: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' 2022-08-03 16:52:22: Info: Cluster.getClusterSet: tid=18356: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' 2022-08-03 16:52:22: Info: Cluster.getClusterSet: tid=18356: SQL: SELECT c.*, m.view_id, m.member_role, m.master_cluster_id, m.invalidated, c.attributes->>'$.group_replication_view_change_uuid' as view_uuid FROM mysql_innodb_cluster_metadata.v2_cs_members m JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = m.cluster_id WHERE m.clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' AND m.invalidated = 0 2022-08-03 16:52:22: Debug: Primary cluster is jay-test2-west 2022-08-03 16:52:22: Debug: Refreshing metadata cache from 10.170.1.106:3306 2022-08-03 16:52:22: Info: Cluster.getClusterSet: tid=18356: SQL: SELECT i.instance_id, i.cluster_id, c.group_name, am.master_instance_id, am.master_member_id, am.member_role, am.view_id, i.label, i.mysql_server_uuid, i.address, i.endpoint, i.xendpoint, ii.addresses->>'$.grLocal' as grendpoint, CAST(ii.attributes->'$.server_id' AS UNSIGNED) server_id FROM mysql_innodb_cluster_metadata.v2_instances i LEFT JOIN mysql_innodb_cluster_metadata.instances ii ON ii.instance_id = i.instance_id LEFT JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = i.cluster_id LEFT JOIN mysql_innodb_cluster_metadata.v2_ar_members am ON am.instance_id = i.instance_id 2022-08-03 16:52:22: Info: Cluster.getClusterSet: tid=18356: SQL: SELECT c.* FROM ( SELECT cluster_type, primary_mode, cluster_id, cluster_name, description, NULL as group_name, async_topology_type, NULL as clusterset_id, 0 as invalidated FROM mysql_innodb_cluster_metadata.v2_ar_clusters UNION ALL SELECT c.cluster_type, c.primary_mode, c.cluster_id, c.cluster_name, c.description, c.group_name, NULL as async_topology_type, c.clusterset_id, coalesce(cv.invalidated, 0) as invalidated FROM mysql_innodb_cluster_metadata.v2_gr_clusters c LEFT JOIN mysql_innodb_cluster_metadata.v2_cs_members cv ON c.cluster_id = cv.cluster_id ) as c 2022-08-03 16:52:22: Debug: I) 10.162.0.219:3306 10.162.0.219:3306 2022-08-03 16:52:22: Debug: I) 10.162.0.229:3306 10.162.0.229:3306 2022-08-03 16:52:22: Debug: I) 10.162.0.248:3306 10.162.0.248:3306 2022-08-03 16:52:22: Debug: I) 10.170.1.106:3306 10.170.1.106:3306 2022-08-03 16:52:22: Debug: I) 10.170.1.122:3306 10.170.1.122:3306 2022-08-03 16:52:22: Debug: I) 10.170.1.142:3306 10.170.1.142:3306 2022-08-03 16:52:22: Debug: C) 1dac51e1-1336-11ed-ba25-067bc1f7780d jay-test2-west 2022-08-03 16:52:22: Debug: C) 4d5be7b6-119c-11ed-ac8b-0eaea3452381 jay-test2-east 2022-08-03 16:52:22: Debug: DONE! 2022-08-03 16:52:22: Debug: Refreshing metadata cache from 10.170.1.106:3306 2022-08-03 16:52:22: Info: Cluster.getClusterSet: tid=18356: SQL: SELECT i.instance_id, i.cluster_id, c.group_name, am.master_instance_id, am.master_member_id, am.member_role, am.view_id, i.label, i.mysql_server_uuid, i.address, i.endpoint, i.xendpoint, ii.addresses->>'$.grLocal' as grendpoint, CAST(ii.attributes->'$.server_id' AS UNSIGNED) server_id FROM mysql_innodb_cluster_metadata.v2_instances i LEFT JOIN mysql_innodb_cluster_metadata.instances ii ON ii.instance_id = i.instance_id LEFT JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = i.cluster_id LEFT JOIN mysql_innodb_cluster_metadata.v2_ar_members am ON am.instance_id = i.instance_id 2022-08-03 16:52:22: Info: Cluster.getClusterSet: tid=18356: SQL: SELECT c.* FROM ( SELECT cluster_type, primary_mode, cluster_id, cluster_name, description, NULL as group_name, async_topology_type, NULL as clusterset_id, 0 as invalidated FROM mysql_innodb_cluster_metadata.v2_ar_clusters UNION ALL SELECT c.cluster_type, c.primary_mode, c.cluster_id, c.cluster_name, c.description, c.group_name, NULL as async_topology_type, c.clusterset_id, coalesce(cv.invalidated, 0) as invalidated FROM mysql_innodb_cluster_metadata.v2_gr_clusters c LEFT JOIN mysql_innodb_cluster_metadata.v2_cs_members cv ON c.cluster_id = cv.cluster_id ) as c 2022-08-03 16:52:22: Debug: I) 10.162.0.219:3306 10.162.0.219:3306 2022-08-03 16:52:22: Debug: I) 10.162.0.229:3306 10.162.0.229:3306 2022-08-03 16:52:22: Debug: I) 10.162.0.248:3306 10.162.0.248:3306 2022-08-03 16:52:22: Debug: I) 10.170.1.106:3306 10.170.1.106:3306 2022-08-03 16:52:22: Debug: I) 10.170.1.122:3306 10.170.1.122:3306 2022-08-03 16:52:22: Debug: I) 10.170.1.142:3306 10.170.1.142:3306 2022-08-03 16:52:22: Debug: C) 1dac51e1-1336-11ed-ba25-067bc1f7780d jay-test2-west 2022-08-03 16:52:22: Debug: C) 4d5be7b6-119c-11ed-ac8b-0eaea3452381 jay-test2-east 2022-08-03 16:52:22: Debug: DONE! 2022-08-03 16:52:22: Info: Connecting to MySQL at: mysql://ods.cluster.config@10.170.1.106:3306?connect-timeout=5000 2022-08-03 16:52:22: Debug3: PLUGIN-TRACE-START: PluginEventHandler.CONNECTING 2022-08-03 16:52:23: Debug3: PLUGIN-EVENT: caching_sha2_password.AUTHENTICATE.AUTH_PLUGIN 2022-08-03 16:52:23: Info: Cluster.getClusterSet: tid=18365: CONNECTED: 10.170.1.106:3306 2022-08-03 16:52:23: Info: Cluster.getClusterSet: tid=18365: SQL: SET SESSION `autocommit` = 1 2022-08-03 16:52:23: Info: Cluster.getClusterSet: tid=18365: SQL: SET SESSION `sql_mode` = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 2022-08-03 16:52:23: Info: Cluster.getClusterSet: tid=18365: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' 2022-08-03 16:52:23: Info: Cluster.getClusterSet: tid=18365: SQL: SELECT COALESCE(@@report_host, @@hostname), COALESCE(@@report_port, @@port) 2022-08-03 16:52:23: Info: Cluster.getClusterSet: tid=18365: SQL: SELECT @@server_uuid 2022-08-03 16:52:23: Info: Cluster.getClusterSet: tid=18365: SQL: SELECT @@group_replication_group_name group_name, NULLIF(CONCAT(''/*!80026, @@group_replication_view_change_uuid*/), '') group_view_change_uuid, @@group_replication_single_primary_mode single_primary, @@server_uuid, member_state, (SELECT sum(IF(member_state in ('ONLINE', 'RECOVERING'), 1, 0)) > sum(1)/2 FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR member_state <> 'ERROR' ) has_quorum, COALESCE(/*!80002 member_role = 'PRIMARY', NULL AND */ NOT @@group_replication_single_primary_mode OR member_id = (select variable_value from performance_schema.global_status where variable_name = 'group_replication_primary_member') ) is_primary FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid 2022-08-03 16:52:23: Debug: Metadata operations will use 10.170.1.106:3306 2022-08-03 16:52:23: Info: Cluster.getClusterSet: tid=18365: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata' 2022-08-03 16:52:23: Info: Cluster.getClusterSet: tid=18365: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__' 2022-08-03 16:52:23: Info: Cluster.getClusterSet: tid=18365: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp' 2022-08-03 16:52:23: Info: Cluster.getClusterSet: tid=18365: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version` 2022-08-03 16:52:23: Debug: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null 2022-08-03 16:52:23: Info: Cluster.getClusterSet: tid=18365: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version` 2022-08-03 16:52:24: Info: Cluster.getClusterSet: tid=18365: SQL: SELECT c.*, m.view_id, m.member_role, m.master_cluster_id, m.invalidated, c.attributes->>'$.group_replication_view_change_uuid' as view_uuid FROM mysql_innodb_cluster_metadata.v2_cs_members m JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = m.cluster_id WHERE c.cluster_id = '2110d454-1336-11ed-a301-02bf31f1104f' 2022-08-03 16:52:24: Info: Cluster.getClusterSet: tid=18365: SQL: SELECT c.*, m.view_id, m.member_role, m.master_cluster_id, m.invalidated, c.attributes->>'$.group_replication_view_change_uuid' as view_uuid FROM mysql_innodb_cluster_metadata.v2_cs_members m JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = m.cluster_id WHERE c.cluster_id = '2110d454-1336-11ed-a301-02bf31f1104f' 2022-08-03 16:52:24: Debug3: PLUGIN-TRACE-STOP: PluginEventHandler 2022-08-03 16:52:24: Debug3: PLUGIN-TRACE-STOP: PluginEventHandler 2022-08-03 16:52:24: Debug3: PLUGIN-TRACE-STOP: PluginEventHandler 2022-08-03 16:52:27: Info: ClusterSet.status: tid=18365: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' 2022-08-03 16:52:27: Info: ClusterSet.status: tid=18365: SQL: SELECT c.*, m.view_id, m.member_role, m.master_cluster_id, m.invalidated, c.attributes->>'$.group_replication_view_change_uuid' as view_uuid FROM mysql_innodb_cluster_metadata.v2_cs_members m JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = m.cluster_id WHERE m.clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' AND m.invalidated = 0 2022-08-03 16:52:27: Debug: Primary cluster is jay-test2-west 2022-08-03 16:52:27: Debug: Refreshing metadata cache from 10.170.1.106:3306 2022-08-03 16:52:27: Info: ClusterSet.status: tid=18365: SQL: SELECT i.instance_id, i.cluster_id, c.group_name, am.master_instance_id, am.master_member_id, am.member_role, am.view_id, i.label, i.mysql_server_uuid, i.address, i.endpoint, i.xendpoint, ii.addresses->>'$.grLocal' as grendpoint, CAST(ii.attributes->'$.server_id' AS UNSIGNED) server_id FROM mysql_innodb_cluster_metadata.v2_instances i LEFT JOIN mysql_innodb_cluster_metadata.instances ii ON ii.instance_id = i.instance_id LEFT JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = i.cluster_id LEFT JOIN mysql_innodb_cluster_metadata.v2_ar_members am ON am.instance_id = i.instance_id 2022-08-03 16:52:27: Info: ClusterSet.status: tid=18365: SQL: SELECT c.* FROM ( SELECT cluster_type, primary_mode, cluster_id, cluster_name, description, NULL as group_name, async_topology_type, NULL as clusterset_id, 0 as invalidated FROM mysql_innodb_cluster_metadata.v2_ar_clusters UNION ALL SELECT c.cluster_type, c.primary_mode, c.cluster_id, c.cluster_name, c.description, c.group_name, NULL as async_topology_type, c.clusterset_id, coalesce(cv.invalidated, 0) as invalidated FROM mysql_innodb_cluster_metadata.v2_gr_clusters c LEFT JOIN mysql_innodb_cluster_metadata.v2_cs_members cv ON c.cluster_id = cv.cluster_id ) as c 2022-08-03 16:52:28: Debug: I) 10.162.0.219:3306 10.162.0.219:3306 2022-08-03 16:52:28: Debug: I) 10.162.0.229:3306 10.162.0.229:3306 2022-08-03 16:52:28: Debug: I) 10.162.0.248:3306 10.162.0.248:3306 2022-08-03 16:52:28: Debug: I) 10.170.1.106:3306 10.170.1.106:3306 2022-08-03 16:52:28: Debug: I) 10.170.1.122:3306 10.170.1.122:3306 2022-08-03 16:52:28: Debug: I) 10.170.1.142:3306 10.170.1.142:3306 2022-08-03 16:52:28: Debug: C) 1dac51e1-1336-11ed-ba25-067bc1f7780d jay-test2-west 2022-08-03 16:52:28: Debug: C) 4d5be7b6-119c-11ed-ac8b-0eaea3452381 jay-test2-east 2022-08-03 16:52:28: Debug: DONE! 2022-08-03 16:52:28: Debug: Refreshing metadata cache from 10.170.1.106:3306 2022-08-03 16:52:28: Info: ClusterSet.status: tid=18365: SQL: SELECT i.instance_id, i.cluster_id, c.group_name, am.master_instance_id, am.master_member_id, am.member_role, am.view_id, i.label, i.mysql_server_uuid, i.address, i.endpoint, i.xendpoint, ii.addresses->>'$.grLocal' as grendpoint, CAST(ii.attributes->'$.server_id' AS UNSIGNED) server_id FROM mysql_innodb_cluster_metadata.v2_instances i LEFT JOIN mysql_innodb_cluster_metadata.instances ii ON ii.instance_id = i.instance_id LEFT JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = i.cluster_id LEFT JOIN mysql_innodb_cluster_metadata.v2_ar_members am ON am.instance_id = i.instance_id 2022-08-03 16:52:28: Info: ClusterSet.status: tid=18365: SQL: SELECT c.* FROM ( SELECT cluster_type, primary_mode, cluster_id, cluster_name, description, NULL as group_name, async_topology_type, NULL as clusterset_id, 0 as invalidated FROM mysql_innodb_cluster_metadata.v2_ar_clusters UNION ALL SELECT c.cluster_type, c.primary_mode, c.cluster_id, c.cluster_name, c.description, c.group_name, NULL as async_topology_type, c.clusterset_id, coalesce(cv.invalidated, 0) as invalidated FROM mysql_innodb_cluster_metadata.v2_gr_clusters c LEFT JOIN mysql_innodb_cluster_metadata.v2_cs_members cv ON c.cluster_id = cv.cluster_id ) as c 2022-08-03 16:52:28: Debug: I) 10.162.0.219:3306 10.162.0.219:3306 2022-08-03 16:52:28: Debug: I) 10.162.0.229:3306 10.162.0.229:3306 2022-08-03 16:52:28: Debug: I) 10.162.0.248:3306 10.162.0.248:3306 2022-08-03 16:52:28: Debug: I) 10.170.1.106:3306 10.170.1.106:3306 2022-08-03 16:52:28: Debug: I) 10.170.1.122:3306 10.170.1.122:3306 2022-08-03 16:52:28: Debug: I) 10.170.1.142:3306 10.170.1.142:3306 2022-08-03 16:52:28: Debug: C) 1dac51e1-1336-11ed-ba25-067bc1f7780d jay-test2-west 2022-08-03 16:52:28: Debug: C) 4d5be7b6-119c-11ed-ac8b-0eaea3452381 jay-test2-east 2022-08-03 16:52:28: Debug: DONE! 2022-08-03 16:52:28: Info: Connecting to MySQL at: mysql://ods.cluster.config@10.170.1.106:3306?connect-timeout=5000 2022-08-03 16:52:28: Debug3: PLUGIN-TRACE-START: PluginEventHandler.CONNECTING 2022-08-03 16:52:28: Debug3: PLUGIN-EVENT: caching_sha2_password.AUTHENTICATE.AUTH_PLUGIN 2022-08-03 16:52:28: Info: ClusterSet.status: tid=18374: CONNECTED: 10.170.1.106:3306 2022-08-03 16:52:28: Info: ClusterSet.status: tid=18374: SQL: SET SESSION `autocommit` = 1 2022-08-03 16:52:28: Info: ClusterSet.status: tid=18374: SQL: SET SESSION `sql_mode` = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 2022-08-03 16:52:28: Info: ClusterSet.status: tid=18374: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' 2022-08-03 16:52:28: Info: ClusterSet.status: tid=18374: SQL: SELECT COALESCE(@@report_host, @@hostname), COALESCE(@@report_port, @@port) 2022-08-03 16:52:28: Info: ClusterSet.status: tid=18374: SQL: SELECT @@server_uuid 2022-08-03 16:52:28: Info: ClusterSet.status: tid=18374: SQL: SELECT @@group_replication_group_name group_name, NULLIF(CONCAT(''/*!80026, @@group_replication_view_change_uuid*/), '') group_view_change_uuid, @@group_replication_single_primary_mode single_primary, @@server_uuid, member_state, (SELECT sum(IF(member_state in ('ONLINE', 'RECOVERING'), 1, 0)) > sum(1)/2 FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR member_state <> 'ERROR' ) has_quorum, COALESCE(/*!80002 member_role = 'PRIMARY', NULL AND */ NOT @@group_replication_single_primary_mode OR member_id = (select variable_value from performance_schema.global_status where variable_name = 'group_replication_primary_member') ) is_primary FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid 2022-08-03 16:52:28: Debug: Metadata operations will use 10.170.1.106:3306 2022-08-03 16:52:28: Debug: Refreshing metadata cache from 10.170.1.106:3306 2022-08-03 16:52:28: Info: ClusterSet.status: tid=18374: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata' 2022-08-03 16:52:28: Info: ClusterSet.status: tid=18374: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__' 2022-08-03 16:52:28: Info: ClusterSet.status: tid=18374: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp' 2022-08-03 16:52:29: Info: ClusterSet.status: tid=18374: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version` 2022-08-03 16:52:29: Debug: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null 2022-08-03 16:52:29: Info: ClusterSet.status: tid=18374: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version` 2022-08-03 16:52:29: Info: ClusterSet.status: tid=18374: SQL: SELECT i.instance_id, i.cluster_id, c.group_name, am.master_instance_id, am.master_member_id, am.member_role, am.view_id, i.label, i.mysql_server_uuid, i.address, i.endpoint, i.xendpoint, ii.addresses->>'$.grLocal' as grendpoint, CAST(ii.attributes->'$.server_id' AS UNSIGNED) server_id FROM mysql_innodb_cluster_metadata.v2_instances i LEFT JOIN mysql_innodb_cluster_metadata.instances ii ON ii.instance_id = i.instance_id LEFT JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = i.cluster_id LEFT JOIN mysql_innodb_cluster_metadata.v2_ar_members am ON am.instance_id = i.instance_id 2022-08-03 16:52:29: Info: ClusterSet.status: tid=18374: SQL: SELECT c.* FROM ( SELECT cluster_type, primary_mode, cluster_id, cluster_name, description, NULL as group_name, async_topology_type, NULL as clusterset_id, 0 as invalidated FROM mysql_innodb_cluster_metadata.v2_ar_clusters UNION ALL SELECT c.cluster_type, c.primary_mode, c.cluster_id, c.cluster_name, c.description, c.group_name, NULL as async_topology_type, c.clusterset_id, coalesce(cv.invalidated, 0) as invalidated FROM mysql_innodb_cluster_metadata.v2_gr_clusters c LEFT JOIN mysql_innodb_cluster_metadata.v2_cs_members cv ON c.cluster_id = cv.cluster_id ) as c 2022-08-03 16:52:29: Debug: I) 10.162.0.219:3306 10.162.0.219:3306 2022-08-03 16:52:29: Debug: I) 10.162.0.229:3306 10.162.0.229:3306 2022-08-03 16:52:29: Debug: I) 10.162.0.248:3306 10.162.0.248:3306 2022-08-03 16:52:29: Debug: I) 10.170.1.106:3306 10.170.1.106:3306 2022-08-03 16:52:29: Debug: I) 10.170.1.122:3306 10.170.1.122:3306 2022-08-03 16:52:29: Debug: I) 10.170.1.142:3306 10.170.1.142:3306 2022-08-03 16:52:29: Debug: C) 1dac51e1-1336-11ed-ba25-067bc1f7780d jay-test2-west 2022-08-03 16:52:29: Debug: C) 4d5be7b6-119c-11ed-ac8b-0eaea3452381 jay-test2-east 2022-08-03 16:52:29: Debug: DONE! 2022-08-03 16:52:29: Debug: Checking 'status' preconditions. 2022-08-03 16:52:29: Info: ClusterSet.status: tid=18374: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata' 2022-08-03 16:52:29: Info: ClusterSet.status: tid=18374: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__' 2022-08-03 16:52:29: Info: ClusterSet.status: tid=18374: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp' 2022-08-03 16:52:29: Info: ClusterSet.status: tid=18374: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version` 2022-08-03 16:52:29: Debug: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null 2022-08-03 16:52:29: Info: ClusterSet.status: tid=18374: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version` 2022-08-03 16:52:29: Debug: Instance type check: 10.170.1.106:3306: Metadata version 2.1.0 found 2022-08-03 16:52:29: Info: ClusterSet.status: tid=18374: SQL: select cluster_type from `mysql_innodb_cluster_metadata`.v2_this_instance 2022-08-03 16:52:29: Debug: Instance type check: 10.170.1.106:3306: Cluster metadata record found (metadata 2.1.0) 2022-08-03 16:52:29: Debug: Instance c5e8984e-1334-11ed-9493-067bc1f7780d is managed for GROUP-REPLICATION 2022-08-03 16:52:29: Info: ClusterSet.status: tid=18356: SQL: select count(*) FROM performance_schema.replication_group_members WHERE MEMBER_ID = @@server_uuid AND MEMBER_STATE NOT IN ('OFFLINE', 'UNREACHABLE') 2022-08-03 16:52:29: Debug: Instance type check: 10.170.1.106:3306: GR is active 2022-08-03 16:52:29: Info: ClusterSet.status: tid=18356: SQL: SELECT COUNT(*) FROM performance_schema.threads WHERE NAME = 'thread/group_rpl/THD_delayed_initialization' 2022-08-03 16:52:29: Info: ClusterSet.status: tid=18356: SQL: SELECT @@group_replication_group_name group_name, NULLIF(CONCAT(''/*!80026, @@group_replication_view_change_uuid*/), '') group_view_change_uuid, @@group_replication_single_primary_mode single_primary, @@server_uuid, member_state, (SELECT sum(IF(member_state in ('ONLINE', 'RECOVERING'), 1, 0)) > sum(1)/2 FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR member_state <> 'ERROR' ) has_quorum, COALESCE(/*!80002 member_role = 'PRIMARY', NULL AND */ NOT @@group_replication_single_primary_mode OR member_id = (select variable_value from performance_schema.global_status where variable_name = 'group_replication_primary_member') ) is_primary FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid 2022-08-03 16:52:29: Info: ClusterSet.status: tid=18374: SQL: SELECT (SELECT COUNT(*) FROM `mysql_innodb_cluster_metadata`.instances WHERE cluster_id = (SELECT cluster_id FROM `mysql_innodb_cluster_metadata`.instances WHERE mysql_server_uuid = @@server_uuid)) = (SELECT count(*) FROM performance_schema.replication_group_members WHERE member_state = 'ONLINE') as all_online 2022-08-03 16:52:29: Info: ClusterSet.status: tid=18374: SQL: SELECT clusterset_id from mysql_innodb_cluster_metadata.clusters c, mysql_innodb_cluster_metadata.instances i WHERE c.cluster_id=i.cluster_id AND i.address = '10.170.1.106:3306' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=18374: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=18374: SQL: SELECT c.*, m.view_id, m.member_role, m.master_cluster_id, m.invalidated, c.attributes->>'$.group_replication_view_change_uuid' as view_uuid FROM mysql_innodb_cluster_metadata.v2_cs_members m JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = m.cluster_id WHERE m.clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' 2022-08-03 16:52:30: Debug: Refreshing metadata cache from 10.170.1.106:3306 2022-08-03 16:52:30: Info: ClusterSet.status: tid=18374: SQL: SELECT i.instance_id, i.cluster_id, c.group_name, am.master_instance_id, am.master_member_id, am.member_role, am.view_id, i.label, i.mysql_server_uuid, i.address, i.endpoint, i.xendpoint, ii.addresses->>'$.grLocal' as grendpoint, CAST(ii.attributes->'$.server_id' AS UNSIGNED) server_id FROM mysql_innodb_cluster_metadata.v2_instances i LEFT JOIN mysql_innodb_cluster_metadata.instances ii ON ii.instance_id = i.instance_id LEFT JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = i.cluster_id LEFT JOIN mysql_innodb_cluster_metadata.v2_ar_members am ON am.instance_id = i.instance_id 2022-08-03 16:52:30: Info: ClusterSet.status: tid=18374: SQL: SELECT c.* FROM ( SELECT cluster_type, primary_mode, cluster_id, cluster_name, description, NULL as group_name, async_topology_type, NULL as clusterset_id, 0 as invalidated FROM mysql_innodb_cluster_metadata.v2_ar_clusters UNION ALL SELECT c.cluster_type, c.primary_mode, c.cluster_id, c.cluster_name, c.description, c.group_name, NULL as async_topology_type, c.clusterset_id, coalesce(cv.invalidated, 0) as invalidated FROM mysql_innodb_cluster_metadata.v2_gr_clusters c LEFT JOIN mysql_innodb_cluster_metadata.v2_cs_members cv ON c.cluster_id = cv.cluster_id ) as c 2022-08-03 16:52:30: Debug: I) 10.162.0.219:3306 10.162.0.219:3306 2022-08-03 16:52:30: Debug: I) 10.162.0.229:3306 10.162.0.229:3306 2022-08-03 16:52:30: Debug: I) 10.162.0.248:3306 10.162.0.248:3306 2022-08-03 16:52:30: Debug: I) 10.170.1.106:3306 10.170.1.106:3306 2022-08-03 16:52:30: Debug: I) 10.170.1.122:3306 10.170.1.122:3306 2022-08-03 16:52:30: Debug: I) 10.170.1.142:3306 10.170.1.142:3306 2022-08-03 16:52:30: Debug: C) 1dac51e1-1336-11ed-ba25-067bc1f7780d jay-test2-west 2022-08-03 16:52:30: Debug: C) 4d5be7b6-119c-11ed-ac8b-0eaea3452381 jay-test2-east 2022-08-03 16:52:30: Debug: DONE! 2022-08-03 16:52:30: Info: Connecting to MySQL at: mysql://ods.cluster.config@10.162.0.219:3306?connect-timeout=5000 2022-08-03 16:52:30: Debug3: PLUGIN-TRACE-START: PluginEventHandler.CONNECTING 2022-08-03 16:52:30: Debug3: PLUGIN-EVENT: caching_sha2_password.AUTHENTICATE.AUTH_PLUGIN 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: CONNECTED: 10.162.0.219:3306 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: SQL: SET SESSION `autocommit` = 1 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: SQL: SET SESSION `sql_mode` = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: SQL: SELECT COALESCE(@@report_host, @@hostname), COALESCE(@@report_port, @@port) 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: SQL: SELECT @@server_uuid 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: SQL: SELECT @@group_replication_group_name group_name, NULLIF(CONCAT(''/*!80026, @@group_replication_view_change_uuid*/), '') group_view_change_uuid, @@group_replication_single_primary_mode single_primary, @@server_uuid, member_state, (SELECT sum(IF(member_state in ('ONLINE', 'RECOVERING'), 1, 0)) > sum(1)/2 FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR member_state <> 'ERROR' ) has_quorum, COALESCE(/*!80002 member_role = 'PRIMARY', NULL AND */ NOT @@group_replication_single_primary_mode OR member_id = (select variable_value from performance_schema.global_status where variable_name = 'group_replication_primary_member') ) is_primary FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: MySQL Error 1193 (HY000): Unknown system variable 'group_replication_group_name', SQL: SELECT @@group_replication_group_name group_name, NULLIF(CONCAT(''/*!80026, @@group_replication_view_change_uuid*/), '') group_view_change_uuid, @@group_replication_single_primary_mode single_primary, @@server_uuid, member_state, (SELECT sum(IF(member_state in ('ONLINE', 'RECOVERING'), 1, 0)) > sum(1)/2 FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR member_state <> 'ERROR' ) has_quorum, COALESCE(/*!80002 member_role = 'PRIMARY', NULL AND */ NOT @@group_replication_single_primary_mode OR member_id = (select variable_value from performance_schema.global_status where variable_name = 'group_replication_primary_member') ) is_primary FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid 2022-08-03 16:52:30: Error: Error while querying for group_replication info: Unknown system variable 'group_replication_group_name' 2022-08-03 16:52:30: Info: Connecting to MySQL at: mysql://ods.cluster.config@10.162.0.229:3306?connect-timeout=5000 2022-08-03 16:52:30: Debug3: PLUGIN-TRACE-START: PluginEventHandler.CONNECTING 2022-08-03 16:52:30: Debug3: PLUGIN-EVENT: caching_sha2_password.AUTHENTICATE.AUTH_PLUGIN 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: CONNECTED: 10.162.0.229:3306 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: SQL: SET SESSION `autocommit` = 1 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: SQL: SET SESSION `sql_mode` = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: SQL: SELECT COALESCE(@@report_host, @@hostname), COALESCE(@@report_port, @@port) 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: SQL: SELECT @@server_uuid 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: SQL: SELECT @@group_replication_group_name group_name, NULLIF(CONCAT(''/*!80026, @@group_replication_view_change_uuid*/), '') group_view_change_uuid, @@group_replication_single_primary_mode single_primary, @@server_uuid, member_state, (SELECT sum(IF(member_state in ('ONLINE', 'RECOVERING'), 1, 0)) > sum(1)/2 FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR member_state <> 'ERROR' ) has_quorum, COALESCE(/*!80002 member_role = 'PRIMARY', NULL AND */ NOT @@group_replication_single_primary_mode OR member_id = (select variable_value from performance_schema.global_status where variable_name = 'group_replication_primary_member') ) is_primary FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: MySQL Error 1193 (HY000): Unknown system variable 'group_replication_group_name', SQL: SELECT @@group_replication_group_name group_name, NULLIF(CONCAT(''/*!80026, @@group_replication_view_change_uuid*/), '') group_view_change_uuid, @@group_replication_single_primary_mode single_primary, @@server_uuid, member_state, (SELECT sum(IF(member_state in ('ONLINE', 'RECOVERING'), 1, 0)) > sum(1)/2 FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR member_state <> 'ERROR' ) has_quorum, COALESCE(/*!80002 member_role = 'PRIMARY', NULL AND */ NOT @@group_replication_single_primary_mode OR member_id = (select variable_value from performance_schema.global_status where variable_name = 'group_replication_primary_member') ) is_primary FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid 2022-08-03 16:52:30: Error: Error while querying for group_replication info: Unknown system variable 'group_replication_group_name' 2022-08-03 16:52:30: Debug3: PLUGIN-TRACE-STOP: PluginEventHandler 2022-08-03 16:52:30: Info: Connecting to MySQL at: mysql://ods.cluster.config@10.162.0.248:3306?connect-timeout=5000 2022-08-03 16:52:30: Debug3: PLUGIN-TRACE-START: PluginEventHandler.CONNECTING 2022-08-03 16:52:30: Debug3: PLUGIN-EVENT: caching_sha2_password.AUTHENTICATE.AUTH_PLUGIN 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3097: CONNECTED: 10.162.0.248:3306 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3097: SQL: SET SESSION `autocommit` = 1 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3097: SQL: SET SESSION `sql_mode` = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3097: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3097: SQL: SELECT COALESCE(@@report_host, @@hostname), COALESCE(@@report_port, @@port) 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3097: SQL: SELECT @@server_uuid 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3097: SQL: SELECT @@group_replication_group_name group_name, NULLIF(CONCAT(''/*!80026, @@group_replication_view_change_uuid*/), '') group_view_change_uuid, @@group_replication_single_primary_mode single_primary, @@server_uuid, member_state, (SELECT sum(IF(member_state in ('ONLINE', 'RECOVERING'), 1, 0)) > sum(1)/2 FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR member_state <> 'ERROR' ) has_quorum, COALESCE(/*!80002 member_role = 'PRIMARY', NULL AND */ NOT @@group_replication_single_primary_mode OR member_id = (select variable_value from performance_schema.global_status where variable_name = 'group_replication_primary_member') ) is_primary FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3097: MySQL Error 1193 (HY000): Unknown system variable 'group_replication_group_name', SQL: SELECT @@group_replication_group_name group_name, NULLIF(CONCAT(''/*!80026, @@group_replication_view_change_uuid*/), '') group_view_change_uuid, @@group_replication_single_primary_mode single_primary, @@server_uuid, member_state, (SELECT sum(IF(member_state in ('ONLINE', 'RECOVERING'), 1, 0)) > sum(1)/2 FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR member_state <> 'ERROR' ) has_quorum, COALESCE(/*!80002 member_role = 'PRIMARY', NULL AND */ NOT @@group_replication_single_primary_mode OR member_id = (select variable_value from performance_schema.global_status where variable_name = 'group_replication_primary_member') ) is_primary FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid 2022-08-03 16:52:30: Error: Error while querying for group_replication info: Unknown system variable 'group_replication_group_name' 2022-08-03 16:52:30: Debug3: PLUGIN-TRACE-STOP: PluginEventHandler 2022-08-03 16:52:30: Info: ClusterSet.status: tid=18374: SQL: SELECT c.*, m.view_id, m.member_role, m.master_cluster_id, m.invalidated, c.attributes->>'$.group_replication_view_change_uuid' as view_uuid FROM mysql_innodb_cluster_metadata.v2_cs_members m JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = m.cluster_id WHERE c.cluster_id = '63b57e4f-119c-11ed-ba1c-067bc1f7780d' 2022-08-03 16:52:30: Debug: Metadata operations will use 10.162.0.219:3306 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp' 2022-08-03 16:52:30: Warning: Could not acquire PRIMARY: MYSQLSH 51101: Metadata schema of an InnoDB cluster or ReplicaSet not found 2022-08-03 16:52:30: Info: ClusterSet.status: tid=18374: SQL: SELECT i.instance_id, i.cluster_id, c.group_name, am.master_instance_id, am.master_member_id, am.member_role, am.view_id, i.label, i.mysql_server_uuid, i.address, i.endpoint, i.xendpoint, ii.addresses->>'$.grLocal' as grendpoint, CAST(ii.attributes->'$.server_id' AS UNSIGNED) server_id FROM mysql_innodb_cluster_metadata.v2_instances i LEFT JOIN mysql_innodb_cluster_metadata.instances ii ON ii.instance_id = i.instance_id LEFT JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = i.cluster_id LEFT JOIN mysql_innodb_cluster_metadata.v2_ar_members am ON am.instance_id = i.instance_id WHERE i.cluster_id = '63b57e4f-119c-11ed-ba1c-067bc1f7780d' 2022-08-03 16:52:30: Info: Connecting to MySQL at: mysql://ods.cluster.config@10.162.0.219:3306?connect-timeout=5000 2022-08-03 16:52:30: Debug3: PLUGIN-TRACE-START: PluginEventHandler.CONNECTING 2022-08-03 16:52:30: Debug3: PLUGIN-EVENT: caching_sha2_password.AUTHENTICATE.AUTH_PLUGIN 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3096: CONNECTED: 10.162.0.219:3306 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3096: SQL: SET SESSION `autocommit` = 1 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3096: SQL: SET SESSION `sql_mode` = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3096: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3096: SQL: SELECT COALESCE(@@report_host, @@hostname), COALESCE(@@report_port, @@port) 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3096: SQL: SELECT @@server_uuid 2022-08-03 16:52:30: Info: Connecting to MySQL at: mysql://ods.cluster.config@10.162.0.229:3306?connect-timeout=5000 2022-08-03 16:52:30: Debug3: PLUGIN-TRACE-START: PluginEventHandler.CONNECTING 2022-08-03 16:52:30: Debug3: PLUGIN-EVENT: caching_sha2_password.AUTHENTICATE.AUTH_PLUGIN 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3096: CONNECTED: 10.162.0.229:3306 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3096: SQL: SET SESSION `autocommit` = 1 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3096: SQL: SET SESSION `sql_mode` = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3096: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3096: SQL: SELECT COALESCE(@@report_host, @@hostname), COALESCE(@@report_port, @@port) 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3096: SQL: SELECT @@server_uuid 2022-08-03 16:52:30: Info: Connecting to MySQL at: mysql://ods.cluster.config@10.162.0.248:3306?connect-timeout=5000 2022-08-03 16:52:30: Debug3: PLUGIN-TRACE-START: PluginEventHandler.CONNECTING 2022-08-03 16:52:30: Debug3: PLUGIN-EVENT: caching_sha2_password.AUTHENTICATE.AUTH_PLUGIN 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3098: CONNECTED: 10.162.0.248:3306 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3098: SQL: SET SESSION `autocommit` = 1 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3098: SQL: SET SESSION `sql_mode` = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3098: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3098: SQL: SELECT COALESCE(@@report_host, @@hostname), COALESCE(@@report_port, @@port) 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3098: SQL: SELECT @@server_uuid 2022-08-03 16:52:30: Info: ClusterSet.status: tid=18374: SQL: SELECT c.*, m.view_id, m.member_role, m.master_cluster_id, m.invalidated, c.attributes->>'$.group_replication_view_change_uuid' as view_uuid FROM mysql_innodb_cluster_metadata.v2_cs_members m JOIN mysql_innodb_cluster_metadata.v2_gr_clusters c ON c.cluster_id = m.cluster_id WHERE c.cluster_id = '63b57e4f-119c-11ed-ba1c-067bc1f7780d' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=18374: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0fdb4c89-119c-11ed-ba1c-067bc1f7780d' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: SQL: SELECT c.channel_name, c.host, c.port, c.user, s.source_uuid, s.group_name, s.last_heartbeat_timestamp, s.service_state io_state, st.processlist_state io_thread_state, s.last_error_number io_errno, s.last_error_message io_errmsg, s.last_error_timestamp io_errtime, co.service_state co_state, cot.processlist_state co_thread_state, co.last_error_number co_errno, co.last_error_message co_errmsg, co.last_error_timestamp co_errtime, w.service_state w_state, wt.processlist_state w_thread_state, w.last_error_number w_errno, w.last_error_message w_errmsg, w.last_error_timestamp w_errtime, /*!80011 TIMEDIFF(NOW(6), IF(TIMEDIFF(s.LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP, s.LAST_HEARTBEAT_TIMESTAMP) >= 0, s.LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP, s.LAST_HEARTBEAT_TIMESTAMP )) as time_since_last_message, IF(s.LAST_QUEUED_TRANSACTION='' OR s.LAST_QUEUED_TRANSACTION=latest_w.LAST_APPLIED_TRANSACTION, 'IDLE', 'APPLYING') as applier_busy_state, IF(s.LAST_QUEUED_TRANSACTION='' OR s.LAST_QUEUED_TRANSACTION=latest_w.LAST_APPLIED_TRANSACTION, NULL, TIMEDIFF(latest_w.LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP, latest_w.LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP) ) as lag_from_original, IF(s.LAST_QUEUED_TRANSACTION='' OR s.LAST_QUEUED_TRANSACTION=latest_w.LAST_APPLIED_TRANSACTION, NULL, TIMEDIFF(latest_w.LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP, latest_w.LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) ) as lag_from_immediate, */ GTID_SUBTRACT(s.RECEIVED_TRANSACTION_SET, @@global.gtid_executed) as queued_gtid_set_to_apply FROM performance_schema.replication_connection_configuration c JOIN performance_schema.replication_connection_status s ON c.channel_name = s.channel_name LEFT JOIN performance_schema.replication_applier_status_by_coordinator co ON c.channel_name = co.channel_name JOIN performance_schema.replication_applier_status a ON c.channel_name = a.channel_name JOIN performance_schema.replication_applier_status_by_worker w ON c.channel_name = w.channel_name LEFT JOIN /* if parallel replication, fetch owner of most recently applied tx */ (SELECT * FROM performance_schema.replication_applier_status_by_worker /*!80011 ORDER BY LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP DESC */ LIMIT 1) latest_w ON c.channel_name = latest_w.channel_name LEFT JOIN performance_schema.threads st ON s.thread_id = st.thread_id LEFT JOIN performance_schema.threads cot ON co.thread_id = cot.thread_id LEFT JOIN performance_schema.threads wt ON w.thread_id = wt.thread_id WHERE c.channel_name = 'clusterset_replication' 2022-08-03 16:52:30: Info: ClusterSet.status: tid=3095: SQL: show GLOBAL variables where `variable_name` in ('group_replication_ssl_mode') 2022-08-03 16:52:30: Debug3: PLUGIN-TRACE-STOP: PluginEventHandler 2022-08-03 16:52:30: Debug3: PLUGIN-TRACE-STOP: PluginEventHandler 2022-08-03 16:52:30: Debug3: PLUGIN-TRACE-STOP: PluginEventHandler 2022-08-03 16:52:30: Debug3: PLUGIN-TRACE-STOP: PluginEventHandler 2022-08-03 16:52:30: Debug: ClusterSet.status: Attempt to read null value (LogicError)