Re: error on vacuum - could not read block

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: error on vacuum - could not read block
Дата
Msg-id 200811131429.03854@hal.medialogik.com
обсуждение исходный текст
Ответ на error on vacuum - could not read block  (glok_twen <glok_twen@yahoo.com>)
Список pgsql-general
On Thursday 13 November 2008, "glok_twen" <glok_twen@yahoo.com> wrote:
> INFO:  vacuuming "public.monthly_res_01"
>
> ERROR:  could not read block 43775860 of relation 1663/11511/24873: read
> only 4096 of 8192 bytes
>
> ERROR:  could not read block 43775860 of relation 1663/11511/24873: read
> only 4096 of 8192 bytes
>
> do you know the process i should follow to diagnose and repair?

You have an underlying hardware issue that needs to be repaired. Then you'll
probably need to recover at least this table from a backup.


--
Alan

В списке pgsql-general по дате отправления:

Предыдущее
От: "Phoenix Kiula"
Дата:
Сообщение: Fwd: Tweaking PG (again)
Следующее
От: "Dan Armbrust"
Дата:
Сообщение: vacuum output question