Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id B495D475CC4 for ; Sat, 11 May 2002 01:06:15 -0400 (EDT) Received: from mail-relay.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 1BC8A4759B3 for ; Sat, 11 May 2002 01:05:40 -0400 (EDT) Received: (qmail 13971 invoked from network); 11 May 2002 04:58:17 -0000 Received: from system29.trade-india-local.com (HELO server) (192.168.0.29) by ptil-236-129-del.primus-india.net with SMTP; 11 May 2002 04:58:17 -0000 Content-Type: text/plain; charset="iso-8859-1" From: "Rajesh Kumar Mallah." Organization: Infocom Network Limited. To: pgsql-sql@postgresql.org Subject: Further info : Very high load average but no cpu utilization ? Date: Sat, 11 May 2002 10:35:05 +0530 X-Mailer: KMail [version 1.4] References: <200205111007.47338.mallah@trade-india.com> In-Reply-To: <200205111007.47338.mallah@trade-india.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Cc: Jan Wieck Message-Id: <200205111035.05281.mallah@trade-india.com> X-Archive-Number: 200205/106 X-Sequence-Number: 7742 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/b= in/postmaster postgres 1132 0.0 0.0 140412 4 ? D May10 0:13 postgres: st= ats buffer process postgres 1133 0.0 0.0 139576 4 ? S May10 0:18 postgres: st= ats collector process postgres 8046 0.0 0.0 238712 4 ? D 00:25 0:13 postgres: tr= adein tradein_clients 130.94.20.27 SELECT postgres 8089 0.0 0.0 139812 4 ? D 00:26 0:00 postgres: ch= eckpoint subprocess postgres 11442 0.0 0.0 218152 4 ? D 04:25 0:03 postgres: tr= adein tradein_clients 130.94.20.27 SELECT postgres 15453 0.1 0.0 0 0 ? Z 08:17 0:09 [postmaster = ] postgres 15455 0.0 0.0 0 0 ? Z 08:17 0:00 [postmaster = ] postgres 15456 0.0 0.0 0 0 ? Z 08:18 0:00 [postmaster = ] postgres 15457 0.0 0.0 0 0 ? Z 08:19 0:00 [postmaster = ] postgres 15462 0.0 0.0 0 0 ? Z 08:20 0:01 [postmaster = ] postgres 15463 0.0 0.0 0 0 ? Z 08:20 0:00 [postmaster = ] postgres 15465 0.0 0.0 0 0 ? Z 08:21 0:01 [postmaster = ] postgres 15466 0.0 0.0 0 0 ? Z 08:22 0:00 [postmaster = ] postgres 15491 0.0 0.0 0 0 ? Z 08:24 0:00 [postmaster = ] postgres 15494 0.0 0.0 0 0 ? Z 08:24 0:00 [postmaster = ] postgres 15496 0.0 0.0 0 0 ? Z 08:24 0:00 [postmaster = ] postgres 15510 0.2 10.2 238712 105008 ? D 08:25 0:20 postgres: tr= adein 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=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20 > 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. --=20 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.