From: | Noah Misch <noah(at)leadboat(dot)com> |
---|---|
To: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
Cc: | tony(dot)reix(at)atos(dot)net, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #14983: ERROR: duplicate key value violates unique constraint "oid_tbl_oid_key" |
Date: | 2018-01-09 06:21:15 |
Message-ID: | 20180109062115.GA3217003@rfd.leadboat.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgrespro(dot)ru
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2018-01-09 06:31:04 | Re: BUG #14983: ERROR: duplicate key value violates unique constraint "oid_tbl_oid_key" |
Previous Message | Michael Paquier | 2018-01-09 05:37:35 | Re: BUG #14983: ERROR: duplicate key value violates unique constraint "oid_tbl_oid_key" |