500 Internal Server Error

From: Ben Nachtrieb <bnachtrieb(at)crescat(dot)net>
To: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Cc: Ben Nachtrieb <bnachtrieb(at)crescat(dot)net>
Subject: 500 Internal Server Error
Date: 2017-11-22 19:31:34
Message-ID: BN6PR1301MB22125260E3559C7CEEB4EDBED4200@BN6PR1301MB2212.namprd13.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello,

When I send a query, unexpectedly and seemingly randomly I get the following text in the Message tab for the query tool output:

"<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <title>500 Internal Server Error</title> <h1>Internal Server Error</h1> <p>The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.</p>"

Notes:
-The html is part of the message.
-It doesn't seem to matter what query is sent.
-The actual query seems to stay active (as if it is still working), but eventually comes back with a wait event: ClientWrite.
-We can remedy the situation by closing the query tool window (hence closing the session) and opening a new query too window (whilst never closing pgAdmin 4 or the connection to the server) then sending the query again.
-We are connected to a Linux VM via my Windows 7 PC.
-This happens probably 10 times a day while queries are being developed and tested.

I have:

Version
2.0
Copyright
Copyright 2013 - 2017, 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

What is causing this? What is the fix? Is this a bug? I see similar bugs listed, but they all seem to depend on a certain type of query (I think).

Thanks!

Ben

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Ben Nachtrieb 2017-11-22 20:29:53 RE: 500 Internal Server Error
Previous Message Dave Page 2017-11-22 13:02:18 Re: pgAdmin4 behind HTTPs