Done
Details
Assignee
parveez.baigparveez.baigReporter
Juan ArrutiJuan ArrutiPlanned Version/s
Needs Review
YesNeeds QA
YesSprint
NoneFix versions
Affects versions
Priority
Medium
Details
Details
Assignee
parveez.baig
parveez.baig
Reporter
Juan Arruti
Juan Arruti
Planned Version/s
Needs Review
Yes
Needs QA
Yes
Sprint
None
Fix versions
Affects versions
Priority
MediumSmart Checklist
Smart Checklist
Smart Checklist
Created February 24, 2024 at 1:20 AM
Updated September 18, 2024 at 3:58 PM
Resolved September 9, 2024 at 9:53 AM
On PXC 8.0.35, running a TOI ALTER USER in one node and a SET PASSWORD in another, causes the statements to hang, locking the affected nodes.
How to repeat:
The error log shows a MDL conflict on mysql.columns_priv table between a foreground and a replication thread:
Processlist output shows both commands as hanging:
The node can be recovered only by shutting down the nodes.
I see the issue on latest version, 8.0.35: