1Parsed test spec with 2 sessions
2
3starting permutation: s2a s1a s2b s2c s2d s2e s1b s2f
4step s2a: SELECT pg_advisory_lock(0);
5pg_advisory_lock
6----------------
7
8(1 row)
9
10step s1a: SELECT * FROM foo WHERE pg_advisory_lock(0) IS NOT NULL ORDER BY id LIMIT 1 FOR UPDATE SKIP LOCKED; <waiting ...>
11step s2b: UPDATE foo SET data = data WHERE id = 1;
12step s2c: BEGIN;
13step s2d: UPDATE foo SET data = data WHERE id = 1;
14step s2e: SELECT pg_advisory_unlock(0);
15pg_advisory_unlock
16------------------
17t
18(1 row)
19
20step s1a: <... completed>
21ERROR:  could not serialize access due to concurrent update
22step s1b: COMMIT;
23step s2f: COMMIT;
24