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

PATCH: CheckAlive on the maintenance database

From: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: PATCH: CheckAlive on the maintenance database
Date: 2012-04-10 09:43:47
Message-ID: CAG7mmoyp+=mxRpLSVUqBfat24juDKxw4RUQ0rmdC+nfMa0ztSw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
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>

Attachment: FB21013_REL-1_14.patch
Description: application/octet-stream (435 bytes)
Attachment: FB21013_master.patch
Description: application/octet-stream (435 bytes)

Responses

pgadmin-hackers by date

Next:From: Dave PageDate: 2012-04-10 16:49:28
Subject: pgAdmin III commit: Fix server reconnect option when the browserbecome
Previous:From: Ashesh VashiDate: 2012-04-09 14:28:33
Subject: Re: Weird code in pgDomain.cpp

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