Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.1.37
-
None
-
AArch64, Odroid C2, Debian 9
Description
Hi,
When I do: CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'b692RzMDSKjTg7AypUMEbhlx'
I dead lock some time:
SHOW FULL PROCESSLIST:
|
| 12 | root | localhost | mysql | Query | 43178 | Waiting for table level lock | UPDATE user LEFT JOIN db USING (Host,User) SET Create_user_priv='Y'
|
WHERE @hadCreateUserPriv = 0 AND
|
(user.Grant_priv = 'Y' OR db.Grant_priv = 'Y') | 0.000 |
|
| 19 | root | localhost | mysql | Query | 43178 | Waiting for table metadata lock | ALTER TABLE user MODIFY Create_user_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Alter_routine_priv | 0.000 |
|
| 23 | root | localhost | NULL | Query | 43178 | Waiting for table metadata lock | CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'XXXXXXXXXXXXXXXXXXXXXXX'
|
Cheers,