FATAL Error - Mailing list pgsql-general

From Matt
Subject FATAL Error
Date
Msg-id 44D7BCD6.4010501@zeut.net
Whole thread Raw
Responses Re: FATAL Error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I'm getting the following error on PGSQL 8.0.8 server that I admin.  I
don't think this is a hardware problem but I'm not sure.  Anyway in the
logfile I'm constantly getting this:

ERROR:  xlog flush request 2/13CEA8AC is not satisfied --- flushed only
to 2/13634EE4
CONTEXT:  writing block 3421 of relation 1663/9533957/9534098
WARNING:  could not write block 3421 of 1663/9533957/9534098
DETAIL:  Multiple failures --- write error may be permanent.


psql -l fails with:
psql: FATAL:  xlog flush request 2/13CEA8AC is not satisfied --- flushed
only to 2/13634EE4
CONTEXT:  writing block 3421 of relation 1663/9533957/9534098

but I can connect using psql DBNAME


Any insight other than restore from your most recent backup?

Thanks,

Matt

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Practical maximums (was Re: PostgreSQL theoretical
Next
From: Steve Peterson
Date:
Subject: DROP TABLESPACE fails