Forum OpenACS Q&A: index error on vacuum analyze

Collapse
1: index error on vacuum analyze
Posted by Rocael Hernández Rizzardini on 05/09/01 08:52 PM 
Hi all,
I did this in my production service:
vacuum analyze
and I got this error:
ERROR:  cannot read block 4 of users_by_last_visit

what is happening?
what should I do?
drop the index and the create it again?

I'm using postgres 7.02 in RH6.2

Thanks
Collapse
2: Response to index error on vacuum analyze (response to 1)
Posted by Don Baccus on 05/10/01 12:40 AM
Do a pg_dump first then drop the index and create it.

When PG 7.1.2 comes out next week, I suggest you give our community a
few days to thrash it, and if it survives our datamodels and queries
UPGRADE YOUR SITE ASAP.

There have been some nasty vacuum bugs fixed since PG 7.0.2.  Some, at
least, made it into PG 7.0.3 but there are many other reasons to
upgrade straight to PG 7.1.2 as soon as you can.