Bug #91995 Too long waiting for metadata lock
Submitted: 13 Aug 2018 16:06 Modified: 30 Aug 2018 15:22
Reporter: Michael Prokopiv Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:mysql-5.6.28 ndb-7.4.10, OS:Any
Assigned to: CPU Architecture:Any
Tags: Metadata lock

[13 Aug 2018 16:06] Michael Prokopiv 
Description:
Attempt to update stored procedure freezes for a few hours:

mysqladmin processlist
+----+-------------+------------------+--------------+---------+------+-------------------------------------------+------------------------------------+
| Id | User        | Host             | db           | Command | Time | State                                     | Info                               |
+----+-------------+------------------+--------------+---------+------+-------------------------------------------+------------------------------------+
| 1  | system user |                  |              | Daemon  | 0    | Waiting for event from ndbcluster         |                                    |
| 16 | root        | 10.23.6.15:56556 |              | Sleep   | 4164 |                                           |                                    |
| 17 | root        | 10.23.6.15:56559 | TMP_PROKOPIV | Sleep   | 4071 |                                           |                                    |
| 22 | root        | 10.23.6.15:49360 | TMP_PROKOPIV | Query   | 4029 | Waiting for stored function metadata lock | DROP FUNCTION IF EXISTS bigint2bin |
| 24 | root        | localhost        |              | Query   | 0    | init                                      | show processlist                   |
+----+-------------+------------------+--------------+---------+------+-------------------------------------------+------------------------------------+

How to repeat:
i don't know, it is takes place periodically
[20 Aug 2018 22:18] MySQL Verification Team 
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information (a repeatable test case), feel free to add a comment to this bug.
 
Thank you for your interest in MySQL.
[30 Aug 2018 15:22] Michael Prokopiv 
Yeah, i'm agree, that this request have no much useful information,
And i'm asking to clarify - how can i get the reason for such long locks?