Normal user dropping system user
General
Escalation
General
Escalation
Description
Environment
None
Smart Checklist
Activity
Show:

puneet.kaushik July 11, 2022 at 5:35 AMEdited
Bug Fix verified in PXC 8.0.28 ! No inconsistency detected . MTR test successfully passed.

Aaditya Dubey March 9, 2022 at 11:26 AM
Hi ,
Thank you for the report.
I am able to reproduce the issue with PXC version 8.0.26 with 3 node cluster, please find my test details below:
Sending issue to engineering for further review.
Thanks,
Aaditya Dubey
Done
Details
Details
Assignee

Reporter

Labels
Needs Review
Yes
Time tracking
1d 4h 54m logged1h 58m remaining
Fix versions
Affects versions
Priority
Smart Checklist
Open Smart Checklist
Smart Checklist

Open Smart Checklist
Created January 20, 2022 at 1:58 AM
Updated March 6, 2024 at 8:59 PM
Resolved May 16, 2022 at 11:51 AM
User without `system_user` privilege is able to drop system users.
Replication issue:
1) Log in as root and create 1 normal user & 1 system user.
Create user x (normal user) with create user privilege.
Create user y (system user) with all privileges.
2) Log in as user x and drop user y.
Error with access denied. But following selects will have error with WSREP not prepared. (due to inconsistency with other nodes)
3) Check mysql error log:
origin node initiated vote with access denied operation, other nodes vote as succeed hence user y will be dropped. origin node will proceed to IST from other pxc nodes.
4) When origin node is ready, user y has been dropped.
Commands and logs are written in percona forum