| From: | Durumdara <durumdara(at)gmail(dot)com> |
|---|---|
| To: | Ben Nachtrieb <bnachtrieb(at)crescat(dot)net> |
| 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 15:43:44 |
| Message-ID: | CAEcMXhms8MY6_DXSLPHb0OYrwTd+kMr-JWoaDezbXp_63pwBww@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Hi!
For multidatabase functions I use PGAdmin III and IV.
But because this (and other) bug, I must decrease the PGAdmin IV usage.
For one database I use EMS PGSQL manager, because I can see the result
better, and it saves my special queries automatically.
The PGAdmin III asked for opened queries (to save) but in PGAdmin IV I
remember more sql text loosing on close.
I hope in next release, because I believe that the PGAdmin IV would reach
the level of PGAdmin III in the future (step by step).
This problem happens with PG 9.4-9.6 too.
Best regards
dd
2017-11-30 14:51 GMT+01:00 Ben Nachtrieb <bnachtrieb(at)crescat(dot)net>:
> 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>:
>
> Never mind. Found the bug #: Bug #2806
>
> Found here: https://redmine.postgresql.org/issues/2806
>
> Ben Nachtrieb |(303) 350-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 or by sending a request via email to
> lsmith(at)crescat(dot)net(dot) 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
> *Cc:* Ben Nachtrieb <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
>
>
>
> 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 *
>
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edson Richter | 2017-12-01 17:34:05 | RES: Faded text in pgAdmin 4 2.0/Win Server 2008r2 |
| Previous Message | Khushboo Vashi | 2017-11-30 14:02:41 | Re: 500 Internal Server Error |