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

Re: Pgadmin III loses connection with remote database and then hangs for a long time.

From: "Belbin, Peter" <Peter(dot)Belbin(at)PAETEC(dot)com>
To: 'Tim Uckun' <timuckun(at)gmail(dot)com>, Bob McConnell <rvm(at)cbord(dot)com>
Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Pgadmin III loses connection with remote database and then hangs for a long time.
Date: 2011-06-02 18:37:22
Message-ID: BCF4A499A1D8A144AF2E49797C63571102335041DD@IAMAILCLUSTER1.corp.paetec.com (view raw or flat)
Thread:
Lists: pgadmin-support
I experience this issue on a fairly regular basis.

I never have this problem using a locally available database.  It's only on remote databases.

It's very annoying when it does happen, as I find I basically have to kill the app and start over.

It seems to me like there is a firewall somewhere along the line that after some time of disuse, decides the session is no longer valid and no longer passes the data.

Now, the network connectivity aspect is totally out of my control, but, the pgadmin's response to the issue could be better, for sure.

Regards,
Peter.





-----Original Message-----
From: pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Tim Uckun
Sent: Wednesday, June 01, 2011 8:57 AM
To: Bob McConnell
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Pgadmin III loses connection with remote database and then hangs for a long time.

> It may just be me, but this sounds like a bug. Have you looked at the
> tracker to see if it has already been reported? Since it appears you can
> reproduce it reliably, perhaps you should post it there so the
> developers can take a closer look at it. If you go that route, I suggest
> using Wireshark to capture one or more sessions that lock up the client
> and attach the raw capture files onto the bug report. This will help
> them identify the actual problem and insure the fix really works.

I haven't done that because I thought I would post it here first and
see if somebody had similar experiences.

I can reproduce it fairly regularly although I have taken to logging
out of the remote sessions immediately after I am done to avoid the
problem. I'll install wireshark and see if I can get a capture
tomorrow.

To me the problem smells like a threading issue. The connection is
timing out and blocking the entire app and the gui locks up until the
timeout exceeds and the app is responsive again. Unfortunately the
timeout seems to be set to something really long.

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

In response to

pgadmin-support by date

Next:From: Dave PageDate: 2011-06-03 11:35:15
Subject: Re: Performance of pgAdmin 14 Beta 1
Previous:From: Dave PageDate: 2011-06-02 14:47:18
Subject: Re: pg_listener table errors with slony

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