summaryrefslogtreecommitdiffstats
path: root/src/test/isolation/expected/nowait-5.out
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--src/test/isolation/expected/nowait-5.out43
1 files changed, 43 insertions, 0 deletions
diff --git a/src/test/isolation/expected/nowait-5.out b/src/test/isolation/expected/nowait-5.out
new file mode 100644
index 0000000..f1aae21
--- /dev/null
+++ b/src/test/isolation/expected/nowait-5.out
@@ -0,0 +1,43 @@
+Parsed test spec with 3 sessions
+
+starting permutation: sl1_prep upd_getlock sl1_exec upd_doupdate lk1_doforshare upd_releaselock
+step sl1_prep:
+ PREPARE sl1_run AS SELECT id FROM test_nowait WHERE pg_advisory_lock(0) is not null FOR UPDATE NOWAIT;
+
+step upd_getlock:
+ SELECT pg_advisory_lock(0);
+
+pg_advisory_lock
+----------------
+
+(1 row)
+
+step sl1_exec:
+ BEGIN ISOLATION LEVEL READ COMMITTED;
+ EXECUTE sl1_run;
+ SELECT xmin, xmax, ctid, * FROM test_nowait;
+ <waiting ...>
+step upd_doupdate:
+ BEGIN ISOLATION LEVEL READ COMMITTED;
+ UPDATE test_nowait SET value = value WHERE id % 2 = 0;
+ COMMIT;
+
+step lk1_doforshare:
+ BEGIN ISOLATION LEVEL READ COMMITTED;
+ SELECT id FROM test_nowait WHERE id % 2 = 0 FOR SHARE;
+
+id
+--
+ 2
+(1 row)
+
+step upd_releaselock:
+ SELECT pg_advisory_unlock(0);
+
+pg_advisory_unlock
+------------------
+t
+(1 row)
+
+step sl1_exec: <... completed>
+ERROR: could not obtain lock on row in relation "test_nowait"