Getting Query in queue

Getting Query in queue… when trying to run a query. And it’s never ends.

After getting the error I check worker log and found below error:

Starting RQ scheduler...
[2020-03-12 08:20:05,271][PID:1][INFO][rq_scheduler.scheduler] Registering birth
Traceback (most recent call last):
  File "/app/manage.py", line 9, in <module>
    manager()
  File "/usr/local/lib/python3.7/site-packages/click/core.py", line 722, in __call__
    return self.main(*args, **kwargs)
  File "/usr/local/lib/python3.7/site-packages/flask/cli.py", line 586, in main
    return super(FlaskGroup, self).main(*args, **kwargs)
  File "/usr/local/lib/python3.7/site-packages/click/core.py", line 697, in main
    rv = self.invoke(ctx)
  File "/usr/local/lib/python3.7/site-packages/click/core.py", line 1066, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/usr/local/lib/python3.7/site-packages/click/core.py", line 1066, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/usr/local/lib/python3.7/site-packages/click/core.py", line 895, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/usr/local/lib/python3.7/site-packages/click/core.py", line 535, in invoke
    return callback(*args, **kwargs)
  File "/usr/local/lib/python3.7/site-packages/click/decorators.py", line 17, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/usr/local/lib/python3.7/site-packages/flask/cli.py", line 426, in decorator
    return __ctx.invoke(f, *args, **kwargs)
  File "/usr/local/lib/python3.7/site-packages/click/core.py", line 535, in invoke
    return callback(*args, **kwargs)
  File "/app/redash/cli/rq.py", line 29, in scheduler
    rq_scheduler.run()
  File "/usr/local/lib/python3.7/site-packages/rq_scheduler/scheduler.py", line 404, in run
    self.register_birth()
  File "/usr/local/lib/python3.7/site-packages/rq_scheduler/scheduler.py", line 46, in register_birth
    raise ValueError("There's already an active RQ scheduler")
ValueError: There's already an active RQ scheduler
Starting RQ scheduler...
[2020-03-12 08:51:52,401][PID:1][INFO][rq_scheduler.scheduler] Registering birth
[2020-03-12 09:19:23,430][PID:1][INFO][rq_scheduler.scheduler] Shutting down RQ scheduler...
[2020-03-12 09:19:23,430][PID:1][INFO][rq_scheduler.scheduler] Registering death
[2020-03-12 09:19:23,432][PID:1][INFO][rq_scheduler.scheduler] Registering death
Starting RQ scheduler...
[2020-03-12 09:19:47,101][PID:1][INFO][rq_scheduler.scheduler] Registering birth

Here is my docker compose file:

# This configuration file is for the **development** setup.
version: '3.2'
# For a production example please refer to getredash/setup repository on GitHub.
services:
  server:
    image: image_url
    command: server
    depends_on:
      - postgres
      - redis
    ports:
      - "5000:5000"
      - "5678:5678"
    environment:
      PYTHONUNBUFFERED: 0
      REDASH_LOG_LEVEL: "INFO"
      REDASH_REDIS_URL: "redis://redis:6379/0"
      REDASH_DATABASE_URL: "postgresql://postgres@postgres/postgres"
      REDASH_RATELIMIT_ENABLED: "false"
    restart: always
  scheduler:
    image: image_url
    command: scheduler
    depends_on:
      - server
    environment:
      REDASH_REDIS_URL: "redis://redis:6379/0"
      REDASH_MAIL_DEFAULT_SENDER: “email”
      REDASH_MAIL_SERVER: "smtp.gmail.com"
  worker:
    image: image_url
    command: worker
    depends_on:
      - server
    environment:
      PYTHONUNBUFFERED: 0
      REDASH_LOG_LEVEL: "INFO"
      REDASH_REDIS_URL: "redis://redis:6379/0"
      REDASH_DATABASE_URL: "postgresql://postgres@postgres/postgres"
      REDASH_RATELIMIT_ENABLED: "false"
      QUEUES: "queries,scheduled_queries,celery"
      WORKERS_COUNT: 10
    restart: always
  redis:
    image: redis:5-alpine
    restart: unless-stopped
  postgres:
    image: postgres:9.5-alpine
    # The following turns the DB into less durable, but gains significant performance improvements for the tests run (x3
    # improvement on my personal machine). We should consider moving this into a dedicated Docker Compose configuration for
    # tests.
    #ports:
    #  - "15432:5432"
    command: "postgres -c fsync=off -c full_page_writes=off -c synchronous_commit=OFF"
    volumes:
      - /home/opt/postgres-data:/var/lib/postgresql/data
    environment:
      POSTGRES_HOST_AUTH_METHOD: "trust"
    restart: unless-stopped

Looks like you’re running the v9 alpha build which is not stable. We don’t recommend running this as we’re still working through the issues internally. V8 is the current stable release.