[MDEV-26600] Waiting for table metadata lock - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Critical
Resolution: Unresolved
Affects Version/s: 10.2.22
Fix Version/s: None
Component/s: Locking, Storage Engine - MyISAM
Labels:
- performance
Environment:

Hide
NAME="openSUSE Leap"
VERSION="15.1 "
ID="opensuse-leap"
ID_LIKE="suse opensuse"
VERSION_ID="15.1"
PRETTY_NAME="openSUSE Leap 15.1"
ANSI_COLOR="0;32"
CPE_NAME="cpe:/o:opensuse:leap:15.1"
Intel(R) Xeon(R) Gold 6126 CPU @ 2.60GHz
Memory = 13145556 MB

Show
NAME="openSUSE Leap" VERSION="15.1 " ID="opensuse-leap" ID_LIKE="suse opensuse" VERSION_ID="15.1" PRETTY_NAME="openSUSE Leap 15.1" ANSI_COLOR="0;32" CPE_NAME="cpe:/o:opensuse:leap:15.1" Intel(R) Xeon(R) Gold 6126 CPU @ 2.60GHz Memory = 13145556 MB

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

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

mysqlBacktraces.zip
7 kB
2021-09-16 15:23
mysqld_full_bt_all_threads_2021-09-18.txt.zip
4 kB
2021-09-18 04:53

Activity

People

Assignee:: Unassigned

Reporter:: Abhay Singh

Votes:: 4 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2021-09-13 18:35

Updated:: 2024-03-26 10:12

Git Integration

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