Refresh Schedule not working in kubernetes

Support Self Hosted Redash Support
1

Issue Summary

I set the refresh schedule for a query every 30 minutes and it is not refreshing the data, last execution was a day ago.

image

The app is deployed in GKE using Helm Chart. All the pods are running.

image

Technical details:

  • Redash Version: 10.0.0.b50363
  • Browser/OS: Chrome
  • How did you install Redash: contrib-helm-chart

config.yaml

image:
  repository: redash/redash
  tag: 10.0.0.b50363
  pullPolicy: IfNotPresent

redash:
  cookieSecret: <cookie-secret>
  secretKey: <secret-key>
  sqlAlchemyEnablePoolPrePing: "true"
  logLevel: "DEBUG"
postgresql:
  enabled: false
externalPostgreSQL: <postgresql-connection-string>

service:
  type: LoadBalancer
  loadBalancerIP: <my-ip-address>
2

The common culprit for things like this is if you have multiple redis instances in your k8s deployment. Redash needs exactly one Redis.

For debugging it will be easiest if you set the refresh schedule to once per minute. Then you can work to figure out what isn’t happening that should be (if the answer to any of the below questions is “yes”, then proceed to the next question, otherwise debug):

  1. Is your scheduler instance periodically creating an execution job in Redis?
  2. Is that job persisted to redis?
  3. Does a worker pick up the job?
  4. Does the execution succeed?
  5. Is a result saved to Redash’s postgres?