Re: corruption since 7.4.13 update ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: FM <dist-list(at)LEXUM(dot)UMontreal(dot)CA>
Cc: Mailing List Postgres-Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: corruption since 7.4.13 update ?
Date: 2006-07-14 00:40:10
Message-ID: 23854.1152837610@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

FM <dist-list(at)LEXUM(dot)UMontreal(dot)CA> writes:
> I'e got a very strange (scary) problem.

> ERROR: could not read block 81235 of relation "pg_largeobject":
> Input/output error

This one is very strongly indicative of a disk hardware problem.
The others look like they could be consequences of catalog corruption
ensuing from a flaky disk.

If I were you I'd run some hardware diagnostics. Also see if you can
pg_dump ...

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Krajmalnik 2006-07-14 01:02:14 Table size growing for no reason
Previous Message Benjamin Krajmalnik 2006-07-14 00:01:34 Determining object name from filenode