Re: Duplicate values found when reindexing unique index

From: "Mason Hale" <masonhale(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Gregory Stark" <stark(at)enterprisedb(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Duplicate values found when reindexing unique index
Date: 2007-12-31 20:27:54
Message-ID: 8bca3aa10712311227k5b551b6cs6a9b17ee60609ef0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Dec 31, 2007 12:51 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "Mason Hale" <masonhale(at)gmail(dot)com> writes:
> > If it is some mysterious hardware or kernel error -- any suggestions for
> how
> > I should go about narrowing that down?
>
> The first thing to ask is whether you're running an up-to-date kernel
> (and whose is it).
>

The kernel is not up to date. What we have is:

Kernel: Linux 2.6.18-8.1.15.el5PAE
Distribution: RedHat EL 5.0-32

We can/will update the kernel at our next opportunity.

>
> > Finally, if it would help to see the full wal segment files, let me know
> and
> > I will email individually. (I assume the list doesn't want 32MB of
> > attachments).
>
> If you'd send them to me privately, I'd be interested.
>

I will send these to you right away.

Mason

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-12-31 22:16:19 Re: Duplicate values found when reindexing unique index
Previous Message Tom Lane 2007-12-31 18:51:41 Re: Duplicate values found when reindexing unique index