Re: [SOLVED] pgAdmin ver 1.10 freezing all too frequently - Mailing list pgadmin-support
| From | Michael Shapiro |
|---|---|
| Subject | Re: [SOLVED] pgAdmin ver 1.10 freezing all too frequently |
| Date | |
| Msg-id | ca3a8da20911120508i746e78cfsaf3e83c9af132c93@mail.gmail.com Whole thread Raw |
| In response to | Re: [SOLVED] pgAdmin ver 1.10 freezing all too frequently (Pedro Doria Meunier <pdoria@netmadeira.com>) |
| Responses |
Re: [SOLVED] pgAdmin ver 1.10 freezing all too
frequently
(Dave Page <dpage@pgadmin.org>)
Re: [SOLVED] pgAdmin ver 1.10 freezing all too frequently (Pedro Doria Meunier <pdoria@netmadeira.com>) |
| List | pgadmin-support |
My server's setting are:
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?
'tcp_keepalives_count','9'
'tcp_keepalives_idle','7200'
'tcp_keepalives_interval','75'
'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@netmadeira.com> wrote:
-----BEGIN PGP SIGNED MESSAGE-----Hi Dave,
Hash: SHA1
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@netmadeira.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-----iEYEARECAAYFAkr79B8ACgkQ2FH5GXCfxAsqpgCdGaG/70MMclIByU9Z0vwD918s
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/
vnEAoLceWLH7/y+RpLMl+UnWXvrsnvoZ
=F1nX
-----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
pgadmin-support by date: