Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3390

table locked not cleared on a successful truncate

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Won't Do
    • None
    • Icebox
    • N/A
    • None
    • 2um 2pm

    Description

      Customer reported:

      We have 2UM, 2PM system and one of the DDL statements appeared to have an issue during a truncate. The table stays locked by DDL and cannot be cleared. The Truncate looks like it worked, however, as there is no error in the logs and the table is empty.

      [root@usfit-scdb1 bin]# ./viewtablelock
      There is 1 table lock

      Table LockID Process PID Session Txn CreationTime State DBRoots
      dairy.dairy_collection_relationship 103583 DDLProc 43080 151725 1270108 Wed Jun 19 14:32:01 2019 LOADING 1,2
      [root@usfit-scdb1 bin]# ./cleartablelock 103583
      Rolling back and clearing table lock for table dairy.dairy_collection_relationship; table lock 103583

      Rollback error: Unable to grab lock; Lock not found or still in use.
      Table lock 103583 for table dairy.dairy_collection_relationship is not cleared.

      1. they did a restart of DMLProc and it didnt clear
      2. they then did a restartsystem and it had this effect

      A restart of the system left the table locked, but changed the LockID to 1. We were able to clear the lock at that point.

      It is still curious how this 'hanging' lock came into play, as it appears the statements that it failed on did indeed truncate the table.

      I got a support report for the issue and there was no errors logged at the time they believe the lock took place.

      Attachments

        Activity

          People

            Unassigned Unassigned
            hill David Hill (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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