FATAL Error

Поиск
Список
Период
Сортировка
От Matt
Тема FATAL Error
Дата
Msg-id 44D7BCD6.4010501@zeut.net
обсуждение исходный текст
Ответы Re: FATAL Error  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Practical maximums (was Re: PostgreSQL theoretical
Следующее
От: Steve Peterson
Дата:
Сообщение: DROP TABLESPACE fails