pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: xlog related error
Date: Wed, 04 Apr 2007 16:10:46 -0400
Message-ID: <2408.1175717446@sss.pgh.pa.us> (raw)
In-Reply-To: <a97c77030704041216t7b473642ic79e7d67ac25c4a1@mail.gmail.com>
References: <a97c77030704041216t7b473642ic79e7d67ac25c4a1@mail.gmail.com>

"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.

			regards, tom lane



view thread (6+ messages)  latest in thread

Message-ID: <2408.1175717446@sss.pgh.pa.us>
Permalink:  ../2408.1175717446@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/2408.1175717446@sss.pgh.pa.us

 · 

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: tgl@sss.pgh.pa.us, mallah.rajesh@gmail.com
  Subject: Re: xlog related error
  In-Reply-To: <2408.1175717446@sss.pgh.pa.us>

* 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