Re: pgAdmin ver 1.10 freezing all too frequently

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

I'm "glad" :] I'm not alone in this...

It's definitely not the router. It's something else...

For instance:

- - One opens a table. leave it be for some time and the next operation
freezes pgAdmin, especially if one tries to open another database
object (or another database).

- - If the SAME object is closed and then re-opened, no matter what time
it takes, it opens without a problem.

I use pgAdmin *intensively* and it's becoming *inpractical* to work
with it to my great sorrow...

I sure hope the gurus come up with a fix for this... ;)

Best regards,
Pedro Doria Meunier

On 11/11/2009 03:20 PM, Michael Shapiro wrote:
> It just happened again. I ran a query in a window and after it
> completed I waited 10-15 minutes and ran it again. I got a
> connection error. I ran the query again (by hitting the green >
> icon) and it caused pgAdmin to crash.
>
> Moreover, I was simultaneously running another tool that was
> connected to a non-Postgres database. After PgAdmin crashed I ran a
> query in the other tool. It ran fine. This implies that the
> connection isn't being dropped by my router due to inactivity. It
> is probably happening within the Postgres server.
>
> I will try to run this test again using PgAdmin and a different
> tool that can connect to the same Postgres database.
>
>
> On Wed, Nov 11, 2009 at 8:32 AM, Michael Shapiro
> <mshapiro51(at)gmail(dot)com <mailto:mshapiro51(at)gmail(dot)com>> wrote:
>
> 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(at)gmail(dot)com <mailto:lisitsky(at)gmail(dot)com>> wrote:
>
>
> I see such problem when remote servers replies slowly.
>
>
> 2009/11/1 Pedro Doria Meunier <pdoria(at)netmadeira(dot)com
> <mailto:pdoria(at)netmadeira(dot)com>>
>
> 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 <mailto: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.
>

- --

Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org
<mailto:pgadmin-support(at)postgresql(dot)org>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

> -- Yours, Eugene Lisitsky

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAkr62hAACgkQ2FH5GXCfxAtuIACbBJGfLn7Ohm9joY1t5UWBJ2Yp
ZMQAn1rfEXf4w3xTvYvayyuOtE53WXG7
=XkJO
-----END PGP SIGNATURE-----