Re: Is 1.14 supposed to behave differently when it loses connection? - Mailing list pgadmin-support

Guillaume,

Are you accessing a remote, network connected server for your testing?

If so, are you causing a network outage by disconnecting your network connection?

I have been seeing for a long time, on windows clients, that pgAdmin does not behave very nicely when, for any reason,
theconnection is no longer up.
 

The reason for the connection not being up is typically that I am accessing a database that is remote, and potentially
sittingbehind at least a couple of layers of firewall or nat, which have their own ideas about how long to allow a
connectionmappings across them valid and functioning, so it's not really something I have direct control over, and in
anycase, we're talking about how pgAdmin reacts to such an occurrence, not how to avoid the problem.
 

The bottom line is that in windows, when pgAdmin discovers that the connection has been broken, pgAdmin most often ends
uphaving to be killed off and restarted.  I've even gotten to the point of not even trying to have it attempt to
reconnect,because it seems that this can fail as well.
 

This issue appears to affect not only the table edit grid tool, but the main app as well.  Not sure about the sql query
tool.

Either way, the problem as a whole is quite annoying when it happens.

Don't get me wrong, pgAdmin is great! But, this is one of it's rough edges.

Regards,
Peter.



-----Original Message-----
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Guillaume
Lelarge
Sent: Thursday, June 09, 2011 11:50 AM
To: Herouth Maoz
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Is 1.14 supposed to behave differently when it loses connection?

On Thu, 2011-06-09 at 11:48 +0300, Herouth Maoz wrote:
> Look, it's very simple, there are two separate problems here.
> 
> 1. In the query tool, I don't get any questions asked. Just error messages in the message area, no alerts, not
anything.I'd attach a screen capture but it's over 42M for just a few frames, I don't have video expertise enough to
makeit smaller. But I feel strange that I have to provide proof anyways. It's very simple. I click the "run query"
button,and I get the errors that I mentioned below. That's it.
 
> 
> 2. In the table tool, it of course doesn't ask me anything. I get it - it isn't supposed to. It just gives me error
messages.Fine, but then I close the query tool and the table tool, bring up the main window, try to reconnect (I first
refreshthe existing connection, it then tells me it lost the connection and asks to re-connect. I allow it to
reconnect.It refreshes the connection) - and then it either gets stuck in watch-cursor and behaves funny (e.g. I can
bringup a table window but I can't resize the columns) or - more often than not - it crashes completely.
 
> 
> So one problem is that the query tool is not allowing me to reconnect. Another problem is that pgAdmin crashes after
Ireconnect a disconnected connection in the main window.
 
> 
> I am not hiding any steps from you. This is the full and complete information that I have!
> 

I don't reproduce it when I follow your steps. I don't know what more I
could say.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support