8000 Add alternative output for ON CONFLICT toast isolation test. · linearregression/postgres@9595383 · GitHub
[go: up one dir, main page]

Skip to content

Commit 9595383

Browse files
committed
Add alternative output for ON CONFLICT toast isolation test.
On some buildfarm animals the isolationtest added in 07ef035 failed, as the order in which processes are run after unlocking is not guaranteed. Add an alternative output for that. Discussion: <7969.1471484738@sss.pgh.pa.us> Backpatch: 9.6, like the test in the aforementioned commit
1 parent 1d2e73a commit 9595383

File tree

1 file changed

+15
-0
lines changed

1 file changed

+15
-0
lines changed
Lines changed: 15 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,15 @@
1+
Parsed test spec with 3 sessions
2+
3+
starting permutation: s2insert s3insert s1commit
4+
pg_advisory_xact_lock
5+
6 7181 +
7+
step s2insert:
8+
INSERT INTO ctoast (key, val) VALUES (1, ctoast_large_val()) ON CONFLICT DO NOTHING;
9+
<waiting ...>
10+
step s3insert:
11+
INSERT INTO ctoast (key, val) VALUES (1, ctoast_large_val()) ON CONFLICT DO NOTHING;
12+
<waiting ...>
13+
step s1commit: COMMIT;
14+
step s3insert: <... completed>
15+
step s2insert: <... completed>

0 commit comments

Comments
 (0)
0