Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP - Mailing list pgsql-general

From Lonni Friedman
Subject Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP
Date
Msg-id 2A29446B.75F6C89F@mail.gmail.com
Whole thread Raw
In response to Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT
List pgsql-general
On Wed, 05 May 2004 12:31:21 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Lonni Friedman <netllama@gmail.com> writes:
> > Unfortunately, i have no clue how to replicate this.  It was happening
> > fairly consistantly before i upgraded from 7.3.3 to 7.3.4 (like nearly
> > every vacuumdb run).
>
> > Then nothing for a month after going to 7.3.4, and now its happening
> > every vacuumdb run again.
>
> Once the complaint starts appearing, I'd expect it to continue until you
> reindex the index.

That's exactly what happens.  It consistantly errors until reindexed.
Any suggestions?  thanks.

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Load Balancing and Backup
Next
From: Tom Lane
Date:
Subject: Re: 7.4.2 Regression tests: test stats loops indefinately...