From: Rajesh Kumar Mallah. <mallah@trade-india.com>
To: pgsql-sql@postgresql.org
Cc: Jan Wieck <janwieck@yahoo.com>
Subject: Further info : Very high load average but no cpu utilization ?
Date: Sat, 11 May 2002 10:35:05 +0530
Message-ID: <200205111035.05281.mallah@trade-india.com> (raw)
In-Reply-To: <200205111007.47338.mallah@trade-india.com>
References: <200205111007.47338.mallah@trade-india.com>
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@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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah@trade-india.com, janwieck@yahoo.com
Subject: Re: Further info : Very high load average but no cpu utilization ?
In-Reply-To: <200205111035.05281.mallah@trade-india.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox