Invalid page in block on autovacuum
Logged by: Freddie Burgess
Email address: fburgess@radiantblue.com
PostgreSQL version: 9.3.4
Operating system: Red_hat Linux 6.4
Description:
Our production log recorded these Errors today
20296____ERROR: Invalid page in block 1225978 of relation pg_tblspc/16434/PG_9.3_201306121/16444/125126685
20296____CONTEXT: automatic vacuum of table sensordb.public.doti_domain_y2006m12 <-- partition table doti_domain
...
11051____ERROR: Invalid page in block 610813 of relation pg_tblspc/16442/PG_9.3_201306121/16444/125127325 <-- file 125127325 doesn't exist
11051____CONTEXT: automatic vacuum of table sensordb.pg_toast.pg_toast_125118423
...
11051____ERROR: Invalid page in block 447869 of relation pg_tblspc/16440/PG_9.3_201306121/16444/125128155
11051____CONTEXT: automatic vacuum of table sensordb.public.doti_source_node_y2012m10 <-- partition table doti_source_node
Is this cause for alarm?
I can still select rows from these tables.
Thanks
On Fri, Nov 7, 2014 at 8:37 AM, Burgess, Freddie
<FBurgess@radiantblue.com> wrote:
11051____ERROR: Invalid page in block 447869 of relation
pg_tblspc/16440/PG_9.3_201306121/16444/125128155
The data on this page is corrupted, this is usually a sign with
potential issues the hardware level...
--
Michael
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs