Re: BUG #14983: ERROR: duplicate key value violates uniqueconstraint "oid_tbl_oid_key" - Mailing list pgsql-bugs

From Noah Misch
Subject Re: BUG #14983: ERROR: duplicate key value violates uniqueconstraint "oid_tbl_oid_key"
Date
Msg-id 20180109062115.GA3217003@rfd.leadboat.com
Whole thread Raw
In response to Re: BUG #14983: ERROR: duplicate key value violates uniqueconstraint "oid_tbl_oid_key"  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: BUG #14983: ERROR: duplicate key value violates uniqueconstraint "oid_tbl_oid_key"
List pgsql-bugs
On Tue, Jan 09, 2018 at 02:37:35PM +0900, Michael Paquier wrote:
> On Mon, Dec 18, 2017 at 03:36:18PM +0000, PG Bug reporting form wrote:
> > Errors appearing in logs:
> > 1) src/bin/pgbench/tmp_check/log/001_pgbench_main.log :
> >    2017-12-18 16:07:39.268 CET [12976136] t/001_pgbench.pl LOG:  execute
> > P0_0: INSERT INTO oid_tbl SELECT FROM generate_series(1,1000);
> >    2017-12-18 16:07:39.268 CET [13041676] t/001_pgbench.pl ERROR:  duplicate
> > key value violates unique constraint "oid_tbl_oid_key"
> >    2017-12-18 16:07:39.268 CET [13041676] t/001_pgbench.pl DETAIL:  Key
> > (oid)=(100291) already exists.
> >    2017-12-18 16:07:39.268 CET [13041676] t/001_pgbench.pl STATEMENT: 
> > INSERT INTO oid_tbl SELECT FROM generate_series(1,1000);
> >    2017-12-18 16:07:39.285 CET [12386468] t/001_pgbench.pl LOG:  execute
> > P0_0: INSERT INTO oid_tbl SELECT FROM generate_series(1,1000);
> 
> This comes from 001_pgbench.pl, which aims at testing LWLock and
> spinlock concurrency. This visibly points to something going wrong with
> what happens on AIX for XLC 13.

Known defect:
https://postgr.es/m/flat/a72cfcb0-37d0-de2f-b3ec-f38ad8d6a8cc@postgrespro.ru


pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #14983: ERROR: duplicate key value violates uniqueconstraint "oid_tbl_oid_key"
Next
From: Michael Paquier
Date:
Subject: Re: BUG #14983: ERROR: duplicate key value violates uniqueconstraint "oid_tbl_oid_key"