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?
