pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bellur Ashwin <bell_ashwin@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: xlog related error
Date: Thu, 5 Apr 2007 07:40:11 +0100 (BST)
Message-ID: <39481.31366.qm@web50606.mail.re2.yahoo.com> (raw)
In-Reply-To: <a97c77030704042032r57b51c7ep3b74cb1d08195429@mail.gmail.com>


--- Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
wrote:

> On 4/5/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>
> 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/



view thread (6+ messages)  latest in thread

Message-ID: <39481.31366.qm@web50606.mail.re2.yahoo.com>
Permalink:  ../39481.31366.qm@web50606.mail.re2.yahoo.com/
Also on:    postgresql.org/message-id/39481.31366.qm@web50606.mail.re2.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: bell_ashwin@yahoo.com
  Subject: Re: xlog related error
  In-Reply-To: <39481.31366.qm@web50606.mail.re2.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox