X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 8D1B79DC9B6 for ; Thu, 2 Feb 2006 16:23:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95724-09 for ; Thu, 2 Feb 2006 16:23:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from bubka.webhack.com (bubka.webhack.com [64.34.168.26]) by postgresql.org (Postfix) with ESMTP id CDAC49DC9B0 for ; Thu, 2 Feb 2006 16:23:18 -0400 (AST) Received: (qmail 17910 invoked by uid 89); 2 Feb 2006 20:23:19 -0000 Received: by simscan 1.1.0 ppid: 17898, pid: 17905, t: 3.9047s scanners: clamav: 0.87.1/m:34/d:1162 spam: 3.1.0 Received: from unknown (HELO ?192.168.1.10?) (ashcraft@13monkeys.com@24.18.51.38) by bubka.webhack.com with SMTP; 2 Feb 2006 20:23:15 -0000 Message-ID: <43E26A23.1080208@edgate.com> Date: Thu, 02 Feb 2006 12:22:59 -0800 From: Jeremy Ashcraft User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051013) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: strange hung processes References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200602/28 X-Sequence-Number: 20449 If it's not sensitive information, what does this show? >> lsof | grep 'pid of hung process' >> From my systems guy: in /proc codd 13262 # cat status {proc "filesystem"} Name: postmaster State: D (disk sleep) Because of the "D" state, it can't be killed as it is not interuptible (waiting on IO ?). codd opt # lsof -p 13263 COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME postmaste 13263 postgres cwd DIR 8,17 464 4030 /app1/user/postgres postmaste 13263 postgres rtd DIR 8,3 488 2 / postmaste 13263 postgres txt REG 8,17 2552859 5012 /app1/pg/7.4.9/bin/postgres postmaste 13263 postgres mem REG 0,0 0 [heap] (stat: No such file or directory) postmaste 13263 postgres DEL REG 0,7 0 /SYSV0052e2c1 postmaste 13263 postgres mem REG 8,3 35428 5729 /lib/libnss_files-2.3.4.so postmaste 13263 postgres mem REG 8,5 18852 6895 /usr/lib/libgpm.so.1.19.0 postmaste 13263 postgres mem REG 8,3 266284 5965 /lib/libncurses.so.5.4 postmaste 13263 postgres mem REG 8,3 1167808 5977 /lib/libc-2.3.4.so postmaste 13263 postgres mem REG 8,3 151896 5755 /lib/libm-2.3.4.so postmaste 13263 postgres mem REG 8,3 10620 5987 /lib/libdl-2.3.4.so postmaste 13263 postgres mem REG 8,3 75848 6003 /lib/libnsl-2.3.4.so postmaste 13263 postgres mem REG 8,3 60884 5998 /lib/libresolv-2.3.4.so postmaste 13263 postgres mem REG 8,3 18424 6006 /lib/libcrypt-2.3.4.so postmaste 13263 postgres mem REG 8,3 173996 6007 /lib/libreadline.so.4.3 postmaste 13263 postgres mem REG 8,3 63204 5976 /lib/libz.so.1.2.2 postmaste 13263 postgres mem REG 8,3 95392 5915 /lib/ld-2.3.4.so postmaste 13263 postgres 0r CHR 1,3 2767 /dev/null postmaste 13263 postgres 1w REG 8,7 7513385 3649 /var/log/pg/ruby.log.bak1 postmaste 13263 postgres 2w REG 8,7 7513385 3649 /var/log/pg/ruby.log.bak1 postmaste 13263 postgres 5u sock 0,4 11790654 can't identify protocol