Normal user dropping system user

Description

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

Environment

None

Smart Checklist

Activity

Show:

puneet.kaushik July 11, 2022 at 5:35 AM
Edited

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

Assignee

Reporter

Needs Review

Yes

Time tracking

1d 4h 54m logged1h 58m remaining

Affects versions

Priority

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