Re: xlog related error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: xlog related error
Date: 2007-04-04 20:10:46
Message-ID: 2408.1175717446@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dave Lazar 2007-04-04 20:25:17 security question
Previous Message Bricklen Anderson 2007-04-04 19:55:38 Re: sequences