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: | |
Category: | Shell AdminAPI InnoDB Cluster / ReplicaSet | Severity: | S2 (Serious) |
Version: | 8.0.31 | OS: | Any |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[28 Oct 2022 17:15]
Jay Janssen
[28 Oct 2022 17:16]
Jay Janssen
terminal output from mysqlsh
Attachment: shell-bug.log (application/octet-stream, text), 42.75 KiB.
[31 Oct 2022 15:02]
MySQL Verification Team
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
[31 Oct 2022 15:20]
Jay Janssen
> 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.
[31 Oct 2022 15:25]
MySQL Verification Team
Thanks for the update, I'll try that way
[8 Nov 2022 15:20]
MySQL Verification Team
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.