Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[BUGS] Invalid page in block on autovacuum

22 views
Skip to first unread message

Burgess, Freddie

unread,
Nov 6, 2014, 6:37:55 PM11/6/14
to
Logged by:          Freddie Burgess
Email address:     fbur...@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


Michael Paquier

unread,
Nov 6, 2014, 9:07:01 PM11/6/14
to
On Fri, Nov 7, 2014 at 8:37 AM, Burgess, Freddie
<FBur...@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...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

0 new messages