Re: BUG #13984: Multiple rows with the same primary key value exist.

From: "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #13984: Multiple rows with the same primary key value exist.
Date: 2016-03-02 01:52:44
Message-ID: 0A3221C70F24FB45833433255569204D1F52A061@G01JPEXMBYT05
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The cause has turned out to be a bad operation of the customer. He removed postmaster.pid after doing 'kill -SIGKILL' against postmaster, and started a new instance. As a consequence, two different server instances wrote different heap pages to the data file, producing multiple rows with the same primary key value.

Thanks for any investigation.

Regards
Takayuki Tsunakawa

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Premsun Choltanwanich 2016-03-02 02:04:10 Re: could not migrate 8.0.13 database with large object data to 9.5.1
Previous Message Vitaly Burovoy 2016-03-01 13:31:09 Re: Bug or incorrect usage?