diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/read-write-unique-3.out /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/read-write-unique-3.out --- /tmp/cirrus-ci-build/src/test/isolation/expected/read-write-unique-3.out 2024-03-21 16:29:26.429951000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/read-write-unique-3.out 2024-03-21 16:31:16.475305000 +0000 @@ -1,12 +1,14 @@ Parsed test spec with 2 sessions starting permutation: rw1 rw2 c1 c2 +s1: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step rw1: SELECT insert_unique(1, '1'); insert_unique ------------- (1 row) +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step rw2: SELECT insert_unique(1, '2'); step c1: COMMIT; step rw2: <... completed> diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/update-conflict-out.out /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/update-conflict-out.out --- /tmp/cirrus-ci-build/src/test/isolation/expected/update-conflict-out.out 2024-03-21 16:29:26.430717000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/update-conflict-out.out 2024-03-21 16:31:28.482559000 +0000 @@ -6,7 +6,9 @@ --+--- (0 rows) +bar: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step bar_insert: INSERT INTO txn0 SELECT 42, 'bar_insert'; +foo: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step foo_insert: INSERT INTO txn1 SELECT 7, 'foo_insert'; step foo_commit: COMMIT; step trouble_update: UPDATE txn1 SET val = 'add physical version for "bar_select"' WHERE id = 7; @@ -21,7 +23,9 @@ --+--- (0 rows) +bar: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step bar_insert: INSERT INTO txn0 SELECT 42, 'bar_insert'; +foo: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step foo_insert: INSERT INTO txn1 SELECT 7, 'foo_insert'; step foo_commit: COMMIT; step trouble_delete: DELETE FROM txn1 WHERE id = 7; diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/detach-partition-concurrently-2.out /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/detach-partition-concurrently-2.out --- /tmp/cirrus-ci-build/src/test/isolation/expected/detach-partition-concurrently-2.out 2024-03-21 16:29:26.428560000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/detach-partition-concurrently-2.out 2024-03-21 16:31:31.722300000 +0000 @@ -9,6 +9,7 @@ 2 (2 rows) +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2d: ALTER TABLE d_lp_fk DETACH PARTITION d_lp_fk_1 CONCURRENTLY; step s3i1: INSERT INTO d_lp_fk_r VALUES (1); ERROR: insert or update on table "d_lp_fk_r" violates foreign key constraint "d_lp_fk_r_a_fkey" @@ -24,6 +25,7 @@ 2 (2 rows) +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2d: ALTER TABLE d_lp_fk DETACH PARTITION d_lp_fk_1 CONCURRENTLY; step s3i2: INSERT INTO d_lp_fk_r VALUES (2); step s3i2: INSERT INTO d_lp_fk_r VALUES (2); @@ -40,6 +42,7 @@ (2 rows) step s3i1: INSERT INTO d_lp_fk_r VALUES (1); +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2d: ALTER TABLE d_lp_fk DETACH PARTITION d_lp_fk_1 CONCURRENTLY; ERROR: removing partition "d_lp_fk_1" violates foreign key constraint "d_lp_fk_r_a_fkey1" step s1c: COMMIT; @@ -54,6 +57,7 @@ (2 rows) step s3i2: INSERT INTO d_lp_fk_r VALUES (2); +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2d: ALTER TABLE d_lp_fk DETACH PARTITION d_lp_fk_1 CONCURRENTLY; step s1c: COMMIT; step s2d: <... completed> @@ -68,6 +72,7 @@ (2 rows) step s3b: BEGIN; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2d: ALTER TABLE d_lp_fk DETACH PARTITION d_lp_fk_1 CONCURRENTLY; step s3i1: INSERT INTO d_lp_fk_r VALUES (1); ERROR: insert or update on table "d_lp_fk_r" violates foreign key constraint "d_lp_fk_r_a_fkey" diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/detach-partition-concurrently-3.out /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/detach-partition-concurrently-3.out --- /tmp/cirrus-ci-build/src/test/isolation/expected/detach-partition-concurrently-3.out 2024-03-21 16:29:26.428576000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/detach-partition-concurrently-3.out 2024-03-21 16:31:32.832489000 +0000 @@ -1,6 +1,7 @@ Parsed test spec with 2 sessions starting permutation: s2snitch s1b s1s s2detach s1cancel s1c s1describe s1alter +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; @@ -20,6 +21,7 @@ (1 row) step s1c: COMMIT; +s1: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s1describe: SELECT 'd3_listp' AS root, * FROM pg_partition_tree('d3_listp') UNION ALL SELECT 'd3_listp1', * FROM pg_partition_tree('d3_listp1'); root |relid |parentrelid|isleaf|level @@ -33,6 +35,7 @@ ERROR: cannot alter partition "d3_listp1" with an incomplete detach starting permutation: s2snitch s1b s1s s2detach s1cancel s1insert s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; @@ -56,6 +59,7 @@ step s1c: COMMIT; starting permutation: s2snitch s1brr s1s s2detach s1cancel s1insert s1c s1spart +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1brr: BEGIN ISOLATION LEVEL REPEATABLE READ; step s1s: SELECT * FROM d3_listp; @@ -85,6 +89,7 @@ starting permutation: s2snitch s1b s1s s2detach s1cancel s1c s1insertpart +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; @@ -107,6 +112,7 @@ step s1insertpart: INSERT INTO d3_listp1 VALUES (1); starting permutation: s2snitch s1b s1s s2detach2 s1cancel s1c s1brr s1insert s1s s1insert s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; @@ -139,6 +145,7 @@ step s1c: COMMIT; starting permutation: s2snitch s1b s1s s2detach2 s1cancel s1c s1brr s1s s1insert s1s s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; @@ -176,6 +183,7 @@ step s1c: COMMIT; starting permutation: s2snitch s1b s1s s2detach s1cancel s1c s1drop s1list +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; @@ -204,6 +212,7 @@ starting permutation: s2snitch s1b s1s s2detach s1cancel s1c s1trunc s1spart +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; @@ -232,6 +241,7 @@ starting permutation: s2snitch s1b s1s s2detach s1cancel s1noop s2detach2 s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; @@ -256,6 +266,7 @@ step s1c: COMMIT; starting permutation: s2snitch s1b s1s s2detach s1cancel s1noop s2detachfinal s1c s2detach2 +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; @@ -281,6 +292,7 @@ step s2detach2: ALTER TABLE d3_listp DETACH PARTITION d3_listp2 CONCURRENTLY; starting permutation: s2snitch s1b s1s s2detach s1cancel s1c s1droppart s2detach2 +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; @@ -304,6 +316,7 @@ step s2detach2: ALTER TABLE d3_listp DETACH PARTITION d3_listp2 CONCURRENTLY; starting permutation: s2snitch s1b s1s s2detach s1cancel s1c s2begin s2drop s1s s2commit +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; @@ -334,6 +347,7 @@ starting permutation: s2snitch s1b s1s s2detach s1cancel s1c s1b s1spart s2detachfinal s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; @@ -365,6 +379,7 @@ step s2detachfinal: <... completed> starting permutation: s2snitch s1b s1s s2detach s1cancel s1c s1b s1s s2detachfinal s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; @@ -394,6 +409,7 @@ step s1c: COMMIT; starting permutation: s2snitch s1b s1s s2detach s1cancel s1c s1b s1spart s2detachfinal s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; @@ -425,6 +441,7 @@ step s2detachfinal: <... completed> starting permutation: s2snitch s1b s1s s2detach s1cancel s1c s2begin s2detachfinal s2commit +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; @@ -449,6 +466,7 @@ step s2commit: COMMIT; starting permutation: s2snitch s1b s1s s2detach s1cancel s1c s2begin s2detachfinal s1spart s2commit +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; @@ -480,6 +498,7 @@ starting permutation: s2snitch s1b s1s s2detach s1cancel s1c s2begin s2detachfinal s1insertpart s2commit +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: INSERT INTO d3_pid SELECT pg_backend_pid(); step s1b: BEGIN; step s1s: SELECT * FROM d3_listp; diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/detach-partition-concurrently-4.out /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/detach-partition-concurrently-4.out --- /tmp/cirrus-ci-build/src/test/isolation/expected/detach-partition-concurrently-4.out 2024-03-21 16:29:26.428591000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/detach-partition-concurrently-4.out 2024-03-21 16:31:34.100559000 +0000 @@ -1,6 +1,7 @@ Parsed test spec with 3 sessions starting permutation: s2snitch s1b s1s s2detach s1cancel s1insert s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s1s: select * from d4_primary; @@ -10,6 +11,7 @@ 2 (2 rows) +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1cancel: select pg_cancel_backend(pid) from d4_pid; step s2detach: <... completed> @@ -25,6 +27,7 @@ step s1c: commit; starting permutation: s2snitch s1b s1s s2detach s1insert s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s1s: select * from d4_primary; @@ -34,6 +37,7 @@ 2 (2 rows) +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1insert: insert into d4_fk values (1); ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" @@ -41,6 +45,7 @@ step s1c: commit; starting permutation: s2snitch s1brr s1s s2detach s1cancel s1insert s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1brr: begin isolation level repeatable read; step s1s: select * from d4_primary; @@ -50,6 +55,7 @@ 2 (2 rows) +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1cancel: select pg_cancel_backend(pid) from d4_pid; step s2detach: <... completed> @@ -65,6 +71,7 @@ step s1c: commit; starting permutation: s2snitch s1brr s1s s2detach s1insert s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1brr: begin isolation level repeatable read; step s1s: select * from d4_primary; @@ -74,6 +81,7 @@ 2 (2 rows) +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1insert: insert into d4_fk values (1); ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" @@ -81,9 +89,11 @@ step s1c: commit; starting permutation: s2snitch s1b s1declare s2detach s1cancel s1fetchall s1insert s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s1declare: declare f cursor for select * from d4_primary; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1cancel: select pg_cancel_backend(pid) from d4_pid; step s2detach: <... completed> @@ -106,9 +116,11 @@ step s1c: commit; starting permutation: s2snitch s1b s1declare s2detach s1fetchall s1insert s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s1declare: declare f cursor for select * from d4_primary; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1fetchall: fetch all from f; a @@ -123,9 +135,11 @@ step s1c: commit; starting permutation: s2snitch s1b s1declare s2detach s1cancel s1svpt s1insert s1rollback s1fetchall s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s1declare: declare f cursor for select * from d4_primary; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1cancel: select pg_cancel_backend(pid) from d4_pid; step s2detach: <... completed> @@ -150,9 +164,11 @@ step s1c: commit; starting permutation: s2snitch s1b s1declare s2detach s1svpt s1insert s1rollback s1fetchall s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s1declare: declare f cursor for select * from d4_primary; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1svpt: savepoint f; step s1insert: insert into d4_fk values (1); @@ -169,8 +185,10 @@ step s2detach: <... completed> starting permutation: s2snitch s1b s2detach s1declare s1cancel s1fetchall s1insert s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1declare: declare f cursor for select * from d4_primary; step s1cancel: select pg_cancel_backend(pid) from d4_pid; @@ -190,8 +208,10 @@ step s1c: commit; starting permutation: s2snitch s1b s2detach s1declare s1fetchall s1insert s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1declare: declare f cursor for select * from d4_primary; step s1fetchall: fetch all from f; @@ -205,8 +225,10 @@ step s1c: commit; starting permutation: s2snitch s1b s2detach s1declare s1cancel s1svpt s1insert s1rollback s1fetchall s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1declare: declare f cursor for select * from d4_primary; step s1cancel: select pg_cancel_backend(pid) from d4_pid; @@ -228,8 +250,10 @@ step s1c: commit; starting permutation: s2snitch s1b s2detach s1declare s1svpt s1insert s1rollback s1fetchall s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1declare: declare f cursor for select * from d4_primary; step s1svpt: savepoint f; @@ -245,6 +269,7 @@ step s1c: commit; starting permutation: s2snitch s1brr s1declare2 s1fetchone s2detach s1cancel s1updcur s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1brr: begin isolation level repeatable read; step s1declare2: declare f cursor for select * from d4_fk where a = 2; @@ -254,6 +279,7 @@ 2 (1 row) +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1cancel: select pg_cancel_backend(pid) from d4_pid; step s2detach: <... completed> @@ -269,6 +295,7 @@ step s1c: commit; starting permutation: s2snitch s1brr s1declare2 s1fetchone s2detach s1updcur s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1brr: begin isolation level repeatable read; step s1declare2: declare f cursor for select * from d4_fk where a = 2; @@ -278,6 +305,7 @@ 2 (1 row) +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1updcur: update d4_fk set a = 1 where current of f; ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" @@ -285,6 +313,7 @@ step s1c: commit; starting permutation: s2snitch s1brr s1declare2 s1fetchone s1updcur s2detach s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1brr: begin isolation level repeatable read; step s1declare2: declare f cursor for select * from d4_fk where a = 2; @@ -297,10 +326,12 @@ step s1updcur: update d4_fk set a = 1 where current of f; step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1c: commit; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: <... completed> ERROR: removing partition "d4_primary1" violates foreign key constraint "d4_fk_a_fkey1" starting permutation: s2snitch s1b s1s s2detach s3insert s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s1s: select * from d4_primary; @@ -310,6 +341,7 @@ 2 (2 rows) +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s3insert: insert into d4_fk values (1); ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" @@ -317,6 +349,7 @@ step s2detach: <... completed> starting permutation: s2snitch s1b s1s s2detach s3brr s3insert s3commit s1cancel s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s1s: select * from d4_primary; @@ -326,6 +359,7 @@ 2 (2 rows) +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s3brr: begin isolation level repeatable read; step s3insert: insert into d4_fk values (1); @@ -343,6 +377,7 @@ step s1c: commit; starting permutation: s2snitch s1b s1s s2detach s3brr s3insert s3commit s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s1s: select * from d4_primary; @@ -352,6 +387,7 @@ 2 (2 rows) +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s3brr: begin isolation level repeatable read; step s3insert: insert into d4_fk values (1); @@ -361,6 +397,7 @@ step s2detach: <... completed> starting permutation: s2snitch s1brr s1s s2detach s1cancel s1noop s3vacfreeze s1s s1insert s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1brr: begin isolation level repeatable read; step s1s: select * from d4_primary; @@ -370,6 +407,7 @@ 2 (2 rows) +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1cancel: select pg_cancel_backend(pid) from d4_pid; step s2detach: <... completed> @@ -394,6 +432,7 @@ step s1c: commit; starting permutation: s2snitch s1b s1s s2detach s1cancel s1noop s3vacfreeze s1s s1insert s1c +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s1s: select * from d4_primary; @@ -403,6 +442,7 @@ 2 (2 rows) +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1cancel: select pg_cancel_backend(pid) from d4_pid; step s2detach: <... completed> diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/fk-partitioned-1.out /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/fk-partitioned-1.out --- /tmp/cirrus-ci-build/src/test/isolation/expected/fk-partitioned-1.out 2024-03-21 16:29:26.428794000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/fk-partitioned-1.out 2024-03-21 16:31:35.340567000 +0000 @@ -5,6 +5,7 @@ step s1d: delete from ppk1 where a = 1; step s1c: commit; step s2b: begin; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2a: alter table pfk attach partition pfk1 for values in (1); ERROR: insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey" step s2c: commit; @@ -14,6 +15,7 @@ step s1d: delete from ppk1 where a = 1; step s2b: begin; step s1c: commit; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2a: alter table pfk attach partition pfk1 for values in (1); ERROR: insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey" step s2c: commit; @@ -24,6 +26,7 @@ step s2b: begin; step s2a: alter table pfk attach partition pfk1 for values in (1); step s1c: commit; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2a: <... completed> ERROR: insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey" step s2c: commit; @@ -33,6 +36,7 @@ step s2b: begin; step s1d: delete from ppk1 where a = 1; step s1c: commit; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2a: alter table pfk attach partition pfk1 for values in (1); ERROR: insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey" step s2c: commit; @@ -43,6 +47,7 @@ step s1d: delete from ppk1 where a = 1; step s2a: alter table pfk attach partition pfk1 for values in (1); step s1c: commit; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2a: <... completed> ERROR: insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey" step s2c: commit; @@ -50,6 +55,7 @@ starting permutation: s1b s2b s2a s1d s2c s1c step s1b: begin; step s2b: begin; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2a: alter table pfk attach partition pfk1 for values in (1); step s1d: delete from ppk1 where a = 1; step s2c: commit; @@ -60,6 +66,7 @@ starting permutation: s1b s2b s2a s2c s1d s1c step s1b: begin; step s2b: begin; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2a: alter table pfk attach partition pfk1 for values in (1); step s2c: commit; step s1d: delete from ppk1 where a = 1; @@ -71,6 +78,7 @@ step s1b: begin; step s1d: delete from ppk1 where a = 1; step s1c: commit; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2a: alter table pfk attach partition pfk1 for values in (1); ERROR: insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey" step s2c: commit; @@ -81,6 +89,7 @@ step s1d: delete from ppk1 where a = 1; step s2a: alter table pfk attach partition pfk1 for values in (1); step s1c: commit; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2a: <... completed> ERROR: insert or update on table "pfk1" violates foreign key constraint "pfk_a_fkey" step s2c: commit; @@ -88,6 +97,7 @@ starting permutation: s2b s1b s2a s1d s2c s1c step s2b: begin; step s1b: begin; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2a: alter table pfk attach partition pfk1 for values in (1); step s1d: delete from ppk1 where a = 1; step s2c: commit; @@ -98,6 +108,7 @@ starting permutation: s2b s1b s2a s2c s1d s1c step s2b: begin; step s1b: begin; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2a: alter table pfk attach partition pfk1 for values in (1); step s2c: commit; step s1d: delete from ppk1 where a = 1; @@ -106,6 +117,7 @@ starting permutation: s2b s2a s1b s1d s2c s1c step s2b: begin; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2a: alter table pfk attach partition pfk1 for values in (1); step s1b: begin; step s1d: delete from ppk1 where a = 1; @@ -116,6 +128,7 @@ starting permutation: s2b s2a s1b s2c s1d s1c step s2b: begin; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2a: alter table pfk attach partition pfk1 for values in (1); step s1b: begin; step s2c: commit; @@ -125,6 +138,7 @@ starting permutation: s2b s2a s2c s1b s1d s1c step s2b: begin; +s2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree step s2a: alter table pfk attach partition pfk1 for values in (1); step s2c: commit; step s1b: begin;