database corruption?

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?"

Responses

Browse pgsql-general by date

  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?