Home > mailing lists

Re: Error on accessing SQL tab for triggers - Mailing list pgadmin-support

From	Murtuza Zabuawala
Subject	Re: Error on accessing SQL tab for triggers
Date	May 17, 2018 20:32:12
Msg-id	CAKKotZRavCJvcgxs3fEpwZVgp5JN+HAx2CnyW5PUtCzC69WabA@mail.gmail.com Whole thread Raw
In response to	Error on accessing SQL tab for triggers (McDonaldR <McDonaldR@angus.gov.uk>)
List	pgadmin-support

Tree view

This bug was found just after we release pgAdmin4 v3.0 but we have fixed it now and it should resolve the issue with next release.

Ref: https://redmine.postgresql.org/issues/3179

Regards,

Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Thu, May 17, 2018 at 7:26 PM, McDonaldR <McDonaldR@angus.gov.uk> wrote:

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>

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@pgadmin.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.

Attachment

image001.png

pgadmin-support by date:

From: Dave Page
Date: 17 May 2018, 20:17:52
Subject: Re: SQL_ASCII support (or lack thereof)

From: richard coleman
Date: 17 May 2018, 22:53:35
Subject: Re: SQL_ASCII support (or lack thereof)

Re: Error on accessing SQL tab for triggers - Mailing list pgadmin-support

Attachment

Previous

Next