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

How to force a ColumnStore lock to be dropped and for a rollback to be abandoned?

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 6.2.1
    • Fix Version/s: Icebox
    • Component/s: DMLProc
    • Labels:
      None
    • Environment:
      Community version with MariaDB 10.6.5 - ColumnStore 6.2.1 Release 1

      Description

      I created a ColumnStore table and ran a series of heavy SQL statements which ended up crashing after several hours. The logs said it was rolling back and after leaving it for 24 hours with it still saying it is rolling back, I thought as the table and it's contents are not important I'll just drop it. viewtablelock showed that there is still a lock on the table from the original SQL and cleartablelock wouldn't clear it. So I just dropped the table thinking that might clear it using the drop table cs_tableau_threads_table_duplicates restrict.

      root@apprep:/home/appadmin/jobs# mariadb --version
      mariadb Ver 15.1 Distrib 10.6.5-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
      root@apprep:/home/appadmin/jobs# viewtablelock
      There is 1 table lock

      Table LockID Process PID Session Txn CreationTime State DBRoots
      tableau_app_uk.cs_tableau_threads_table_duplicates 1 DMLProc 40023 172493 2500 Tue Feb 1 15:09:11 2022 LOADING 1

      root@apprep:/home/appadmin/jobs# mariadb
      Welcome to the MariaDB monitor. Commands end with ; or \g.
      Your MariaDB connection id is 17275
      Server version: 10.6.5-MariaDB-1:10.6.5+maria~focal-log mariadb.org binary distribution

      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

      MariaDB [(none)]> use tableau_app_uk;
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A

      Database changed
      MariaDB [tableau_app_uk]> desc cs_tableau_threads_table_duplicates;
      ERROR 1146 (42S02): Table 'tableau_app_uk.cs_tableau_threads_table_duplicates' doesn't exist
      MariaDB [tableau_app_uk]>

      As you can see the table has gone but the lock is still there. How do I force the lock to be dropped and for the rollback to be abandoned?

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              simonthepieman Simon Heyes
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.