From: | bobby(dot)rullo(at)coreos(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #13524: Not Getting expected Serialization error |
Date: | 2015-07-28 20:45:30 |
Message-ID: | 20150728204530.25042.78768@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 13524
Logged by: Robert Rullo
Email address: bobby(dot)rullo(at)coreos(dot)com
PostgreSQL version: 9.4.1
Operating system: Mac OS X
Description:
Because this requires concurrent transactions, we will consider two
different sequences of SQL statements, each to be executed in PSQL against
the same database.
Sequence 1:
=========
drop table if exists "t1";
create table if not exists "t1" ("id" text not null primary key, "name"
text, "email" text) ;
begin;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
select count(*) from "t1" where email = 'bill(at)example(dot)com';
insert into "t1" ("id","name","email") values
('1','bill','bill(at)example(dot)com');
-- EXECUTE sequence1.txt HERE
commit;
Sequence 2:
==========
begin;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
--select count(*) from "t1" where email = 'bill(at)example(dot)com'; --UNCOMMENT
ME LATER
insert into "t1" ("id","name","email") values
('2','william','bill(at)example(dot)com');
commit;
To reproduce:
1) execute statements in sequence 1 on a connection, stopping at the
"--EXECUTE" statement.
2) In another connection, execute all the statements in Sequence 2.
3) Back in the first connection execute the remaining statement (the
"commit;")
Expected:
error when trying to commit, eg. "ERROR: could not serialize"
Actual:
Both commits succeed.
Interesting tidbit:
If you do the exact steps as above but uncomment the "select count(*)" in
sequence 2, you get the expected error.
From | Date | Subject | |
---|---|---|---|
Next Message | Niall Ross | 2015-07-28 21:34:12 | Re: BUG #13518: CancelRequest lacks statement identifier |
Previous Message | Andres Freund | 2015-07-28 20:06:13 | Re: BUG #13518: CancelRequest lacks statement identifier |