From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: PATCH: CheckAlive on the maintenance database |
Date: | 2012-04-10 16:52:24 |
Message-ID: | CA+OCxow6nUEVidYb0rS6me7cNsTYB0t3C+rMNXAMG8jcjnLTTQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Thanks - patch applied.
On Tue, Apr 10, 2012 at 9:43 AM, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com
> wrote:
> Hi,
>
> Steps to reproduce the problem:
> 1. Connect a server.
> i.e. PostgreSQL 9.0
> 2. Go to the Database->postgr"es->Schemas->public
> PS: 'postgres' is the maintenance database for the 'PostgreSQL 9.0'.
> 3. Stop the server in background
> i.e. bin/pg_ctl -D data -m fast stop
> 4. Click on any of the object under the same database node.
> i.e. Database->postgres->Schemas->public->Functions->abc(text, integer)
> You will get an error:
> "An error occurred:
>
> FATAL: terminating connection due to administrator command
> FATAL: terminating connection due to administrator command"
>
> Error occurred, but nothing happens.
> 5. Refresh the 'PostgreSQL 9.0' server node, using right click "Refresh".
> 6. It will collapse all the children nodes and still showed connected.
>
> And, that server node becomes unusable afterwards.
> We will have to restart the pgAdmin3 application to use it.
>
> I was able to see this problem on both Ubuntu 10.04 & RHEL 5.5.
> Never tried on windows though.
>
> Expected behaviour, it should ask for reconnection after the error message.
>
> Attached are the patches for both master & REL-1_14.
> I believe - these are still not complete patches, because the user will
> have to click on other node for the message reconnecting the server.
>
> --
>
> Thanks & Regards,
>
> Ashesh Vashi
> EnterpriseDB INDIA: Enterprise PostgreSQL Company<http://www.enterprisedb.com>
>
>
>
> *http://www.linkedin.com/in/asheshvashi*<http://www.linkedin.com/in/asheshvashi>
>
>
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2012-04-10 21:17:19 | Re: Weird code in pgDomain.cpp |
Previous Message | Dave Page | 2012-04-10 16:52:06 | pgAdmin III commit: Fix server reconnect option when the browser become |