Skip site navigation (1) Skip section navigation (2)

Re: [SOLVED] pgAdmin ver 1.10 freezing all too frequently

From: Michael Shapiro <mshapiro51(at)gmail(dot)com>
To: Pedro Doria Meunier <pdoria(at)netmadeira(dot)com>
Cc: Dave Page <dpage(at)pgadmin(dot)org>, pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: [SOLVED] pgAdmin ver 1.10 freezing all too frequently
Date: 2009-11-12 13:08:50
Message-ID: ca3a8da20911120508i746e78cfsaf3e83c9af132c93@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
My server's setting are:

'tcp_keepalives_count','9'
'tcp_keepalives_idle','7200'
'tcp_keepalives_interval','75'

and I still get the problem. I just have to wait 20 minutes or so.

(I don't really know how to predict how long it takes to lose a connection,
even knowing these settings)

Note that if someone wants to replicate my problem, they could use these
settings and run PgAdmin from a Windows box (since the settings don't mean
anything for Unix connections).

Pedro, what are your setttings?

On Thu, Nov 12, 2009 at 5:40 AM, Pedro Doria Meunier
<pdoria(at)netmadeira(dot)com>wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi Dave,
>
> I was thinking about Michael's observations and the fact that this
> problem never happened if the server status window was opened.
>
> So what I did was:
> set the "tcp_keepalives_interval" = 75 and reloaded the server's
> configuration.
>
> No more freezes ever since! :)
>
> IMHO, however, pgAdmin should better handle connection status or,
> alternatively, check it and initiate a new connection if the previous
> one stalled...
>
> I have *some* C proficiency so if you point me in the right direction
> I might start investigating it and try to come up with a solution ... ;)
>
> BR,
> Pedro.
>
> On 11/12/2009 11:17 AM, Dave Page wrote:
> > On Thu, Nov 12, 2009 at 11:06 AM, Pedro Doria Meunier
> > <pdoria(at)netmadeira(dot)com> wrote:
> >> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
> >>
> >> I'm sorry Dave.
> >>
> >> I'm unable to... :(
> >>
> >> Whenever I try to get a backtrace it's already frozen solid and
> >> there's nothing to do other than kill it...
> >
> > If you start it under gdb, doesn't gdb break when you kill
> > pgAdmin? Something like:
> >
> > Program received signal SIGKILL, Killed. 0x943407da in
> > mach_msg_trap () (gdb) (gdb) bt #0  0x943407da in mach_msg_trap ()
> > #1  0x94340f47 in mach_msg () #2  0x99006dbf in __CFRunLoopRun ()
> > #3  0x99005d34 in CFRunLoopRunSpecific () #4  0x99005b61 in
> > CFRunLoopRunInMode () #5  0x919f3fec in RunCurrentEventLoopInMode
> > () #6  0x919f3da3 in ReceiveNextEventCommon () #7  0x91b7bd91 in
> > ReceiveNextEvent () #8  0x00e9d7e7 in wxApp::MacDoOneEvent () #9
> > 0x00eb6fd3 in wxEventLoop::Dispatch () #10 0x00f5d708 in
> > wxEventLoopManual::Run () #11 0x00f36bf3 in wxAppBase::MainLoop ()
> > #12 0x0136981a in wxEntry () #13 0x0003f548 in main ()
> >
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
> Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/
>
> iEYEARECAAYFAkr79B8ACgkQ2FH5GXCfxAsqpgCdGaG/70MMclIByU9Z0vwD918s
> vnEAoLceWLH7/y+RpLMl+UnWXvrsnvoZ
> =F1nX
> -----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
>

In response to

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2009-11-12 13:11:18
Subject: Re: [SOLVED] pgAdmin ver 1.10 freezing all too frequently
Previous:From: Eugene LisitskyDate: 2009-11-12 11:55:30
Subject: Re: PgAdmin forgets stored password on connection problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group