Concurrent CREATE and DROP USER queries on different nodes lead to permanent lock

Description

This simple loop will cause a permanent stall when executed against two different PXC nodes:

processlist looks like this:

and second node:

These queries cannot be canceled or killed. Nodes refuse to be gracefully restarted. The shutdown is stuck with this forever:

Only forcible service kill helps to restore the cluster.

Environment

None

blocks

is duplicated by

Activity

Show:

Kamil Holubicki May 3, 2024 at 8:44 AM

Duplicae of PXC-4385

Aaditya Dubey March 10, 2024 at 9:59 AM

Hi

Thank you for the report and feedback.

Verified as described:

Duplicate

Details

Assignee

Reporter

Needs QA

Yes

Sprint

Affects versions

Priority

Smart Checklist

Created January 18, 2024 at 5:52 PM
Updated August 7, 2024 at 6:52 PM
Resolved May 3, 2024 at 8:44 AM