Postgres Pro
Downloads
Home   >   mailing lists

Thread: Invalid page in block on autovacuum

Invalid page in block on autovacuum

From
"Burgess, Freddie"
Date:
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/P=
G_9.3_201306121/16444/125126685
20296____CONTEXT: automatic vacuum of table sensordb.public.doti_domain_y20=
06m12  <-- 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_1251=
18423

...
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_nod=
e_y2012m10        <-- partition table doti_source_node

Is this cause for alarm?

I  can still select rows from these tables.

Thanks

Re: Invalid page in block on autovacuum

From
Michael Paquier
Date:
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