I am having some issues regarding the postgres db connection being dropped periodically when using the docker-compose setup of the redash. It seems that is somehow related with the psycopg2 adapter.
Versions:
redash version: 3.0.0.b3147
postgres db version: 9.4-alpine
Log Error: DEBUG: 08003: unexpected EOF on client connection [PID:1][ERROR][MainProcess] Task redash.tasks.execute_query[c938876b-26f6-4e77-9623-440091e59f8e] raised unexpected: OperationalError('(psycopg2.OperationalError) server closed the connection unexpectedly\n\tThis probably means the server terminated abnormally\n\tbefore or while processing the request.\n',)
Since the docker-compose file we use is a custom one with several confidential information I can’t post it here. We have some memory and cpu limitations applied for each one of the containers (2G for the redash server/workers 512M for the postgres/redis and 128M for the nginx), but it doesn’t seem to be the issue. The major diferences when comparing with the one provided by te redash repo are only the postgres and redash docker image versions.
The error described on the original post does’t happen very often (~1 or 2 times/day), usually after a Exception when some API endpoints (ERROR in app: Exception on /api/queries/1 [GET] for example).
On the user point of view, seems that it can cause some dashboard calls using queries to fail (500 HTTP errors).
I’m not entirely sure if this is an error of connection with the metadata database or with the one you’re querying. Is the database you’re querying is Postgres or Redshift too?
Also, how did you deploy your Docker containers?
Login or sign up disabled while the site is in read only mode