[jayj@ip-10-160-132-218 ~]$ mysql-shell --cluster 10.160.132.218:3306 --log-sql=on --verbose=2 verbose: 2022-10-28T17:09:28Z: Loading startup files... verbose: 2022-10-28T17:09:28Z: Searching for plugins at '/usr/lib/mysqlsh/plugins' verbose: 2022-10-28T17:09:28Z: Loading plugins... verbose: 2022-10-28T17:09:28Z: - /usr/lib/mysqlsh/plugins/debug/init.py verbose: 2022-10-28T17:09:28Z: The 'debug' extension object has been registered as a member into the 'util' extension object. verbose: 2022-10-28T17:09:28Z: The 'collectDiagnostics' function has been registered into the 'debug' extension object. verbose: 2022-10-28T17:09:28Z: The 'collectHighLoadDiagnostics' function has been registered into the 'debug' extension object. verbose: 2022-10-28T17:09:28Z: The 'collectSlowQueryDiagnostics' function has been registered into the 'debug' extension object. verbose: 2022-10-28T17:09:28Z: - /usr/lib/mysqlsh/plugins/plugins_plugin/init.py verbose: 2022-10-28T17:09:28Z: The 'plugins' extension object has been registered as a global object. verbose: 2022-10-28T17:09:28Z: The 'repositories' extension object has been registered as a member into the 'plugins' extension object. verbose: 2022-10-28T17:09:28Z: The 'list' function has been registered into the 'repositories' extension object. verbose: 2022-10-28T17:09:28Z: The 'add' function has been registered into the 'repositories' extension object. verbose: 2022-10-28T17:09:28Z: The 'remove' function has been registered into the 'repositories' extension object. verbose: 2022-10-28T17:09:28Z: The 'info' function has been registered into the 'plugins' extension object. verbose: 2022-10-28T17:09:28Z: The 'version' function has been registered into the 'plugins' extension object. verbose: 2022-10-28T17:09:28Z: The 'about' function has been registered into the 'plugins' extension object. verbose: 2022-10-28T17:09:28Z: The 'list' function has been registered into the 'plugins' extension object. verbose: 2022-10-28T17:09:28Z: The 'install' function has been registered into the 'plugins' extension object. verbose: 2022-10-28T17:09:28Z: The 'uninstall' function has been registered into the 'plugins' extension object. verbose: 2022-10-28T17:09:28Z: The 'update' function has been registered into the 'plugins' extension object. verbose: 2022-10-28T17:09:28Z: The 'details' function has been registered into the 'plugins' extension object. verbose: 2022-10-28T17:09:28Z: Using color mode 2 verbose: 2022-10-28T17:09:28Z: Connecting to MySQL at: config@10.160.132.218:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca verbose: 2022-10-28T17:09:28Z: main: tid=5925: CONNECTED: 10.160.132.218:3306 MySQL Shell 8.0.31 Copyright (c) 2016, 2022, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type '\help' or '\?' for help; '\quit' to exit. Creating a session to 'config@10.160.132.218:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca' Fetching schema names for auto-completion... Press ^C to stop. Your MySQL connection id is 5925 Server version: 8.0.31 MySQL Community Server - GPL No default schema selected; type \use to set one. verbose: 2022-10-28T17:09:28Z: Connecting to MySQL at: mysql://config@10.160.132.218:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:09:28Z: main: tid=5926: CONNECTED: 10.160.132.218:3306 verbose: 2022-10-28T17:09:28Z: main: tid=5926: SQL: SET SESSION `autocommit` = 1 verbose: 2022-10-28T17:09:28Z: main: tid=5926: 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' verbose: 2022-10-28T17:09:28Z: main: tid=5926: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' verbose: 2022-10-28T17:09:28Z: Metadata operations will use 10.160.132.218:3306 verbose: 2022-10-28T17:09:28Z: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null verbose: 2022-10-28T17:09:28Z: Instance type check: 10.160.132.218:3306: Metadata version 2.1.0 found verbose: 2022-10-28T17:09:28Z: Instance type check: 10.160.132.218:3306: Cluster metadata record found (metadata 2.1.0) verbose: 2022-10-28T17:09:28Z: Instance 60d40df3-56dd-11ed-8778-02ce79cb17b9 is managed for GROUP-REPLICATION verbose: 2022-10-28T17:09:28Z: Instance type check: 10.160.132.218:3306: GR is active verbose: 2022-10-28T17:09:28Z: Metadata operations will use 10.160.132.218:3306 verbose: 2022-10-28T17:09:28Z: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null verbose: 2022-10-28T17:09:28Z: Instance type check: 10.160.132.218:3306: Cluster metadata record found (metadata 2.1.0) verbose: 2022-10-28T17:09:28Z: Refreshing metadata cache from '10.160.132.218:3306' verbose: 2022-10-28T17:09:28Z: I) 10.160.132.218:3306 10.160.132.218:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:28Z: I) 10.168.138.241:3306 10.168.138.241:3306 (jaytest-development-001-usw2) verbose: 2022-10-28T17:09:28Z: I) 10.160.132.29:3306 10.160.132.29:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:28Z: I) 10.160.133.190:3306 10.160.133.190:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:28Z: C) 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 'jaytest-development-001-use1' verbose: 2022-10-28T17:09:28Z: C) a1e8de84-56dd-11ed-8c29-02eb68887bf5 'jaytest-development-001-usw2' verbose: 2022-10-28T17:09:28Z: DONE! verbose: 2022-10-28T17:09:28Z: Instance type check: 10.160.132.218:3306: Metadata version 2.1.0 found verbose: 2022-10-28T17:09:28Z: Instance type check: 10.160.132.218:3306: Cluster metadata record found (metadata 2.1.0) verbose: 2022-10-28T17:09:28Z: Instance 60d40df3-56dd-11ed-8778-02ce79cb17b9 is managed for GROUP-REPLICATION verbose: 2022-10-28T17:09:28Z: Instance type check: 10.160.132.218:3306: GR is active verbose: 2022-10-28T17:09:28Z: Group Replication 'group_name' value: 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 verbose: 2022-10-28T17:09:28Z: Metadata 'group_name' value: 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 verbose: 2022-10-28T17:09:28Z: Primary cluster is 'jaytest-development-001-use1' verbose: 2022-10-28T17:09:28Z: Refreshing metadata cache from '10.160.132.218:3306' verbose: 2022-10-28T17:09:28Z: I) 10.160.132.218:3306 10.160.132.218:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:28Z: I) 10.168.138.241:3306 10.168.138.241:3306 (jaytest-development-001-usw2) verbose: 2022-10-28T17:09:28Z: I) 10.160.132.29:3306 10.160.132.29:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:28Z: I) 10.160.133.190:3306 10.160.133.190:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:28Z: C) 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 'jaytest-development-001-use1' verbose: 2022-10-28T17:09:28Z: C) a1e8de84-56dd-11ed-8c29-02eb68887bf5 'jaytest-development-001-usw2' verbose: 2022-10-28T17:09:28Z: DONE! verbose: 2022-10-28T17:09:28Z: Connecting to MySQL at: mysql://config@10.160.132.218:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:09:28Z: main: tid=5927: CONNECTED: 10.160.132.218:3306 verbose: 2022-10-28T17:09:28Z: main: tid=5927: SQL: SET SESSION `autocommit` = 1 verbose: 2022-10-28T17:09:28Z: main: tid=5927: 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' verbose: 2022-10-28T17:09:28Z: main: tid=5927: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' verbose: 2022-10-28T17:09:28Z: Metadata operations will use 10.160.132.218:3306 verbose: 2022-10-28T17:09:28Z: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null verbose: 2022-10-28T17:09:28Z: Metadata operations will use 10.160.132.218:3306 verbose: 2022-10-28T17:09:28Z: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null verbose: 2022-10-28T17:09:28Z: Instance type check: 10.160.132.218:3306: Cluster metadata record found (metadata 2.1.0) verbose: 2022-10-28T17:09:28Z: Checking if primary cluster 'jaytest-development-001-use1' (id=9971936f-56dd-11ed-ae90-02ce79cb17b9, view_id_generation=0) has the most recent clusterset metadata verbose: 2022-10-28T17:09:28Z: Connecting to MySQL at: mysql://config@10.168.138.241:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:09:33Z: warning: 10.168.138.241:3306: MySQL Error 2003: Could not open connection to '10.168.138.241:3306': Can't connect to MySQL server on '10.168.138.241:3306' (110) verbose: 2022-10-28T17:09:33Z: Refreshing metadata cache from '10.160.132.218:3306' verbose: 2022-10-28T17:09:33Z: I) 10.160.132.218:3306 10.160.132.218:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:33Z: I) 10.168.138.241:3306 10.168.138.241:3306 (jaytest-development-001-usw2) verbose: 2022-10-28T17:09:33Z: I) 10.160.132.29:3306 10.160.132.29:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:33Z: I) 10.160.133.190:3306 10.160.133.190:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:33Z: C) 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 'jaytest-development-001-use1' verbose: 2022-10-28T17:09:33Z: C) a1e8de84-56dd-11ed-8c29-02eb68887bf5 'jaytest-development-001-usw2' verbose: 2022-10-28T17:09:33Z: DONE! verbose: 2022-10-28T17:09:33Z: Checking if primary cluster 'jaytest-development-001-use1' (id=9971936f-56dd-11ed-ae90-02ce79cb17b9, view_id_generation=0) has the most recent clusterset metadata verbose: 2022-10-28T17:09:33Z: Connecting to MySQL at: mysql://config@10.168.138.241:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:09:38Z: warning: 10.168.138.241:3306: MySQL Error 2003: Could not open connection to '10.168.138.241:3306': Can't connect to MySQL server on '10.168.138.241:3306' (110) verbose: 2022-10-28T17:09:38Z: Connecting to MySQL at: mysql://config@10.160.132.218:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:09:38Z: main: tid=5949: CONNECTED: 10.160.132.218:3306 verbose: 2022-10-28T17:09:38Z: main: tid=5949: SQL: SET SESSION `autocommit` = 1 verbose: 2022-10-28T17:09:38Z: main: tid=5949: 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' verbose: 2022-10-28T17:09:38Z: main: tid=5949: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' verbose: 2022-10-28T17:09:38Z: Metadata operations will use 10.160.132.218:3306 verbose: 2022-10-28T17:09:38Z: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null verbose: 2022-10-28T17:09:38Z: Instance type check: 10.160.132.218:3306: Metadata version 2.1.0 found verbose: 2022-10-28T17:09:38Z: Instance type check: 10.160.132.218:3306: Cluster metadata record found (metadata 2.1.0) verbose: 2022-10-28T17:09:38Z: Instance 60d40df3-56dd-11ed-8778-02ce79cb17b9 is managed for GROUP-REPLICATION verbose: 2022-10-28T17:09:38Z: Instance type check: 10.160.132.218:3306: GR is active verbose: 2022-10-28T17:09:38Z: Refreshing metadata cache from '10.160.132.218:3306' verbose: 2022-10-28T17:09:38Z: I) 10.160.132.218:3306 10.160.132.218:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:38Z: I) 10.168.138.241:3306 10.168.138.241:3306 (jaytest-development-001-usw2) verbose: 2022-10-28T17:09:38Z: I) 10.160.132.29:3306 10.160.132.29:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:38Z: I) 10.160.133.190:3306 10.160.133.190:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:38Z: C) 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 'jaytest-development-001-use1' verbose: 2022-10-28T17:09:38Z: C) a1e8de84-56dd-11ed-8c29-02eb68887bf5 'jaytest-development-001-usw2' verbose: 2022-10-28T17:09:38Z: DONE! verbose: 2022-10-28T17:09:38Z: Group Replication 'group_name' value: 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 verbose: 2022-10-28T17:09:38Z: Metadata 'group_name' value: 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 verbose: 2022-10-28T17:09:38Z: Primary cluster is 'jaytest-development-001-use1' verbose: 2022-10-28T17:09:38Z: Refreshing metadata cache from '10.160.132.218:3306' verbose: 2022-10-28T17:09:38Z: I) 10.160.132.218:3306 10.160.132.218:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:38Z: I) 10.168.138.241:3306 10.168.138.241:3306 (jaytest-development-001-usw2) verbose: 2022-10-28T17:09:38Z: I) 10.160.132.29:3306 10.160.132.29:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:38Z: I) 10.160.133.190:3306 10.160.133.190:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:38Z: C) 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 'jaytest-development-001-use1' verbose: 2022-10-28T17:09:38Z: C) a1e8de84-56dd-11ed-8c29-02eb68887bf5 'jaytest-development-001-usw2' verbose: 2022-10-28T17:09:38Z: DONE! verbose: 2022-10-28T17:09:38Z: Connecting to MySQL at: mysql://config@10.160.132.218:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:09:38Z: main: tid=5950: CONNECTED: 10.160.132.218:3306 verbose: 2022-10-28T17:09:38Z: main: tid=5950: SQL: SET SESSION `autocommit` = 1 verbose: 2022-10-28T17:09:38Z: main: tid=5950: 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' verbose: 2022-10-28T17:09:38Z: main: tid=5950: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' verbose: 2022-10-28T17:09:38Z: Metadata operations will use 10.160.132.218:3306 verbose: 2022-10-28T17:09:38Z: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null verbose: 2022-10-28T17:09:38Z: Metadata operations will use 10.160.132.218:3306 verbose: 2022-10-28T17:09:38Z: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null verbose: 2022-10-28T17:09:38Z: Instance type check: 10.160.132.218:3306: Cluster metadata record found (metadata 2.1.0) verbose: 2022-10-28T17:09:38Z: Checking if primary cluster 'jaytest-development-001-use1' (id=9971936f-56dd-11ed-ae90-02ce79cb17b9, view_id_generation=0) has the most recent clusterset metadata verbose: 2022-10-28T17:09:38Z: Connecting to MySQL at: mysql://config@10.168.138.241:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:09:43Z: warning: 10.168.138.241:3306: MySQL Error 2003: Could not open connection to '10.168.138.241:3306': Can't connect to MySQL server on '10.168.138.241:3306' (110) verbose: 2022-10-28T17:09:43Z: Refreshing metadata cache from '10.160.132.218:3306' verbose: 2022-10-28T17:09:43Z: I) 10.160.132.218:3306 10.160.132.218:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:43Z: I) 10.168.138.241:3306 10.168.138.241:3306 (jaytest-development-001-usw2) verbose: 2022-10-28T17:09:43Z: I) 10.160.132.29:3306 10.160.132.29:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:43Z: I) 10.160.133.190:3306 10.160.133.190:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:43Z: C) 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 'jaytest-development-001-use1' verbose: 2022-10-28T17:09:43Z: C) a1e8de84-56dd-11ed-8c29-02eb68887bf5 'jaytest-development-001-usw2' verbose: 2022-10-28T17:09:43Z: DONE! verbose: 2022-10-28T17:09:43Z: Checking if primary cluster 'jaytest-development-001-use1' (id=9971936f-56dd-11ed-ae90-02ce79cb17b9, view_id_generation=0) has the most recent clusterset metadata verbose: 2022-10-28T17:09:43Z: Connecting to MySQL at: mysql://config@10.168.138.241:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:09:48Z: warning: 10.168.138.241:3306: MySQL Error 2003: Could not open connection to '10.168.138.241:3306': Can't connect to MySQL server on '10.168.138.241:3306' (110) verbose: 2022-10-28T17:09:48Z: Using prompt theme file /usr/share/mysqlsh/prompt/prompt_256.json You are connected to a member of cluster 'jaytest-development-001-use1'. Variable 'cluster' is set. Use cluster.status() in scripting mode to get status of this cluster or \? Cluster for more commands. You are connected to a member of clusterset 'jaytest-development-001'. Variable 'clusterset' is set. Use clusterset.status() in scripting mode to get status of this clusterset or \? ClusterSet for more commands. MySQL 10.160.132.218:3306 ssl JS > clusterset.status() verbose: 2022-10-28T17:09:53Z: Refreshing metadata cache from '10.160.132.218:3306' verbose: 2022-10-28T17:09:53Z: I) 10.160.132.218:3306 10.160.132.218:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:53Z: I) 10.168.138.241:3306 10.168.138.241:3306 (jaytest-development-001-usw2) verbose: 2022-10-28T17:09:53Z: I) 10.160.132.29:3306 10.160.132.29:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:53Z: I) 10.160.133.190:3306 10.160.133.190:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:53Z: C) 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 'jaytest-development-001-use1' verbose: 2022-10-28T17:09:53Z: C) a1e8de84-56dd-11ed-8c29-02eb68887bf5 'jaytest-development-001-usw2' verbose: 2022-10-28T17:09:53Z: DONE! verbose: 2022-10-28T17:09:53Z: Primary cluster is 'jaytest-development-001-use1' verbose: 2022-10-28T17:09:53Z: Refreshing metadata cache from '10.160.132.218:3306' verbose: 2022-10-28T17:09:53Z: I) 10.160.132.218:3306 10.160.132.218:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:53Z: I) 10.168.138.241:3306 10.168.138.241:3306 (jaytest-development-001-usw2) verbose: 2022-10-28T17:09:53Z: I) 10.160.132.29:3306 10.160.132.29:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:53Z: I) 10.160.133.190:3306 10.160.133.190:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:53Z: C) 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 'jaytest-development-001-use1' verbose: 2022-10-28T17:09:53Z: C) a1e8de84-56dd-11ed-8c29-02eb68887bf5 'jaytest-development-001-usw2' verbose: 2022-10-28T17:09:53Z: DONE! verbose: 2022-10-28T17:09:53Z: Connecting to MySQL at: mysql://config@10.160.132.218:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:09:53Z: ClusterSet.status: tid=5984: CONNECTED: 10.160.132.218:3306 verbose: 2022-10-28T17:09:53Z: ClusterSet.status: tid=5984: SQL: SET SESSION `autocommit` = 1 verbose: 2022-10-28T17:09:53Z: ClusterSet.status: tid=5984: 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' verbose: 2022-10-28T17:09:53Z: ClusterSet.status: tid=5984: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' verbose: 2022-10-28T17:09:53Z: Metadata operations will use 10.160.132.218:3306 verbose: 2022-10-28T17:09:53Z: Checking 'status' preconditions. verbose: 2022-10-28T17:09:53Z: Refreshing metadata cache from '10.160.132.218:3306' verbose: 2022-10-28T17:09:53Z: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null verbose: 2022-10-28T17:09:53Z: I) 10.160.132.218:3306 10.160.132.218:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:53Z: I) 10.168.138.241:3306 10.168.138.241:3306 (jaytest-development-001-usw2) verbose: 2022-10-28T17:09:53Z: I) 10.160.132.29:3306 10.160.132.29:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:53Z: I) 10.160.133.190:3306 10.160.133.190:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:53Z: C) 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 'jaytest-development-001-use1' verbose: 2022-10-28T17:09:53Z: C) a1e8de84-56dd-11ed-8c29-02eb68887bf5 'jaytest-development-001-usw2' verbose: 2022-10-28T17:09:53Z: DONE! verbose: 2022-10-28T17:09:53Z: Primary cluster is 'jaytest-development-001-use1' verbose: 2022-10-28T17:09:53Z: Refreshing metadata cache from '10.160.132.218:3306' verbose: 2022-10-28T17:09:53Z: I) 10.160.132.218:3306 10.160.132.218:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:53Z: I) 10.168.138.241:3306 10.168.138.241:3306 (jaytest-development-001-usw2) verbose: 2022-10-28T17:09:53Z: I) 10.160.132.29:3306 10.160.132.29:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:53Z: I) 10.160.133.190:3306 10.160.133.190:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:09:53Z: C) 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 'jaytest-development-001-use1' verbose: 2022-10-28T17:09:53Z: C) a1e8de84-56dd-11ed-8c29-02eb68887bf5 'jaytest-development-001-usw2' verbose: 2022-10-28T17:09:53Z: DONE! verbose: 2022-10-28T17:09:53Z: Connecting to MySQL at: mysql://config@10.160.132.218:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:09:53Z: ClusterSet.status: tid=5985: CONNECTED: 10.160.132.218:3306 verbose: 2022-10-28T17:09:53Z: ClusterSet.status: tid=5985: SQL: SET SESSION `autocommit` = 1 verbose: 2022-10-28T17:09:53Z: ClusterSet.status: tid=5985: 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' verbose: 2022-10-28T17:09:53Z: ClusterSet.status: tid=5985: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' verbose: 2022-10-28T17:09:53Z: Metadata operations will use 10.160.132.218:3306 verbose: 2022-10-28T17:09:53Z: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null verbose: 2022-10-28T17:09:53Z: Metadata operations will use 10.160.132.218:3306 verbose: 2022-10-28T17:09:53Z: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null verbose: 2022-10-28T17:09:53Z: Instance type check: 10.160.132.218:3306: Cluster metadata record found (metadata 2.1.0) verbose: 2022-10-28T17:09:53Z: Checking if primary cluster 'jaytest-development-001-use1' (id=9971936f-56dd-11ed-ae90-02ce79cb17b9, view_id_generation=0) has the most recent clusterset metadata verbose: 2022-10-28T17:09:53Z: Connecting to MySQL at: mysql://config@10.168.138.241:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:09:58Z: warning: 10.168.138.241:3306: MySQL Error 2003: Could not open connection to '10.168.138.241:3306': Can't connect to MySQL server on '10.168.138.241:3306' (110) verbose: 2022-10-28T17:09:58Z: Instance type check: 10.160.132.218:3306: Metadata version 2.1.0 found verbose: 2022-10-28T17:09:58Z: Instance type check: 10.160.132.218:3306: Cluster metadata record found (metadata 2.1.0) verbose: 2022-10-28T17:09:58Z: Instance 60d40df3-56dd-11ed-8778-02ce79cb17b9 is managed for GROUP-REPLICATION verbose: 2022-10-28T17:09:58Z: Instance type check: 10.160.132.218:3306: GR is active verbose: 2022-10-28T17:09:58Z: Connecting to MySQL at: mysql://config@10.168.138.241:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:10:03Z: warning: 10.168.138.241:3306: MySQL Error 2003: Could not open connection to '10.168.138.241:3306': Can't connect to MySQL server on '10.168.138.241:3306' (110) verbose: 2022-10-28T17:10:03Z: Connecting to MySQL at: mysql://config@10.168.138.241:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:10:08Z: Instance with uuid=8ec80aa3-56dd-11ed-88da-02eb68887bf5 address=10.168.138.241:3306 is in MD but not in group verbose: 2022-10-28T17:10:08Z: Connecting to MySQL at: mysql://config@10.160.132.218:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:10:08Z: ClusterSet.status: tid=6017: CONNECTED: 10.160.132.218:3306 verbose: 2022-10-28T17:10:08Z: ClusterSet.status: tid=6017: SQL: SET SESSION `autocommit` = 1 verbose: 2022-10-28T17:10:08Z: ClusterSet.status: tid=6017: 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' verbose: 2022-10-28T17:10:08Z: ClusterSet.status: tid=6017: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' verbose: 2022-10-28T17:10:08Z: Metadata operations will use 10.160.132.218:3306 verbose: 2022-10-28T17:10:08Z: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null verbose: 2022-10-28T17:10:08Z: Instance type check: 10.160.132.218:3306: GR is active verbose: 2022-10-28T17:10:08Z: Instance type check: 10.160.132.218:3306: GR is active verbose: 2022-10-28T17:10:08Z: Connecting to MySQL at: mysql://config@10.160.132.218:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:10:08Z: ClusterSet.status: tid=6019: CONNECTED: 10.160.132.218:3306 verbose: 2022-10-28T17:10:08Z: ClusterSet.status: tid=6019: SQL: SET SESSION `autocommit` = 1 verbose: 2022-10-28T17:10:08Z: ClusterSet.status: tid=6019: 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' verbose: 2022-10-28T17:10:08Z: ClusterSet.status: tid=6019: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' verbose: 2022-10-28T17:10:08Z: Connecting to MySQL at: mysql://config@10.160.132.29:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:10:08Z: ClusterSet.status: tid=1932: CONNECTED: 10.160.132.29:3306 verbose: 2022-10-28T17:10:08Z: ClusterSet.status: tid=1932: SQL: SET SESSION `autocommit` = 1 verbose: 2022-10-28T17:10:08Z: ClusterSet.status: tid=1932: 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' verbose: 2022-10-28T17:10:08Z: ClusterSet.status: tid=1932: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' verbose: 2022-10-28T17:10:08Z: Connecting to MySQL at: mysql://config@10.160.133.190:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:10:08Z: ClusterSet.status: tid=1819: CONNECTED: 10.160.133.190:3306 verbose: 2022-10-28T17:10:08Z: ClusterSet.status: tid=1819: SQL: SET SESSION `autocommit` = 1 verbose: 2022-10-28T17:10:08Z: ClusterSet.status: tid=1819: 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' verbose: 2022-10-28T17:10:08Z: ClusterSet.status: tid=1819: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' verbose: 2022-10-28T17:10:08Z: Executing UDF: group_replication_get_communication_protocol() verbose: 2022-10-28T17:10:08Z: Instance type check: 10.160.132.218:3306: GR is active verbose: 2022-10-28T17:10:08Z: Instance type check: 10.160.132.218:3306: GR is active verbose: 2022-10-28T17:10:08Z: Instance type check: 10.160.132.218:3306: GR is active verbose: 2022-10-28T17:10:08Z: Instance type check: 10.160.132.218:3306: Metadata record found { "clusters": { "jaytest-development-001-use1": { "clusterRole": "PRIMARY", "globalStatus": "OK", "primary": "10.160.132.218:3306" }, "jaytest-development-001-usw2": { "clusterErrors": [ "ERROR: Could not connect to any ONLINE members but there are unreachable instances that could still be ONLINE." ], "clusterRole": "REPLICA", "clusterSetReplicationStatus": "UNKNOWN", "globalStatus": "UNKNOWN", "status": "UNREACHABLE", "statusText": "Could not connect to any ONLINE members" } }, "domainName": "jaytest-development-001", "globalPrimaryInstance": "10.160.132.218:3306", "primaryCluster": "jaytest-development-001-use1", "status": "AVAILABLE", "statusText": "Primary Cluster available, there are issues with a Replica cluster." } MySQL 10.160.132.218:3306 ssl JS > clusterset.removeCluster("jaytest-development-001-usw2", {force:true}) verbose: 2022-10-28T17:11:01Z: Refreshing metadata cache from '10.160.132.218:3306' verbose: 2022-10-28T17:11:01Z: I) 10.160.132.218:3306 10.160.132.218:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:11:01Z: I) 10.168.138.241:3306 10.168.138.241:3306 (jaytest-development-001-usw2) verbose: 2022-10-28T17:11:01Z: I) 10.160.132.29:3306 10.160.132.29:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:11:01Z: I) 10.160.133.190:3306 10.160.133.190:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:11:01Z: C) 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 'jaytest-development-001-use1' verbose: 2022-10-28T17:11:01Z: C) a1e8de84-56dd-11ed-8c29-02eb68887bf5 'jaytest-development-001-usw2' verbose: 2022-10-28T17:11:01Z: DONE! verbose: 2022-10-28T17:11:01Z: Checking 'removeCluster' preconditions. verbose: 2022-10-28T17:11:01Z: Refreshing metadata cache from '10.160.132.218:3306' verbose: 2022-10-28T17:11:01Z: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null verbose: 2022-10-28T17:11:01Z: I) 10.160.132.218:3306 10.160.132.218:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:11:01Z: I) 10.168.138.241:3306 10.168.138.241:3306 (jaytest-development-001-usw2) verbose: 2022-10-28T17:11:01Z: I) 10.160.132.29:3306 10.160.132.29:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:11:01Z: I) 10.160.133.190:3306 10.160.133.190:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:11:01Z: C) 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 'jaytest-development-001-use1' verbose: 2022-10-28T17:11:01Z: C) a1e8de84-56dd-11ed-8c29-02eb68887bf5 'jaytest-development-001-usw2' verbose: 2022-10-28T17:11:01Z: DONE! verbose: 2022-10-28T17:11:01Z: Primary cluster is 'jaytest-development-001-use1' verbose: 2022-10-28T17:11:01Z: Refreshing metadata cache from '10.160.132.218:3306' verbose: 2022-10-28T17:11:01Z: I) 10.160.132.218:3306 10.160.132.218:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:11:01Z: I) 10.168.138.241:3306 10.168.138.241:3306 (jaytest-development-001-usw2) verbose: 2022-10-28T17:11:01Z: I) 10.160.132.29:3306 10.160.132.29:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:11:01Z: I) 10.160.133.190:3306 10.160.133.190:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:11:01Z: C) 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 'jaytest-development-001-use1' verbose: 2022-10-28T17:11:01Z: C) a1e8de84-56dd-11ed-8c29-02eb68887bf5 'jaytest-development-001-usw2' verbose: 2022-10-28T17:11:01Z: DONE! verbose: 2022-10-28T17:11:01Z: Connecting to MySQL at: mysql://config@10.160.132.218:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:11:01Z: ClusterSet.removeCluster: tid=6131: CONNECTED: 10.160.132.218:3306 verbose: 2022-10-28T17:11:01Z: ClusterSet.removeCluster: tid=6131: SQL: SET SESSION `autocommit` = 1 verbose: 2022-10-28T17:11:01Z: ClusterSet.removeCluster: tid=6131: 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' verbose: 2022-10-28T17:11:01Z: ClusterSet.removeCluster: tid=6131: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' verbose: 2022-10-28T17:11:01Z: Metadata operations will use 10.160.132.218:3306 verbose: 2022-10-28T17:11:01Z: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null verbose: 2022-10-28T17:11:01Z: Metadata operations will use 10.160.132.218:3306 verbose: 2022-10-28T17:11:01Z: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null verbose: 2022-10-28T17:11:01Z: Instance type check: 10.160.132.218:3306: Cluster metadata record found (metadata 2.1.0) verbose: 2022-10-28T17:11:01Z: Checking if primary cluster 'jaytest-development-001-use1' (id=9971936f-56dd-11ed-ae90-02ce79cb17b9, view_id_generation=0) has the most recent clusterset metadata verbose: 2022-10-28T17:11:01Z: Connecting to MySQL at: mysql://config@10.168.138.241:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:11:06Z: warning: 10.168.138.241:3306: MySQL Error 2003: Could not open connection to '10.168.138.241:3306': Can't connect to MySQL server on '10.168.138.241:3306' (110) verbose: 2022-10-28T17:11:06Z: Instance type check: 10.160.132.218:3306: Metadata version 2.1.0 found verbose: 2022-10-28T17:11:06Z: Instance type check: 10.160.132.218:3306: Cluster metadata record found (metadata 2.1.0) verbose: 2022-10-28T17:11:06Z: Instance 60d40df3-56dd-11ed-8778-02ce79cb17b9 is managed for GROUP-REPLICATION verbose: 2022-10-28T17:11:06Z: Instance type check: 10.160.132.218:3306: GR is active verbose: 2022-10-28T17:11:06Z: Primary cluster is 'jaytest-development-001-use1' verbose: 2022-10-28T17:11:06Z: Refreshing metadata cache from '10.160.132.218:3306' verbose: 2022-10-28T17:11:06Z: I) 10.160.132.218:3306 10.160.132.218:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:11:06Z: I) 10.168.138.241:3306 10.168.138.241:3306 (jaytest-development-001-usw2) verbose: 2022-10-28T17:11:06Z: I) 10.160.132.29:3306 10.160.132.29:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:11:06Z: I) 10.160.133.190:3306 10.160.133.190:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:11:06Z: C) 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 'jaytest-development-001-use1' verbose: 2022-10-28T17:11:06Z: C) a1e8de84-56dd-11ed-8c29-02eb68887bf5 'jaytest-development-001-usw2' verbose: 2022-10-28T17:11:06Z: DONE! verbose: 2022-10-28T17:11:06Z: Connecting to MySQL at: mysql://config@10.160.132.218:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:11:06Z: ClusterSet.removeCluster: tid=6141: CONNECTED: 10.160.132.218:3306 verbose: 2022-10-28T17:11:06Z: ClusterSet.removeCluster: tid=6141: SQL: SET SESSION `autocommit` = 1 verbose: 2022-10-28T17:11:06Z: ClusterSet.removeCluster: tid=6141: 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' verbose: 2022-10-28T17:11:06Z: ClusterSet.removeCluster: tid=6141: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' verbose: 2022-10-28T17:11:06Z: Metadata operations will use 10.160.132.218:3306 verbose: 2022-10-28T17:11:06Z: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null verbose: 2022-10-28T17:11:06Z: Metadata operations will use 10.160.132.218:3306 verbose: 2022-10-28T17:11:06Z: Detected state of MD schema as OK... schema_version=2.1.0, target_version=2.1.0, backup_exists=0, saved_stage=null verbose: 2022-10-28T17:11:06Z: Instance type check: 10.160.132.218:3306: Cluster metadata record found (metadata 2.1.0) verbose: 2022-10-28T17:11:06Z: Checking if primary cluster 'jaytest-development-001-use1' (id=9971936f-56dd-11ed-ae90-02ce79cb17b9, view_id_generation=0) has the most recent clusterset metadata verbose: 2022-10-28T17:11:06Z: Connecting to MySQL at: mysql://config@10.168.138.241:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:11:11Z: warning: 10.168.138.241:3306: MySQL Error 2003: Could not open connection to '10.168.138.241:3306': Can't connect to MySQL server on '10.168.138.241:3306' (110) verbose: 2022-10-28T17:11:11Z: Instance type check: 10.160.132.218:3306: GR is active verbose: 2022-10-28T17:11:11Z: Instance type check: 10.160.132.218:3306: GR is active verbose: 2022-10-28T17:11:11Z: Primary cluster is 'jaytest-development-001-use1' verbose: 2022-10-28T17:11:11Z: Refreshing metadata cache from '10.160.132.218:3306' verbose: 2022-10-28T17:11:11Z: I) 10.160.132.218:3306 10.160.132.218:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:11:11Z: I) 10.168.138.241:3306 10.168.138.241:3306 (jaytest-development-001-usw2) verbose: 2022-10-28T17:11:11Z: I) 10.160.132.29:3306 10.160.132.29:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:11:11Z: I) 10.160.133.190:3306 10.160.133.190:3306 (jaytest-development-001-use1) verbose: 2022-10-28T17:11:11Z: C) 89d73d6a-56dd-11ed-ae90-02ce79cb17b9 'jaytest-development-001-use1' verbose: 2022-10-28T17:11:11Z: C) a1e8de84-56dd-11ed-8c29-02eb68887bf5 'jaytest-development-001-usw2' verbose: 2022-10-28T17:11:11Z: DONE! verbose: 2022-10-28T17:11:11Z: Connecting to MySQL at: mysql://config@10.160.132.218:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:11:11Z: ClusterSet.removeCluster: tid=6156: CONNECTED: 10.160.132.218:3306 verbose: 2022-10-28T17:11:11Z: ClusterSet.removeCluster: tid=6156: SQL: SET SESSION `autocommit` = 1 verbose: 2022-10-28T17:11:11Z: ClusterSet.removeCluster: tid=6156: 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' verbose: 2022-10-28T17:11:11Z: ClusterSet.removeCluster: tid=6156: SQL: SET SESSION `group_replication_consistency` = 'EVENTUAL' verbose: 2022-10-28T17:11:11Z: Metadata operations will use 10.160.132.218:3306 verbose: 2022-10-28T17:11:11Z: Instance type check: 10.160.132.218:3306: GR is active verbose: 2022-10-28T17:11:11Z: Instance type check: 10.160.132.218:3306: GR is active verbose: 2022-10-28T17:11:11Z: Connecting to MySQL at: mysql://config@10.168.138.241:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:11:16Z: Connecting to MySQL at: mysql://config@10.168.138.241:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 verbose: 2022-10-28T17:11:21Z: warning: 10.168.138.241:3306: MySQL Error 2003: Could not open connection to '10.168.138.241:3306': Can't connect to MySQL server on '10.168.138.241:3306' (110) WARNING: The target Cluster's Primary instance is unavailable so the Cluster cannot be cleanly removed from the ClusterSet. Removing anyway because 'force' is enabled. The Cluster 'jaytest-development-001-usw2' will be removed from the InnoDB ClusterSet. verbose: 2022-10-28T17:11:21Z: Connecting to MySQL at: mysql://config@10.168.138.241:3306?ssl-ca=%2Fetc%2Fods%2Fcerts%2Fca.pem&ssl-cert=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.crt&ssl-key=%2Fetc%2Fods%2Fcerts%2Fconfig-jaytest-development-001.key&ssl-mode=verify_ca&connect-timeout=5000 * Waiting for the Cluster to synchronize with the PRIMARY Cluster... * Updating topology verbose: 2022-10-28T17:11:26Z: Removing Cluster from the Metadata. verbose: 2022-10-28T17:11:26Z: ClusterSet.removeCluster: tid=6131: SQL: START TRANSACTION verbose: 2022-10-28T17:11:26Z: Acquiring EXCLUSIVE lock ('AdminAPI_metadata', 'AdminAPI_lock') on 10.160.132.218:3306. verbose: 2022-10-28T17:11:26Z: ClusterSet.removeCluster: tid=6131: SQL: CALL mysql_innodb_cluster_metadata.v2_cs_member_removed('9971936f-56dd-11ed-ae90-02ce79cb17b9', 'ace8db60-56dd-11ed-ae90-02ce79cb17b9') verbose: 2022-10-28T17:12:16Z: ClusterSet.removeCluster: tid=6131: MySQL Error 1205 (HY000): Lock wait timeout exceeded; try restarting transaction verbose: 2022-10-28T17:12:16Z: warning: While querying metadata: MySQL Error 1205 (HY000): Lock wait timeout exceeded; try restarting transaction verbose: 2022-10-28T17:12:16Z: Releasing locks for 'AdminAPI_metadata' on 10.160.132.218:3306. verbose: 2022-10-28T17:12:16Z: ClusterSet.removeCluster: tid=6131: SQL: ROLLBACK ERROR: Error removing Replica Cluster: MySQL Error 1205: Failed to execute query on Metadata server 10.160.132.218:3306: Lock wait timeout exceeded; try restarting transaction NOTE: Reverting changes... Changes successfully reverted. ClusterSet.removeCluster: Failed to execute query on Metadata server 10.160.132.218:3306: Lock wait timeout exceeded; try restarting transaction (MySQL Error 1205)