Issue Summary
Hello Redash Team,
Greetings for the day,
Redash Team,This Is Regarding Redash Query Error which we are facing more than 2month,
When our business teams run any queries like scheduled or adhoc its showing error on UI like
Error running query: failed communicating with server. Please check your Internet connection and try again
out of 10 we got this error almost 5 times,
We have enabled logs on debug level but on logs we are not able to see any logs regarding failed queries or any unknown error
Here are our Redash Configuration
Redash runing on EC2 Instance
Instance type: r5a.large, 2CPU core,16gb ram,Storage 50GB
Redash Setup type Docker container
Redash Version 10.1.0.b50633
Redash Env value:
PYTHONUNBUFFERED=0
REDASH_LOG_LEVEL=DEBUG
GUNICORN_CMD_ARGS=“–timeout=600”
REDASH_ADHOC_QUERY_TIME_LIMIT=7200
Redash Docker File
version: “2”
x-redash-service: &redash-service
image: redash/redash:10.1.0.b50633
depends_on:
- postgres
- redis
env_file: /opt/redash/env
restart: always
services:
server:
<<: *redash-service
command: server
ports:
- “5000:5000”
environment:
REDASH_WEB_WORKERS: 16
scheduler:
<<: *redash-service
command: scheduler
scheduled_worker:
<<: *redash-service
command: worker
adhoc_worker:
<<: *redash-service
command: worker
worker:
<<: *redash-service
command: worker
environment:
QUEUES: “schemas queries periodic emails default”
WORKERS_COUNT: 20
redis:
image: redis:5.0-alpine
restart: always
postgres:
image: postgres:9.6-alpine
env_file: /opt/redash/env
volumes:
- /opt/redash/postgres-data:/var/lib/postgresql/data
restart: always
environment:
POSTGRES_HOST_AUTH_METHOD: “trust”
nginx:
image: redash/nginx:latest
ports:
- “80:80”
depends_on:
- server
links:
- server:redash
restart: always
Please Take Look Into it we are facing this issue constantly,hope will get solution fast
Thanks & Regards
Nabil Purkar