Solved Redash workers not executing jobs
After installing redash, configuring a datasource, and submitting a query to be run, it remains in queue and is never executed by a worker.
I have uninstalled and reinstalled redash and reconfigured the data sources and such as I thought maybe I did something wrong to mess it up the first time but both times I get the same result, queries sit queued but never execute.
All the processes for the workers appear to be running:
@christophermag I think this is related to https://forum.cloudron.io/topic/6187/has-anyone-used-v10-1-0 . Also see, https://github.com/getredash/redash/issues/5561 . The Cloudron package has a bug which I am fixing. For some reason, even the old package does not build anymore, so it's taking a bit more time. I think it's something to do with redash not having pinned it's deps properly.
@christophermag I have pushed a new package, can you reinstall redash and try again? (updating won't work).
@girish I uninstalled and reinstalled, I made sure when I was installing it from the app store it said last updated 15 hours ago so I believe it pulled the updated version.
Unfortunately, same problem, queries get queued but never dequeued and run.
@christophermag just to double check, if you go to App -> Updates, does it say package version as 4.0.0 ? What's a good way to reproduce this?
In my RQ workers, I see that jobs are running:
ChristopherMag last edited by ChristopherMag
@girish Package version shows 4.0.0:
I also see successful jobs count on that screen but those do not appear to be the queued jobs as we can also see that the queued jobs count only increases, started jobs never increases:
To reproduce this you can submit any query to any data source and confirm that it never completes.
Below is an example of submitting
select "test"as the query to a CSV data source which may not even be valid but if it is not at least it should error instead of remaining indefinitely queued:
I have also tried this with a SQLite data source and get the same results, for each query I submit the queued count increases and the screen where the query was submitted just keeps counting up.
@christophermag thanks for reporting, just back from vacation, will fix the package.
@girish It doesn't look like Redash has been updated yet, just making sure this didn't fall of the list of things to do as I know it came in over the holidays.
@christophermag yes, didn't forget but got backlogged. Just looking into this now. I have posting at https://forum.cloudron.io/topic/6187/has-anyone-used-v10-1-0 with the progress.