"Could not read block" during vacuum

Started by Jack Orensteinalmost 21 years ago2 messagesgeneral
Jump to latest
#1Jack Orenstein
jao@geophile.com

My company's product is developing a product using postgres 7.4.6 on a
Linux 2.6.10 or 11 kernel, (don't have the exact version handy). We
do "vacuum verbose analyze" daily. Two days after the database was
created and loaded with a small amount of data (megabytes), the
postgres logs had this line:

2005-04-16 00:00:53 ERROR: could not read block 52 of
relation "idx_ef_hash": Input/output error

idx_ef_hash is an index. I believe that vacuuming is to blame based on
vacuum output:

04/16 00:00:14.388 03136277 Starting daily vacuum
04/16 00:00:53.192 03136280 process failed with exit code 1.
04/16 00:00:53.193 03136281 stderr: INFO: vacuuming
"information_schema.sql_features"
04/16 00:00:53.193 03136282 stderr: INFO: "sql_features": found 0
removable, 360 nonremovable row versions in 5 pages
04/16 00:00:53.193 03136283 stderr: DETAIL: 0 dead row versions cannot be
removed yet.
04/16 00:00:53.193 03136284 stderr: There were 0 unused item pointers.
04/16 00:00:53.193 03136285 stderr: 0 pages are entirely empty.
04/16 00:00:53.193 03136286 stderr: CPU 0.00s/0.00u sec elapsed 0.00 sec.
04/16 00:00:53.193 03136287 stderr: INFO: vacuuming
"pg_toast.pg_toast_17070"
...

(The first two lines are from my application, the rest is stderr from
the vacuum process.)

Googling didn't turn up useful information on this problem. Can anyone
tell me whether this error indicates a disk problem, OS problem, known
postgres bug, or something else? We've only seen this occur once.

Jack Orenstein

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Jack Orenstein (#1)
Re: "Could not read block" during vacuum

jao@geophile.com writes:

2005-04-16 00:00:53 ERROR: could not read block 52 of
relation "idx_ef_hash": Input/output error

Googling didn't turn up useful information on this problem. Can anyone
tell me whether this error indicates a disk problem, OS problem, known
postgres bug, or something else? We've only seen this occur once.

Hardware problem ... probably the disk, but could be disk interface.

regards, tom lane