Redash get hang after killing a mysql process

#1

Datasource: Mysql

I created a query but it runs in a long time. I clicked cancel, but no response. So, I try to kill the process in mysql. After refresh that query page, it’ stay on 「Loading result… 00:00:01」, and turns to blank page after few seconds. Other queries work well.

I guess something locked in redash as it’s not stop execution properly. How can I fix this?

0 Likes

Celery worker stuck with 100% CPU
#2

As a general thought, if you’re self-hosting Redash you should be able to restart the Docker containers without it causing problems.

Guessing you’re not self hosting though?

0 Likes

#3

Thanks for your reply.

Redash is self hosting.
I’ve just tried to restart the redash as you suggested, sudo supervisorctl restart all, but it doesn’t work.

0 Likes

#4

Hmmm, what happens if you force them to shutdown and restart?

$ docker-compose down
$ docker-compose ps    <-- to confirm they are all stopped
$ docker-compose up -d   <-- to start things up again
0 Likes

#5

But, I’m not using docker

0 Likes

#6

Ahhh, sorry. I thought you were self-hosting using the docker based setup.

0 Likes

#7

Followed Restart all processes: sudo supervisorctl restart all mentioned in https://redash.io/help/open-source/admin-guide/maintenance

Unsuccess:cry:

0 Likes