From: | "J(dot) Hondius" <jhondius(at)rem(dot)nl> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: Sequence problem in stresstest on 8.0-beta1 (windows) |
Date: | 2004-08-17 14:53:47 |
Message-ID: | 000001c4846a$024b8500$18884fc1@JOEK |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi Tom,
Ehr...
The problem must have been the heat...
I forgot to set the sequences to the right values after inserting the data.
This is something that is done automatically in our testprocedure, but in
this windows test i forgot.
Did it the right way now, the errors are history.
-- sigh --
BTW: We (and the sales guys) are absolutely delighted with the arrival of
the native windows version!
Greetings, Joek
-----Oorspronkelijk bericht-----
Van: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Verzonden: zaterdag 14 augustus 2004 2:13
Aan: J. Hondius
CC: pgsql-bugs(at)postgresql(dot)org
Onderwerp: Re: [BUGS] Sequence problem in stresstest on 8.0-beta1 (windows)
"J. Hondius" <jhondius(at)rem(dot)nl> writes:
> These statements:
> insert into "tbverantwoording" ("dnkeyaanstelling", "dnjaarweek",
> "dnkeyactiviteitenschema") values (27, 200343, 1781); insert into
> "tbverantwoording" ("dnkeyaanstelling", "dnjaarweek",
> "dnkeyactiviteitenschema") values (27, 200343, 1780);
> Reported these errors:
> psql:sqlfiles/0.sql:241: ERROR: duplicate key violates unique
> constraint "pk_tbverantw"
> psql:sqlfiles/0.sql:223: ERROR: duplicate key violates unique
> constraint "pk_tbverantw"
> BUT ONLY DURING HIGH LOAD, 717 errors where reported, for 2000
> inserts.
I couldn't replicate any problem. I put 5000 copies of those two statements
into a file and set up half a dozen psql sessions concurrently reading the
file. No errors.
If you can provide a complete, reproducible test case, I'll be glad to look
at it, but there's not enough information here to do anything ...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-08-17 15:09:58 | Re: BUG #1220: "alter table rename to" inside a transaction violates ACID ordering |
Previous Message | PostgreSQL Bugs List | 2004-08-17 14:14:09 | BUG #1220: "alter table rename to" inside a transaction violates ACID ordering |