Re: [HACKERS] major flaw in 6.5beta1??? (UPDATE/INSERT waiting)

Dirk Lutzebaeck writes:> Tom Lane writes:>  > Dirk Lutzebaeck <lutzeb@aeccom.com> writes:>  > > cs=> select envelope
fromrecipient where envelope=510349;>  > > [ returns a tuple that obviously fails the WHERE condition ]>  > >  > Yipes.
Do you have an index on the envelope field, and if so is>  > it being used for this query?  (Use EXPLAIN to check.)  My
guess> > is that the index is corrupted.  Dropping and recreating the index>  > would probably set things right.> >
Yes,thanks, recreating the index cures the problem.
 

Here is some more info: the automatic vacuum tonight gave the
following errors:

vacuum analyze;
NOTICE:  Index recipient_oid_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE:  Index recipient_addr_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE:  Index recipient_mem_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE:  Index recipient_env_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE:  Index recipient_oid_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE:  Index recipient_addr_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE:  Index recipient_mem_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE:  Index recipient_env_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
VACUUM