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

Re: Duplicate values found when reindexing unique index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mason Hale" <masonhale(at)gmail(dot)com>
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 23:35:26
Message-ID: 10641.1199144126@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Mason Hale" <masonhale(at)gmail(dot)com> writes:
>> This could be the kernel's fault, but I'm wondering whether the
>> RAID controller is going south.

> To clarify a bit further -- on the production server, the data is written to
> a 10-disk RAID 1+0, but the pg_xlog directory is symlinked to a separate,
> dedicated SATA II disk.

> There is a similar setup on the standby server, except that in addition to
> the RAID for the data, and a separate SATA II disk for the pg_xlog, there is
> another disk (also SATA II) dedicated for the archive of wal files copied
> over from the production server.

Oh.  Maybe it's one of those disks' fault then.  Although WAL corruption
would not lead to corruption of the primary DB as long as there were no
crash/replay events.  Maybe there is more than one issue here, or maybe
it's the kernel's fault after all.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Mark ReidDate: 2007-12-31 23:42:19
Subject: BUG #3847: plpython trigger caches table structure - doesn't see new / changed columns
Previous:From: Mason HaleDate: 2007-12-31 22:51:02
Subject: Re: Duplicate values found when reindexing unique index

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