Periodic refreshes are not happening

Issue Summary

I am running Redash 10.1.0.b50633 on a kubernetes cluster. I didn’t use helm, I did setup all the required deployments myself. Queries and stuff are working great. However, no matter what I tried I couldn’t get periodic query refreshes running.

I have 4 other deployments, in addition to the server:

  1. adhoc-worker

    cmd=worker

    QUEUES=queries
    WORKERS_COUNT=2
    
  2. scheduled-worker

    cmd=worker

    Environment variables:

    QUEUES=scheduled_queries,schemas
    WORKERS_COUNT=1
    
  3. scheduler

    cmd=scheduler

  4. worker

    cmd=worker

    Environment variables:

    QUEUES=periodic emails default
    WORKERS_COUNT=1
    

And here are some screenshots from the admin:

What am I missing?

Technical details:

  • Redash Version: 10.1.0.b50633
  • Browser/OS:
  • How did you install Redash:

I don’t have an immediate answer for your. But a few observations and some questions:

  • Why is your scheduled_worker WORKERS_COUNT only 1? How many scheduled queries are you trying to execute?
  • I notice your RQ Status > Queues tab doesn’t even show a scheduled queue…

A common issue with k8s (which we don’t official support, yet) deployments is if you duplicated your redis pod. Redash is built to work on a single message queue. All other pods should point to the same redis, otherwise you’ll have side-effects just like this.

I wonder if your scheduler has been configured to with the right redis URI.

Do you see anything in your logs from the scheduler?

I have single redis container, so all the workers and scheduler are using same redis instance. And the REDASH_REDIS_URL is coming from the same secret variable, so it shouldn’t be the issue.

  • This is a new instance, so I only have a single query with I use to test the refresh. Once I get it working, I can increase the number of workers.

  • Yes, I noticed the same thing. There isn’t a scheduled_queries queue, I don’t know why.

Here is the log for the scheduler container:

➜  redash kubectl logs -f deployment/scheduler -n redash
Starting RQ scheduler...
[2022-07-27 13:26:52,274][PID:1][INFO][rq_scheduler.scheduler] Registering birth

It just says “Registering birth” and nothing more.

Would it help if I share logs for REDASH_LOG_LEVEL=DEBUG?

Here is the log for the scheduler after setting REDASH_LOG_LEVEL=DEBUG:

➜  redash kubectl logs -f deployment/scheduler -n redash
Starting RQ scheduler...
[2022-07-27 14:38:07,998][PID:1][DEBUG][redash.query_runner] Registering Amazon Athena (athena) query runner.
[2022-07-27 14:38:08,145][PID:1][DEBUG][redash.query_runner] Registering BigQuery (bigquery) query runner.
[2022-07-27 14:38:08,164][PID:1][DEBUG][redash.query_runner] Registering Google Sheets (google_spreadsheets) query runner.
[2022-07-27 14:38:08,165][PID:1][DEBUG][redash.query_runner] Registering Graphite (graphite) query runner.
[2022-07-27 14:38:08,215][PID:1][DEBUG][redash.query_runner] Registering MongoDB (mongodb) query runner.
[2022-07-27 14:38:08,218][PID:1][DEBUG][redash.query_runner] Registering Couchbase (couchbase) query runner.
[2022-07-27 14:38:08,228][PID:1][DEBUG][redash.query_runner] Registering MySQL (mysql) query runner.
[2022-07-27 14:38:08,228][PID:1][DEBUG][redash.query_runner] Registering MySQL (Amazon RDS) (rds_mysql) query runner.
[2022-07-27 14:38:08,244][PID:1][DEBUG][redash.query_runner] Registering PostgreSQL (pg) query runner.
[2022-07-27 14:38:08,244][PID:1][DEBUG][redash.query_runner] Registering Redshift (redshift) query runner.
[2022-07-27 14:38:08,244][PID:1][DEBUG][redash.query_runner] Registering Redshift (with IAM User/Role) (redshift_iam) query runner.
[2022-07-27 14:38:08,244][PID:1][DEBUG][redash.query_runner] Registering CockroachDB (cockroach) query runner.
[2022-07-27 14:38:08,245][PID:1][DEBUG][redash.query_runner] Registering Url (url) query runner.
[2022-07-27 14:38:08,795][PID:1][DEBUG][redash.query_runner] Registering InfluxDB (influxdb) query runner.
[2022-07-27 14:38:08,800][PID:1][DEBUG][redash.query_runner] Registering Kibana (kibana) query runner.
[2022-07-27 14:38:08,800][PID:1][DEBUG][redash.query_runner] Registering Elasticsearch (elasticsearch) query runner.
[2022-07-27 14:38:08,801][PID:1][DEBUG][redash.query_runner] Registering Amazon Elasticsearch Service (aws_es) query runner.
[2022-07-27 14:38:08,805][PID:1][DEBUG][redash.query_runner] Registering Trino (trino) query runner.
[2022-07-27 14:38:08,812][PID:1][DEBUG][redash.query_runner] Registering Presto (presto) query runner.
[2022-07-27 14:38:08,815][PID:1][DEBUG][redash.query_runner] Registering Databricks (databricks) query runner.
[2022-07-27 14:38:08,826][PID:1][DEBUG][redash.query_runner] Registering Hive (hive) query runner.
[2022-07-27 14:38:08,826][PID:1][DEBUG][redash.query_runner] Registering Hive (HTTP) (hive_http) query runner.
[2022-07-27 14:38:09,509][PID:1][DEBUG][redash.query_runner] Registering Impala (impala) query runner.
[2022-07-27 14:38:09,531][PID:1][DEBUG][redash.query_runner] Registering Vertica (vertica) query runner.
[2022-07-27 14:38:09,533][PID:1][DEBUG][redash.query_runner] Registering ClickHouse (clickhouse) query runner.
[2022-07-27 14:38:09,549][PID:1][DEBUG][redash.query_runner] Registering Yandex Metrica (yandex_metrika) query runner.
[2022-07-27 14:38:09,550][PID:1][DEBUG][redash.query_runner] Registering Yandex AppMetrica (yandex_appmetrika) query runner.
[2022-07-27 14:38:09,551][PID:1][DEBUG][redash.query_runner] Registering Rockset (rockset) query runner.
[2022-07-27 14:38:09,561][PID:1][DEBUG][redash.query_runner] Registering TreasureData (treasuredata) query runner.
[2022-07-27 14:38:09,564][PID:1][DEBUG][redash.query_runner] Registering Sqlite (sqlite) query runner.
[2022-07-27 14:38:09,622][PID:1][DEBUG][redash.query_runner] Registering DynamoDB (with DQL) (dynamodb_sql) query runner.
[2022-07-27 14:38:09,626][PID:1][DEBUG][redash.query_runner] Registering Microsoft SQL Server (mssql) query runner.
[2022-07-27 14:38:09,628][PID:1][DEBUG][redash.query_runner] Registering Microsoft SQL Server (ODBC) (mssql_odbc) query runner.
[2022-07-27 14:38:09,630][PID:1][DEBUG][redash.query_runner] Registering MemSQL (memsql) query runner.
[2022-07-27 14:38:09,634][PID:1][DEBUG][thrift.transport.sslcompat] ipaddress module is available
[2022-07-27 14:38:09,634][PID:1][DEBUG][thrift.transport.sslcompat] ssl.match_hostname is available
[2022-07-27 14:38:09,680][PID:1][DEBUG][redash.query_runner] Registering Mapd (mapd) query runner.
[2022-07-27 14:38:09,682][PID:1][DEBUG][redash.query_runner] Registering JIRA (JQL) (jirajql) query runner.
[2022-07-27 14:38:09,684][PID:1][DEBUG][redash.query_runner] Registering Google Analytics (google_analytics) query runner.
[2022-07-27 14:38:09,700][PID:1][DEBUG][root] Checking 'python-requests' version...
[2022-07-27 14:38:09,701][PID:1][DEBUG][root] Module 'python-requests' version is 2.21.0. The version is compatible.
[2022-07-27 14:38:09,701][PID:1][DEBUG][redash.query_runner] Registering Axibase Time Series Database (axibasetsd) query runner.
[2022-07-27 14:38:09,727][PID:1][DEBUG][redash.query_runner] Registering Salesforce (salesforce) query runner.
[2022-07-27 14:38:09,770][PID:1][DEBUG][passlib.utils.compat] loaded lazy attr 'SafeConfigParser': <class 'configparser.ConfigParser'>
[2022-07-27 14:38:09,770][PID:1][DEBUG][passlib.utils.compat] loaded lazy attr 'NativeStringIO': <class '_io.StringIO'>
[2022-07-27 14:38:09,770][PID:1][DEBUG][passlib.utils.compat] loaded lazy attr 'BytesIO': <class '_io.BytesIO'>
[2022-07-27 14:38:10,354][PID:1][DEBUG][redash.query_runner] Registering Query Results (results) query runner.
[2022-07-27 14:38:10,356][PID:1][DEBUG][redash.query_runner] Registering Prometheus (prometheus) query runner.
[2022-07-27 14:38:10,389][PID:1][DEBUG][redash.query_runner] Registering Qubole (qubole) query runner.
[2022-07-27 14:38:10,406][PID:1][DEBUG][redash.query_runner] Registering DB2 (db2) query runner.
[2022-07-27 14:38:10,409][PID:1][DEBUG][redash.query_runner] Registering Druid (druid) query runner.
[2022-07-27 14:38:10,411][PID:1][DEBUG][redash.query_runner] Registering Kylin (kylin) query runner.
[2022-07-27 14:38:10,412][PID:1][DEBUG][redash.query_runner] Registering Apache Drill (drill) query runner.
[2022-07-27 14:38:10,416][PID:1][DEBUG][redash.query_runner] Registering Uptycs (uptycs) query runner.
[2022-07-27 14:38:10,599][PID:1][DEBUG][snowflake.connector.ssl_wrap_socket] Injecting ssl_wrap_socket_with_ocsp
[2022-07-27 14:38:10,601][PID:1][DEBUG][snowflake.connector.auth] cache directory: /home/redash/.cache/snowflake
[2022-07-27 14:38:10,776][PID:1][DEBUG][redash.query_runner] Registering Snowflake (snowflake) query runner.
[2022-07-27 14:38:10,794][PID:1][DEBUG][redash.query_runner] Registering Phoenix (phoenix) query runner.
[2022-07-27 14:38:10,795][PID:1][DEBUG][redash.query_runner] Registering JSON (json) query runner.
[2022-07-27 14:38:10,843][PID:1][DEBUG][redash.query_runner] Registering Cassandra (Cassandra) query runner.
[2022-07-27 14:38:10,843][PID:1][DEBUG][redash.query_runner] Registering ScyllaDB (scylla) query runner.
[2022-07-27 14:38:10,863][PID:1][DEBUG][redash.query_runner] Registering Dgraph (dgraph) query runner.
[2022-07-27 14:38:10,872][PID:1][DEBUG][redash.query_runner] Registering Azure Data Explorer (Kusto) (azure_kusto) query runner.
[2022-07-27 14:38:10,882][PID:1][DEBUG][redash.query_runner] Registering Exasol (exasol) query runner.
[2022-07-27 14:38:10,883][PID:1][DEBUG][redash.query_runner] Registering Amazon CloudWatch (cloudwatch) query runner.
[2022-07-27 14:38:10,884][PID:1][DEBUG][redash.query_runner] Registering Amazon CloudWatch Logs Insights (cloudwatch_insights) query runner.
[2022-07-27 14:38:10,985][PID:1][DEBUG][redash.query_runner] Registering eccenca Corporate Memory (with SPARQL) (corporate_memory) query runner.
[2022-07-27 14:38:10,988][PID:1][DEBUG][redash.query_runner] Registering SPARQL Endpoint (sparql_endpoint) query runner.
[2022-07-27 14:38:11,120][PID:1][DEBUG][redash.query_runner] Registering Excel (excel) query runner.
[2022-07-27 14:38:11,121][PID:1][DEBUG][redash.query_runner] Registering CSV (csv) query runner.
[2022-07-27 14:38:11,124][PID:1][DEBUG][redash.query_runner] Registering Firebolt (firebolt) query runner.
[2022-07-27 14:38:11,125][PID:1][DEBUG][redash.destinations] Registering Email (email) destinations.
[2022-07-27 14:38:11,126][PID:1][DEBUG][redash.destinations] Registering Slack (slack) destinations.
[2022-07-27 14:38:11,147][PID:1][DEBUG][redash.destinations] Registering Webhook (webhook) destinations.
[2022-07-27 14:38:11,147][PID:1][DEBUG][redash.destinations] Registering HipChat (hipchat) destinations.
[2022-07-27 14:38:11,148][PID:1][DEBUG][redash.destinations] Registering Mattermost (mattermost) destinations.
[2022-07-27 14:38:11,149][PID:1][DEBUG][redash.destinations] Registering ChatWork (chatwork) destinations.
[2022-07-27 14:38:11,154][PID:1][DEBUG][redash.destinations] Registering PagerDuty (pagerduty) destinations.
[2022-07-27 14:38:11,154][PID:1][DEBUG][redash.destinations] Registering Google Hangouts Chat (hangouts_chat) destinations.
[2022-07-27 14:38:11,885][PID:1][INFO][rq_scheduler.scheduler] Registering birth
[2022-07-27 14:38:11,887][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:38:11,888][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:38:11,891][PID:1][DEBUG][rq_scheduler.scheduler] Pushing 18281a865ed3d1a60f366aeb8596fe2283aa421f to periodic
[2022-07-27 14:38:11,896][PID:1][DEBUG][rq_scheduler.scheduler] Pushing 305c0cae0a196ae96915fd2b6f81001c435aad65 to periodic
[2022-07-27 14:38:11,901][PID:1][DEBUG][rq_scheduler.scheduler] Pushing 59a84668e68687338646f735965213c58e814b32 to periodic
[2022-07-27 14:38:11,905][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 4.98 seconds
[2022-07-27 14:38:16,890][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:38:16,892][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:38:16,895][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:38:21,894][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:38:21,896][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:38:21,898][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:38:26,900][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:38:26,902][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:38:26,904][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:38:31,902][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:38:31,904][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:38:31,905][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:38:36,907][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:38:36,910][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:38:36,911][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:38:41,910][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:38:41,912][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:38:41,915][PID:1][DEBUG][rq_scheduler.scheduler] Pushing 305c0cae0a196ae96915fd2b6f81001c435aad65 to periodic
[2022-07-27 14:38:41,920][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 4.99 seconds
[2022-07-27 14:38:46,916][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:38:46,918][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:38:46,919][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:38:51,918][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:38:51,920][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:38:51,922][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:38:56,924][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:38:56,926][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:38:56,927][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:39:01,930][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:39:01,932][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:39:01,934][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:39:06,932][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:39:06,933][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:39:06,935][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:39:11,937][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:39:11,938][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:39:11,940][PID:1][DEBUG][rq_scheduler.scheduler] Pushing 18281a865ed3d1a60f366aeb8596fe2283aa421f to periodic
[2022-07-27 14:39:11,943][PID:1][DEBUG][rq_scheduler.scheduler] Pushing 305c0cae0a196ae96915fd2b6f81001c435aad65 to periodic
[2022-07-27 14:39:11,947][PID:1][DEBUG][rq_scheduler.scheduler] Pushing 59a84668e68687338646f735965213c58e814b32 to periodic
[2022-07-27 14:39:11,952][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 4.99 seconds
[2022-07-27 14:39:16,943][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:39:16,945][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:39:16,947][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:39:21,947][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:39:21,948][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:39:21,950][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:39:26,950][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:39:26,952][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:39:26,954][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:39:31,954][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:39:31,956][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:39:31,958][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:39:36,957][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:39:36,959][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:39:36,961][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:39:41,963][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:39:41,965][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:39:41,966][PID:1][DEBUG][rq_scheduler.scheduler] Pushing 305c0cae0a196ae96915fd2b6f81001c435aad65 to periodic
[2022-07-27 14:39:41,970][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 4.99 seconds
[2022-07-27 14:39:46,966][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:39:46,968][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:39:46,970][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:39:51,970][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:39:51,972][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:39:51,974][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:39:56,976][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:39:56,978][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:39:56,979][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:40:01,978][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:40:01,980][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:40:01,982][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:40:06,984][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:40:06,986][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:40:06,988][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:40:11,989][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:40:11,991][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:40:11,994][PID:1][DEBUG][rq_scheduler.scheduler] Pushing e27209059575fcc17c527c47d0957cb21756e551 to periodic
[2022-07-27 14:40:11,998][PID:1][DEBUG][rq_scheduler.scheduler] Pushing 18281a865ed3d1a60f366aeb8596fe2283aa421f to periodic
[2022-07-27 14:40:12,004][PID:1][DEBUG][rq_scheduler.scheduler] Pushing 305c0cae0a196ae96915fd2b6f81001c435aad65 to periodic
[2022-07-27 14:40:12,013][PID:1][DEBUG][rq_scheduler.scheduler] Pushing 59a84668e68687338646f735965213c58e814b32 to periodic
[2022-07-27 14:40:12,019][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 4.97 seconds
[2022-07-27 14:40:16,995][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:40:16,997][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:40:16,999][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:40:22,000][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:40:22,002][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:40:22,004][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:40:27,002][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:40:27,005][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:40:27,009][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 4.99 seconds
[2022-07-27 14:40:32,007][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:40:32,009][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:40:32,012][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:40:37,010][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:40:37,012][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:40:37,015][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:40:42,014][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:40:42,015][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:40:42,018][PID:1][DEBUG][rq_scheduler.scheduler] Pushing 305c0cae0a196ae96915fd2b6f81001c435aad65 to periodic
[2022-07-27 14:40:42,023][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 4.99 seconds
[2022-07-27 14:40:47,020][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:40:47,021][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:40:47,023][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:40:52,022][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:40:52,024][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:40:52,027][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:40:57,026][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:40:57,028][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:40:57,029][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:41:02,031][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:41:02,032][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:41:02,033][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:41:07,034][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:41:07,036][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:41:07,037][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:41:12,039][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:41:12,040][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:41:12,042][PID:1][DEBUG][rq_scheduler.scheduler] Pushing 18281a865ed3d1a60f366aeb8596fe2283aa421f to periodic
[2022-07-27 14:41:12,046][PID:1][DEBUG][rq_scheduler.scheduler] Pushing 305c0cae0a196ae96915fd2b6f81001c435aad65 to periodic
[2022-07-27 14:41:12,049][PID:1][DEBUG][rq_scheduler.scheduler] Pushing 59a84668e68687338646f735965213c58e814b32 to periodic
[2022-07-27 14:41:12,052][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 4.99 seconds
[2022-07-27 14:41:17,043][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:41:17,044][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:41:17,045][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:41:22,048][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:41:22,049][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:41:22,050][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds
[2022-07-27 14:41:27,053][PID:1][DEBUG][rq_scheduler.scheduler] Entering run loop
[2022-07-27 14:41:27,055][PID:1][DEBUG][rq_scheduler.scheduler] Checking for scheduled jobs
[2022-07-27 14:41:27,056][PID:1][DEBUG][rq_scheduler.scheduler] Sleeping 5.00 seconds

I still don’t see a scheduled_queries queue on RQ Status > Queues.

And the logs for the scheduled-worker after setting REDASH_LOG_LEVEL=DEBUG:


Starting RQ worker...

2022-07-27 14:44:45,601 INFO RPC interface 'supervisor' initialized

2022-07-27 14:44:45,601 CRIT Server 'unix_http_server' running without any HTTP authentication checking

2022-07-27 14:44:45,601 INFO supervisord started with pid 1

2022-07-27 14:44:46,603 INFO spawned: 'worker_healthcheck' with pid 9

2022-07-27 14:44:46,606 INFO spawned: 'worker-0' with pid 10

2022-07-27 14:44:46,608 INFO spawned: 'worker-1' with pid 11

2022-07-27 14:44:46,611 INFO spawned: 'worker-2' with pid 12

2022-07-27 14:44:46,614 INFO spawned: 'worker-3' with pid 13

2022-07-27 14:44:47,641 INFO success: worker_healthcheck entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)

...

[2022-07-27 14:44:59,659][PID:12][DEBUG][thrift.transport.sslcompat] ipaddress module is available

[2022-07-27 14:44:59,660][PID:12][DEBUG][thrift.transport.sslcompat] ssl.match_hostname is available

[2022-07-27 14:44:59,665][PID:9][DEBUG][redash.query_runner] Registering Yandex Metrica (yandex_metrika) query runner.

[2022-07-27 14:44:59,665][PID:9][DEBUG][redash.query_runner] Registering Yandex AppMetrica (yandex_appmetrika) query runner.

[2022-07-27 14:44:59,666][PID:9][DEBUG][redash.query_runner] Registering Rockset (rockset) query runner.

[2022-07-27 14:44:59,751][PID:9][DEBUG][redash.query_runner] Registering TreasureData (treasuredata) query runner.

[2022-07-27 14:44:59,754][PID:9][DEBUG][redash.query_runner] Registering Sqlite (sqlite) query runner.

[2022-07-27 14:44:59,943][PID:12][DEBUG][redash.query_runner] Registering Mapd (mapd) query runner.

[2022-07-27 14:44:59,946][PID:12][DEBUG][redash.query_runner] Registering JIRA (JQL) (jirajql) query runner.

[2022-07-27 14:44:59,960][PID:12][DEBUG][redash.query_runner] Registering Google Analytics (google_analytics) query runner.

[2022-07-27 14:45:00,056][PID:9][DEBUG][redash.query_runner] Registering DynamoDB (with DQL) (dynamodb_sql) query runner.

[2022-07-27 14:45:00,061][PID:9][DEBUG][redash.query_runner] Registering Microsoft SQL Server (mssql) query runner.

[2022-07-27 14:45:00,062][PID:9][DEBUG][redash.query_runner] Registering Microsoft SQL Server (ODBC) (mssql_odbc) query runner.

[2022-07-27 14:45:00,064][PID:9][DEBUG][redash.query_runner] Registering MemSQL (memsql) query runner.

[2022-07-27 14:45:00,068][PID:12][DEBUG][root] Checking 'python-requests' version...

[2022-07-27 14:45:00,068][PID:12][DEBUG][root] Module 'python-requests' version is 2.21.0. The version is compatible.

[2022-07-27 14:45:00,068][PID:12][DEBUG][redash.query_runner] Registering Axibase Time Series Database (axibasetsd) query runner.

[2022-07-27 14:45:00,145][PID:9][DEBUG][thrift.transport.sslcompat] ipaddress module is available

[2022-07-27 14:45:00,146][PID:9][DEBUG][thrift.transport.sslcompat] ssl.match_hostname is available

[2022-07-27 14:45:00,347][PID:9][DEBUG][redash.query_runner] Registering Mapd (mapd) query runner.

[2022-07-27 14:45:00,348][PID:9][DEBUG][redash.query_runner] Registering JIRA (JQL) (jirajql) query runner.

[2022-07-27 14:45:00,349][PID:9][DEBUG][redash.query_runner] Registering Google Analytics (google_analytics) query runner.

[2022-07-27 14:45:00,359][PID:12][DEBUG][redash.query_runner] Registering Salesforce (salesforce) query runner.

[2022-07-27 14:45:00,453][PID:9][DEBUG][root] Checking 'python-requests' version...

[2022-07-27 14:45:00,541][PID:9][DEBUG][root] Module 'python-requests' version is 2.21.0. The version is compatible.

[2022-07-27 14:45:00,543][PID:9][DEBUG][redash.query_runner] Registering Axibase Time Series Database (axibasetsd) query runner.

[2022-07-27 14:45:00,543][PID:13][DEBUG][redash.query_runner] Registering Impala (impala) query runner.

[2022-07-27 14:45:00,647][PID:13][DEBUG][redash.query_runner] Registering Vertica (vertica) query runner.

[2022-07-27 14:45:00,648][PID:13][DEBUG][redash.query_runner] Registering ClickHouse (clickhouse) query runner.

[2022-07-27 14:45:00,659][PID:9][DEBUG][redash.query_runner] Registering Salesforce (salesforce) query runner.

[2022-07-27 14:45:00,748][PID:13][DEBUG][redash.query_runner] Registering Yandex Metrica (yandex_metrika) query runner.

[2022-07-27 14:45:00,749][PID:13][DEBUG][redash.query_runner] Registering Yandex AppMetrica (yandex_appmetrika) query runner.

[2022-07-27 14:45:00,750][PID:13][DEBUG][redash.query_runner] Registering Rockset (rockset) query runner.

[2022-07-27 14:45:00,764][PID:12][DEBUG][passlib.utils.compat] loaded lazy attr 'SafeConfigParser': <class 'configparser.ConfigParser'>

[2022-07-27 14:45:00,764][PID:12][DEBUG][passlib.utils.compat] loaded lazy attr 'NativeStringIO': <class '_io.StringIO'>

[2022-07-27 14:45:00,764][PID:12][DEBUG][passlib.utils.compat] loaded lazy attr 'BytesIO': <class '_io.BytesIO'>

[2022-07-27 14:45:00,764][PID:13][DEBUG][redash.query_runner] Registering TreasureData (treasuredata) query runner.

[2022-07-27 14:45:00,768][PID:13][DEBUG][redash.query_runner] Registering Sqlite (sqlite) query runner.

[2022-07-27 14:45:00,862][PID:10][DEBUG][redash.query_runner] Registering Impala (impala) query runner.

[2022-07-27 14:45:01,046][PID:10][DEBUG][redash.query_runner] Registering Vertica (vertica) query runner.

[2022-07-27 14:45:01,047][PID:10][DEBUG][redash.query_runner] Registering ClickHouse (clickhouse) query runner.

[2022-07-27 14:45:01,058][PID:13][DEBUG][redash.query_runner] Registering DynamoDB (with DQL) (dynamodb_sql) query runner.

[2022-07-27 14:45:01,061][PID:13][DEBUG][redash.query_runner] Registering Microsoft SQL Server (mssql) query runner.

[2022-07-27 14:45:01,062][PID:13][DEBUG][redash.query_runner] Registering Microsoft SQL Server (ODBC) (mssql_odbc) query runner.

[2022-07-27 14:45:01,064][PID:13][DEBUG][redash.query_runner] Registering MemSQL (memsql) query runner.

[2022-07-27 14:45:01,142][PID:10][DEBUG][redash.query_runner] Registering Yandex Metrica (yandex_metrika) query runner.

[2022-07-27 14:45:01,143][PID:10][DEBUG][redash.query_runner] Registering Yandex AppMetrica (yandex_appmetrika) query runner.

[2022-07-27 14:45:01,143][PID:10][DEBUG][redash.query_runner] Registering Rockset (rockset) query runner.

[2022-07-27 14:45:01,144][PID:13][DEBUG][thrift.transport.sslcompat] ipaddress module is available

[2022-07-27 14:45:01,145][PID:9][DEBUG][passlib.utils.compat] loaded lazy attr 'SafeConfigParser': <class 'configparser.ConfigParser'>

[2022-07-27 14:45:01,145][PID:9][DEBUG][passlib.utils.compat] loaded lazy attr 'NativeStringIO': <class '_io.StringIO'>

[2022-07-27 14:45:01,145][PID:13][DEBUG][thrift.transport.sslcompat] ssl.match_hostname is available

[2022-07-27 14:45:01,145][PID:9][DEBUG][passlib.utils.compat] loaded lazy attr 'BytesIO': <class '_io.BytesIO'>

[2022-07-27 14:45:01,159][PID:10][DEBUG][redash.query_runner] Registering TreasureData (treasuredata) query runner.

[2022-07-27 14:45:01,163][PID:10][DEBUG][redash.query_runner] Registering Sqlite (sqlite) query runner.

[2022-07-27 14:45:01,357][PID:13][DEBUG][redash.query_runner] Registering Mapd (mapd) query runner.

[2022-07-27 14:45:01,358][PID:13][DEBUG][redash.query_runner] Registering JIRA (JQL) (jirajql) query runner.

[2022-07-27 14:45:01,360][PID:13][DEBUG][redash.query_runner] Registering Google Analytics (google_analytics) query runner.

[2022-07-27 14:45:01,471][PID:13][DEBUG][root] Checking 'python-requests' version...

[2022-07-27 14:45:01,472][PID:13][DEBUG][root] Module 'python-requests' version is 2.21.0. The version is compatible.

[2022-07-27 14:45:01,472][PID:13][DEBUG][redash.query_runner] Registering Axibase Time Series Database (axibasetsd) query runner.

[2022-07-27 14:45:01,544][PID:10][DEBUG][redash.query_runner] Registering DynamoDB (with DQL) (dynamodb_sql) query runner.

[2022-07-27 14:45:01,548][PID:10][DEBUG][redash.query_runner] Registering Microsoft SQL Server (mssql) query runner.

[2022-07-27 14:45:01,549][PID:10][DEBUG][redash.query_runner] Registering Microsoft SQL Server (ODBC) (mssql_odbc) query runner.

[2022-07-27 14:45:01,551][PID:10][DEBUG][redash.query_runner] Registering MemSQL (memsql) query runner.

[2022-07-27 14:45:01,554][PID:10][DEBUG][thrift.transport.sslcompat] ipaddress module is available

[2022-07-27 14:45:01,555][PID:10][DEBUG][thrift.transport.sslcompat] ssl.match_hostname is available

[2022-07-27 14:45:01,748][PID:10][DEBUG][redash.query_runner] Registering Mapd (mapd) query runner.

[2022-07-27 14:45:01,750][PID:10][DEBUG][redash.query_runner] Registering JIRA (JQL) (jirajql) query runner.

[2022-07-27 14:45:01,751][PID:10][DEBUG][redash.query_runner] Registering Google Analytics (google_analytics) query runner.

[2022-07-27 14:45:01,756][PID:13][DEBUG][redash.query_runner] Registering Salesforce (salesforce) query runner.

[2022-07-27 14:45:01,857][PID:10][DEBUG][root] Checking 'python-requests' version...

[2022-07-27 14:45:01,858][PID:10][DEBUG][root] Module 'python-requests' version is 2.21.0. The version is compatible.

[2022-07-27 14:45:01,859][PID:10][DEBUG][redash.query_runner] Registering Axibase Time Series Database (axibasetsd) query runner.

[2022-07-27 14:45:02,145][PID:10][DEBUG][redash.query_runner] Registering Salesforce (salesforce) query runner.

[2022-07-27 14:45:02,152][PID:13][DEBUG][passlib.utils.compat] loaded lazy attr 'SafeConfigParser': <class 'configparser.ConfigParser'>

[2022-07-27 14:45:02,161][PID:13][DEBUG][passlib.utils.compat] loaded lazy attr 'NativeStringIO': <class '_io.StringIO'>

[2022-07-27 14:45:02,162][PID:13][DEBUG][passlib.utils.compat] loaded lazy attr 'BytesIO': <class '_io.BytesIO'>

[2022-07-27 14:45:02,562][PID:10][DEBUG][passlib.utils.compat] loaded lazy attr 'SafeConfigParser': <class 'configparser.ConfigParser'>

[2022-07-27 14:45:02,562][PID:10][DEBUG][passlib.utils.compat] loaded lazy attr 'NativeStringIO': <class '_io.StringIO'>

[2022-07-27 14:45:02,563][PID:10][DEBUG][passlib.utils.compat] loaded lazy attr 'BytesIO': <class '_io.BytesIO'>

[2022-07-27 14:45:03,342][PID:11][DEBUG][redash.query_runner] Registering Impala (impala) query runner.

[2022-07-27 14:45:03,446][PID:11][DEBUG][redash.query_runner] Registering Vertica (vertica) query runner.

[2022-07-27 14:45:03,448][PID:11][DEBUG][redash.query_runner] Registering ClickHouse (clickhouse) query runner.

[2022-07-27 14:45:03,541][PID:11][DEBUG][redash.query_runner] Registering Yandex Metrica (yandex_metrika) query runner.

[2022-07-27 14:45:03,542][PID:11][DEBUG][redash.query_runner] Registering Yandex AppMetrica (yandex_appmetrika) query runner.

[2022-07-27 14:45:03,543][PID:11][DEBUG][redash.query_runner] Registering Rockset (rockset) query runner.

[2022-07-27 14:45:03,554][PID:11][DEBUG][redash.query_runner] Registering TreasureData (treasuredata) query runner.

[2022-07-27 14:45:03,558][PID:11][DEBUG][redash.query_runner] Registering Sqlite (sqlite) query runner.

[2022-07-27 14:45:03,767][PID:11][DEBUG][redash.query_runner] Registering DynamoDB (with DQL) (dynamodb_sql) query runner.

[2022-07-27 14:45:03,842][PID:11][DEBUG][redash.query_runner] Registering Microsoft SQL Server (mssql) query runner.

[2022-07-27 14:45:03,843][PID:11][DEBUG][redash.query_runner] Registering Microsoft SQL Server (ODBC) (mssql_odbc) query runner.

[2022-07-27 14:45:03,846][PID:11][DEBUG][redash.query_runner] Registering MemSQL (memsql) query runner.

[2022-07-27 14:45:03,850][PID:11][DEBUG][thrift.transport.sslcompat] ipaddress module is available

[2022-07-27 14:45:03,851][PID:11][DEBUG][thrift.transport.sslcompat] ssl.match_hostname is available

[2022-07-27 14:45:04,058][PID:11][DEBUG][redash.query_runner] Registering Mapd (mapd) query runner.

[2022-07-27 14:45:04,059][PID:11][DEBUG][redash.query_runner] Registering JIRA (JQL) (jirajql) query runner.

[2022-07-27 14:45:04,062][PID:11][DEBUG][redash.query_runner] Registering Google Analytics (google_analytics) query runner.

[2022-07-27 14:45:04,161][PID:9][DEBUG][redash.query_runner] Registering Query Results (results) query runner.

[2022-07-27 14:45:04,164][PID:9][DEBUG][redash.query_runner] Registering Prometheus (prometheus) query runner.

[2022-07-27 14:45:04,246][PID:11][DEBUG][root] Checking 'python-requests' version...

[2022-07-27 14:45:04,253][PID:11][DEBUG][root] Module 'python-requests' version is 2.21.0. The version is compatible.

[2022-07-27 14:45:04,254][PID:11][DEBUG][redash.query_runner] Registering Axibase Time Series Database (axibasetsd) query runner.

[2022-07-27 14:45:04,264][PID:12][DEBUG][redash.query_runner] Registering Query Results (results) query runner.

[2022-07-27 14:45:04,264][PID:12][DEBUG][redash.query_runner] Registering Prometheus (prometheus) query runner.

[2022-07-27 14:45:04,354][PID:9][DEBUG][redash.query_runner] Registering Qubole (qubole) query runner.

[2022-07-27 14:45:04,365][PID:9][DEBUG][redash.query_runner] Registering DB2 (db2) query runner.

[2022-07-27 14:45:04,444][PID:9][DEBUG][redash.query_runner] Registering Druid (druid) query runner.

[2022-07-27 14:45:04,446][PID:9][DEBUG][redash.query_runner] Registering Kylin (kylin) query runner.

[2022-07-27 14:45:04,447][PID:9][DEBUG][redash.query_runner] Registering Apache Drill (drill) query runner.

[2022-07-27 14:45:04,451][PID:9][DEBUG][redash.query_runner] Registering Uptycs (uptycs) query runner.

[2022-07-27 14:45:04,452][PID:11][DEBUG][redash.query_runner] Registering Salesforce (salesforce) query runner.

[2022-07-27 14:45:04,454][PID:12][DEBUG][redash.query_runner] Registering Qubole (qubole) query runner.

[2022-07-27 14:45:04,463][PID:12][DEBUG][redash.query_runner] Registering DB2 (db2) query runner.

[2022-07-27 14:45:04,466][PID:12][DEBUG][redash.query_runner] Registering Druid (druid) query runner.

[2022-07-27 14:45:04,467][PID:12][DEBUG][redash.query_runner] Registering Kylin (kylin) query runner.

[2022-07-27 14:45:04,468][PID:12][DEBUG][redash.query_runner] Registering Apache Drill (drill) query runner.

[2022-07-27 14:45:04,471][PID:12][DEBUG][redash.query_runner] Registering Uptycs (uptycs) query runner.

[2022-07-27 14:45:04,763][PID:11][DEBUG][passlib.utils.compat] loaded lazy attr 'SafeConfigParser': <class 'configparser.ConfigParser'>

[2022-07-27 14:45:04,841][PID:11][DEBUG][passlib.utils.compat] loaded lazy attr 'NativeStringIO': <class '_io.StringIO'>

[2022-07-27 14:45:04,842][PID:11][DEBUG][passlib.utils.compat] loaded lazy attr 'BytesIO': <class '_io.BytesIO'>

[2022-07-27 14:45:05,142][PID:12][DEBUG][snowflake.connector.ssl_wrap_socket] Injecting ssl_wrap_socket_with_ocsp

[2022-07-27 14:45:05,145][PID:9][DEBUG][snowflake.connector.ssl_wrap_socket] Injecting ssl_wrap_socket_with_ocsp

[2022-07-27 14:45:05,146][PID:12][DEBUG][snowflake.connector.auth] cache directory: /home/redash/.cache/snowflake

[2022-07-27 14:45:05,146][PID:9][DEBUG][snowflake.connector.auth] cache directory: /home/redash/.cache/snowflake

[2022-07-27 14:45:05,760][PID:13][DEBUG][redash.query_runner] Registering Query Results (results) query runner.

[2022-07-27 14:45:05,761][PID:13][DEBUG][redash.query_runner] Registering Prometheus (prometheus) query runner.

[2022-07-27 14:45:05,955][PID:13][DEBUG][redash.query_runner] Registering Qubole (qubole) query runner.

[2022-07-27 14:45:06,041][PID:13][DEBUG][redash.query_runner] Registering DB2 (db2) query runner.

[2022-07-27 14:45:06,044][PID:13][DEBUG][redash.query_runner] Registering Druid (druid) query runner.

[2022-07-27 14:45:06,044][PID:13][DEBUG][redash.query_runner] Registering Kylin (kylin) query runner.

[2022-07-27 14:45:06,045][PID:13][DEBUG][redash.query_runner] Registering Apache Drill (drill) query runner.

[2022-07-27 14:45:06,047][PID:12][DEBUG][redash.query_runner] Registering Snowflake (snowflake) query runner.

[2022-07-27 14:45:06,048][PID:13][DEBUG][redash.query_runner] Registering Uptycs (uptycs) query runner.

[2022-07-27 14:45:06,054][PID:9][DEBUG][redash.query_runner] Registering Snowflake (snowflake) query runner.

[2022-07-27 14:45:06,149][PID:12][DEBUG][redash.query_runner] Registering Phoenix (phoenix) query runner.

[2022-07-27 14:45:06,152][PID:12][DEBUG][redash.query_runner] Registering JSON (json) query runner.

[2022-07-27 14:45:06,157][PID:9][DEBUG][redash.query_runner] Registering Phoenix (phoenix) query runner.

[2022-07-27 14:45:06,157][PID:9][DEBUG][redash.query_runner] Registering JSON (json) query runner.

[2022-07-27 14:45:06,360][PID:12][DEBUG][redash.query_runner] Registering Cassandra (Cassandra) query runner.

[2022-07-27 14:45:06,361][PID:12][DEBUG][redash.query_runner] Registering ScyllaDB (scylla) query runner.

[2022-07-27 14:45:06,449][PID:9][DEBUG][redash.query_runner] Registering Cassandra (Cassandra) query runner.

[2022-07-27 14:45:06,450][PID:9][DEBUG][redash.query_runner] Registering ScyllaDB (scylla) query runner.

[2022-07-27 14:45:06,546][PID:12][DEBUG][redash.query_runner] Registering Dgraph (dgraph) query runner.

[2022-07-27 14:45:06,551][PID:9][DEBUG][redash.query_runner] Registering Dgraph (dgraph) query runner.

[2022-07-27 14:45:06,560][PID:12][DEBUG][redash.query_runner] Registering Azure Data Explorer (Kusto) (azure_kusto) query runner.

[2022-07-27 14:45:06,564][PID:9][DEBUG][redash.query_runner] Registering Azure Data Explorer (Kusto) (azure_kusto) query runner.

[2022-07-27 14:45:06,645][PID:12][DEBUG][redash.query_runner] Registering Exasol (exasol) query runner.

[2022-07-27 14:45:06,647][PID:12][DEBUG][redash.query_runner] Registering Amazon CloudWatch (cloudwatch) query runner.

[2022-07-27 14:45:06,649][PID:12][DEBUG][redash.query_runner] Registering Amazon CloudWatch Logs Insights (cloudwatch_insights) query runner.

[2022-07-27 14:45:06,649][PID:9][DEBUG][redash.query_runner] Registering Exasol (exasol) query runner.

[2022-07-27 14:45:06,650][PID:9][DEBUG][redash.query_runner] Registering Amazon CloudWatch (cloudwatch) query runner.

[2022-07-27 14:45:06,650][PID:9][DEBUG][redash.query_runner] Registering Amazon CloudWatch Logs Insights (cloudwatch_insights) query runner.

[2022-07-27 14:45:06,755][PID:13][DEBUG][snowflake.connector.ssl_wrap_socket] Injecting ssl_wrap_socket_with_ocsp

[2022-07-27 14:45:06,759][PID:13][DEBUG][snowflake.connector.auth] cache directory: /home/redash/.cache/snowflake

[2022-07-27 14:45:07,155][PID:12][DEBUG][redash.query_runner] Registering eccenca Corporate Memory (with SPARQL) (corporate_memory) query runner.

[2022-07-27 14:45:07,157][PID:12][DEBUG][redash.query_runner] Registering SPARQL Endpoint (sparql_endpoint) query runner.

[2022-07-27 14:45:07,248][PID:9][DEBUG][redash.query_runner] Registering eccenca Corporate Memory (with SPARQL) (corporate_memory) query runner.

[2022-07-27 14:45:07,250][PID:9][DEBUG][redash.query_runner] Registering SPARQL Endpoint (sparql_endpoint) query runner.

[2022-07-27 14:45:07,654][PID:13][DEBUG][redash.query_runner] Registering Snowflake (snowflake) query runner.

[2022-07-27 14:45:07,752][PID:13][DEBUG][redash.query_runner] Registering Phoenix (phoenix) query runner.

[2022-07-27 14:45:07,753][PID:13][DEBUG][redash.query_runner] Registering JSON (json) query runner.

[2022-07-27 14:45:07,963][PID:13][DEBUG][redash.query_runner] Registering Cassandra (Cassandra) query runner.

[2022-07-27 14:45:07,963][PID:13][DEBUG][redash.query_runner] Registering ScyllaDB (scylla) query runner.

[2022-07-27 14:45:08,060][PID:13][DEBUG][redash.query_runner] Registering Dgraph (dgraph) query runner.

[2022-07-27 14:45:08,060][PID:12][DEBUG][redash.query_runner] Registering Excel (excel) query runner.

[2022-07-27 14:45:08,062][PID:12][DEBUG][redash.query_runner] Registering CSV (csv) query runner.

[2022-07-27 14:45:08,062][PID:9][DEBUG][redash.query_runner] Registering Excel (excel) query runner.

[2022-07-27 14:45:08,062][PID:9][DEBUG][redash.query_runner] Registering CSV (csv) query runner.

[2022-07-27 14:45:08,065][PID:12][DEBUG][redash.query_runner] Registering Firebolt (firebolt) query runner.

[2022-07-27 14:45:08,066][PID:12][DEBUG][redash.destinations] Registering Email (email) destinations.

[2022-07-27 14:45:08,067][PID:12][DEBUG][redash.destinations] Registering Slack (slack) destinations.

[2022-07-27 14:45:08,142][PID:9][DEBUG][redash.query_runner] Registering Firebolt (firebolt) query runner.

[2022-07-27 14:45:08,143][PID:9][DEBUG][redash.destinations] Registering Email (email) destinations.

[2022-07-27 14:45:08,143][PID:9][DEBUG][redash.destinations] Registering Slack (slack) destinations.

[2022-07-27 14:45:08,145][PID:13][DEBUG][redash.query_runner] Registering Azure Data Explorer (Kusto) (azure_kusto) query runner.

[2022-07-27 14:45:08,155][PID:10][DEBUG][redash.query_runner] Registering Query Results (results) query runner.

[2022-07-27 14:45:08,157][PID:13][DEBUG][redash.query_runner] Registering Exasol (exasol) query runner.

[2022-07-27 14:45:08,157][PID:13][DEBUG][redash.query_runner] Registering Amazon CloudWatch (cloudwatch) query runner.

[2022-07-27 14:45:08,157][PID:13][DEBUG][redash.query_runner] Registering Amazon CloudWatch Logs Insights (cloudwatch_insights) query runner.

[2022-07-27 14:45:08,162][PID:10][DEBUG][redash.query_runner] Registering Prometheus (prometheus) query runner.

[2022-07-27 14:45:08,253][PID:12][DEBUG][redash.destinations] Registering Webhook (webhook) destinations.

[2022-07-27 14:45:08,253][PID:9][DEBUG][redash.destinations] Registering Webhook (webhook) destinations.

[2022-07-27 14:45:08,254][PID:12][DEBUG][redash.destinations] Registering HipChat (hipchat) destinations.

[2022-07-27 14:45:08,255][PID:9][DEBUG][redash.destinations] Registering HipChat (hipchat) destinations.

[2022-07-27 14:45:08,255][PID:12][DEBUG][redash.destinations] Registering Mattermost (mattermost) destinations.

[2022-07-27 14:45:08,255][PID:9][DEBUG][redash.destinations] Registering Mattermost (mattermost) destinations.

[2022-07-27 14:45:08,256][PID:12][DEBUG][redash.destinations] Registering ChatWork (chatwork) destinations.

[2022-07-27 14:45:08,257][PID:9][DEBUG][redash.destinations] Registering ChatWork (chatwork) destinations.

[2022-07-27 14:45:08,261][PID:12][DEBUG][redash.destinations] Registering PagerDuty (pagerduty) destinations.

[2022-07-27 14:45:08,262][PID:12][DEBUG][redash.destinations] Registering Google Hangouts Chat (hangouts_chat) destinations.

[2022-07-27 14:45:08,264][PID:9][DEBUG][redash.destinations] Registering PagerDuty (pagerduty) destinations.

[2022-07-27 14:45:08,264][PID:9][DEBUG][redash.destinations] Registering Google Hangouts Chat (hangouts_chat) destinations.

[2022-07-27 14:45:08,452][PID:10][DEBUG][redash.query_runner] Registering Qubole (qubole) query runner.

[2022-07-27 14:45:08,553][PID:10][DEBUG][redash.query_runner] Registering DB2 (db2) query runner.

[2022-07-27 14:45:08,643][PID:10][DEBUG][redash.query_runner] Registering Druid (druid) query runner.

[2022-07-27 14:45:08,654][PID:10][DEBUG][redash.query_runner] Registering Kylin (kylin) query runner.

[2022-07-27 14:45:08,655][PID:10][DEBUG][redash.query_runner] Registering Apache Drill (drill) query runner.

[2022-07-27 14:45:08,659][PID:10][DEBUG][redash.query_runner] Registering Uptycs (uptycs) query runner.

[2022-07-27 14:45:08,755][PID:13][DEBUG][redash.query_runner] Registering eccenca Corporate Memory (with SPARQL) (corporate_memory) query runner.

[2022-07-27 14:45:08,757][PID:13][DEBUG][redash.query_runner] Registering SPARQL Endpoint (sparql_endpoint) query runner.

[2022-07-27 14:45:09,461][PID:13][DEBUG][redash.query_runner] Registering Excel (excel) query runner.

[2022-07-27 14:45:09,461][PID:13][DEBUG][redash.query_runner] Registering CSV (csv) query runner.

[2022-07-27 14:45:09,464][PID:13][DEBUG][redash.query_runner] Registering Firebolt (firebolt) query runner.

[2022-07-27 14:45:09,465][PID:13][DEBUG][redash.destinations] Registering Email (email) destinations.

[2022-07-27 14:45:09,465][PID:13][DEBUG][redash.destinations] Registering Slack (slack) destinations.

[2022-07-27 14:45:09,552][PID:13][DEBUG][redash.destinations] Registering Webhook (webhook) destinations.

[2022-07-27 14:45:09,553][PID:13][DEBUG][redash.destinations] Registering HipChat (hipchat) destinations.

[2022-07-27 14:45:09,553][PID:13][DEBUG][redash.destinations] Registering Mattermost (mattermost) destinations.

[2022-07-27 14:45:09,553][PID:13][DEBUG][redash.destinations] Registering ChatWork (chatwork) destinations.

[2022-07-27 14:45:09,561][PID:13][DEBUG][redash.destinations] Registering PagerDuty (pagerduty) destinations.

[2022-07-27 14:45:09,562][PID:13][DEBUG][redash.destinations] Registering Google Hangouts Chat (hangouts_chat) destinations.

[2022-07-27 14:45:09,958][PID:10][DEBUG][snowflake.connector.ssl_wrap_socket] Injecting ssl_wrap_socket_with_ocsp

[2022-07-27 14:45:09,961][PID:10][DEBUG][snowflake.connector.auth] cache directory: /home/redash/.cache/snowflake

[2022-07-27 14:45:10,642][PID:11][DEBUG][redash.query_runner] Registering Query Results (results) query runner.

[2022-07-27 14:45:10,645][PID:11][DEBUG][redash.query_runner] Registering Prometheus (prometheus) query runner.

[2022-07-27 14:45:10,947][PID:11][DEBUG][redash.query_runner] Registering Qubole (qubole) query runner.

[2022-07-27 14:45:11,052][PID:11][DEBUG][redash.query_runner] Registering DB2 (db2) query runner.

[2022-07-27 14:45:11,067][PID:11][DEBUG][redash.query_runner] Registering Druid (druid) query runner.

[2022-07-27 14:45:11,068][PID:11][DEBUG][redash.query_runner] Registering Kylin (kylin) query runner.

[2022-07-27 14:45:11,068][PID:11][DEBUG][redash.query_runner] Registering Apache Drill (drill) query runner.

[2022-07-27 14:45:11,144][PID:11][DEBUG][redash.query_runner] Registering Uptycs (uptycs) query runner.

READY

2022/07/27 14:45:11 [worker_healthcheck] Starting the health check for worker process Checks config: [(<class 'redash.cli.rq.WorkerHealthcheck'>, {})]

2022/07/27 14:45:11 [worker_healthcheck] Installing signal handlers.

2022/07/27 14:45:11 [worker_healthcheck] Received TICK_60 event from supervisor

2022/07/27 14:45:11 [worker_healthcheck] No processes in state RUNNING found for process worker

RESULT 2

OKREADY

[2022-07-27 14:45:11,865][PID:10][DEBUG][redash.query_runner] Registering Snowflake (snowflake) query runner.

[2022-07-27 14:45:11,967][PID:10][DEBUG][redash.query_runner] Registering Phoenix (phoenix) query runner.

[2022-07-27 14:45:11,967][PID:10][DEBUG][redash.query_runner] Registering JSON (json) query runner.

[2022-07-27 14:45:12,061][PID:12][INFO][rq.worker] Worker rq:worker:60c6eba149684095a80e3c2e5709f5c8: started, version 1.5.0

[2022-07-27 14:45:12,062][PID:12][INFO][rq.worker] *** Listening on scheduled_queries, schemas...

[2022-07-27 14:45:12,150][PID:11][DEBUG][snowflake.connector.ssl_wrap_socket] Injecting ssl_wrap_socket_with_ocsp

[2022-07-27 14:45:12,152][PID:11][DEBUG][snowflake.connector.auth] cache directory: /home/redash/.cache/snowflake

[2022-07-27 14:45:12,247][PID:10][DEBUG][redash.query_runner] Registering Cassandra (Cassandra) query runner.

[2022-07-27 14:45:12,248][PID:10][DEBUG][redash.query_runner] Registering ScyllaDB (scylla) query runner.

[2022-07-27 14:45:12,273][PID:10][DEBUG][redash.query_runner] Registering Dgraph (dgraph) query runner.

[2022-07-27 14:45:12,349][PID:10][DEBUG][redash.query_runner] Registering Azure Data Explorer (Kusto) (azure_kusto) query runner.

[2022-07-27 14:45:12,361][PID:10][DEBUG][redash.query_runner] Registering Exasol (exasol) query runner.

[2022-07-27 14:45:12,362][PID:10][DEBUG][redash.query_runner] Registering Amazon CloudWatch (cloudwatch) query runner.

[2022-07-27 14:45:12,362][PID:10][DEBUG][redash.query_runner] Registering Amazon CloudWatch Logs Insights (cloudwatch_insights) query runner.

[2022-07-27 14:45:12,764][PID:10][DEBUG][redash.query_runner] Registering eccenca Corporate Memory (with SPARQL) (corporate_memory) query runner.

[2022-07-27 14:45:12,765][PID:10][DEBUG][redash.query_runner] Registering SPARQL Endpoint (sparql_endpoint) query runner.

[2022-07-27 14:45:12,856][PID:11][DEBUG][redash.query_runner] Registering Snowflake (snowflake) query runner.

[2022-07-27 14:45:12,870][PID:13][INFO][rq.worker] Worker rq:worker:174b3f26d67c471fa97b27609a3ba072: started, version 1.5.0

[2022-07-27 14:45:12,871][PID:13][INFO][rq.worker] *** Listening on scheduled_queries, schemas...

[2022-07-27 14:45:12,951][PID:11][DEBUG][redash.query_runner] Registering Phoenix (phoenix) query runner.

[2022-07-27 14:45:12,952][PID:11][DEBUG][redash.query_runner] Registering JSON (json) query runner.

[2022-07-27 14:45:13,049][PID:11][DEBUG][redash.query_runner] Registering Cassandra (Cassandra) query runner.

[2022-07-27 14:45:13,049][PID:11][DEBUG][redash.query_runner] Registering ScyllaDB (scylla) query runner.

[2022-07-27 14:45:13,075][PID:11][DEBUG][redash.query_runner] Registering Dgraph (dgraph) query runner.

[2022-07-27 14:45:13,088][PID:11][DEBUG][redash.query_runner] Registering Azure Data Explorer (Kusto) (azure_kusto) query runner.

[2022-07-27 14:45:13,153][PID:11][DEBUG][redash.query_runner] Registering Exasol (exasol) query runner.

[2022-07-27 14:45:13,154][PID:11][DEBUG][redash.query_runner] Registering Amazon CloudWatch (cloudwatch) query runner.

[2022-07-27 14:45:13,154][PID:11][DEBUG][redash.query_runner] Registering Amazon CloudWatch Logs Insights (cloudwatch_insights) query runner.

[2022-07-27 14:45:13,184][PID:10][DEBUG][redash.query_runner] Registering Excel (excel) query runner.

[2022-07-27 14:45:13,184][PID:10][DEBUG][redash.query_runner] Registering CSV (csv) query runner.

[2022-07-27 14:45:13,187][PID:10][DEBUG][redash.query_runner] Registering Firebolt (firebolt) query runner.

[2022-07-27 14:45:13,188][PID:10][DEBUG][redash.destinations] Registering Email (email) destinations.

[2022-07-27 14:45:13,241][PID:10][DEBUG][redash.destinations] Registering Slack (slack) destinations.

[2022-07-27 14:45:13,253][PID:10][DEBUG][redash.destinations] Registering Webhook (webhook) destinations.

[2022-07-27 14:45:13,254][PID:10][DEBUG][redash.destinations] Registering HipChat (hipchat) destinations.

[2022-07-27 14:45:13,254][PID:10][DEBUG][redash.destinations] Registering Mattermost (mattermost) destinations.

[2022-07-27 14:45:13,254][PID:10][DEBUG][redash.destinations] Registering ChatWork (chatwork) destinations.

[2022-07-27 14:45:13,261][PID:10][DEBUG][redash.destinations] Registering PagerDuty (pagerduty) destinations.

[2022-07-27 14:45:13,261][PID:10][DEBUG][redash.destinations] Registering Google Hangouts Chat (hangouts_chat) destinations.

[2022-07-27 14:45:13,451][PID:11][DEBUG][redash.query_runner] Registering eccenca Corporate Memory (with SPARQL) (corporate_memory) query runner.

[2022-07-27 14:45:13,451][PID:11][DEBUG][redash.query_runner] Registering SPARQL Endpoint (sparql_endpoint) query runner.

[2022-07-27 14:45:13,789][PID:11][DEBUG][redash.query_runner] Registering Excel (excel) query runner.

[2022-07-27 14:45:13,790][PID:11][DEBUG][redash.query_runner] Registering CSV (csv) query runner.

[2022-07-27 14:45:13,792][PID:11][DEBUG][redash.query_runner] Registering Firebolt (firebolt) query runner.

[2022-07-27 14:45:13,793][PID:11][DEBUG][redash.destinations] Registering Email (email) destinations.

[2022-07-27 14:45:13,793][PID:11][DEBUG][redash.destinations] Registering Slack (slack) destinations.

[2022-07-27 14:45:13,854][PID:11][DEBUG][redash.destinations] Registering Webhook (webhook) destinations.

[2022-07-27 14:45:13,855][PID:11][DEBUG][redash.destinations] Registering HipChat (hipchat) destinations.

[2022-07-27 14:45:13,855][PID:11][DEBUG][redash.destinations] Registering Mattermost (mattermost) destinations.

[2022-07-27 14:45:13,855][PID:11][DEBUG][redash.destinations] Registering ChatWork (chatwork) destinations.

[2022-07-27 14:45:13,861][PID:11][DEBUG][redash.destinations] Registering PagerDuty (pagerduty) destinations.

[2022-07-27 14:45:13,861][PID:11][DEBUG][redash.destinations] Registering Google Hangouts Chat (hangouts_chat) destinations.

[2022-07-27 14:45:15,042][PID:10][INFO][rq.worker] Worker rq:worker:708c92aa826f4c4aaba5e233009905b2: started, version 1.5.0

[2022-07-27 14:45:15,043][PID:10][INFO][rq.worker] *** Listening on scheduled_queries, schemas...

[2022-07-27 14:45:15,276][PID:11][INFO][rq.worker] Worker rq:worker:3fa3498ecfa849fe888b664f0aaf7a4f: started, version 1.5.0

[2022-07-27 14:45:15,277][PID:11][INFO][rq.worker] *** Listening on scheduled_queries, schemas...

2022/07/27 14:46:01 [worker_healthcheck] Received TICK_60 event from supervisor

2022/07/27 14:46:01 [worker_healthcheck] No processes in state RUNNING found for process worker

RESULT 2

OKREADY

Thanks for the info.

Have you scheduled a query to execute every minute or similar?

Same question as with redis: do you have exactly one postgres?

I scheduled to run for every minute yes, to test faster.

I have one instance of the both postgres and redis, yes.

When are the queues are created? Can you think of any reason for scheduled_queries not to get created?

The queue is created the first time it’s used. For example when you first load Redash it won’t even have a queries queue until you try executing your first query. See here. There is nothing special about a Queue in basic terms. It’s just a prefix to the Redis key which rq uses when handing jobs off to workers.

You can test this for yourself by connecting to the redis service and flushing all its keys:

docker-compose run --rm redis redis-cli -h redis

# then..

flushall

…then visit the System Status page and observe that all but the default queue disappeared.

From this we can presume the reason you don’t see a scheduled query queue is because the background execution does not occur.

Since I can’t reproduce your issue, you’ll need to poke around a bit to see exactly what isn’t happening here.

Are you sure your query schedule is being saved? Does it persist between page reloads?
Is the scheduler service running? Do you see it enqueuing any jobs at all, such as schema refreshes (every 30 minutes)?

You can try changing the scheduler service cmd to dev_scheduler. And double, triple, quadruple check that it’s accessing the same Redis as your workers.

Even tough there is only one redis on the whole cluster, I went ahead and stopped the redis and every other container crashed, so I am kind of sure they are using the same redis :slight_smile:

I spent hours trying to debug, I think I did read through all the issues and forum messages that include the word “refresh”. I updated my workload yamls according to other people’s docker-compose.yamls, still no luck :confused:

And I can’t run dev_secheduler because I guess the thing that is used for watching the file changes is not available in the production docker image.

Yes, the query schedule is saved. I tried changing it multiple times in case it triggers some kind of scheduling thing.

The scheduler service is running but I am not sure if it does anything, the only log it has is this:

Starting RQ scheduler...
[2022-07-27 23:23:15,274][PID:1][INFO][rq_scheduler.scheduler] Registering birth

Can you check whether any jobs appear in your redis?

Also, this other thread may be related:

How should I check the jobs in redis?

Can you please share an up-to-date docker-compose.yml without the dev stuff so I can check my deployment definitions?

This is how you access redis. Then just check what keys are there.

Just look at the docker-compose.yml on the master branch. This is a working dev setup that everyone uses.

I meant a docker-compose.yaml for production environment, not development.

EDIT: Looks like I am not allowed to add more comments… So, I think I have to update this comment:

Here is the output of the keys *.

Show output
127.0.0.1:6379> keys *
 1) "rq:job:3c08d33f-31eb-4d76-a7e2-2f80c10a820b"
 2) "rq:finished:queries"
 3) "rq:worker:2e942e8ce18f4d23b819eb390210405d"
 4) "rq:job:526f2c7f55dfe92457914cd7df02cfffe4dec877"
 5) "rq:scheduler"
 6) "rq:workers:scheduled_queries"
 7) "rq:worker:405b1bc8c2b144118deeca22bb004ff6"
 8) "rq:clean_registries:schemas"
 9) "rq:job:ef7973e7-a3a1-458b-a4a8-af8fe4513202"
10) "rq:job:52fade8a-cf38-48d7-a516-10f051ff3f86"
11) "rq:worker:cfa73bea53424ab1a9dc72b70f4964f1"
12) "rq:workers"
13) "rq:workers:schemas"
14) "rq:workers:queries"
15) "data_source:schema:1"
16) "rq:clean_registries:emails"
17) "rq:job:75540cdf868e7873f5eec072177423b13b98dece"
18) "rq:job:52bcd40c254552539398db3cdb15055d4a9a536a"
19) "rq:job:a59fb7c4-6208-495b-8378-86154b1fe22c"
20) "rq:finished:periodic"
21) "rq:job:631a8e45-4f22-4d1a-87be-620124f3c908"
22) "rq:worker:d816db59e0e14acdaf3c10ca151c6a3e"
23) "rq:job:c58795f7-ed23-4d42-be73-cdb8925e7d00"
24) "rq:job:a8395797-f7bd-46f9-9612-2eefd0a453b7"
25) "rq:job:9e73adb7-5dfd-463e-933d-7a4a2272f6a6"
26) "rq:finished:schemas"
27) "rq:workers:emails"
28) "rq:job:305c0cae0a196ae96915fd2b6f81001c435aad65"
29) "rq:job:59a84668e68687338646f735965213c58e814b32"
30) "rq:job:e27209059575fcc17c527c47d0957cb21756e551"
31) "rq:queues"
32) "rq:worker:a014f1728f5a4e658163239210448dbe"
33) "rq:job:058e3fea-faa3-44b1-a528-b1bef16b3552"
34) "rq:workers:periodic"
35) "rq:clean_registries:default"
36) "rq:finished:default"
37) "rq:workers:default"
38) "rq:job:b0df8cf9-14c9-427f-a9ae-8d9276ad5860"
39) "rq:clean_registries:periodic"
40) "users:last_active_at"
41) "rq:clean_registries:scheduled_queries"
42) "rq:job:1d6c33b6-da90-4bcb-ba4f-b81bca0962f6"
43) "rq:worker:a46bbac6853040bab35586ade06e4017"
44) "rq:job:18281a865ed3d1a60f366aeb8596fe2283aa421f"
45) "rq:job:3e094116-cde7-4c31-aa2d-50f0a28f40d1"
46) "redash:status"
47) "rq:worker:4ca6c9e5aa504c458bae92e0d327399d"
48) "rq:job:797f4f959c6c96c738efd445b17db75742db80a9"
49) "rq:scheduler:scheduled_jobs"

Sorry I misunderstood your question. You can examine the getredash/setup repository for an example. It hasn’t been updated for V10 yet, but the release notes on GitHub describe the exact updates needed for V10.

What value do you see for rq:scheduler:scheduled_jobs?