Re: I/O error during autovacuum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
Cc: PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: I/O error during autovacuum
Date: 2010-04-22 22:47:33
Message-ID: 22757.1271976453@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim(at)gunduz(dot)org> writes:
> 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"

> Is this *definitely* a disk error, or could it be related to PostgreSQL
> itself?

"Input/output error" is pretty much always indicative of a hardware
problem. If it's always associated with attempts to access a specific
disk block then it's definitely a bad-sector error. There might be more
details in the kernel log.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-04-22 22:56:17 Re: Error installing postgresql version higher than 8.1 on centos 5.4 linux 2.6.18-164.el5
Previous Message Szymon Guz 2010-04-22 22:32:43 Re: Foreign Key