From 311bcfc6b3acdd6fd152798c7f287ddf74fa2a98 Mon Sep 17 00:00:00 2001
From: Daniel Baumann <daniel.baumann@progress-linux.org>
Date: Tue, 16 Apr 2024 21:46:48 +0200
Subject: Adding upstream version 15.4.

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
---
 .../isolation/expected/lock-committed-update.out   | 931 +++++++++++++++++++++
 1 file changed, 931 insertions(+)
 create mode 100644 src/test/isolation/expected/lock-committed-update.out

(limited to 'src/test/isolation/expected/lock-committed-update.out')

diff --git a/src/test/isolation/expected/lock-committed-update.out b/src/test/isolation/expected/lock-committed-update.out
new file mode 100644
index 0000000..84b9ce7
--- /dev/null
+++ b/src/test/isolation/expected/lock-committed-update.out
@@ -0,0 +1,931 @@
+Parsed test spec with 2 sessions
+
+starting permutation: s1b s2b1 s1l s2l s1u s1c s1ul s2c
+step s1b: BEGIN;
+step s2b1: BEGIN ISOLATION LEVEL READ COMMITTED;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1c: COMMIT;
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b1 s1l s1u s2l s1c s1ul s2c
+step s1b: BEGIN;
+step s2b1: BEGIN ISOLATION LEVEL READ COMMITTED;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1c: COMMIT;
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b1 s1l s2l s1ul s1u s1c s2c
+step s1b: BEGIN;
+step s2b1: BEGIN ISOLATION LEVEL READ COMMITTED;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1c: COMMIT;
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b1 s1l s1u s1ul s2l s1c s2c
+step s1b: BEGIN;
+step s2b1: BEGIN ISOLATION LEVEL READ COMMITTED;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE;
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s1c: COMMIT;
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b1 s1l s2l s1u s1c s1hint s1ul s2c
+step s1b: BEGIN;
+step s2b1: BEGIN ISOLATION LEVEL READ COMMITTED;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1c: COMMIT;
+step s1hint: SELECT * FROM lcu_table;
+id|value
+--+-----
+ 1|two  
+(1 row)
+
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b1 s1l s1u s2l s1c s1hint s1ul s2c
+step s1b: BEGIN;
+step s2b1: BEGIN ISOLATION LEVEL READ COMMITTED;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1c: COMMIT;
+step s1hint: SELECT * FROM lcu_table;
+id|value
+--+-----
+ 1|two  
+(1 row)
+
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b1 s1l s2l s1ul s1u s1c s1hint s2c
+step s1b: BEGIN;
+step s2b1: BEGIN ISOLATION LEVEL READ COMMITTED;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1c: COMMIT;
+step s1hint: SELECT * FROM lcu_table;
+id|value
+--+-----
+ 1|two  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b1 s1l s1u s1ul s2l s1c s1hint s2c
+step s1b: BEGIN;
+step s2b1: BEGIN ISOLATION LEVEL READ COMMITTED;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE;
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s1c: COMMIT;
+step s1hint: SELECT * FROM lcu_table;
+id|value
+--+-----
+ 1|two  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b2 s1l s2l s1u s1c s1ul s2c
+step s1b: BEGIN;
+step s2b2: BEGIN ISOLATION LEVEL REPEATABLE READ;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1c: COMMIT;
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b2 s1l s1u s2l s1c s1ul s2c
+step s1b: BEGIN;
+step s2b2: BEGIN ISOLATION LEVEL REPEATABLE READ;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1c: COMMIT;
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b2 s1l s2l s1ul s1u s1c s2c
+step s1b: BEGIN;
+step s2b2: BEGIN ISOLATION LEVEL REPEATABLE READ;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1c: COMMIT;
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b2 s1l s1u s1ul s2l s1c s2c
+step s1b: BEGIN;
+step s2b2: BEGIN ISOLATION LEVEL REPEATABLE READ;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE;
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s1c: COMMIT;
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b2 s1l s2l s1u s1c s1hint s1ul s2c
+step s1b: BEGIN;
+step s2b2: BEGIN ISOLATION LEVEL REPEATABLE READ;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1c: COMMIT;
+step s1hint: SELECT * FROM lcu_table;
+id|value
+--+-----
+ 1|two  
+(1 row)
+
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b2 s1l s1u s2l s1c s1hint s1ul s2c
+step s1b: BEGIN;
+step s2b2: BEGIN ISOLATION LEVEL REPEATABLE READ;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1c: COMMIT;
+step s1hint: SELECT * FROM lcu_table;
+id|value
+--+-----
+ 1|two  
+(1 row)
+
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b2 s1l s2l s1ul s1u s1c s1hint s2c
+step s1b: BEGIN;
+step s2b2: BEGIN ISOLATION LEVEL REPEATABLE READ;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1c: COMMIT;
+step s1hint: SELECT * FROM lcu_table;
+id|value
+--+-----
+ 1|two  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b2 s1l s1u s1ul s2l s1c s1hint s2c
+step s1b: BEGIN;
+step s2b2: BEGIN ISOLATION LEVEL REPEATABLE READ;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE;
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s1c: COMMIT;
+step s1hint: SELECT * FROM lcu_table;
+id|value
+--+-----
+ 1|two  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b3 s1l s2l s1u s1c s1ul s2c
+step s1b: BEGIN;
+step s2b3: BEGIN ISOLATION LEVEL SERIALIZABLE;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1c: COMMIT;
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b3 s1l s1u s2l s1c s1ul s2c
+step s1b: BEGIN;
+step s2b3: BEGIN ISOLATION LEVEL SERIALIZABLE;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1c: COMMIT;
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b3 s1l s2l s1ul s1u s1c s2c
+step s1b: BEGIN;
+step s2b3: BEGIN ISOLATION LEVEL SERIALIZABLE;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1c: COMMIT;
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b3 s1l s1u s1ul s2l s1c s2c
+step s1b: BEGIN;
+step s2b3: BEGIN ISOLATION LEVEL SERIALIZABLE;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE;
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s1c: COMMIT;
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b3 s1l s2l s1u s1c s1hint s1ul s2c
+step s1b: BEGIN;
+step s2b3: BEGIN ISOLATION LEVEL SERIALIZABLE;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1c: COMMIT;
+step s1hint: SELECT * FROM lcu_table;
+id|value
+--+-----
+ 1|two  
+(1 row)
+
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b3 s1l s1u s2l s1c s1hint s1ul s2c
+step s1b: BEGIN;
+step s2b3: BEGIN ISOLATION LEVEL SERIALIZABLE;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1c: COMMIT;
+step s1hint: SELECT * FROM lcu_table;
+id|value
+--+-----
+ 1|two  
+(1 row)
+
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b3 s1l s2l s1ul s1u s1c s1hint s2c
+step s1b: BEGIN;
+step s2b3: BEGIN ISOLATION LEVEL SERIALIZABLE;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE; <waiting ...>
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: <... completed>
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1c: COMMIT;
+step s1hint: SELECT * FROM lcu_table;
+id|value
+--+-----
+ 1|two  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+
+starting permutation: s1b s2b3 s1l s1u s1ul s2l s1c s1hint s2c
+step s1b: BEGIN;
+step s2b3: BEGIN ISOLATION LEVEL SERIALIZABLE;
+step s1l: SELECT pg_advisory_lock(380170116);
+pg_advisory_lock
+----------------
+                
+(1 row)
+
+step s1u: UPDATE lcu_table SET value = 'two' WHERE id = 1;
+step s1ul: SELECT pg_advisory_unlock(380170116);
+pg_advisory_unlock
+------------------
+t                 
+(1 row)
+
+step s2l: SELECT * FROM lcu_table WHERE pg_advisory_lock(380170116) IS NOT NULL FOR KEY SHARE;
+id|value
+--+-----
+ 1|one  
+(1 row)
+
+step s1c: COMMIT;
+step s1hint: SELECT * FROM lcu_table;
+id|value
+--+-----
+ 1|two  
+(1 row)
+
+step s2c: COMMIT;
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
+pg_advisory_unlock_all
+----------------------
+                      
+(1 row)
+
-- 
cgit v1.2.3