500 Internal Server Error - Mailing list pgadmin-support

From Ben Nachtrieb
Subject 500 Internal Server Error
Date
Msg-id BN6PR1301MB22125260E3559C7CEEB4EDBED4200@BN6PR1301MB2212.namprd13.prod.outlook.com
Whole thread Raw
Responses RE: 500 Internal Server Error  (Ben Nachtrieb <bnachtrieb@crescat.net>)
List 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@pgadmin.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

 

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: pgAdmin4 behind HTTPs
Next
From: Ben Nachtrieb
Date:
Subject: RE: 500 Internal Server Error