Re: pgAdmin ver 1.10 freezing all too frequently

Поиск
Список
Период
Сортировка
От Michael Shapiro
Тема Re: pgAdmin ver 1.10 freezing all too frequently
Дата
Msg-id ca3a8da20911110632ocfa87bcgc690b9313d643f6d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgAdmin ver 1.10 freezing all too frequently  (Eugene Lisitsky <lisitsky@gmail.com>)
Ответы Re: pgAdmin ver 1.10 freezing all too frequently  (Michael Shapiro <mshapiro51@gmail.com>)
Список pgadmin-support
It happens to me quite a lot, as well. I will lose the contents of the SQL window as well when it happens.

It would be good if PgAdmin would automatically try to reconnect (at least once) before giving up.

On Wed, Nov 11, 2009 at 8:08 AM, Eugene Lisitsky <lisitsky@gmail.com> wrote:

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 по дате отправления:

Предыдущее
От: Eugene Lisitsky
Дата:
Сообщение: Query window and non-english text
Следующее
От: Dave Page
Дата:
Сообщение: Re: Deleting servers