MariaDB: Terminate long-running clearnup process?
2
votes
0
answers
790
views
This is a follow up to my [previous question](https://dba.stackexchange.com/questions/325259/mariadb-large-insert-select-query-failed-without-generating-an-error) about a long-running
INSERT SELECT
query that may have exceeded the max_statement_time
and was Killed
. It has been in the Reset for next command
state for 3.5 days. I think it is rolling back changes on the table I was inserting into.
However, that table was empty to begin with, and I would rather terminate this cleanup process, drop the table, and start fresh than continue waiting for it to finish. But I do not know if that would be safe for the general health of the database.
The table that I was copying into had no keys, and thus no foreign_key constraints. It was a bare table that I was planning to index once populated.
What is the quickest way for me to get back to work without doing more harm?
Id User Host db Command Time State
10237 root localhost singlecell Killed 300819 Reset for next command
Asked by Chris Cox
(43 rep)
Mar 28, 2023, 02:30 PM