Query Editor Connection Timeout

From: Jared Vacanti <jaredvacanti(at)gmail(dot)com>
To: pgadmin-hackers(at)lists(dot)postgresql(dot)org
Subject: Query Editor Connection Timeout
Date: 2018-12-06 05:22:06
Message-ID: CAJ49pGZtif+y4ZgkhQ82e+_v8K20U1xUw1KV95LFb=fkAtoqhg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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?

Browse pgadmin-hackers by date

  From Date Subject
Next Message Khushboo Vashi 2018-12-06 05:43:21 Re: Build failed in Jenkins: pgadmin4-master-python27 #825
Previous Message pgAdmin 4 Jenkins 2018-12-05 17:45:06 Build failed in Jenkins: pgadmin4-master-python27 #825