Thread: Server status hanging on OS X

Server status hanging on OS X

From
MattK
Date:
When connecting to a v8.4.9 server on with PgAdmin v1.14.2 on OS X (SL and Lion) and launching the Server Status window, PgAdmin displays the status window with highlighted process info, but then the entire application becomes unresponsive, and shows as not responding in the Mac activity monitor, consuming ~10% CPU. 

This issue was also present in PgAdmin v1.14.1, but seemed to occur less frequently (subjective). The server is question is accessed by a local ssh forward (ssh -L), but this may or not be related, as I have been able to use this configuration in the past without issue.

I also use DbVisualizer, which has a similar but less detailed display (essentially pg_stat_activity), that does not seem to have any issue through the same connection. I can execute "select * from pg_stat_activity" via a PgAdmin query successfully on the connection.

What other information can I collect to diagnose the cause?

Re: Server status hanging on OS X

From
Guillaume Lelarge
Date:
Le 17/03/2012 19:06, MattK a écrit :
> When connecting to a v8.4.9 server on with PgAdmin v1.14.2 on OS X (SL
> and Lion) and launching the Server Status window, PgAdmin displays the
> status window with highlighted process info, but then the entire
> application becomes unresponsive, and shows as not responding in the Mac
> activity monitor, consuming ~10% CPU.
>
> This issue was also present in PgAdmin v1.14.1, but seemed to occur less
> frequently (subjective). The server is question is accessed by a local
> ssh forward (ssh -L), but this may or not be related, as I have been
> able to use this configuration in the past without issue.
>
> I also use DbVisualizer, which has a similar but less detailed display
> (essentially pg_stat_activity), that does not seem to have any issue
> through the same connection. I can execute "select * from
> pg_stat_activity" via a PgAdmin query successfully on the connection.
>
> What other information can I collect to diagnose the cause?
>

How many times does the Server Status refresh the display?


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com


Re: Server status hanging on OS X

From
MattK
Date:
I can reproduce the issue in v1.14.0 and v1.14.1 as well. This does not happen on all of my Postgres instances, the one I am trying to actively monitor that exhibits the problem is through the ssh port forward.

Running ssh -v -L  5433:<server>:5432 <user>@<server> seems to show a constant traffic stream, with messages like this repeating:

debug2: channel 5: window 1997018 sent adjust 100134
debug2: channel 5: window 1997018 sent adjust 100134
debug2: channel 5: window 1997018 sent adjust 100134
debug2: channel 5: window 1997018 sent adjust 100134
debug2: channel 5: window 1997018 sent adjust 100134
debug2: channel 5: window 1997018 sent adjust 100134



From: MattK <mksql@yahoo.com>
To: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>
Sent: Saturday, March 17, 2012 2:06 PM
Subject: [pgadmin-support] Server status hanging on OS X

When connecting to a v8.4.9 server on with PgAdmin v1.14.2 on OS X (SL and Lion) and launching the Server Status window, PgAdmin displays the status window with highlighted process info, but then the entire application becomes unresponsive, and shows as not responding in the Mac activity monitor, consuming ~10% CPU. 

This issue was also present in PgAdmin v1.14.1, but seemed to occur less frequently (subjective). The server is question is accessed by a local ssh forward (ssh -L), but this may or not be related, as I have been able to use this configuration in the past without issue.

I also use DbVisualizer, which has a similar but less detailed display (essentially pg_stat_activity), that does not seem to have any issue through the same connection. I can execute "select * from pg_stat_activity" via a PgAdmin query successfully on the connection.

What other information can I collect to diagnose the cause?



Re: Server status hanging on OS X

From
Dave Page
Date:
On Mon, Mar 19, 2012 at 7:26 PM, MattK <mksql@yahoo.com> wrote:
> I can reproduce the issue in v1.14.0 and v1.14.1 as well. This does not
> happen on all of my Postgres instances, the one I am trying to actively
> monitor that exhibits the problem is through the ssh port forward.
>
> Running ssh -v -L  5433:<server>:5432 <user>@<server> seems to show a
> constant traffic stream, with messages like this repeating:
>
> debug2: channel 5: window 1997018 sent adjust 100134
> debug2: channel 5: window 1997018 sent adjust 100134
> debug2: channel 5: window 1997018 sent adjust 100134
> debug2: channel 5: window 1997018 sent adjust 100134
> debug2: channel 5: window 1997018 sent adjust 100134
> debug2: channel 5: window 1997018 sent adjust 100134

Could it be trying to load a very large log file?

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Re: Server status hanging on OS X

From
MattK
Date:
Very likely. I had some large log files (>1GB). Setting the log rotation size to 100MB seems to have brought my the server status monitor back to life.

Thanks!


From: Dave Page <dpage@pgadmin.org>
To: MattK <mksql@yahoo.com>
Cc: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>
Sent: Tuesday, March 20, 2012 4:47 AM
Subject: Re: [pgadmin-support] Server status hanging on OS X

On Mon, Mar 19, 2012 at 7:26 PM, MattK <mksql@yahoo.com> wrote:
> I can reproduce the issue in v1.14.0 and v1.14.1 as well. This does not
> happen on all of my Postgres instances, the one I am trying to actively
> monitor that exhibits the problem is through the ssh port forward.
>
> Running ssh -v -L  5433:<server>:5432 <user>@<server> seems to show a
> constant traffic stream, with messages like this repeating:
>
> debug2: channel 5: window 1997018 sent adjust 100134
> debug2: channel 5: window 1997018 sent adjust 100134
> debug2: channel 5: window 1997018 sent adjust 100134
> debug2: channel 5: window 1997018 sent adjust 100134
> debug2: channel 5: window 1997018 sent adjust 100134
> debug2: channel 5: window 1997018 sent adjust 100134

Could it be trying to load a very large log file?

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Re: Server status hanging on OS X

From
MattK
Date:
With reduced logging, I still get regular periods of unresponsiveness, even when Don't Refresh is set in the monitor window.

Does PgAdmin look at all logs in pg_log, or only the current one?

Is there a way to disable log monitoring, as a test for the cause of this issue?



From: MattK <mksql@yahoo.com>
To: Dave Page <dpage@pgadmin.org>
Cc: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>
Sent: Tuesday, March 20, 2012 12:54 PM
Subject: Re: [pgadmin-support] Server status hanging on OS X

Very likely. I had some large log files (>1GB). Setting the log rotation size to 100MB seems to have brought my the server status monitor back to life.

Thanks!


From: Dave Page <dpage@pgadmin.org>
To: MattK <mksql@yahoo.com>
Cc: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>
Sent: Tuesday, March 20, 2012 4:47 AM
Subject: Re: [pgadmin-support] Server status hanging on OS X

On Mon, Mar 19, 2012 at 7:26 PM, MattK <mksql@yahoo.com> wrote:
> I can reproduce the issue in v1.14.0 and v1.14.1 as well. This does not
> happen on all of my Postgres instances, the one I am trying to actively
> monitor that exhibits the problem is through the ssh port forward.
>
> Running ssh -v -L  5433:<server>:5432 <user>@<server> seems to show a
> constant traffic stream, with messages like this repeating:
>
> debug2: channel 5: window 1997018 sent adjust 100134
> debug2: channel 5: window 1997018 sent adjust 100134
> debug2: channel 5: window 1997018 sent adjust 100134
> debug2: channel 5: window 1997018 sent adjust 100134
> debug2: channel 5: window 1997018 sent adjust 100134
> debug2: channel 5: window 1997018 sent adjust 100134

Could it be trying to load a very large log file?

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company




Re: Server status hanging on OS X

From
Guillaume Lelarge
Date:
On Tue, 2012-03-20 at 12:53 -0700, MattK wrote:
> With reduced logging, I still get regular periods of unresponsiveness, even when Don't Refresh is set in the monitor
window.
> 
> Does PgAdmin look at all logs in pg_log, or only the current one?
> 

Only the selected one in the combobox.

> Is there a way to disable log monitoring, as a test for the cause of this issue?
> 

Yes, in the menu View, checkbox Logfile to uncheck.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com