Re: pgAdmin ver 1.10 freezing all too frequently

I see such problem when remote servers replies slowly.

2009/11/1 Pedro Doria Meunier <pdoria(at)netmadeira(dot)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(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-----
>
>
> --
> 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
>

--
Yours,
Eugene Lisitsky