Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-26600

Waiting for table metadata lock

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 10.2.22
    • Fix Version/s: None
    • Labels:
    • Environment:

      Description

      DML query is stuking with status "Waiting for table metadata lock", don't see any thing in mysql log for this, then engine of the table is MyISAM

      14569 cubot localhost mutual Query 7938 Waiting for table metadata lock Truncate Table MST2_S_INVESTOR 0.000
      14588 cubot localhost mutual Query 5300 Waiting for table metadata lock Truncate Table MST2_S_INVESTOR 0.000

      no other query running on this table which might be causing this lock.
      the similar problem happens with drop table also.
      All these happens only with certain tables and not all tables

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            abhaysingh Abhay Singh
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration