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 ACAEB9DC814 for ; Wed, 4 Jan 2006 11:25:26 -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 34618-09 for ; Wed, 4 Jan 2006 11:25:31 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 407739DC868 for ; Wed, 4 Jan 2006 11:25:24 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k04FPKoM002784; Wed, 4 Jan 2006 10:25:21 -0500 (EST) To: Tsirkin Evgeny cc: pgsql-admin@postgresql.org Subject: Re: postmaster hangs In-reply-to: References: Comments: In-reply-to Tsirkin Evgeny message dated "Wed, 04 Jan 2006 13:33:51 +0200" Date: Wed, 04 Jan 2006 10:25:20 -0500 Message-ID: <2783.1136388320@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.065 required=5 tests=[AWL=0.065] X-Spam-Score: 0.065 X-Spam-Level: X-Archive-Number: 200601/45 X-Sequence-Number: 20133 Tsirkin Evgeny writes: > Today i was trying to run an old ver. of an application on test server . > After a while i have got the pg hangs : It looks like someone is holding a critical LWLock --- hard to tell if it's the BufMgrLock or a per-buffer lock for a system index's metapage, but must be one or the other. Try backtracing the processes that *aren't* hung in this particular way. I'm not sure you'll be able to learn anything much given that the build doesn't have debug info, but you might as well try. regards, tom lane