Error while vacuuming

From: Bhakti Ghatkar <bghatkar(at)zedo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Error while vacuuming
Date: 2011-11-04 12:14:21
Message-ID: CAJeA4QHVjPFvQP+Lg=mbTrFzsHRa9v+QwM1e_C-+6hSRG=-rAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi ,

While performing full vacuum we encountered the error below:

INFO: vacuuming "pg_catalog.pg_index"
vacuumdb: vacuuming of database "xxxx" failed: ERROR: duplicate key value
violates unique constraint "ccccc"
DETAIL: Key (indexrelid)=(2678) already exists.

We are using Postgres 9.0.1

Can you please help us out in understanding the cause of this error?

Regards,
Bhakti

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Guillaume Cottenceau 2011-11-04 13:21:53 Re: Error while vacuuming
Previous Message Albe Laurenz 2011-11-04 08:43:47 Re: SSL encryption makes bytea transfer slow