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 4C8909DCBE0 for ; Sat, 25 Mar 2006 12:08:08 -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 65677-10 for ; Sat, 25 Mar 2006 12:08:06 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from prod01.jerrysievers.com (adsl-64-118-249-70.netrox.net [64.118.249.70]) by postgresql.org (Postfix) with ESMTP id 3DB6A9DC812 for ; Sat, 25 Mar 2006 12:08:04 -0400 (AST) Received: (from gsievers@localhost) by prod01.jerrysievers.com (8.11.0/8.11.0) id k2PG83030129; Sat, 25 Mar 2006 11:08:03 -0500 To: pgsql-admin@postgresql.org Subject: pg_stat_activity showing non-existent processes From: Jerry Sievers Date: 25 Mar 2006 11:08:03 -0500 Message-ID: Lines: 25 X-Mailer: Gnus v5.7/Emacs 20.7 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.088 required=5 tests=[AWL=0.088] X-Spam-Score: 0.088 X-Spam-Level: X-Archive-Number: 200603/257 X-Sequence-Number: 21014 Hello; Briefly, we've been fighting an "old idle transaction" problem on our Pg 8.0.3 Solaris 2.9 production system for a long time. This is due to some quirks in our app server code (to be fixed ASAP ). Hourly we run a script that SIGTERMs all backends reported as being in idle transaction state for 6 hours or better. Many, many runs of this procedure during past several weeks; no problem. Suddently, we have a condition where the pg_stat_activity view is reporting several such backends and there is no such PID in the system any more. These were either successfully terminated by an earlier script run, died off abnormally or even by normal client disconnect. (Unknown). At any rate; I'm wondering what possible causes might be responsible for pg_stat_activity's underlying functions to lose track of the valid process list? Great big thanks! -- ------------------------------------------------------------------------------- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobile http://www.JerrySievers.com/