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

Waiting for table metadata lock

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.2.22
    • None
    • Locking, Storage Engine - MyISAM

    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

            Unassigned Unassigned
            abhaysingh Abhay Singh
            Votes:
            4 Vote for this issue
            Watchers:
            8 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.