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