Hi,

I am getting following strange errors while executing queries.

1)
ERROR: xlog flush request 0/108EA5F8 is not satisfied --- flushed only
to 0/1813C60
CONTEXT: writing block 2 of relation 17142/16653
WARNING: could not write block 2 of 17142/16653
DETAIL: Multiple failures --- write error may be permanent.
ERROR: xlog flush request 0/108EA5F8 is not satisfied --- flushed only
to 0/1813C60
CONTEXT: writing block 2 of relation 17142/16653
WARNING: could not write block 2 of 17142/16653
DETAIL: Multiple failures --- write error may be permanent.
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection

2)I am getting messages saying that

WARNING: relation page <number> is uninitialized in <tablename>

I am getting this WARNING multiple times...



Could u please help me regarding these issues,

Thanking You in advance,
Prasanna.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

On Mon, Jan 16, 2006 at 09:27:30AM +0530, Mavinakuli, Prasanna (STSD) wrote:
>
> Hi,
>
> I am getting following strange errors while executing queries.
>
> 1)
> ERROR: xlog flush request 0/108EA5F8 is not satisfied --- flushed only
> to 0/1813C60

If I had to guess, I'd say you're having a hard disk failure of some
kind. In particular, this tells you that a flush of the write ahead
log isn't completing. That's a Bad Thing.

A

--
Andrew Sullivan | ajs@crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend