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?

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?

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.

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

But, I’m not using docker

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

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

Unsuccess:cry: