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