| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| 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 23:30:16 |
| Message-ID: | 20100422233016.GE3244@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Gainty | 2010-04-22 23:44:00 | Re: Creating indexes? |
| Previous 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 |