From: | Chris Jones <cjones(at)rightnowtech(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | database corruption? |
Date: | 2000-03-03 16:38:28 |
Message-ID: | x6d7pc80vv.fsf@reddwarf.rightnowtech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?"
From | Date | Subject | |
---|---|---|---|
Next Message | kaiq | 2000-03-03 17:42:07 | PG is great and m$sucks |
Previous Message | Steve Wolfe | 2000-03-03 16:22:27 | Re: [GENERAL] Simple problem? |