Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3683A9FBC16 for ; Thu, 5 Apr 2007 00:32:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 86400-05 for ; Thu, 5 Apr 2007 00:32:24 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.240]) by postgresql.org (Postfix) with ESMTP id 174259FB2C6 for ; Thu, 5 Apr 2007 00:32:24 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c24so509358ana for ; Wed, 04 Apr 2007 20:32:24 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=dI7ruUVGXvpjBlW1g6ippTZ00sRJktl44XdPQWULKLXZzyWkz9nbZ3Qe3c8UAQB2j+d7txvReHLUMs3ZnsaaMvrgaF500D9YdQbOxo0j86XPx/7KdSs0l9kF3z4cbN6zz/RseIQeWDOtJGdOtIFLYoXhvH+9l4G8Wahv9RpdTFE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=B9BoZMTwnzTginlPL5a2kDyT9bIdOBD5nVUdlrIIw2faoVAsSRLx9nKiXpcC11TKtVLajCe003fGDhC/b5fvj1X3r8hrra/z1uMHm+OR9s5q2P5/EMDFukAxfbDPTh3jdhtBL6iV/Q/AKZXZiZNITJPNDDGWzUPu/71b91ky6EE= Received: by 10.100.140.6 with SMTP id n6mr1028818and.1175743944256; Wed, 04 Apr 2007 20:32:24 -0700 (PDT) Received: by 10.100.197.13 with HTTP; Wed, 4 Apr 2007 20:32:24 -0700 (PDT) Message-ID: Date: Thu, 5 Apr 2007 09:02:24 +0530 From: "Rajesh Kumar Mallah" To: "Tom Lane" Subject: Re: xlog related error Cc: "pgsql-admin@postgresql.org" In-Reply-To: <2408.1175717446@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <2408.1175717446@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/51 X-Sequence-Number: 25115 On 4/5/07, Tom Lane wrote: > "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. The person "Ashwin" might contact the list directly. If he does'nt i shall try my best to get the details regds mallah. > > regards, tom lane >