Query job not starting automatically

Support Self Hosted Redash Support
1

Issue Summary

When i Create a query redash does not execute it.

but after running following command it will be executed:
python manage.py rq worker

and result of python manage.py status is as follow:
$ python manage.py status

{
  "version": "10.0.0",
  "workers": [],
  "redis_used_memory": 1287088,
  "redis_used_memory_human": "1.23M",
  "queries_count": 1,
  "query_results_count": 5,
  "unused_query_results_count": 0,
  "dashboards_count": 1,
  "widgets_count": 0,
  "manager": {
    "outdated_queries_count": "0",
    "last_refresh_at": "1634993558.8604321",
    "query_ids": "[]",
    "queues": {
      "default": {
        "size": 20
      },
      "periodic": {
        "size": 0
      },
      "schemas": {
        "size": 0
      },
      "queries": {
        "size": 1
      }
    }
  },
  "database_metrics": {
    "metrics": [
      [
        "Query Results Size",
        49152
      ],
      [
        "Redash DB Size",
        9531951
      ]
    ]
  }
}

Why we have no worker to execute the query? what is the problem

Technical details:

  • Redash Version: 10.0.
  • Browser/OS: chrome
  • How did you install Redash: with docker image
2

What does your docker-compose file look like? Did you specify any worker services?

3

I just started redash/redash (version 10) official docker image not from docker-compose up command.

does it need any other start command?

4

It doesn’t work automatically because the image is meant to be orchestrated with docker-compose. You should check out our docs for setting up an instance. This will be a bit easier once we update our setup script for V10 (which is one of our V10 Follow Up Items).

A really basic docker-compose.yml file for testing V10 appears below. Observe that it effectively automates what you’re doing manually. It spins up the web server, scheduler, database, redis, and a couple workers.

version: "2"
x-redash-service: &redash-service
  image: redash/redash:10.0.0.b50363
  depends_on:
    - postgres
    - redis
  env_file: env
  restart: always
services:
  server:
    <<: *redash-service
    command: server
    ports:
      - "5000:5000"
    environment:
      REDASH_WEB_WORKERS: 4
  scheduler:
    <<: *redash-service
    command: scheduler
  scheduled_worker:
    <<: *redash-service
    command: worker
    environment:
      QUEUES: "scheduled_queries,schemas"
      WORKERS_COUNT: 1
  adhoc_worker:
    <<: *redash-service
    command: worker
    environment:
      QUEUES: "queries"
      WORKERS_COUNT: 2
  redis:
    image: redis:5.0-alpine
    restart: always
  postgres:
    image: postgres:9.6-alpine
    env_file: env
    volumes:
      - ./postgres-data:/var/lib/postgresql/data
    restart: always
  nginx:
    image: redash/nginx:latest
    ports:
      - "80:80"
    depends_on:
      - server
    links:
      - server:redash
    restart: always
  worker:
    <<: *redash-service
    command: worker
    environment:
      QUEUES: "periodic emails default"
      WORKERS_COUNT: 1