Re: pgAdmin ver 1.10 freezing all too frequently - Mailing list pgadmin-support

From Eugene Lisitsky
Subject Re: pgAdmin ver 1.10 freezing all too frequently
Date
Msg-id a745310911110608j35a5094y7994b23011995d91@mail.gmail.com
Whole thread Raw
In response to Re: pgAdmin ver 1.10 freezing all too frequently  (Pedro Doria Meunier <pdoria@netmadeira.com>)
Responses Re: pgAdmin ver 1.10 freezing all too frequently  (Michael Shapiro <mshapiro51@gmail.com>)
List pgadmin-support

I see such problem when remote servers replies slowly.


2009/11/1 Pedro Doria Meunier <pdoria@netmadeira.com>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Replying to self:
Altering the tcp_keepalive_time, tcp_keepalive_intvl values *didn't*
solve the problem.


On 11/01/2009 03:04 PM, Pedro Doria Meunier wrote:
>
> Sorry forgot to tell it happens on a remote connection... :)
>
> This is AFAICS is most probably a timeout problem. It makes me
> wonder if my router isn't dropping idle connections...
>
> Anyway I'm playing with tcp_keepalive_time, tcp_keepalive_intvl
> values to see if it solves the problem. btw: tcp_keepalive_time =
> 75 tcp_keepalive_intvl = 60
>
>
> I'll post my results.
>
> BR, Pedro Doria Meunier
>
>
> On 11/01/2009 12:37 PM, Dave Page wrote:
>> On Sun, Nov 1, 2009 at 11:04 AM, Pedro Doria Meunier
>> <pdoria@netmadeira.com> wrote:
>>> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
>>>
>>> Hi,
>>>
>>> pgAdmin ver 1.10.0 rev. 7945:7946 freezes after a short time
>>> of inactivity... Fedora 11 - kernel 2.6.30.9-90.fc11.i686.PAE
>>>
>>> Reproducible by: - - connect to a db - - click on any of the
>>> db's objects - - wait a while (1-3 minutes) - - refresh the
>>> object
>>>
>>> kaboom. it freezes. have to force termination.
>
>> I only have 64 bit CentOS 5 here at the moment, but I can't
>> reproduce on that. Anyone else?
>
>>> Setting the log to "debug" offers no joy as to discover the
>>> cause...
>>>
>>> I'm unsure as if it's a pgAdmin problem or rather a connection
> timeout...
>>> At any rate... does pgAdmin make any attempt to KEEP_ALIVE
>>> (the connection)?
>
>> No.
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAkrtq3EACgkQ2FH5GXCfxAuPUQCdExxsfhj3pyrCXuK0MqB0Sm9w
xsIAoI3N5xHOiHlGQC6HfW2BtPXpTtlt
=gNcZ
-----END PGP SIGNATURE-----


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



--
Yours,
Eugene Lisitsky

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Missing pgagent on 1.10.0 FreeBSD port?
Next
From: Maximilian Tyrtania
Date:
Subject: Deleting servers