Re: [GENERAL] database corruption?

Drop index and recreate.

> Hi, all.
>
> I'm relatively new to PostgreSQL, but I've been quite impressed with
> it so far. This may be due to too much experience with MySQL. :)
>
> I'm currently getting this error on my nightly vacuum. These two
> indices (as you may have guessed already) are on columns named
> interface and ewhen, on a table named error. The error table is
> constantly being updated. (No comments about the implications of
> that, please.)
>
> NOTICE: Index error_interface_idx: NUMBER OF INDEX' TUPLES (226766) IS NOT THE SAME AS HEAP' (226765)
> NOTICE: Index error_ewhen_idx: NUMBER OF INDEX' TUPLES (226766) IS NOT THE SAME AS HEAP' (226765)
> NOTICE: Index error_interface_idx: NUMBER OF INDEX' TUPLES (226766) IS NOT THE SAME AS HEAP' (226765)
> NOTICE: Index error_ewhen_idx: NUMBER OF INDEX' TUPLES (226766) IS NOT THE SAME AS HEAP' (226765)
>
> Is this indicative of a serious problem? If this were MySQL, I'd
> assume I had a corrupt table, and I'd run isamchk on it. But I don't
> see a similar utility for PgSQL.
>
> AFAIK, nothing really bad has happened to the host; it hasn't crashed
> or anything, though it was rebooted ungracefully a few weeks ago.
>
> This is on an i386 running NetBSD 1.4.1, if that makes a difference.
>
> TIA for any help.
>
> Chris
>
> --
> ---------------------------------------------------- cjones(at)rightnowtech(dot)com
> Chris Jones
> System Administrator, Right Now Technologies, Inc.
> "Is this going to be a stand-up programming session, sir, or another bug hunt?"
>
> ************
>
>

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026