Re: pgAdmin ver 1.10 freezing all too frequently

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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/

iEYEARECAAYFAkrto34ACgkQ2FH5GXCfxAsvuwCePKO950pHKcUx6OCmw5LVy3SM
xLAAn0YRPupAa0JqO8dHcR+0EfDcXyUX
=EIax
-----END PGP SIGNATURE-----