From: | Chris Pacejo <cpacejo(at)clearskydata(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Missing PRIMARY KEYs and duplicated rows |
Date: | 2017-04-12 20:46:17 |
Message-ID: | CAC8iE5ieb5tnFUnkO9L81sNQbg3F5MAUnv5b8GNoN+Se61ZA2g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi all, we're encountering a very strange issue lately on a 9.4.5 server.
We recently performed a dump & restore of the entire cluster to
migrate to a new server. All but one of the databases seem fine.
That one is encountering a very strange issue.
It seems that periodically, the primary keys (and underlying indexes)
of all tables in the database disappear, and every row in each table
gets duplicated. This appears to occur at the storage level, as the
duplicated rows get their own ctids (so it's not just a query
artifact). I've seen this happen twice in the past week.
I can delete the duplicate rows (by their ctid). In the first
instance, I was unable to re-add the primary key, as it had reappeared
by the time I issued the statement. In the most recent instance, I
did re-add the primary key to a table, and the other primary keys have
not yet re-appeared.
All indexes are b-tree indexes. They were not created using
CONCURRENTLY. They are in the default tablespace. The installation
is on an Intel CentOS machine using the PGDG RPMs. I've checked the
release notes for all 9.4 bugfixes and do not see anything which could
relate to this issue.
Any insight into this issue? We will probably just drop and recreate
the database from the recent dump, as it is on a production server and
we'd rather not take chances tinkering around with it. But it would
be nice to know why/how we've encountered this to ensure it won't
happen again, because frankly it's quite a scary issue.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2017-04-12 20:55:59 | Re: Missing PRIMARY KEYs and duplicated rows |
Previous Message | Lara Schembri | 2017-04-12 14:23:28 | Re: BUG #14621: ERROR: compressed data is corrupt |