Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B47229FB460 for ; Thu, 5 Apr 2007 03:40:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 11030-05 for ; Thu, 5 Apr 2007 03:40:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web50606.mail.re2.yahoo.com (web50606.mail.re2.yahoo.com [206.190.38.93]) by postgresql.org (Postfix) with SMTP id 408559FB44F for ; Thu, 5 Apr 2007 03:40:13 -0300 (ADT) Received: (qmail 92966 invoked by uid 60001); 5 Apr 2007 06:40:12 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=PEz5RKFf4gn8kPr0WSuXyEf4uAh8lnqZ8jZX5k93FJZrOt1rYNLTPXUcrigDitE+xTPKrns4uXYUkhMuFAiZ3Z/R5JhyFKBgbSFPLI/rG9hLvl4PrKrZfLKyuagdhQQrZz3kCw97/j6k8dl1TbTHV4P867OMhuihJLmp/AXsZJE=; X-YMail-OSG: FMuMHQcVM1ldlnEwi3Szk8flUdPEqZ.8WJQfMsTbGxuYPOQ3yRTJ1RWcvFgWWewz72tdxuif_LDqMZz3EzTkoBEKGSHcyuroxGWDGj8oIYiBdpVJ6B84y9stFOVK Received: from [220.227.207.31] by web50606.mail.re2.yahoo.com via HTTP; Thu, 05 Apr 2007 07:40:11 BST Date: Thu, 5 Apr 2007 07:40:11 +0100 (BST) From: Bellur Ashwin Subject: Re: xlog related error To: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <39481.31366.qm@web50606.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.356 tagged_above=0 required=5 tests=BAYES_50=0.001, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447 X-Spam-Level: *** X-Archive-Number: 200704/52 X-Sequence-Number: 25116 --- Rajesh Kumar Mallah wrote: > 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 > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > I am using postgres-8.2.3, i have changed my postgres.c file, in the function PostgresMain in the case P of processing the command so that, whenever i see a word say "tiger" as the first word of the query, i will generate 10,000 inserts into a table and execute them using exec_simple. I will fire one query through jdbc beginning with the same word "tiger". Here after inserting 5600 inserts i get the above ERROR message. Any idea how to succesfully insert all those values. Regards, Ashwin __________________________________________________________ Yahoo! India Answers: Share what you know. Learn something new http://in.answers.yahoo.com/