Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 907389FB8A5 for ; Wed, 4 Apr 2007 17:11:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 11475-04 for ; Wed, 4 Apr 2007 17:10:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id D1B899FB668 for ; Wed, 4 Apr 2007 17:10:47 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l34KAkEs002409; Wed, 4 Apr 2007 16:10:46 -0400 (EDT) To: "Rajesh Kumar Mallah" cc: "pgsql-admin@postgresql.org" Subject: Re: xlog related error In-reply-to: References: Comments: In-reply-to "Rajesh Kumar Mallah" message dated "Thu, 05 Apr 2007 00:46:32 +0530" Date: Wed, 04 Apr 2007 16:10:46 -0400 Message-ID: <2408.1175717446@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/37 X-Sequence-Number: 25101 "Rajesh Kumar Mallah" writes: > A friend of mine getting following error > Error: xlog flush request 0/797FED50/ is not satisfied -- flushed only > to 0/797FC1D8 > CONTEXT: writing block 681 of relation 1663/10819/16520 Which PG version exactly? Has he had any crashes lately? The message means that that block contains an LSN that's past the current end of WAL, which is a pretty suspicious situation. The message will go away pretty soon (as soon as another 10K or so of WAL is generated) but this looks like a symptom of a bug to me. Details would be good. regards, tom lane