Re: [BUGS] Missing PRIMARY KEYs and duplicated rows - Mailing list pgsql-bugs

From Chris Pacejo
Subject Re: [BUGS] Missing PRIMARY KEYs and duplicated rows
Date
Msg-id CAC8iE5iXZauGLC3eBWKHHGSWFsP2W1BsRnP789AjaRFY2pGEdQ@mail.gmail.com
Whole thread Raw
In response to [BUGS] Missing PRIMARY KEYs and duplicated rows  (Chris Pacejo <cpacejo@clearskydata.com>)
List pgsql-bugs
On Apr 12, 2017 6:13 PM, "Mark Kirkwood" <mark.kirkwood@catalyst.net.nz> wrote:

I'd be inclined to suspect the hardware with weird behaviour like that (memory and disk errors in particular).


Me too, but how would that explain the observation that it's occurring only within one database (and on all tables within that database)? The only thing all tables within a database have in common on disk is that they reside in the same directory.

And the ctids of the duplicate rows indicate that they're allocated sequentially in the same page as the legitimate rows. (The tables are mostly all less than a dozen rows.) How could this be explained by disk corruption?

I suppose memory corruption is possible, but it still seems oddly specific.

pgsql-bugs by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: [BUGS] Missing PRIMARY KEYs and duplicated rows
Next
From: Mark Kirkwood
Date:
Subject: Re: [BUGS] Missing PRIMARY KEYs and duplicated rows