Re: pgAdmin ver 1.10 freezing all too frequently

From: Pedro Doria Meunier <pdoria(at)netmadeira(dot)com>
To: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: pgAdmin ver 1.10 freezing all too frequently
Date: 2009-11-01 15:38:34
Message-ID: 4AEDAB7A.1060609@netmadeira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

-----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(at)netmadeira(dot)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-----

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dick Kriesel 2009-11-03 22:45:24 pg_catalog and information_schema in pgAdmin object Browser?
Previous Message Pedro Doria Meunier 2009-11-01 15:04:40 Re: pgAdmin ver 1.10 freezing all too frequently