Re: I/O error during autovacuum - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: I/O error during autovacuum
Date
Msg-id 20100422233016.GE3244@alvh.no-ip.org
Whole thread Raw
In response to I/O error during autovacuum  (Devrim GÜNDÜZ <devrim@gunduz.org>)
List pgsql-general
Devrim GÜNDÜZ wrote:
>
> I recently started seeing the following in the logs:
>
> ERROR:  could not read block 46 of relation
> pg_tblspc/16385/8578554/11521501: Input/output error
> CONTEXT:  automatic vacuum of table "foo.pg_toast.pg_toast_8578780"
>
> This is a Slony-I 1.2.21 slave, which runs 8.4.3 on RHEL 5.5.
>
> This toast relation is the toast of an index of one of the most
> frequently used tables.
>
> Is this *definitely* a disk error, or could it be related to PostgreSQL
> itself? I'm in the process of replacing disks, but I wanted to make
> sure.

The error comes straight from the kernel, so the problem is certainly
not in PostgreSQL.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error installing postgresql version higher than 8.1 on centos 5.4 linux 2.6.18-164.el5
Next
From: Martin Gainty
Date:
Subject: Re: Creating indexes?