MySQL Bugs: #108921: lock wait timeout trying to removeCluster from clusterset

Bug #108921	lock wait timeout trying to removeCluster from clusterset
Submitted:	28 Oct 2022 17:15	Modified:	8 Nov 2022 15:20
Reporter:	Jay Janssen	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Shell AdminAPI InnoDB Cluster / ReplicaSet	Severity:	S2 (Serious)
Version:	8.0.31	OS:	Any
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
I have a replica cluster in a clusterset that I need to remove (all instances are gone).  However, I am getting a lock wait timeout when I try removeCluster.

I will attach the full mysqlsh log with --log-sql=on and --verbose=2

How to repeat:
not sure it's repeatable yet.

terminal output from mysqlsh

Attachment: shell-bug.log (application/octet-stream, text), 42.75 KiB.

Hi,

I am having issues reproducing this. How was this setup created. Was this 8.0.31 from the start or was it upgraded from another version? 

On USW2 you have

ERROR: Could not connect to any ONLINE members but there are unreachable instances that could still be ONLINE.

what happened to members? are they removed or they are just powered off?

Thanks

> I am having issues reproducing this. How was this setup created. Was this 8.0.31 from the start or was it upgraded from another version? 

I don't recall, it could have been either.  

> On USW2 you have
> ERROR: Could not connect to any ONLINE members but there are unreachable instances that could still be ONLINE.
> what happened to members? are they removed or they are just powered off?

I was testing clusterset failover, so I executed:
```
kill -9 `pidof mysqld`; systemctl stop mysqld
```
on each node in that cluster at the same time.

Thanks for the update, I'll try that way

Hi,

I cannot reproduce this. Please let us know if this happens to you again. As it is now anything I tried worked as expected.