RE: 500 Internal Server Error

From: Ben Nachtrieb <bnachtrieb(at)crescat(dot)net>
To: Durumdara <durumdara(at)gmail(dot)com>
Cc: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: RE: 500 Internal Server Error
Date: 2017-11-30 13:51:23
Message-ID: BN6PR1301MB2212264D059E8A1F5FD788DED4380@BN6PR1301MB2212.namprd13.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Sorry, I don’t have a solution. I experience it every day multiple times a day. Very frustrating and disruptive to workflows. The link does not have a fix. The bug/issue is outstanding (known and not fixed) as far as I know.

Are you using pgAdmin 4 and postgres 10.1? I am starting to think it is a pgAdmin 4 issue, but I haven’t drilled into it much due to time constraints.
Ben
From: Durumdara [mailto:durumdara(at)gmail(dot)com]
Sent: Thursday, November 30, 2017 12:27 AM
To: Ben Nachtrieb <bnachtrieb(at)crescat(dot)net>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: 500 Internal Server Error

Dear Ben!

What is the solution of this problem?
I don't have account there. :-(

Thank you!

BW

dd

2017-11-22 21:29 GMT+01:00 Ben Nachtrieb <bnachtrieb(at)crescat(dot)net<mailto:bnachtrieb(at)crescat(dot)net>>:
Never mind. Found the bug #: Bug #2806
Found here: https://redmine.postgresql.org/issues/2806
Ben Nachtrieb |(303) 350-4287<tel:(303)%20350-4287>
Only accredited investors and qualified clients will be admitted as limited partners to a Crescat fund. For natural persons, investors must meet SEC requirements including minimum annual income or net worth thresholds. Crescat funds are being offered in reliance on an exemption from the registration requirements of the Securities Act of 1933 and are not required to comply with specific disclosure requirements that apply to registration under the Securities Act. The SEC has not passed upon the merits of or given its approval to the Crescat funds, the terms of the offering, or the accuracy or completeness of any offering materials. A registration statement has not been filed for any Crescat fund with the SEC. Limited partner interests in the Crescat funds are subject to legal restrictions on transfer and resale. Investors should not assume they will be able to resell their securities. Investing in securities involves risk. Investors should be able to bear the loss of their investment. Investments in the Crescat funds are not subject to the protections of the Investment Company Act of 1940. Performance data represents past performance, and past performance does not guarantee future results. Performance data is subject to revision following each monthly reconciliation and annual audit. Current performance may be lower or higher than the performance data presented. Crescat is not required by law to follow any standard methodology when calculating and representing performance data. The performance of Crescat funds may not be directly comparable to the performance of other private or registered funds. Investors may obtain the most current performance data and private offering memorandum for a Crescat fund by contacting Linda Smith at (303) 271-9997<tel:(303)%20271-9997> or by sending a request via email to lsmith(at)crescat(dot)net<mailto:lsmith(at)crescat(dot)net>. See the private offering memorandum for each Crescat fund for complete information and risk factors.

From: Ben Nachtrieb
Sent: Wednesday, November 22, 2017 12:32 PM
To: pgadmin-support(at)lists(dot)postgresql(dot)org<mailto:pgadmin-support(at)lists(dot)postgresql(dot)org>
Cc: Ben Nachtrieb <bnachtrieb(at)crescat(dot)net<mailto:bnachtrieb(at)crescat(dot)net>>
Subject: 500 Internal Server Error

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<mailto: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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Khushboo Vashi 2017-11-30 14:02:41 Re: 500 Internal Server Error
Previous Message Durumdara 2017-11-30 07:26:37 Re: 500 Internal Server Error