diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/spill.out /tmp/cirrus-ci-build/contrib/test_decoding/results/spill.out --- /tmp/cirrus-ci-build/contrib/test_decoding/expected/spill.out 2024-11-06 21:22:46.185015799 +0000 +++ /tmp/cirrus-ci-build/contrib/test_decoding/results/spill.out 2024-11-06 21:28:40.751051567 +0000 @@ -221,12 +221,7 @@ SELECT (regexp_split_to_array(data, ':'))[4] COLLATE "C", COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; - regexp_split_to_array | count | array_agg | array_agg ---------------------------------------+-------+-------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------- - 'serialize-nested-subsmall-subbig--1 | 1 | table public.spill_test: INSERT: data[text]:'serialize-nested-subsmall-subbig--1:1' | table public.spill_test: INSERT: data[text]:'serialize-nested-subsmall-subbig--1:1' - 'serialize-nested-subsmall-subbig--2 | 5000 | table public.spill_test: INSERT: data[text]:'serialize-nested-subsmall-subbig--2:2' | table public.spill_test: INSERT: data[text]:'serialize-nested-subsmall-subbig--2:5001' -(2 rows) - +ERROR: could not find record for logical decoding: unexpected pageaddr 0/2278000 in WAL segment 000000010000000000000003, LSN 0/3278000, offset 2588672 -- not spilling subxact, containing a spilling subxact that aborts and one that commits BEGIN; SAVEPOINT s1; @@ -241,11 +236,13 @@ SELECT (regexp_split_to_array(data, ':'))[4] COLLATE "C", COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; - regexp_split_to_array | count | array_agg | array_agg ------------------------------------------------+-------+-------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------- - 'serialize-nested-subbig-subbigabort--1 | 5000 | table public.spill_test: INSERT: data[text]:'serialize-nested-subbig-subbigabort--1:1' | table public.spill_test: INSERT: data[text]:'serialize-nested-subbig-subbigabort--1:5000' - 'serialize-nested-subbig-subbigabort-subbig-3 | 5000 | table public.spill_test: INSERT: data[text]:'serialize-nested-subbig-subbigabort-subbig-3:5001' | table public.spill_test: INSERT: data[text]:'serialize-nested-subbig-subbigabort-subbig-3:10000' -(2 rows) + regexp_split_to_array | count | array_agg | array_agg +-----------------------------------------------+-------+--------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------- + 'serialize-nested-subbig-subbigabort--1 | 5000 | table public.spill_test: INSERT: data[text]:'serialize-nested-subbig-subbigabort--1:1' | table public.spill_test: INSERT: data[text]:'serialize-nested-subbig-subbigabort--1:2' + 'serialize-nested-subbig-subbigabort-subbig-3 | 5000 | table public.spill_test: INSERT: data[text]:'serialize-nested-subbig-subbigabort-subbig-3:10000' | table public.spill_test: INSERT: data[text]:'serialize-nested-subbig-subbigabort-subbig-3:9999' + 'serialize-nested-subsmall-subbig--1 | 1 | table public.spill_test: INSERT: data[text]:'serialize-nested-subsmall-subbig--1:1' | table public.spill_test: INSERT: data[text]:'serialize-nested-subsmall-subbig--1:1' + 'serialize-nested-subsmall-subbig--2 | 5000 | table public.spill_test: INSERT: data[text]:'serialize-nested-subsmall-subbig--2:5001' | table public.spill_test: INSERT: data[text]:'serialize-nested-subsmall-subbig--2:3' +(4 rows) DROP TABLE spill_test; SELECT pg_drop_replication_slot('regression_slot');