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

Поиск
Список
Период
Сортировка
От Noah Misch
Тема Re: BUG #14983: ERROR: duplicate key value violates uniqueconstraint "oid_tbl_oid_key"
Дата
Msg-id 20180109062115.GA3217003@rfd.leadboat.com
обсуждение исходный текст
Ответ на Re: BUG #14983: ERROR: duplicate key value violates uniqueconstraint "oid_tbl_oid_key"  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: BUG #14983: ERROR: duplicate key value violates uniqueconstraint "oid_tbl_oid_key"  (Michael Paquier <michael.paquier@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #14983: ERROR: duplicate key value violates uniqueconstraint "oid_tbl_oid_key"
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #14983: ERROR: duplicate key value violates uniqueconstraint "oid_tbl_oid_key"