Thread: BUG #15210: Internal Server Error When Attempting to Look at TriggerFunctions
BUG #15210: Internal Server Error When Attempting to Look at TriggerFunctions
From
PG Bug reporting form
Date:
The following bug has been logged on the website: Bug reference: 15210 Logged by: Diana Petty Email address: diana.petty@csra.com PostgreSQL version: 10.4 Operating system: Server=Redhat, pgAdmin = Mac OS High Sierra Description: I log into pgAdmin pointing at either our 10.4 server or our 9.5 server - I get the same error in both cases. I open the schema, click on trigger functions, and click on one to show in the sql panel. Then I get the internal server error. It doesn't matter which schema or which trigger function. Other objects display appropriately. Here is the contents of the log: 2018-05-25 14:07:32,657: 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'
Re: BUG #15210: Internal Server Error When Attempting to Look atTrigger Functions
From
"David G. Johnston"
Date:
The following bug has been logged on the website:
Bug reference: 15210
Logged by: Diana Petty
Email address: diana.petty@csra.com
PostgreSQL version: 10.4
Operating system: Server=Redhat, pgAdmin = Mac OS High Sierra
Description:
I log into pgAdmin pointing at either our 10.4 server or our 9.5 server - I
get the same error in both cases. I open the schema, click on trigger
functions, and click on one to show in the sql panel. Then I get the
internal server error. It doesn't matter which schema or which trigger
function. Other objects display appropriately. Here is the contents of the
log:
This bug report list does not cover the external pgAdmin application.
Please see the following for guidance on reporting problems to them.
David J.
Re: BUG #15210: Internal Server Error When Attempting to Look at Trigger Functions
From
Tom Lane
Date:
"David G. Johnston" <david.g.johnston@gmail.com> writes: > On Fri, May 25, 2018 at 11:23 AM, PG Bug reporting form < > noreply@postgresql.org> wrote: >> I log into pgAdmin pointing at either our 10.4 server or our 9.5 server - I >> get the same error in both cases. I open the schema, click on trigger >> functions, and click on one to show in the sql panel. Then I get the >> internal server error. It doesn't matter which schema or which trigger >> function. Other objects display appropriately. Here is the contents of the >> log: > This bug report list does not cover the external pgAdmin application. > Please see the following for guidance on reporting problems to them. > https://www.pgadmin.org/support/list/ The reference to an "internal server error" suggests that it could be our turf, but a traceback on the client side proves nothing about that. It might be useful to look at the server log and see if it reports any interesting error when you do this. regards, tom lane
Re: BUG #15210: Internal Server Error When Attempting to Look atTrigger Functions
From
"Petty, Diana"
Date:
I checked the server log and saw nothing that looked like it would be related to my error. But to be sure I made the errorhappen again and the log wasn't changed. ________________________________________ From: Tom Lane <tgl@sss.pgh.pa.us> Sent: Friday, May 25, 2018 2:39 PM To: David G. Johnston Cc: Petty, Diana; pgsql-bugs@lists.postgresql.org Subject: Re: BUG #15210: Internal Server Error When Attempting to Look at Trigger Functions "David G. Johnston" <david.g.johnston@gmail.com> writes: > On Fri, May 25, 2018 at 11:23 AM, PG Bug reporting form < > noreply@postgresql.org> wrote: >> I log into pgAdmin pointing at either our 10.4 server or our 9.5 server - I >> get the same error in both cases. I open the schema, click on trigger >> functions, and click on one to show in the sql panel. Then I get the >> internal server error. It doesn't matter which schema or which trigger >> function. Other objects display appropriately. Here is the contents of the >> log: > This bug report list does not cover the external pgAdmin application. > Please see the following for guidance on reporting problems to them. > https://www.pgadmin.org/support/list/ The reference to an "internal server error" suggests that it could be our turf, but a traceback on the client side proves nothing about that. It might be useful to look at the server log and see if it reports any interesting error when you do this. regards, tom lane This electronic message transmission contains information from CSRA that may be attorney-client privileged, proprietary orconfidential. The information in this message is intended only for use by the individual(s) to whom it is addressed. Ifyou believe you have received this message in error, please contact me immediately and be aware that any use, disclosure,copying or distribution of the contents of this message is strictly prohibited. NOTE: Regardless of content, thisemail shall not operate to bind CSRA to any order or other contract unless pursuant to explicit written agreement orgovernment initiative expressly permitting the use of email for such purpose.
Re: BUG #15210: Internal Server Error When Attempting to Look at Trigger Functions
From
Tom Lane
Date:
"Petty, Diana" <Diana.Petty@csra.com> writes: > I checked the server log and saw nothing that looked like it would be related to my error. But to be sure I made the errorhappen again and the log wasn't changed. Hm. "Internal server error" seems to be stretching the truth then. Anyway, at this point I'd concur with David's advice to report it to the pgadmin list. regards, tom lane