PATCH: CheckAlive on the maintenance database

Поиск
Список
Период
Сортировка
От Ashesh Vashi
Тема PATCH: CheckAlive on the maintenance database
Дата
Msg-id CAG7mmoyp+=mxRpLSVUqBfat24juDKxw4RUQ0rmdC+nfMa0ztSw@mail.gmail.com
обсуждение исходный текст
Ответы Re: PATCH: CheckAlive on the maintenance database  (Dave Page <dpage@pgadmin.org>)
Список 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.linkedin.com/in/asheshvashi


Вложения

В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Ashesh Vashi
Дата:
Сообщение: Re: Weird code in pgDomain.cpp
Следующее
От: Dave Page
Дата:
Сообщение: pgAdmin III commit: Fix server reconnect option when the browser become