Postgres Pro
Downloads
Home   >   mailing lists

Re: error on vacuum - could not read block - Mailing list pgsql-general

From Alan Hodgson
Subject Re: error on vacuum - could not read block
Date
Msg-id 200811131429.03854@hal.medialogik.com
Whole thread Raw
In response to error on vacuum - could not read block  (glok_twen <glok_twen@yahoo.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: "Phoenix Kiula"
Date:
Subject: Fwd: Tweaking PG (again)
Next
From: "Dan Armbrust"
Date:
Subject: vacuum output question