Queries with parameters aren't refreshed on schedule

[myonlylonely]

Steps to Reproduce

When a query with a query based dropdown list parameter, scheduling query does not work.

Technical details:

• Redash Version: 8.0 beta 2
• Browser/OS: Cent OS 7
• How did you install Redash: Docker

[ranbena]

@myonlylonely can you reproduce this on the Deploy Preview?

[myonlylonely]

@myonlylonely can you reproduce this on the Deploy Preview?

Yes. I created 2 queries.

1. Select AlbumTitles
2. Search Album (which has a drop list parameter based on AlbumTitles query)

I schedule both queries at 1 minute. Query 1 works, and query 2 does not schedule as I expected.

[ranbena]

@arikfr is this an expected behavior or a bug?

[arikfr]

Thank you for creating the example queries, @myonlylonely. See my comment here: https://discuss.redash.io/t/queries-with-parameters-not-updating/3737/14?u=arikfr.

I will update the issue title to better reflect the actual bug. #1909 is a possible fix for this, at least until we revise how the scheduler works.

[myonlylonely]

Thank you for creating the example queries, @myonlylonely. See my comment here: https://discuss.redash.io/t/queries-with-parameters-not-updating/3737/14?u=arikfr.

I will update the issue title to better reflect the actual bug. #1909 is a possible fix for this, at least until we revise how the scheduler works.

I tried the #1909 fix, and it didn't work in this case.

[arikfr]

I tried the #1909 fix, and it didn't work in this case.

How did you try it?

[myonlylonely]

I tried the #1909 fix, and it didn't work in this case.

How did you try it?

I edited the python file that mentioned in #1909 in the docker image, and the queries with parameters still didn't refresh on schedule as expected.

[jotolo]

This problem persists in redash:10.1.0.b50633 still