2024-04-11 14:20:30: Info: Using credential store helper: /usr/bin/mysql-secret-store-login-path
2024-04-11 14:20:30: Info: Loading startup files...
2024-04-11 14:20:30: Info: Loading plugins...
2024-04-11 14:20:30: Info: Connecting to MySQL at: clusteradmin@db2-0.db2-endpoints.o7.svc.cluster.local
2024-04-11 14:20:30: Info: Shell.connect: tid=0: SQL: select @@lower_case_table_names, @@version, connection_id(), variable_value from performance_schema.session_status where variable_name = 'mysqlx_ssl_cipher'
2024-04-11 14:20:30: Info: Shell.connect: tid=152: CONNECTED: db2-0.db2-endpoints.o7.svc.cluster.local
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=152: SQL: SELECT @@GLOBAL.port
2024-04-11 14:20:30: Info: Connecting to MySQL at: mysql://clusteradmin@db2-0.db2-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: CONNECTED: db2-0.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: 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'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: SELECT @@server_uuid
2024-04-11 14:20:30: Info: Connecting to MySQL at: mysql://clusteradmin@db2-0.db2-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: CONNECTED: db2-0.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: 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'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: SQL: SELECT @@server_uuid
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: SQL: select cluster_type from `mysql_innodb_cluster_metadata`.v2_this_instance
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: select count(*) FROM performance_schema.replication_group_members WHERE MEMBER_ID = @@server_uuid AND MEMBER_STATE NOT IN ('OFFLINE', 'UNREACHABLE')
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: SELECT COUNT(*) FROM performance_schema.threads WHERE NAME = 'thread/group_rpl/THD_delayed_initialization'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: 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
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: 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
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: 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 = 'db2-0.db2-endpoints.o7.svc.cluster.local:3306'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: select cluster_type from `mysql_innodb_cluster_metadata`.v2_this_instance
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: SELECT member_state FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR (member_id = '' AND member_state = 'OFFLINE')
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: 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
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: SELECT @@group_replication_single_primary_mode,        variable_value AS primary_uuid   FROM performance_schema.global_status   WHERE variable_name = 'group_replication_primary_member'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: 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 = '1111c4e6-f803-11ee-897c-82ac0a512f1b'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: 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 = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f' AND m.invalidated = 0
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: SQL: show GLOBAL variables where `variable_name` in ('group_replication_group_name')
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=154: 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
2024-04-11 14:20:30: Info: Connecting to MySQL at: mysql://clusteradmin@db1-2.db1-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: CONNECTED: db1-2.db1-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: 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'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: SQL: SELECT @@server_uuid
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: 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
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: SQL: SELECT @@group_replication_single_primary_mode,        variable_value AS primary_uuid   FROM performance_schema.global_status   WHERE variable_name = 'group_replication_primary_member'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: 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
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: 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 = '1111c4e6-f803-11ee-897c-82ac0a512f1b'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: 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_name = 'cluster-50adc00bae8acb407dd5db53990ce9de'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: show GLOBAL variables where `variable_name` in ('group_replication_group_name')
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=153: SQL: SELECT @@group_replication_group_name
2024-04-11 14:20:30: Info: Group Replication 'group_name' value: 6c6dc026-f80e-11ee-b801-82ac0a512f1b
2024-04-11 14:20:30: Info: Metadata 'group_name' value: 6c6dc026-f80e-11ee-b801-82ac0a512f1b
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: 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 = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f' AND m.invalidated = 0
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42318: 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
2024-04-11 14:20:30: Info: Connecting to MySQL at: mysql://clusteradmin@db1-2.db1-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: CONNECTED: db1-2.db1-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: 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'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: SQL: SELECT @@server_uuid
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: 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
2024-04-11 14:20:30: Info: Connecting to MySQL at: mysql://clusteradmin@db1-2.db1-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: CONNECTED: db1-2.db1-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: 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'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: SQL: SELECT @@server_uuid
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: SQL: select cluster_type from `mysql_innodb_cluster_metadata`.v2_this_instance
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: SQL: SELECT member_state FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR (member_id = '' AND member_state = 'OFFLINE')
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: 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
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42320: SQL: SELECT @@group_replication_single_primary_mode,        variable_value AS primary_uuid   FROM performance_schema.global_status   WHERE variable_name = 'group_replication_primary_member'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: 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 = '09a7135d-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: 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 = '09a7135d-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: 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 = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f' AND m.invalidated = 0
2024-04-11 14:20:30: Info: Connecting to MySQL at: mysql://clusteradmin@db2-0.db2-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: CONNECTED: db2-0.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: 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'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: SQL: SELECT @@server_uuid
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: 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
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: 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 = 'db2-0.db2-endpoints.o7.svc.cluster.local:3306'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: SQL: SELECT domain_name, clusterset_id FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=155: SQL: SELECT MAX(view_id) FROM mysql_innodb_cluster_metadata.clusterset_views WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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
2024-04-11 14:20:30: Info: Dba.get_cluster: tid=42321: 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
2024-04-11 14:20:30: Warning: The password option is deprecated and will be removed in a future release.
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=153: SQL: select 1
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42318: SQL: SELECT COUNT(*) as count FROM mysql_innodb_cluster_metadata.instances WHERE cluster_id = '827e931a-f80e-11ee-b05b-9e84dc9f859f' AND instance_name = 'db2-2'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42318: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42318: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42318: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42318: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42318: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42318: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42318: 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
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=153: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=153: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=153: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=153: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=153: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=153: SQL: select cluster_type from `mysql_innodb_cluster_metadata`.v2_this_instance
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=153: SQL: SELECT member_state FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR (member_id = '' AND member_state = 'OFFLINE')
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=153: 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
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=153: SQL: SELECT @@group_replication_single_primary_mode,        variable_value AS primary_uuid   FROM performance_schema.global_status   WHERE variable_name = 'group_replication_primary_member'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42318: 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42318: 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42318: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42318: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42318: 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 = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f' AND m.invalidated = 0
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42318: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42318: 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
2024-04-11 14:20:30: Info: Connecting to MySQL at: mysql://clusteradmin@db1-2.db1-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: CONNECTED: db1-2.db1-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: 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'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: SQL: SELECT @@server_uuid
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: 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
2024-04-11 14:20:30: Info: Connecting to MySQL at: mysql://clusteradmin@db1-2.db1-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: CONNECTED: db1-2.db1-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: 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'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: SQL: SELECT @@server_uuid
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: SQL: select cluster_type from `mysql_innodb_cluster_metadata`.v2_this_instance
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: SQL: SELECT member_state FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR (member_id = '' AND member_state = 'OFFLINE')
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: 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
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42323: SQL: SELECT @@group_replication_single_primary_mode,        variable_value AS primary_uuid   FROM performance_schema.global_status   WHERE variable_name = 'group_replication_primary_member'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: 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 = '09a7135d-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: 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 = '09a7135d-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42324: 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 = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f' AND m.invalidated = 0
2024-04-11 14:20:30: Info: Connecting to MySQL at: mysql://clusteradmin@db2-0.db2-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: CONNECTED: db2-0.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: 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'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: SQL: SELECT @@server_uuid
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: 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
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: 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 = 'db2-0.db2-endpoints.o7.svc.cluster.local:3306'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: SQL: SELECT domain_name, clusterset_id FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=156: SQL: SELECT MAX(view_id) FROM mysql_innodb_cluster_metadata.clusterset_views WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Connecting to db1-2.db1-endpoints.o7.svc.cluster.local:3306...
2024-04-11 14:20:30: Info: Connecting to MySQL at: mysql://clusteradmin@db1-2.db1-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42325: CONNECTED: db1-2.db1-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42325: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42325: 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'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42325: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42325: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42325: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42325: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42325: SQL: SELECT @@server_uuid
2024-04-11 14:20:30: Info: Connecting to MySQL at: mysql://clusteradmin@db1-2.db1-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: CONNECTED: db1-2.db1-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: 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'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: SQL: SELECT @@server_uuid
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: SQL: select cluster_type from `mysql_innodb_cluster_metadata`.v2_this_instance
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=153: SQL: select count(*) FROM performance_schema.replication_group_members WHERE MEMBER_ID = @@server_uuid AND MEMBER_STATE NOT IN ('OFFLINE', 'UNREACHABLE')
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=153: SQL: SELECT COUNT(*) FROM performance_schema.threads WHERE NAME = 'thread/group_rpl/THD_delayed_initialization'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=153: 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
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: 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
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: 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 = 'db2-0.db2-endpoints.o7.svc.cluster.local:3306'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: 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 = '1111c4e6-f803-11ee-897c-82ac0a512f1b'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: 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 = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f' AND m.invalidated = 0
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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
2024-04-11 14:20:30: Info: Cluster.add_instance: tid=42326: 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
2024-04-11 14:20:30: Info: Connecting to MySQL at: mysql://clusteradmin@db1-2.db1-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: CONNECTED: db1-2.db1-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: 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'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SELECT @@server_uuid
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: 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
2024-04-11 14:20:31: Info: Connecting to MySQL at: mysql://clusteradmin@db1-2.db1-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: CONNECTED: db1-2.db1-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: 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'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: SQL: SELECT @@server_uuid
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: select cluster_type from `mysql_innodb_cluster_metadata`.v2_this_instance
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SELECT member_state FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR (member_id = '' AND member_state = 'OFFLINE')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: 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
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SELECT @@group_replication_single_primary_mode,        variable_value AS primary_uuid   FROM performance_schema.global_status   WHERE variable_name = 'group_replication_primary_member'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: 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 = '09a7135d-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: 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 = '09a7135d-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: 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 = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f' AND m.invalidated = 0
2024-04-11 14:20:31: Info: Connecting to MySQL at: mysql://clusteradmin@db2-0.db2-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: CONNECTED: db2-0.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: 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'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: SQL: SELECT @@server_uuid
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: 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
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: 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 = 'db2-0.db2-endpoints.o7.svc.cluster.local:3306'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: SQL: SELECT domain_name, clusterset_id FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=157: SQL: SELECT MAX(view_id) FROM mysql_innodb_cluster_metadata.clusterset_views WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: SQL: SELECT COUNT(*) as count FROM mysql_innodb_cluster_metadata.instances WHERE cluster_id = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: select count(*) FROM performance_schema.replication_group_members WHERE MEMBER_ID = @@server_uuid AND MEMBER_STATE NOT IN ('OFFLINE', 'UNREACHABLE')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE NAME = 'thread/group_rpl/THD_autorejoin'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT COUNT(*) FROM performance_schema.threads WHERE NAME = 'thread/group_rpl/THD_delayed_initialization'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: 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
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT @@group_replication_single_primary_mode,        variable_value AS primary_uuid   FROM performance_schema.global_status   WHERE variable_name = 'group_replication_primary_member'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: 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'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: SQL: SELECT COUNT(*) as count FROM mysql_innodb_cluster_metadata.instances WHERE cluster_id = '09a7135d-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: select count(*) FROM performance_schema.replication_group_members WHERE MEMBER_ID = @@server_uuid AND MEMBER_STATE NOT IN ('OFFLINE', 'UNREACHABLE')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE NAME = 'thread/group_rpl/THD_autorejoin'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SELECT COUNT(*) FROM performance_schema.threads WHERE NAME = 'thread/group_rpl/THD_delayed_initialization'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: 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
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SELECT @@group_replication_single_primary_mode,        variable_value AS primary_uuid   FROM performance_schema.global_status   WHERE variable_name = 'group_replication_primary_member'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: select count(*) FROM performance_schema.replication_group_members WHERE MEMBER_ID = @@server_uuid AND MEMBER_STATE NOT IN ('OFFLINE', 'UNREACHABLE')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SELECT NOT @@group_replication_single_primary_mode OR     (select variable_value       from performance_schema.global_status       where variable_name = 'group_replication_primary_member')    = @@server_uuid
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: SELECT enabled FROM performance_schema.replication_group_member_actions WHERE name = 'mysql_disable_super_read_only_if_primary'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: 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'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: select @@global.gtid_executed
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: show GLOBAL variables where `variable_name` in ('group_replication_view_change_uuid')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: select received_transaction_set from performance_schema.replication_connection_status where channel_name='clusterset_replication'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT gtid_subtract('0256f83a-f7fe-11ee-b05b-9e84dc9f859f:1-39813,\n0256fb52-f7fe-11ee-b05b-9e84dc9f859f:1-5,\n6c6dc717-f80e-11ee-b801-82ac0a512f1b:1,\nd2b18318-f7fd-11ee-bf06-9e84dc9f859f:1-4', '6c6dc717-f80e-11ee-b801-82ac0a512f1b:1')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT gtid_subtract('0256f83a-f7fe-11ee-b05b-9e84dc9f859f:1-39813,\n0256fb52-f7fe-11ee-b05b-9e84dc9f859f:1-5,\nd2b18318-f7fd-11ee-bf06-9e84dc9f859f:1-4', '0256f83a-f7fe-11ee-b05b-9e84dc9f859f:39444-39815')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42327: SQL: select @@global.gtid_executed
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT gtid_subtract('0256f83a-f7fe-11ee-b05b-9e84dc9f859f:1-39443,\n0256fb52-f7fe-11ee-b05b-9e84dc9f859f:1-5,\nd2b18318-f7fd-11ee-bf06-9e84dc9f859f:1-4', '0256f83a-f7fe-11ee-b05b-9e84dc9f859f:1-39815,\n0256fb52-f7fe-11ee-b05b-9e84dc9f859f:1-5,\nd2b18318-f7fd-11ee-bf06-9e84dc9f859f:1-4')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: 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 = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f' AND m.invalidated = 0
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42329: 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
2024-04-11 14:20:31: Info: Connecting to MySQL at: mysql://clusteradmin@db1-2.db1-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42331: CONNECTED: db1-2.db1-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42331: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42331: 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'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42331: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42331: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42331: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42331: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42331: SQL: SELECT @@server_uuid
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42331: 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
2024-04-11 14:20:31: Info: Connecting to MySQL at: mysql://clusteradmin@db1-2.db1-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42332: CONNECTED: db1-2.db1-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42332: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42332: 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'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42332: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42332: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42332: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42332: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42332: SQL: SELECT @@server_uuid
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: 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 = '1111c4e6-f803-11ee-897c-82ac0a512f1b'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: SQL: SELECT COUNT(*) as count FROM mysql_innodb_cluster_metadata.instances WHERE cluster_id = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: select count(*) FROM performance_schema.replication_group_members WHERE MEMBER_ID = @@server_uuid AND MEMBER_STATE NOT IN ('OFFLINE', 'UNREACHABLE')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE NAME = 'thread/group_rpl/THD_autorejoin'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT COUNT(*) FROM performance_schema.threads WHERE NAME = 'thread/group_rpl/THD_delayed_initialization'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: 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
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT @@group_replication_single_primary_mode,        variable_value AS primary_uuid   FROM performance_schema.global_status   WHERE variable_name = 'group_replication_primary_member'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Connecting to MySQL at: mysql://clusteradmin@db2-2.db2-endpoints.o7.svc.cluster.local?connect-timeout=5000
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: CONNECTED: db2-2.db2-endpoints.o7.svc.cluster.local
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: 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'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SELECT @@server_uuid
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: show GLOBAL variables where `variable_name` in ('version_compile_os')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT COUNT(*) FROM mysql.func WHERE dl = /*(*/ 'locking_service.so' /*(*/ AND name IN ('service_get_read_locks', 'service_get_write_locks', 'service_release_locks')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT service_get_write_locks('AdminAPI_cluster', 'AdminAPI_lock', 0)
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: show GLOBAL variables where `variable_name` in ('version_compile_os')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SELECT COUNT(*) FROM mysql.func WHERE dl = /*(*/ 'locking_service.so' /*(*/ AND name IN ('service_get_read_locks', 'service_get_write_locks', 'service_release_locks')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SELECT service_get_write_locks('AdminAPI_instance', 'AdminAPI_lock', 0)
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: SQL: SELECT attributes->'$.opt_manualStartOnBoot' FROM mysql_innodb_cluster_metadata.clusters WHERE cluster_id='827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: show GLOBAL variables where `variable_name` in ('group_replication_communication_stack')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SELECT PROCESSLIST_STATE FROM performance_schema.threads WHERE NAME = 'thread/group_rpl/THD_autorejoin'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SELECT COUNT(*) FROM performance_schema.threads WHERE NAME = 'thread/group_rpl/THD_delayed_initialization'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: select count(*) FROM performance_schema.replication_group_members WHERE MEMBER_ID = @@server_uuid AND MEMBER_STATE NOT IN ('OFFLINE', 'UNREACHABLE')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: 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
ORDER BY channel_name
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SHOW SLAVE HOSTS
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: show GLOBAL variables where `variable_name` in ('group_replication_communication_stack')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: SQL: SELECT attributes->'$.opt_disableClone' FROM mysql_innodb_cluster_metadata.clusters WHERE cluster_id='827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: SQL: SELECT attributes->'$.opt_gtidSetIsComplete' FROM mysql_innodb_cluster_metadata.clusters WHERE cluster_id='827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SELECT @@GLOBAL.GTID_EXECUTED
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT @@GLOBAL.GTID_EXECUTED
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT @@GLOBAL.GTID_PURGED
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SET @gtidset_a='0256f83a-f7fe-11ee-b05b-9e84dc9f859f:1-39813,\n0256fb52-f7fe-11ee-b05b-9e84dc9f859f:1-5,\n6c6dc717-f80e-11ee-b801-82ac0a512f1b:1,\nd2b18318-f7fd-11ee-bf06-9e84dc9f859f:1-4'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SET @gtidset_b='1111c4e6-f803-11ee-897c-82ac0a512f1b:1-4,\n1af01566-f803-11ee-b801-82ac0a512f1b:1-104,\n1af01967-f803-11ee-b801-82ac0a512f1b:1-6'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT GTID_SUBTRACT(@gtidset_a, @gtidset_b)
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT GTID_SUBTRACT(@gtidset_b, @gtidset_a)
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT GTID_SUBTRACT(@gtidset_a, GTID_SUBTRACT(@gtidset_a, @gtidset_b))
2024-04-11 14:20:31: Warning: A GTID set check of the MySQL instance at 'db2-2.db2-endpoints.o7.svc.cluster.local:3306' determined that it contains transactions that do not originate from the cluster, which must be discarded before it can join the cluster.
2024-04-11 14:20:31: Warning: Discarding these extra GTID events can either be done manually or by completely overwriting the state of db2-2.db2-endpoints.o7.svc.cluster.local:3306 with a physical snapshot from an existing cluster member. To use this method by default, set the 'recoveryMethod' option to 'clone'.

Having extra GTID events is not expected, and it is recommended to investigate this further and ensure that the data can be removed prior to choosing the clone recovery method.
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: 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
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: 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
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: show GLOBAL variables where `variable_name` in ('group_replication_allow_local_lower_version_join')
2024-04-11 14:20:31: Info: Connecting to MySQL at: mysql://clusteradmin@db2-2.db2-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: CONNECTED: db2-2.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: 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'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT @@server_uuid
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('persisted_globals_load')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('persisted_globals_load')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT CURRENT_USER()
2024-04-11 14:20:31: Info: Validating account clusteradmin@%...
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT PRIVILEGE_TYPE FROM INFORMATION_SCHEMA.USER_PRIVILEGES WHERE GRANTEE='\'clusteradmin\'@\'%\'' LIMIT 1
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SHOW PRIVILEGES
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('activate_all_roles_on_login')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT default_role_user, default_role_host FROM mysql.default_roles WHERE user='clusteradmin' AND host='%'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('partial_revokes')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SHOW GRANTS FOR 'clusteradmin'@'%'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT CURRENT_USER()
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT DISTINCT grantee FROM information_schema.user_privileges WHERE grantee like '\'clusteradmin\'@%'
2024-04-11 14:20:31: Info: clusteradmin user has 1 accounts with wildcard or netmask and 0 without
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: select @@port, @@datadir;
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT @@hostname, @@report_host
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT plugin_status FROM information_schema.plugins WHERE plugin_name = 'clone'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT table_schema, table_name, engine  FROM information_schema.tables  WHERE engine NOT IN ('InnoDB', 'MEMORY') AND table_schema NOT IN ('mysql', 'sys', 'performance_schema', 'information_schema')
2024-04-11 14:20:31: Info: Validating InnoDB page size of instance 'db2-2.db2-endpoints.o7.svc.cluster.local:3306'.
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('innodb_page_size')
2024-04-11 14:20:31: Info: Checking if performance_schema is enabled on instance 'db2-2.db2-endpoints.o7.svc.cluster.local:3306'.
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('performance_schema')
2024-04-11 14:20:31: Info: Validating configuration of db2-2.db2-endpoints.o7.svc.cluster.local:3306 (mycnf = )
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('server_id')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('performance_schema')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT variable_source FROM performance_schema.variables_info WHERE variable_name = 'server_id'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('log_bin')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('port')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('replica_parallel_workers')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('binlog_format')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT variable_value FROM performance_schema.persisted_variables WHERE variable_name = 'binlog_format'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('enforce_gtid_consistency')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT variable_value FROM performance_schema.persisted_variables WHERE variable_name = 'enforce_gtid_consistency'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('gtid_mode')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT variable_value FROM performance_schema.persisted_variables WHERE variable_name = 'gtid_mode'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('master_info_repository')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT variable_value FROM performance_schema.persisted_variables WHERE variable_name = 'master_info_repository'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('relay_log_info_repository')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT variable_value FROM performance_schema.persisted_variables WHERE variable_name = 'relay_log_info_repository'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('log_replica_updates')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT variable_value FROM performance_schema.persisted_variables WHERE variable_name = 'log_replica_updates'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('log_slave_updates')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT variable_value FROM performance_schema.persisted_variables WHERE variable_name = 'log_slave_updates'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('group_replication_tls_source')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT variable_value FROM performance_schema.persisted_variables WHERE variable_name = 'group_replication_tls_source'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('transaction_write_set_extraction')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT variable_value FROM performance_schema.persisted_variables WHERE variable_name = 'transaction_write_set_extraction'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('replica_parallel_type')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT variable_value FROM performance_schema.persisted_variables WHERE variable_name = 'replica_parallel_type'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('replica_preserve_commit_order')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT variable_value FROM performance_schema.persisted_variables WHERE variable_name = 'replica_preserve_commit_order'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('binlog_transaction_dependency_tracking')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT variable_value FROM performance_schema.persisted_variables WHERE variable_name = 'binlog_transaction_dependency_tracking'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: show GLOBAL variables where `variable_name` in ('report_port')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=338: SQL: SELECT variable_value FROM performance_schema.persisted_variables WHERE variable_name = 'report_port'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SHOW MASTER STATUS
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SELECT count(*) FROM performance_schema.replication_applier_global_filters WHERE filter_rule <> ''
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SELECT count(*) FROM performance_schema.replication_applier_filters WHERE filter_rule <> ''
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: show GLOBAL variables where `variable_name` in ('lower_case_table_names')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: show GLOBAL variables where `variable_name` in ('lower_case_table_names')
2024-04-11 14:20:31: Info: Validating if 'lower_case_table_names' variable has the same value on target instance 'db2-2.db2-endpoints.o7.svc.cluster.local:3306' as it does on the cluster.
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: 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
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: show GLOBAL variables where `variable_name` in ('default_table_encryption')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: show GLOBAL variables where `variable_name` in ('default_table_encryption')
2024-04-11 14:20:31: Info: Validating if 'default_table_encryption' variable has the same value on target instance 'db2-2.db2-endpoints.o7.svc.cluster.local:3306' as it does on the cluster.
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: 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
ORDER BY channel_name
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: show GLOBAL variables where `variable_name` in ('server_uuid')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SELECT @@server_id
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: show GLOBAL variables where `variable_name` in ('group_replication_ssl_mode')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SELECT value FROM performance_schema.tls_channel_status WHERE channel='mysql_main' AND property = 'Enabled'
2024-04-11 14:20:31: Info: SSL mode used to configure the instance: 'REQUIRED'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: 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
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Connecting to MySQL at: mysql://clusteradmin@db2-0.db2-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=158: CONNECTED: db2-0.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=158: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=158: 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'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=158: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=158: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=158: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=158: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=158: SQL: SELECT @@server_uuid
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=158: SQL: show GLOBAL variables where `variable_name` in ('group_replication_consistency')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=158: SQL: show GLOBAL variables where `variable_name` in ('group_replication_member_expel_timeout')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: show GLOBAL variables where `variable_name` in ('group_replication_communication_stack')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: show GLOBAL variables where `variable_name` in ('port')
2024-04-11 14:20:31: Info: Group Replication will communicate with other members using 'db2-2.db2-endpoints.o7.svc.cluster.local:3306'. Use the localAddress option to override.
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: 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
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: SQL: SELECT attributes->'$.opt_memberAuthType' FROM mysql_innodb_cluster_metadata.clusters WHERE cluster_id='827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: SQL: SELECT attributes->'$.opt_certIssuer' FROM mysql_innodb_cluster_metadata.clusters WHERE cluster_id='827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=42326: SQL: SELECT attributes->'$.opt_certSubject' FROM mysql_innodb_cluster_metadata.instances WHERE mysql_server_uuid = '1111c4e6-f803-11ee-897c-82ac0a512f1b'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: show GLOBAL variables where `variable_name` in ('group_replication_local_address')
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SELECT @@global.super_read_only
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SET GLOBAL super_read_only=0
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SELECT @@session.sql_log_bin
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SET SESSION sql_log_bin=0
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: DROP USER IF EXISTS 'mysqlsh.test'@'%'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: MySQL Error 1290 (HY000): The MySQL server is running with the --super-read-only option so it cannot execute this statement
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=153: SQL: SET SESSION sql_log_bin=1
2024-04-11 14:20:31: Info: Cannot create test account at db2-0.db2-endpoints.o7.svc.cluster.local:3306: MySQL Error 1290 (HY000): db2-0.db2-endpoints.o7.svc.cluster.local:3306: The MySQL server is running with the --super-read-only option so it cannot execute this statement
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SELECT @@session.sql_log_bin
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SET SESSION sql_log_bin=0
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: DROP USER IF EXISTS 'mysqlsh.test'@'%'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SET SESSION sql_log_bin=1
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SELECT @@session.sql_log_bin
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SET SESSION sql_log_bin=0
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: DROP USER IF EXISTS 'mysqlsh-lo.test'@'%'
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SET SESSION sql_log_bin=1
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SELECT @@global.slave_net_timeout
2024-04-11 14:20:31: Info: Cluster.add_instance: tid=337: SQL: SET GLOBAL slave_net_timeout=5
2024-04-11 14:20:31: Info: Checking connection from db2-2.db2-endpoints.o7.svc.cluster.local:3306 to mysqlsh-lo.test@db2-2.db2-endpoints.o7.svc.cluster.local:3306 (localAddress) ssl_mode=REQUIRED auth_type=PASSWORD cert_issuer= cert_subject=
2024-04-11 14:20:31: Info: Setting up async source for channel 'mysqlsh.test' of db2-2.db2-endpoints.o7.svc.cluster.local:3306 to db2-2.db2-endpoints.o7.svc.cluster.local:3306 (user 'mysqlsh-lo.test')
2024-04-11 14:20:32: Info: Cluster.add_instance: tid=337: SQL: START REPLICA IO_THREAD FOR CHANNEL 'mysqlsh.test'
2024-04-11 14:20:32: Info: Cluster.add_instance: tid=337: 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 = 'mysqlsh.test'
2024-04-11 14:20:32: Info: Cluster.add_instance: tid=337: 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 = 'mysqlsh.test'
2024-04-11 14:20:32: Info: Connection check db2-2.db2-endpoints.o7.svc.cluster.local:3306 -> db2-2.db2-endpoints.o7.svc.cluster.local:3306 io_state=OFF io_error=Fatal error: The replica I/O thread stops because source and replica have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on replica but this does not always make sense; please check the manual before using it). (13117) at 2024-04-11 14:20:32.639177
2024-04-11 14:20:32: Info: Cluster.add_instance: tid=337: SQL: STOP REPLICA IO_THREAD FOR CHANNEL 'mysqlsh.test'
2024-04-11 14:20:32: Info: Cluster.add_instance: tid=337: SQL: RESET REPLICA ALL FOR CHANNEL 'mysqlsh.test'
2024-04-11 14:20:32: Info: Cluster.add_instance: tid=337: SQL: SET GLOBAL slave_net_timeout=60
2024-04-11 14:20:32: Info: Cluster.add_instance: tid=153: SQL: SELECT @@global.slave_net_timeout
2024-04-11 14:20:32: Info: Cluster.add_instance: tid=153: SQL: SET GLOBAL slave_net_timeout=5
2024-04-11 14:20:32: Info: Checking connection from db2-0.db2-endpoints.o7.svc.cluster.local:3306 to mysqlsh.test@db2-2.db2-endpoints.o7.svc.cluster.local:3306 (report_host) ssl_mode=REQUIRED auth_type=PASSWORD cert_issuer= cert_subject=
2024-04-11 14:20:32: Info: Setting up async source for channel 'mysqlsh.test' of db2-0.db2-endpoints.o7.svc.cluster.local:3306 to db2-2.db2-endpoints.o7.svc.cluster.local:3306 (user 'mysqlsh.test')
2024-04-11 14:20:34: Info: Cluster.add_instance: tid=153: SQL: START REPLICA IO_THREAD FOR CHANNEL 'mysqlsh.test'
2024-04-11 14:20:34: Info: Cluster.add_instance: tid=153: 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 = 'mysqlsh.test'
2024-04-11 14:20:34: Info: Cluster.add_instance: tid=153: 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 = 'mysqlsh.test'
2024-04-11 14:20:34: Info: Connection check db2-0.db2-endpoints.o7.svc.cluster.local:3306 -> db2-2.db2-endpoints.o7.svc.cluster.local:3306 io_state=OFF io_error=Source command COM_REGISTER_REPLICA failed: Access denied for user 'mysqlsh.test'@'%' (using password: YES) (Errno: 1045) (13120) at 2024-04-11 14:20:34.534378
2024-04-11 14:20:34: Info: Cluster.add_instance: tid=153: SQL: STOP REPLICA IO_THREAD FOR CHANNEL 'mysqlsh.test'
2024-04-11 14:20:34: Info: Cluster.add_instance: tid=153: SQL: RESET REPLICA ALL FOR CHANNEL 'mysqlsh.test'
2024-04-11 14:20:36: Info: Cluster.add_instance: tid=153: SQL: SET GLOBAL slave_net_timeout=60
2024-04-11 14:20:36: Info: Cluster.add_instance: tid=337: SQL: SELECT @@session.sql_log_bin
2024-04-11 14:20:36: Info: Cluster.add_instance: tid=337: SQL: SET SESSION sql_log_bin=0
2024-04-11 14:20:36: Info: Cluster.add_instance: tid=337: SQL: DROP USER IF EXISTS `mysqlsh.test`@'%'
2024-04-11 14:20:36: Info: Cluster.add_instance: tid=337: SQL: DROP USER IF EXISTS `mysqlsh-lo.test`@'%'
2024-04-11 14:20:36: Info: Cluster.add_instance: tid=337: SQL: SET SESSION sql_log_bin=1
2024-04-11 14:20:36: Info: Cluster.add_instance: tid=153: SQL: SELECT @@session.sql_log_bin
2024-04-11 14:20:36: Info: Cluster.add_instance: tid=153: SQL: SET SESSION sql_log_bin=0
2024-04-11 14:20:36: Info: Cluster.add_instance: tid=153: SQL: DROP USER IF EXISTS `mysqlsh.test`@'%'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=153: MySQL Error 1290 (HY000): The MySQL server is running with the --super-read-only option so it cannot execute this statement
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=153: SQL: SET SESSION sql_log_bin=1
2024-04-11 14:20:37: Error: Unexpected exception: db2-0.db2-endpoints.o7.svc.cluster.local:3306: The MySQL server is running with the --super-read-only option so it cannot execute this statement
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=337: SQL: SET GLOBAL super_read_only=1
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=153: SQL: show GLOBAL variables where `variable_name` in ('group_replication_transaction_size_limit')
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=153: SQL: SELECT plugin_status FROM information_schema.plugins WHERE plugin_name = 'group_replication'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=153: SQL: SELECT WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE FROM performance_schema.replication_group_communication_information
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=337: SQL: show GLOBAL variables where `variable_name` in ('persisted_globals_load')
2024-04-11 14:20:37: Info: Using Group Replication local address: db2-2.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:37: Info: Using Group Replication group seeds: db2-0.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:37: Info: Using Group Replication failover consistency: EVENTUAL
2024-04-11 14:20:37: Info: Using Group Replication expel timeout: 5
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=337: SQL: SELECT plugin_status FROM information_schema.plugins WHERE plugin_name = 'group_replication'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=337: SQL: show GLOBAL variables where `variable_name` in ('group_replication_gtid_assignment_block_size')
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=153: SQL: show GLOBAL variables where `variable_name` in ('group_replication_gtid_assignment_block_size')
2024-04-11 14:20:37: Info: Validating if 'group_replication_gtid_assignment_block_size' variable has the same value on target instance 'db2-2.db2-endpoints.o7.svc.cluster.local:3306' as it does on the cluster.
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=42326: SQL: SELECT COUNT(*) as count FROM mysql_innodb_cluster_metadata.instances WHERE cluster_id = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=337: SQL: SELECT plugin_status FROM information_schema.plugins WHERE plugin_name = 'clone'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=42326: SQL: SELECT attributes->'$.opt_disableClone' FROM mysql_innodb_cluster_metadata.clusters WHERE cluster_id='827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=337: SQL: show GLOBAL variables where `variable_name` in ('group_replication_clone_threshold')
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=337: SQL: SET GLOBAL `group_replication_clone_threshold` = 1
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=337: SQL: RESET MASTER
2024-04-11 14:20:37: Info: Installing the clone plugin on instance 'db2-2.db2-endpoints.o7.svc.cluster.local:3306'.
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=337: SQL: SELECT plugin_status FROM information_schema.plugins WHERE plugin_name = 'clone'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=42326: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:37: Info: Connecting to MySQL at: mysql://clusteradmin@db2-0.db2-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=164: CONNECTED: db2-0.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=164: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=164: 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'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=164: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=164: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=164: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=164: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=164: SQL: SELECT @@server_uuid
2024-04-11 14:20:37: Info: Installing the clone plugin on instance 'db2-0.db2-endpoints.o7.svc.cluster.local:3306'.
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=164: SQL: SELECT plugin_status FROM information_schema.plugins WHERE plugin_name = 'clone'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=42326: SQL: SELECT (attributes->>'$.recoveryAccountUser') as recovery_user, (attributes->>'$.recoveryAccountHost') as recovery_host FROM mysql_innodb_cluster_metadata.instances  WHERE mysql_server_uuid = '1111c4e6-f803-11ee-897c-82ac0a512f1b'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=42325: SQL: GRANT BACKUP_ADMIN ON *.* TO 'mysql_innodb_cluster_3112003636'@'%'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=42326: SQL: SELECT attributes->'$.opt_replicationAllowedHost' FROM mysql_innodb_cluster_metadata.clusters WHERE cluster_id='827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:37: Info: Creating recovery account 'mysql_innodb_cluster_628041534'@'%' for instance 'db2-2.db2-endpoints.o7.svc.cluster.local:3306'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=42325: SQL: SELECT host from mysql.user where user='mysql_innodb_cluster_628041534'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=153: 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
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=42326: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=42326: SQL: SELECT attributes->'$.opt_memberAuthType' FROM mysql_innodb_cluster_metadata.clusters WHERE cluster_id='827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:37: Info: Cluster.add_instance: tid=42325: SQL: GRANT REPLICATION SLAVE, BACKUP_ADMIN ON *.* TO 'mysql_innodb_cluster_628041534'@'%'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42325: SQL: GRANT GROUP_REPLICATION_STREAM ON *.* TO 'mysql_innodb_cluster_628041534'@'%'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42325: SQL: GRANT CONNECTION_ADMIN ON *.* TO 'mysql_innodb_cluster_628041534'@'%'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST_ONLY `skip_replica_start` = 'ON'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42325: SQL: SELECT @@GLOBAL.GTID_EXECUTED
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=153: SQL: SELECT WAIT_FOR_EXECUTED_GTID_SET('0256f83a-f7fe-11ee-b05b-9e84dc9f859f:1-39850,\n0256fb52-f7fe-11ee-b05b-9e84dc9f859f:1-5,\nd2b18318-f7fd-11ee-bf06-9e84dc9f859f:1-4', 2)
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42326: 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42326: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42326: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42326: 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 = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f' AND m.invalidated = 0
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42326: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42326: 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
2024-04-11 14:20:38: Info: Connecting to MySQL at: mysql://clusteradmin@db1-2.db1-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: CONNECTED: db1-2.db1-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: 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'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: SQL: SELECT @@server_uuid
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: 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
2024-04-11 14:20:38: Info: Connecting to MySQL at: mysql://clusteradmin@db1-2.db1-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: CONNECTED: db1-2.db1-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: 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'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: SQL: SELECT @@server_uuid
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: SQL: select cluster_type from `mysql_innodb_cluster_metadata`.v2_this_instance
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: SQL: SELECT member_state FROM performance_schema.replication_group_members WHERE member_id = @@server_uuid OR (member_id = '' AND member_state = 'OFFLINE')
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: 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
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42366: SQL: SELECT @@group_replication_single_primary_mode,        variable_value AS primary_uuid   FROM performance_schema.global_status   WHERE variable_name = 'group_replication_primary_member'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: 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 = '09a7135d-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: 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 = '09a7135d-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: SQL: SELECT clusterset_id, domain_name FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: 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 = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f' AND m.invalidated = 0
2024-04-11 14:20:38: Info: Connecting to MySQL at: mysql://clusteradmin@db2-0.db2-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: CONNECTED: db2-0.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: 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'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: SQL: SELECT @@server_uuid
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: 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
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: SQL: SELECT * FROM mysql.slave_master_info WHERE channel_name = '__mysql_innodb_cluster_creating_cluster__'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: SQL: SHOW DATABASES LIKE 'mysql_innodb_cluster_metadata_bkp'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: SQL: SELECT `major`, `minor`, `patch` FROM `mysql_innodb_cluster_metadata`.`schema_version`
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: 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 = 'db2-0.db2-endpoints.o7.svc.cluster.local:3306'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: SQL: SELECT domain_name, clusterset_id FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=165: SQL: SELECT MAX(view_id) FROM mysql_innodb_cluster_metadata.clusterset_views WHERE clusterset_id = '0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: SQL: SELECT attributes->'$.opt_clusterSetReplicationSslMode' FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id='0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42367: SQL: SELECT attributes->'$.opt_memberAuthType' FROM mysql_innodb_cluster_metadata.clustersets WHERE clusterset_id='0afefb24-f7fe-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:38: Info: Cluster.add_instance: tid=42326: SQL: SELECT (attributes->>'$.replicationAccountUser') as replication_user, (attributes->>'$.replicationAccountHost') as replication_host FROM mysql_innodb_cluster_metadata.clusters  WHERE cluster_id = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:38: Info: Resetting password for mysql_innodb_cs_b97d6834@% at db1-2.db1-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:39: Info: Cluster.add_instance: tid=153: 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
2024-04-11 14:20:39: Info: Cluster.add_instance: tid=42326: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:39: Info: Connecting to MySQL at: mysql://clusteradmin@db2-0.db2-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:39: Info: Cluster.add_instance: tid=166: CONNECTED: db2-0.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:39: Info: Cluster.add_instance: tid=166: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:39: Info: Cluster.add_instance: tid=166: 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'
2024-04-11 14:20:39: Info: Cluster.add_instance: tid=166: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:39: Info: Cluster.add_instance: tid=166: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:39: Info: Cluster.add_instance: tid=166: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:39: Info: Cluster.add_instance: tid=166: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:39: Info: Cluster.add_instance: tid=166: SQL: SELECT @@server_uuid
2024-04-11 14:20:39: Info: Stopping channel 'clusterset_replication' at db2-0.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:39: Info: Cluster.add_instance: tid=166: 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'
2024-04-11 14:20:39: Info: Cluster.add_instance: tid=166: SQL: STOP REPLICA FOR CHANNEL 'clusterset_replication'
2024-04-11 14:20:40: Info: Starting channel 'clusterset_replication' at db2-0.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:40: Info: Cluster.add_instance: tid=166: SQL: START REPLICA FOR CHANNEL 'clusterset_replication'
2024-04-11 14:20:41: Info: Stopping channel 'clusterset_replication' at db2-2.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:41: Info: Cluster.add_instance: tid=337: 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'
2024-04-11 14:20:41: Info: db2-2.db2-endpoints.o7.svc.cluster.local:3306: Replication channel 'clusterset_replication' does not exist. Skipping stop.
2024-04-11 14:20:41: Info: Setting up async source for channel 'clusterset_replication' of db2-2.db2-endpoints.o7.svc.cluster.local:3306 to db1-2.db1-endpoints.o7.svc.cluster.local:3306 (user 'mysql_innodb_cs_b97d6834')
2024-04-11 14:20:42: Info: Fencing new instance 'db2-2.db2-endpoints.o7.svc.cluster.local:3306' to prevent updates.
2024-04-11 14:20:42: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `SUPER_READ_ONLY` = 'ON'
2024-04-11 14:20:42: Info: Cluster.add_instance: tid=337: SQL: SELECT NOW(3)
2024-04-11 14:20:42: Info: Cluster.add_instance: tid=42326: SQL: SELECT attributes->'$.opt_memberAuthType' FROM mysql_innodb_cluster_metadata.clusters WHERE cluster_id='827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:42: Info: Joining 'db2-2.db2-endpoints.o7.svc.cluster.local:3306' to cluster using account 'clusteradmin' to peer 'db2-0.db2-endpoints.o7.svc.cluster.local:3306'.
2024-04-11 14:20:42: Info: Cluster.add_instance: tid=337: SQL: SET SESSION sql_log_bin=0
2024-04-11 14:20:42: Info: Cluster.add_instance: tid=337: SQL: show GLOBAL variables where `variable_name` in ('super_read_only')
2024-04-11 14:20:42: Info: Cluster.add_instance: tid=337: SQL: SET GLOBAL `super_read_only` = 'OFF'
2024-04-11 14:20:42: Info: Cluster.add_instance: tid=42326: SQL: SELECT attributes->'$.opt_replicationAllowedHost' FROM mysql_innodb_cluster_metadata.clusters WHERE cluster_id='827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:42: Info: Creating recovery account 'mysql_innodb_cluster_628041534'@'%' for instance 'db2-2.db2-endpoints.o7.svc.cluster.local:3306'
2024-04-11 14:20:42: Info: Cluster.add_instance: tid=337: SQL: SELECT host from mysql.user where user='mysql_innodb_cluster_628041534'
2024-04-11 14:20:42: Info: Cluster.add_instance: tid=153: 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
2024-04-11 14:20:42: Info: Cluster.add_instance: tid=42326: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:42: Info: Cluster.add_instance: tid=42326: SQL: SELECT attributes->'$.opt_memberAuthType' FROM mysql_innodb_cluster_metadata.clusters WHERE cluster_id='827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:42: Info: Cluster.add_instance: tid=337: SQL: GRANT REPLICATION SLAVE, BACKUP_ADMIN ON *.* TO 'mysql_innodb_cluster_628041534'@'%'
2024-04-11 14:20:42: Info: Cluster.add_instance: tid=337: SQL: GRANT GROUP_REPLICATION_STREAM ON *.* TO 'mysql_innodb_cluster_628041534'@'%'
2024-04-11 14:20:43: Info: Cluster.add_instance: tid=337: SQL: GRANT CONNECTION_ADMIN ON *.* TO 'mysql_innodb_cluster_628041534'@'%'
2024-04-11 14:20:43: Info: Cluster.add_instance: tid=153: 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
2024-04-11 14:20:43: Info: Cluster.add_instance: tid=42326: 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, IFNULL(CAST(ii.attributes->'$.tags._hidden' AS UNSIGNED), false) hidden_from_router 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 = '827e931a-f80e-11ee-b05b-9e84dc9f859f'
2024-04-11 14:20:43: Info: Connecting to MySQL at: mysql://clusteradmin@db2-0.db2-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:43: Info: Cluster.add_instance: tid=180: CONNECTED: db2-0.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:43: Info: Cluster.add_instance: tid=180: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:43: Info: Cluster.add_instance: tid=180: 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'
2024-04-11 14:20:43: Info: Cluster.add_instance: tid=180: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:43: Info: Cluster.add_instance: tid=180: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:43: Info: Cluster.add_instance: tid=180: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:43: Info: Cluster.add_instance: tid=180: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:43: Info: Cluster.add_instance: tid=180: SQL: SELECT @@server_uuid
2024-04-11 14:20:44: Info: Cluster.add_instance: tid=337: SQL: SET SESSION sql_log_bin=1
2024-04-11 14:20:44: Info: Cluster.add_instance: tid=337: SQL: show GLOBAL variables where `variable_name` in ('offline_mode')
2024-04-11 14:20:44: Info: Cluster.add_instance: tid=153: 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
2024-04-11 14:20:44: Info: Cluster.add_instance: tid=337: SQL: SET GLOBAL `group_replication_recovery_ssl_ca` = DEFAULT
2024-04-11 14:20:44: Info: Cluster.add_instance: tid=337: SQL: SET GLOBAL `group_replication_recovery_ssl_capath` = DEFAULT
2024-04-11 14:20:44: Info: Cluster.add_instance: tid=337: SQL: SET GLOBAL `group_replication_recovery_ssl_cipher` = DEFAULT
2024-04-11 14:20:44: Info: Cluster.add_instance: tid=337: SQL: SET GLOBAL `group_replication_recovery_ssl_crl` = DEFAULT
2024-04-11 14:20:44: Info: Cluster.add_instance: tid=337: SQL: SET GLOBAL `group_replication_recovery_ssl_crlpath` = DEFAULT
2024-04-11 14:20:44: Info: Cluster.add_instance: tid=337: SQL: SET GLOBAL `group_replication_recovery_tls_version` = DEFAULT
2024-04-11 14:20:44: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `super_read_only` = 'ON'
2024-04-11 14:20:44: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `group_replication_group_name` = '6c6dc026-f80e-11ee-b801-82ac0a512f1b'
2024-04-11 14:20:44: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `group_replication_view_change_uuid` = '6c6dc717-f80e-11ee-b801-82ac0a512f1b'
2024-04-11 14:20:44: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `group_replication_enforce_update_everywhere_checks` = 'OFF'
2024-04-11 14:20:44: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `group_replication_single_primary_mode` = 'ON'
2024-04-11 14:20:44: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `group_replication_recovery_use_ssl` = 'ON'
2024-04-11 14:20:44: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `group_replication_recovery_ssl_verify_server_cert` = 'OFF'
2024-04-11 14:20:45: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `group_replication_ssl_mode` = 'REQUIRED'
2024-04-11 14:20:45: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `group_replication_local_address` = 'db2-2.db2-endpoints.o7.svc.cluster.local:3306'
2024-04-11 14:20:46: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `group_replication_group_seeds` = 'db2-0.db2-endpoints.o7.svc.cluster.local:3306'
2024-04-11 14:20:46: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:46: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `group_replication_member_expel_timeout` = 5
2024-04-11 14:20:46: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `group_replication_start_on_boot` = 'ON'
2024-04-11 14:20:46: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `group_replication_communication_stack` = 'MYSQL'
2024-04-11 14:20:47: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `group_replication_transaction_size_limit` = 0
2024-04-11 14:20:47: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `group_replication_paxos_single_leader` = 'OFF'
2024-04-11 14:20:47: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `auto_increment_increment` = 1
2024-04-11 14:20:47: Info: Cluster.add_instance: tid=337: SQL: SET PERSIST `auto_increment_offset` = 2
2024-04-11 14:20:48: Info: Cluster.add_instance: tid=337: SQL: SELECT NOW(6)
2024-04-11 14:20:48: Info: Cluster.add_instance: tid=337: SQL: START GROUP_REPLICATION
2024-04-11 14:20:52: Info: Waiting for GR recovery to start for db2-2.db2-endpoints.o7.svc.cluster.local:3306...
2024-04-11 14:20:52: Info: Connecting to MySQL at: mysql://clusteradmin@db2-2.db2-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=359: CONNECTED: db2-2.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=359: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=359: 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'
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=359: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=359: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=359: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=359: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=359: SQL: SELECT @@server_uuid
2024-04-11 14:20:52: Info: db2-2.db2-endpoints.o7.svc.cluster.local:3306 has started
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=359: SQL: SELECT (SELECT count(*)   FROM performance_schema.replication_applier_status_by_worker a   JOIN performance_schema.replication_connection_status c     ON a.channel_name = c.channel_name   WHERE a.channel_name = 'group_replication_recovery'     AND ((a.service_state = 'ON' OR a.last_error_message <> '')          OR (c.service_state = 'ON' OR c.last_error_message <> '')) ) recovery, (SELECT member_state   FROM performance_schema.replication_group_members   WHERE member_id = @@server_uuid) member_state, (SELECT concat(state, '@', begin_time)   FROM performance_schema.clone_status   WHERE begin_time >= '2024-04-11 14:20:42.725') clone
2024-04-11 14:20:52: Info: Connecting to MySQL at: mysql://clusteradmin@db2-2.db2-endpoints.o7.svc.cluster.local:3306?connect-timeout=5000
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=362: CONNECTED: db2-2.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=362: SQL: SET SESSION `autocommit` = 1
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=362: 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'
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=362: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL'
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=362: SQL: SET SESSION `collation_connection` = 'utf8mb4_0900_ai_ci'
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=362: SQL: SET SESSION `group_concat_max_len` = 1073741824
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=362: SQL: SELECT COALESCE(@@report_host, @@hostname),  COALESCE(@@report_port, @@port)
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=362: SQL: SELECT @@server_uuid
2024-04-11 14:20:52: Info: A server restart is expected to happen as part of the clone process. If the
server does not support the RESTART command or does not come back after a
while, you may need to manually start it back.
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_status WHERE begin_time >= '2024-04-11 14:20:42.725' ORDER BY id DESC LIMIT 1
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_progress WHERE id = 1 AND begin_time >= '2024-04-11 14:20:42.725'
2024-04-11 14:20:52: Info: db2-2.db2-endpoints.o7.svc.cluster.local:3306 is being cloned from db2-0.db2-endpoints.o7.svc.cluster.local:3306
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_status WHERE begin_time >= '2024-04-11 14:20:42.725' ORDER BY id DESC LIMIT 1
2024-04-11 14:20:52: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_progress WHERE id = 1 AND begin_time >= '2024-04-11 14:20:42.725'
2024-04-11 14:20:53: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_status WHERE begin_time >= '2024-04-11 14:20:42.725' ORDER BY id DESC LIMIT 1
2024-04-11 14:20:53: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_progress WHERE id = 1 AND begin_time >= '2024-04-11 14:20:42.725'
2024-04-11 14:20:53: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_status WHERE begin_time >= '2024-04-11 14:20:42.725' ORDER BY id DESC LIMIT 1
2024-04-11 14:20:53: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_progress WHERE id = 1 AND begin_time >= '2024-04-11 14:20:42.725'
2024-04-11 14:20:54: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_status WHERE begin_time >= '2024-04-11 14:20:42.725' ORDER BY id DESC LIMIT 1
2024-04-11 14:20:54: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_progress WHERE id = 1 AND begin_time >= '2024-04-11 14:20:42.725'
2024-04-11 14:20:54: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_status WHERE begin_time >= '2024-04-11 14:20:42.725' ORDER BY id DESC LIMIT 1
2024-04-11 14:20:54: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_progress WHERE id = 1 AND begin_time >= '2024-04-11 14:20:42.725'
2024-04-11 14:20:55: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_status WHERE begin_time >= '2024-04-11 14:20:42.725' ORDER BY id DESC LIMIT 1
2024-04-11 14:20:55: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_progress WHERE id = 1 AND begin_time >= '2024-04-11 14:20:42.725'
2024-04-11 14:20:55: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_status WHERE begin_time >= '2024-04-11 14:20:42.725' ORDER BY id DESC LIMIT 1
2024-04-11 14:20:55: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_progress WHERE id = 1 AND begin_time >= '2024-04-11 14:20:42.725'
2024-04-11 14:20:56: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_status WHERE begin_time >= '2024-04-11 14:20:42.725' ORDER BY id DESC LIMIT 1
2024-04-11 14:20:56: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_progress WHERE id = 1 AND begin_time >= '2024-04-11 14:20:42.725'
2024-04-11 14:20:56: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_status WHERE begin_time >= '2024-04-11 14:20:42.725' ORDER BY id DESC LIMIT 1
2024-04-11 14:20:56: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_progress WHERE id = 1 AND begin_time >= '2024-04-11 14:20:42.725'
2024-04-11 14:20:57: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_status WHERE begin_time >= '2024-04-11 14:20:42.725' ORDER BY id DESC LIMIT 1
2024-04-11 14:20:57: Info: Cluster.add_instance: tid=362: SQL: SELECT *, end_time-begin_time as elapsed FROM performance_schema.clone_progress WHERE id = 1 AND begin_time >= '2024-04-11 14:20:42.725'

# Reporter comment: log trimmed here. Line keep repeating