SchedulerWorker doesn't refresh query

[ognjen-it]

Hi all,

I have a problem with the scheduler worker. It will work if I set it to run every 1 minute or 1 hour, but if I set every week it doesn't refresh query.

Configuration for scheduler:

GUI:
20/02/24 13:54 -> CET

I can see it exists in redis:

Log:

Is there anyone who can help me please?

I deployed Redash on Azure Kubernetes
Helm chart: https://github.com/getredash/contrib-helm-chart Version: 3.0.1
Image version: 23.12.0-dev (I built from 23.12.0-dev tag)

[eradman]

@ognjen-it can you try the snapshot from 24.02.0? Commit 4d81c31 may solve this.

[ognjen-it]

Hi @eradman and thank you for your fast replay.
I couldn't find snapshot 24.02.0 in the repository (23.12.0 is the latest?) but I built it from the commit you provided and it's not working.

If I schedule it to run every day, I can see standard logs in scheduledworker pod:

And in redis I can see it successfully finished:

Job information:

Here we can see the count of successful jobs: 3

However, If I configure a specific day (except Monday because from some reason it works on Monday), I don't see anything in logs:

rq:finished still the same:

And worker didn't change count of successful jobs:

[eradman]

Even after building from source, the query hashes may be incorrect. Try downloading the attached script:
refresh-query-hash.py.gz

gzip -d refresh-query-hash.py.gz
./refresh-query-hash-alt.py --url=http://localhost:5001 --api-key=XXXXX

This works by

1. Listing all queries
2. Updating each query with an empty payload to trigger the new query hash code path

[ognjen-it]

Thank you again for fast replay. Just ran script and it printed 5x strings:

However, it didn't resolve scheduling problem.

I just tried to run redash from master (81d22f1) but it also doesn't work. I still investigating where is the problem.

[ognjen-it]

@eradman just to mention that I tried to run ReDash from master branch with clean Redis and Postgres, but it's not working :(

[eradman]

Sounds like this feature just doesn't work. We'll have to investigate