Further info : Very high load average but no cpu utilization ? - Mailing list pgsql-sql

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
orwhile processing the request. 
[rmallah@server rmallah]$


how do i bring down postmaster safetly?

ps output is as below.

[root@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@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.