[MDEV-15154] WSREP: BF lock wait long after a TRUNCATE TABLE - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Duplicate
Affects Version/s: 10.2.12
Fix Version/s: 10.1.35, 10.2.17, 10.3.9
Component/s: Galera
Labels:
- innodb
- wsrep
Environment:

Hide
innodb_version 5.7.20
protocol_version 10
slave_type_conversions
version 10.2.12-MariaDB
version_comment MariaDB Server
version_compile_machine x86_64
version_compile_os Linux
version_malloc_library system
version_ssl_library OpenSSL 1.0.1e-fips 11 Feb 2013
wsrep_patch_version wsrep_25.21

Show
innodb_version 5.7.20 protocol_version 10 slave_type_conversions version 10.2.12-MariaDB version_comment MariaDB Server version_compile_machine x86_64 version_compile_os Linux version_malloc_library system version_ssl_library OpenSSL 1.0.1e-fips 11 Feb 2013 wsrep_patch_version wsrep_25.21

Description

This issue seems to be similar to ~~MDEV-12837~~ (which was closed) and I was asked to open a new case.

Just like it is described in the other defect, once the log shows these waits, everything is locked. It looks like it is triggered by a TRUNCATE TABLE:

_LOCK WAIT
MySQL thread id 138641, OS thread handle 139936878089984, query id 139638795 ........ Opening tables
TRUNCATE TABLE `ds$etl_dimension_discovery_local_standard_1`
2018-01-24 11:51:38 139938787669760 [Note] InnoDB: WSREP: BF lock wait long for trx:0x1a3598f query: TRUNCATE TABLE `ds$etl_dimension_discovery_local_standard_1`
TRANSACTION 27482511, ACTIVE 1997 sec_

An email with logs was sent out to Jan Lindström ...if need it I can send the link again.

Attachments

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

mysqld.log-20180327
2018-04-06 14:17
41 kB
Reinhard Sojka

Issue Links

duplicates

MDEV-15822 WSREP: BF lock wait long for trx

Closed

relates to

MDEV-12837 WSREP: BF lock wait long

Closed

MDEV-13564 TRUNCATE TABLE and undo tablespace truncation are not compatible with Mariabackup

Closed

MDEV-14637 Latching order violation during btr_cur_pessimistic_delete()

Closed

MDEV-15855 Assertion `mysql_table' failed in innobase_get_computed_value upon DDL/DML on a table with virtual columns

Closed

Activity

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Adrian Tarau

Votes:: 6 Vote for this issue

Watchers:: 18 Start watching this issue

Dates

Created:: 2018-01-31 19:12

Updated:: 2020-08-25 16:39

Resolved:: 2018-07-25 08:41

Git Integration

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