Thread: ERROR: XLogFlush:

ERROR: XLogFlush:

From
Chris Pizzo
Date:
Hi all,
My server crashed in the middle of  a vacuum operation and when I restarted
postgres I got the following error trying any command from psql promt:

ERROR:  XLogFlush: request 19/8AF0757C is not satisfied --- flushed only to
19/8ACCCD88

I'm running 7.3.2.

What exactly does this mean and can I recover from this?

Thanks in advance,
Chris


Re: ERROR: XLogFlush:

From
Tom Lane
Date:
Chris Pizzo <chris@artinside.com> writes:
> My server crashed in the middle of  a vacuum operation and when I restarted
> postgres I got the following error trying any command from psql promt:

> ERROR:  XLogFlush: request 19/8AF0757C is not satisfied --- flushed only to
> 19/8ACCCD88

"Any" command?

I would guess that this indicates a corrupted LSN field in some specific
data page, but which page is impossible to tell without more
information.

            regards, tom lane