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

WSREP: BF lock wait long after a TRUNCATE TABLE

    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:
    • Environment:

      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

          Issue Links

            Activity

              People

              • Assignee:
                jplindst Jan Lindström
                Reporter:
                adrian.tarau Adrian Tarau
              • Votes:
                6 Vote for this issue
                Watchers:
                18 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: