Re: BUG #14983: ERROR: duplicate key value violates uniqueconstraint "oid_tbl_oid_key"

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