Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] database corruption?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Chris Jones <cjones(at)rightnowtech(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] database corruption?
Date: 2000-03-07 23:11:19
Message-ID: 200003072311.SAA27246@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
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

In response to

pgsql-general by date

Next:From: Bruce MomjianDate: 2000-03-07 23:51:10
Subject: Re: [GENERAL] binary data & LOBs
Previous:From: Ron PetersonDate: 2000-03-07 22:33:30
Subject: International Address Format Standard

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group