Обсуждение: database corruption?
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?"
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
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