BUG: PgAdminIII crashes when server closes the connection by idle time

From: Jeferson Alberto Rodrigues <jefersonal(at)celepar(dot)pr(dot)gov(dot)br>
To: pgadmin-support(at)postgresql(dot)org
Subject: BUG: PgAdminIII crashes when server closes the connection by idle time
Date: 2010-09-23 11:48:19
Message-ID: 1285242499.1445.1.camel@ECELEPAR11775
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi guys,

I would like do report an ancient bug on PgAdminIII.

I'm using PgAdminIII 1.10.2 on Ubuntu Lucid Kernel 2.6.32-25, that was
installed by apt-get.
The server is running the version 8.3.8 of PostgreSQL.

Here I will reproduce the steps, and the prerequisites are only the
server configured to kill idle connections from clients after X time.
1) With PgAdminIII opened, and connected in the database, open the Query
Tool, to make custom queries.
2) Make one, execute, and leave PgAdmin in second plan (minimized, for
example) for more than the X time, and keep the window open.
3) After the idle time, return to the window of custom query, make one
more query and execute.
4) At this time, in the Output Pane, in the tab Messages will appear
written only "********** Error **********".
5) Rerun the same query.
6) PgAdminIII closes immediately.

In the ~/pgadmin.log is writen this:

2010-09-15 16:36:21 ERROR : Server closed connection unexpectedly.
This probably means the server terminated abnormally
before or while processing the request.
2010-09-15 16:36:24 ERROR : no connection to the server.

To circumvent the problem, it would be interesting to test connectivity
with the server before performing each query, and if client is
disconnected, reconnects to the database, then performs the query.
Obviously this was only a hint, and it is up to you to decide how to
handle this problem.

Tks for the attention.

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2010-09-23 12:03:46 Re: BUG: PgAdminIII crashes when server closes the connection by idle time
Previous Message Jeferson Alberto Rodrigues 2010-09-23 11:48:06 BUG: PgAdminIII crashes when server closes the connection by idle time