Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E02DF9FB280 for ; Mon, 9 Apr 2007 09:38:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 27541-04 for ; Mon, 9 Apr 2007 09:38:08 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web50602.mail.re2.yahoo.com (web50602.mail.re2.yahoo.com [206.190.38.89]) by postgresql.org (Postfix) with SMTP id 3E40B9FB27C for ; Mon, 9 Apr 2007 09:38:08 -0300 (ADT) Received: (qmail 76481 invoked by uid 60001); 9 Apr 2007 12:38:06 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=qJIV3CIt6GN4BMuV9mYCR9h6uXGo8Ajl5TMFm6JRcVao1WSy+WX7nerl6ufyaSsyFAQxOCBfoctCI+Satf5WadntEBjv6jMNnEy1iLoktnUSVwv/p8xCfsc4/KoG7CUyf4W8q/WlvUHwb3uBF3EIZOIdHj6os1YZQqJaZs8eT4o=; X-YMail-OSG: 2T891h0VM1nWybUEE_TYs_5BUvHnMN2PUXywuFqe62.5_mpK5qF2KMRStLDNUyQ8vEg5fBiI5eOZBryRYtAopQzgrN9ebRUy79rs49gf0zJf66Qm9etIZDgb29sb Received: from [203.200.35.38] by web50602.mail.re2.yahoo.com via HTTP; Mon, 09 Apr 2007 05:38:06 PDT X-Mailer: YahooMailRC/478 YahooMailWebService/0.7.41.10 Date: Mon, 9 Apr 2007 05:38:06 -0700 (PDT) From: Bellur Ashwin Subject: Re: xlog related error To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-40083359-1176122286=:75679" Message-ID: <797322.75679.qm@web50602.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.069 tagged_above=0 required=5 tests=AWL=-0.062, BAYES_00=-2.599, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447, HTML_30_40=0.374, HTML_MESSAGE=0.001 X-Spam-Level: * X-Archive-Number: 200704/75 X-Sequence-Number: 25139 --0-40083359-1176122286=:75679 Content-Type: text/plain; charset=ascii >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 I have done pg_restore as i found in some website about this error. Now i am not getting the error but now my postgres stops after inserting 5600(+/- 50) rows. I cant find out where the problem is Regards, Ashwin __________________________________________________________ Yahoo! India Answers: Share what you know. Learn something new http://in.answers.yahoo.com/ --0-40083359-1176122286=:75679 Content-Type: text/html; charset=iso-8859-7 Content-Transfer-Encoding: quoted-printable
>Rajesh Kumar Mallah <mallah ( dot ) rajesh ( at ) gmail ( dot ) com=
>
>wrote:

>> On 4/5/07, Tom Lane <tgl ( at ) sss (= dot ) pgh ( dot ) pa ( dot ) us> wrote:
>> > "Rajesh Kumar = Mallah" <mallah ( dot ) rajesh ( at ) gmail ( dot ) com>
>> = writes:
>> > > A friend of mine getting following error
&= gt;> >
>> > > Error: xlog flush request 0/797FED50/ is= not
>> satisfied -- flushed only
>> > > to 0/797FC= 1D8
>> > > CONTEXT: writing block 681 of relation
>>= ; 1663/10819/16520
>> >
>> > Which PG version exact= ly? Has he had any crashes
>> lately? The message
>> &g= t; means that that block contains an LSN that's past
>> the current end of WAL,
&= gt;> > which is a pretty suspicious situation.
>> >
&g= t;> > The message will go away pretty soon (as soon as
>> an= other 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
>&= gt;
>> regds mallah.
>>
>> >
>> &g= t; regards, tom lane
>> >
>> <= br>>> ---------------------------(end of
>> broadcast)------= ---------------------
>> TIP 2: Don't 'kill -9' the postmaster
= >>
>I am using postgres-8.2.3, i have changed my
>postgr= es.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 th= e
>query, i will generate 10,000 inserts into a table and
>exec= ute them using exec_simple.

>I will fire one query through jdbc b= eginning with the
>same word "tiger".
>Here after inserting 560= 0 inserts i get the above
>ERROR message.
>Any idea how to suc= cesfully insert all those values.

>Regards,
>Ashwin
I ha= ve done pg_restore as i found in some website about this error.
Now i am= not getting the error but now my postgres stops after inserting
5600(+/= - 50) rows. I cant find out where the problem is

Regards,
Ashwin<= br>

=0A=09=0A=0A=09=0A=09=09
=0AHere=A2s a new way to find what you're looking for - Yahoo= ! Answers --0-40083359-1176122286=:75679--