Postgres Pro
Downloads
Home   >   mailing lists

Thread: database corruption?

database corruption?

From
Chris Jones
Date:
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@rightnowtech.com
Chris Jones
           System Administrator, Right Now Technologies, Inc.
"Is this going to be a stand-up programming session, sir, or another bug hunt?"

Re: [GENERAL] database corruption?

From
Ed Loehr
Date:
Chris Jones wrote:
>
> 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)

Hope this was not already answered...

I believe it means that the indices "error_interface_idx" and
error_ewhen_idx" have become corrupted.  The fix is to drop and
rebuild them.

Cheers,
Ed Loehr

Re: [GENERAL] database corruption?

From
Bruce Momjian
Date:
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@rightnowtech.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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026