Skip site navigation (1) Skip section navigation (2)

Re: PATCH: CheckAlive on the maintenance database

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 (view raw or flat)
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

In response to

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2012-04-10 21:17:19
Subject: Re: Weird code in pgDomain.cpp
Previous:From: Dave PageDate: 2012-04-10 16:52:06
Subject: pgAdmin III commit: Fix server reconnect option when the browserbecome

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group