[MDEV-25122] Locking mysql.user view and invoking flush privileges Created: 2021-03-12  Updated: 2021-03-12

Status: Open
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.5
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Anel Husakovic Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

When locking the mysql.user view and invoking flush privileges obtained behavior is as such:

MariaDB [(none)]> flush privileges;
 
Query OK, 0 rows affected (0.001 sec)
 
 
 
MariaDB [(none)]> lock tables mysql.user write;
 
Query OK, 0 rows affected (0.001 sec)
 
 
 
MariaDB [(none)]> flush privileges;
 
ERROR 1100 (HY000): Table 'db' was not locked with LOCK TABLES

Some reference (documentation) of above behavior would be great.
Generated at Thu Feb 08 09:35:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.