I have a pgadmin4 instance (dpage/pgadmin4 docker image) running behind nginx and can successfully connect to the database, but after about 60 seconds I begin to get status errors for the connection and the logs show:
[2018-12-06 05:04:08 +0000] [16] [ERROR] Error handling request /pgadmin4/sqleditor/status/5602426
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/gunicorn/workers/gthread.py", line 279, in handle
keepalive = self.handle_request(req, conn)
File "/usr/local/lib/python3.6/site-packages/gunicorn/workers/gthread.py", line 328, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1997, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1985, in wsgi_app
response = self.handle_exception(e)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1540, in handle_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1982, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1614, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1517, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1612, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1598, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/usr/local/lib/python3.6/site-packages/flask_login.py", line 792, in decorated_view
return func(*args, **kwargs)
File "/pgadmin4/pgadmin/tools/sqleditor/__init__.py", line 1512, in query_tool_status
conn.check_notifies(True)
File "/pgadmin4/pgadmin/utils/driver/psycopg2/connection.py", line 1805, in check_notifies
self.conn.poll()
psycopg2.InterfaceError: connection already closed
Do I need to set additional settings to keep connections alive longer than 60 seconds?