Cannot cancel queries in admin/queries/tasks#in_progress


#1

I have a question. “in progress” queries sometimes remain after clicking Cancel button in admin page.
It is because “query_task_trackers:in_progress” in redis remain even if Celery tasks we canceled . I don’t know how to reproduce these data, but should I flushall redis data?


#2

I’m having this exact problem, with two queries stuck in executing query. I cannot cancel them and I cannot run them again because the system evidently things they are running. How can I flush or cancel or otherwise remove them from the queue?

It’s worth noting that this seems to be a similar problem:

and this:


Update:

After multiple tries of redis-cli flushall and rebooting the server, the queries finally cleared.