Some of my queries are only saying “Query in queue”
any way to see or clear the queue
A summary of the issue and the browser/OS environment in which it occurs.
Is it random? Do they have anything in common? If you wait do they eventually execute?
Query in queue means that an execution task has been placed in Redis but has not been picked up by a worker to be executed. This can happen if you have lots of queries running simultaneously without enough workers to handle the load.
You can see the status of your queues from with Redash by viewing the system status.
Also, I strongly encourage you to upgrade to V10.1 which we just release. The v8 codebase you run today is more than three years old and we don’t support it any longer.
I just upgraded to 10 Version: 10.1.0 (2589bef1). Still an issue.
you mentioned may not be enough workers. is there a query I can run to determine how many are in the queue?
It seems to be every query I start
There’s not a query per se. You can check the system status page to show all the queues, how many jobs are waiting, how many workers there are etc. Just click your user avatar and then System Information.
How would I check if the worker is doing?
Did you start all your services in docker? Looks like you have no workers which means nothing will execute.
What does your docker-compose file look like? Have you tried executing a query since you bounced everything?
it runs now why are there 403 queries on this page?
What does this mean? Does it mean that a query can execute successfully? If this is the case, do you see your workers behaving as expected in the System Information panel?
It will be easiest to help you if you can provide information about the nature of the errors. 403’s are authentication errors. Where do you see them? In the network inspector? Which URLs return 403’s?
unlucky number since 403 is also an HTTP response code.
It looks like none of your workers are monitoring the periodic queue, which can fill up. Although I would expect the jobs to timeout eventually.
how many queues are there? the setup instructions didn’t have that in it
There are six queues. If you follow the setup instructions they should all be covered.
"periodic", "emails", "default", "scheduled_queries", "queries", "schemas"
[edit] The docs around setup still need to be revised for V10, though, so your confusion is surely justified.
That did it the number of queued jobs is going down.
and the scheduled worker is getting to work