Also faced this issue when running the docker image -
redash/redash:9.0.0-beta.b42121 (this image was built in June, 2020). Also restared scheduler but it works for a day and then same problem again.
After trying to find if discussion on this problem, ran into the below github issues and to this ghost locks.
The issues are,
#4926 Query doesn’t not get queued because redash thinks it is already queued
#5087 Add: periodic job to remove ghost locks.
Also noticed that the
ghost locks was fixed in August, 2020 via the last issue above (issue 5087).
@Albert mentions this issue might be duplicate of Worker shutdowns in v9 resulting in stuck queries.
But a pull request was already merged in Nov. 2020 it seems.
So if you are running the latest version then it may not be any of the above problems… I guess…
Btw, I just noticed docker image
redash/redash:preview was pushed 10days ago - which will have the latest.
Now, I want to try running the
preview docker image, but, @xavier-d already said he is running
preview image since more than 10days ago.
So I am kind of confused about the
Maybe, is the
preview image being overwritten by pushing new image every few days… ?
(also this image I checked has
rq==1.5.0 maybe it won’t have the stuck query issues…)
I want to check the redash version that is more closer to the upcoming release of v9.
So, I need to be checking the
redash/redash:preview right? not the old image
Sorry about my confusions and doubts… new to redash, please execuse
Thanks so much!