Thread: pgAdmin 4 3.0 - bug when browsing on trigger functions
Hi, Description of bug. The SQL tab shows the following error when clicking on a trigger function: “Error retrieving the information - INTERNAL SERVERERROR” Issue replicated on both macOS (High Sierra 10.13.4) and docker (18.03.0-ce-mac60) versions. Mac Version: Version: 3.0 Copyright: Copyright 2013 - 2018, The pgAdmin Development Team Python Version: 2.7.10 (default, Jul 30 2016, 19:40:32) [GCC 4.2.1 Compatible Apple LLVM 8.0.0 (clang-800.0.34)] Flask Version: 0.12.2 Application Mode: Desktop Current User: pgadmin4@pgadmin.org Output from log 2018-04-17 11:47:59,885: ERROR werkzeug: Error on request: Traceback (most recent call last): File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/werkzeug/serving.py", line 270, in run_wsgi execute(self.server.app) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/werkzeug/serving.py", line 258, in execute application_iter = app(environ, start_response) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1997, in __call__ return self.wsgi_app(environ, start_response) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1985, in wsgi_app response = self.handle_exception(e) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1540, in handle_exception reraise(exc_type, exc_value, tb) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1982, in wsgi_app response = self.full_dispatch_request() File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1614, in full_dispatch_request rv = self.handle_user_exception(e) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1517, in handle_user_exception reraise(exc_type, exc_value, tb) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1612, in full_dispatch_request rv = self.dispatch_request() File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1598, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/views.py", line 84, in view return self.dispatch_request(*args, **kwargs) File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/utils.py", line 254, in dispatch_request return method(*args, **kwargs) File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/server_groups/servers/databases/schemas/functions/__init__.py",line 345, inwrap return f(*args, **kwargs) File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/server_groups/servers/databases/schemas/functions/__init__.py",line 1053, insql ) + '(' + res['rows'][0]['func_args'] + ')' KeyError: ‘nspname' Docker version: Version: 3.0 Copyright: Copyright 2013 - 2018, The pgAdmin Development Team Python Version: 3.6.5 (default, Mar 31 2018, 01:52:14) [GCC 6.4.0] Flask Version: 0.12.2 Application Mode: Server Current User: pgadmin@example.com Kind Regards, Alan.
Attachment
Hi
This was fixed the day after 3.0 was released, and will be in 3.1.
On Tue, Apr 17, 2018 at 3:58 PM, Alan Campbell <alan.campbell@riskpoint.co.uk> wrote:
Hi,
Description of bug.
The SQL tab shows the following error when clicking on a trigger function: “Error retrieving the information - INTERNAL SERVER ERROR”
Issue replicated on both macOS (High Sierra 10.13.4) and docker (18.03.0-ce-mac60) versions.
Mac Version:
Version: 3.0
Copyright: Copyright 2013 - 2018, The pgAdmin Development Team
Python Version: 2.7.10 (default, Jul 30 2016, 19:40:32) [GCC 4.2.1 Compatible Apple LLVM 8.0.0 (clang-800.0.34)]
Flask Version: 0.12.2
Application Mode: Desktop
Current User: pgadmin4@pgadmin.org
Output from log
2018-04-17 11:47:59,885: ERROR werkzeug: Error on request:
Traceback (most recent call last):
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/ werkzeug/serving.py", line 270, in run_wsgi
execute(self.server.app)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/ werkzeug/serving.py", line 258, in execute
application_iter = app(environ, start_response)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/ flask/app.py", line 1997, in __call__
return self.wsgi_app(environ, start_response)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/ flask/app.py", line 1985, in wsgi_app
response = self.handle_exception(e)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/ flask/app.py", line 1540, in handle_exception
reraise(exc_type, exc_value, tb)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/ flask/app.py", line 1982, in wsgi_app
response = self.full_dispatch_request()
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/ flask/app.py", line 1614, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/ flask/app.py", line 1517, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/ flask/app.py", line 1612, in full_dispatch_request
rv = self.dispatch_request()
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/ flask/app.py", line 1598, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/ flask/views.py", line 84, in view
return self.dispatch_request(*args, **kwargs)
File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/utils.py", line 254, in dispatch_request
return method(*args, **kwargs)
File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/server_groups/ servers/databases/schemas/ functions/__init__.py", line 345, in wrap
return f(*args, **kwargs)
File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/server_groups/ servers/databases/schemas/ functions/__init__.py", line 1053, in sql
) + '(' + res['rows'][0]['func_args'] + ')'
KeyError: ‘nspname'
Docker version:
Version: 3.0
Copyright: Copyright 2013 - 2018, The pgAdmin Development Team
Python Version: 3.6.5 (default, Mar 31 2018, 01:52:14) [GCC 6.4.0]
Flask Version: 0.12.2
Application Mode: Server
Current User: pgadmin@example.com
Kind Regards,
Alan.
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company