Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP

From: Lonni Friedman <netllama(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP
Date: 2004-05-05 17:35:43
Message-ID: 2A29446B.75F6C89F@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 05 May 2004 12:31:21 -0400, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Lonni Friedman <netllama(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-05-05 17:56:41 Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP
Previous Message Tom Lane 2004-05-05 17:30:19 Re: 7.4.2 Regression tests: test stats loops indefinately...