Further info : Very high load average but no cpu utilization ?

Hi ,

i am sorry to bother you people again and again , but i guess this
is a bad patch for me which will soon pass on ;-)

my postmaster is running but most of the backeds are defunct ,
and on connecting get following error message:

$ psql -h 130.94.22.209 -U tradein tradein_clients
psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
[rmallah(at)server rmallah]$

how do i bring down postmaster safetly?

ps output is as below.

[root(at)linux10320 root2]# ps auxwww| grep post
postgres 1131 0.0 0.0 139424 4 ? D May1004/usr/local/pgsql/bin/postmaster
postgres 1132 0.0 0.0 140412 4 ? D May10 0:13 postgres: stats buffer process
postgres 1133 0.0 0.0 139576 4 ? S May10 0:18 postgres: stats collector process
postgres 8046 0.0 0.0 238712 4 ? D 00:25 0:13 postgres: tradein tradein_clients 130.94.20.27 SELECT
postgres 8089 0.0 0.0 139812 4 ? D 00:26 0:00 postgres: checkpoint subprocess
postgres 11442 0.0 0.0 218152 4 ? D 04:25 0:03 postgres: tradein tradein_clients 130.94.20.27 SELECT
postgres 15453 0.1 0.0 0 0 ? Z 08:17 0:09 [postmaster <defunct>]
postgres 15455 0.0 0.0 0 0 ? Z 08:17 0:00 [postmaster <defunct>]
postgres 15456 0.0 0.0 0 0 ? Z 08:18 0:00 [postmaster <defunct>]
postgres 15457 0.0 0.0 0 0 ? Z 08:19 0:00 [postmaster <defunct>]
postgres 15462 0.0 0.0 0 0 ? Z 08:20 0:01 [postmaster <defunct>]
postgres 15463 0.0 0.0 0 0 ? Z 08:20 0:00 [postmaster <defunct>]
postgres 15465 0.0 0.0 0 0 ? Z 08:21 0:01 [postmaster <defunct>]
postgres 15466 0.0 0.0 0 0 ? Z 08:22 0:00 [postmaster <defunct>]
postgres 15491 0.0 0.0 0 0 ? Z 08:24 0:00 [postmaster <defunct>]
postgres 15494 0.0 0.0 0 0 ? Z 08:24 0:00 [postmaster <defunct>]
postgres 15496 0.0 0.0 0 0 ? Z 08:24 0:00 [postmaster <defunct>]
postgres 15510 0.2 10.2 238712 105008 ? D 08:25 0:20 postgres: tradein tradein_clients 130.94.20.27 SELECT
root 19268 0.0 0.0 1364 528 pts/1 S 10:42 0:00 grep post
[root(at)linux10320 root2]#

On Saturday 11 May 2002 10:07 am, Rajesh Kumar Mallah. wrote:
> Hi Again,
>
> 10:22am up 15:06, 1 user, load average: 9.02, 9.02, 8.98
> 85 processes: 73 sleeping, 1 running, 11 zombie, 0 stopped
> CPU states: 0.0% user, 0.4% system, 0.0% nice, 99.4% idle
> Mem: 1028484K av, 1017488K used, 10996K free, 0K shrd, 8996K
> buff Swap: 971004K av, 240344K used, 730660K free
> 760208K cached
>
> In my postgresql server load avearge is very high but cpu is 99.4 % idle
>
> this is not strictly a pgsql issue but , can anyone tell me how can i
> find what is loading my server heavily
>
>
> regds
> Mallah.

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.