| From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
|---|---|
| To: | PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org> |
| Subject: | I/O error during autovacuum |
| Date: | 2010-04-22 20:09:14 |
| Message-ID: | 1271966954.2273.12.camel@hp-laptop2.gunduz.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Vanasco | 2010-04-22 21:10:28 | Re: trying to write a bit of logic as one query, can't seem to do it under 2 |
| Previous Message | Richard Huxton | 2010-04-22 19:55:11 | Re: PSQL segmentation fault after setting host |