I don't think this is a charm bug. The issue appears when using the mysql to remove a node from the cluster. From what I can see you cannot persist group_replication_force_members and is correctly unset. So the error being reported seems wrong
https://pastebin.ubuntu.com/p/sx6ZB3rs6r/ root@juju-1f04f3-zaza-90b9e082f2aa-2:/var/lib/juju/agents/unit-mysql-innodb-cluster-1/charm# /snap/bin/mysqlsh Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory MySQL Shell 8.0.23 Copyright (c) 2016, 2021, 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. mysql-py> shell.connect('clusteruser:d2Z27kpxZmJ826tSVWL6SVV4LYZhZwwryHtM@172.20.0.111') Creating a session to 'clusteruser@172.20.0.111' Fetching schema names for autocompletion... Press ^C to stop. Your MySQL connection id is 1644 (X protocol) Server version: 8.0.27-0ubuntu0.20.04.1 (Ubuntu) No default schema selected; type \use <schema> to set one. <Session:clusteruser@172.20.0.111:33060> mysql-py []> cluster = dba.get_cluster('jujuCluster') mysql-py []> cluster.remove_instance('clusteruser@172.20.0.166', {'force': False}) The instance will be removed from the InnoDB cluster. Depending on the instance being the Seed or not, the Metadata session might become invalid. If so, please start a new session to the Metadata Storage R/W instance. Instance '172.20.0.166:3306' is attempting to leave the cluster... ERROR: Instance '172.20.0.166:3306' failed to leave the cluster: Variable 'group_replication_force_members' is a non persistent variable Traceback (most recent call last): File "<string>", line 1, in <module> mysqlsh.DBError: MySQL Error (1238): Cluster.remove_instance: Variable 'group_replication_force_members' is a non persistent variable mysql-py []> \sql show variables like 'group_replication_force_members'; +---------------------------------+-------+ | Variable_name | Value | +---------------------------------+-------+ | group_replication_force_members | | +---------------------------------+-------+ 1 row in set (0.0086 sec) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1954306 Title: Action `remove-instance` works but appears to fail To manage notifications about this bug go to: https://bugs.launchpad.net/charm-mysql-innodb-cluster/+bug/1954306/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
