Error on accessing SQL tab for triggers

From: McDonaldR <McDonaldR(at)angus(dot)gov(dot)uk>
To: "pgAdmin Support (pgadmin-support(at)postgresql(dot)org)" <pgadmin-support(at)postgresql(dot)org>
Subject: Error on accessing SQL tab for triggers
Date: 2018-05-17 13:56:25
Message-ID: 7CCEF44D1C42854999B19B1EB27281F6013D369BF7@SR2ORBHQ2K803.angus.gov.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi List

I've comes across an error when trying to access my triggers through pgAdmin 4 v3.0. Maybe you can point me in the right direction for a solution? Expanding the tree down through database > schemas > schema > trigger functions > trigger returns:

Error retrieving the information - INTERNAL SERVER ERROR
Click for details

<click>

[cid:image001(dot)png(at)01D3EDEC(dot)BEB787C0]

Accessing functions, materialised views, sequences, tables and views works fine. Everything works as expected in pgAdmin3 1.22.2.

The pgAdmin4.log has the following in it:

2018-05-17 14:28:06,539: ERROR pgadmin: Exception when checking for update
Traceback (most recent call last):
File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\__init__.py", line 508, in index
response = urlreq.urlopen(url, data, 5)
File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line 154, in urlopen
return opener.open(url, data, timeout)
File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line 429, in open
response = self._open(req, data)
File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line 447, in _open
'_open', req)
File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line 407, in _call_chain
result = func(*args)
File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line 1241, in https_open
context=self._context)
File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line 1198, in do_open
raise URLError(err)
URLError: <urlopen error Tunnel connection failed: 407 Proxy Authentication Required>
2018-05-17 14:28:45,897: ERROR werkzeug: Error on request:
Traceback (most recent call last):
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\werkzeug\serving.py", line 209, in run_wsgi
execute(self.server.app)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\werkzeug\serving.py", line 197, in execute
application_iter = app(environ, start_response)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1997, in __call__
return self.wsgi_app(environ, start_response)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1985, in wsgi_app
response = self.handle_exception(e)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1540, in handle_exception
reraise(exc_type, exc_value, tb)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1982, in wsgi_app
response = self.full_dispatch_request()
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1614, in full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1517, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1612, in full_dispatch_request
rv = self.dispatch_request()
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1598, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\views.py", line 84, in view
return self.dispatch_request(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\utils.py", line 254, in dispatch_request
return method(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\server_groups\servers\databases\schemas\functions\__init__.py", line 345, in wrap
return f(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\server_groups\servers\databases\schemas\functions\__init__.py", line 1053, in sql
) + '(' + res['rows'][0]['func_args'] + ')'
KeyError: 'nspname'
2018-05-17 14:31:10,102: ERROR werkzeug: Error on request:
Traceback (most recent call last):
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\werkzeug\serving.py", line 209, in run_wsgi
execute(self.server.app)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\werkzeug\serving.py", line 197, in execute
application_iter = app(environ, start_response)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1997, in __call__
return self.wsgi_app(environ, start_response)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1985, in wsgi_app
response = self.handle_exception(e)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1540, in handle_exception
reraise(exc_type, exc_value, tb)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1982, in wsgi_app
response = self.full_dispatch_request()
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1614, in full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1517, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1612, in full_dispatch_request
rv = self.dispatch_request()
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1598, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\views.py", line 84, in view
return self.dispatch_request(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\utils.py", line 254, in dispatch_request
return method(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\server_groups\servers\databases\schemas\functions\__init__.py", line 345, in wrap
return f(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\server_groups\servers\databases\schemas\functions\__init__.py", line 1053, in sql
) + '(' + res['rows'][0]['func_args'] + ')'
KeyError: 'nspname'
2018-05-17 14:33:43,618: ERROR werkzeug: Error on request:
Traceback (most recent call last):
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\werkzeug\serving.py", line 209, in run_wsgi
execute(self.server.app)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\werkzeug\serving.py", line 197, in execute
application_iter = app(environ, start_response)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1997, in __call__
return self.wsgi_app(environ, start_response)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1985, in wsgi_app
response = self.handle_exception(e)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1540, in handle_exception
reraise(exc_type, exc_value, tb)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1982, in wsgi_app
response = self.full_dispatch_request()
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1614, in full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1517, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1612, in full_dispatch_request
rv = self.dispatch_request()
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\app.py", line 1598, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "C:\Program Files (x86)\pgAdmin 4\v3\venv\Lib\site-packages\flask\views.py", line 84, in view
return self.dispatch_request(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\utils.py", line 254, in dispatch_request
return method(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\server_groups\servers\databases\schemas\functions\__init__.py", line 345, in wrap
return f(*args, **kwargs)
File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\server_groups\servers\databases\schemas\functions\__init__.py", line 1053, in sql
) + '(' + res['rows'][0]['func_args'] + ')'
KeyError: 'nspname'

pgAdmin4 Version
3.0
Copyright
Copyright 2013 - 2018, The pgAdmin Development Team
Python Version
2.7.13 (v2.7.13:a06454b1afa1, Dec 17 2016, 20:42:59) [MSC v.1500 32 bit (Intel)]
Flask Version
0.12.2
Application Mode
Desktop
Current User
pgadmin4(at)pgadmin(dot)org

Postgresql 9.6.9 64bit
PostGIS 2.4.4

Client Windows 7 64bit

Server Windows 2008 R2

Ross McDonald | GIS Data Coordinator | Angus Council, People, IT | Angus House, Orchardbank Business Park, Sylvie Way, Forfar DD8 1AT | t: 01307 476419

This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message richard coleman 2018-05-17 14:06:03 SQL_ASCII support (or lack thereof)
Previous Message Chris Cowan 2018-05-17 10:28:49 Re: Query Tool Initialization Error