Re: pgAdmin ver 1.10 freezing all too frequently

Поиск
Список
Период
Сортировка
От Pedro Doria Meunier
Тема Re: pgAdmin ver 1.10 freezing all too frequently
Дата
Msg-id 4AEDA388.1070002@netmadeira.com
обсуждение исходный текст
Ответ на Re: pgAdmin ver 1.10 freezing all too frequently  (Dave Page <dpage@pgadmin.org>)
Ответы Re: pgAdmin ver 1.10 freezing all too frequently  (Pedro Doria Meunier <pdoria@netmadeira.com>)
Список pgadmin-support
-----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@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/

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



В списке pgadmin-support по дате отправления:

Предыдущее
От: Sachin Srivastava
Дата:
Сообщение: Re: pgAdmin ver 1.10 freezing all too frequently
Следующее
От: Pedro Doria Meunier
Дата:
Сообщение: Re: pgAdmin ver 1.10 freezing all too frequently