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
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
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
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
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?