On Sat, Feb 12, 2022 at 6:04 AM Tomas Vondra <tomas.von...@enterprisedb.com> wrote: > > On 2/10/22 19:17, Tomas Vondra wrote: > > I've polished & pushed the first part adding sequence decoding > > infrastructure etc. Attached are the two remaining parts. > > > > I plan to wait a day or two and then push the test_decoding part. The > > last part (for built-in replication) will need more work and maybe > > rethinking the grammar etc. > > > > I've pushed the second part, adding sequences to test_decoding. >
The test_decoding is failing randomly in the last few days. I am not completely sure but they might be related to this work. The two of these appears to be due to the same reason: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=skink&dt=2022-02-25%2018%3A50%3A09 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=locust&dt=2022-02-17%2015%3A17%3A07 TRAP: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File: "reorderbuffer.c", Line: 1173, PID: 35013) 0 postgres 0x00593de0 ExceptionalCondition + 160\\0 Another: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=mandrill&dt=2022-02-16%2006%3A21%3A48 --- /home/nm/farm/xlc32/HEAD/pgsql.build/contrib/test_decoding/expected/rewrite.out 2022-02-14 20:19:14.000000000 +0000 +++ /home/nm/farm/xlc32/HEAD/pgsql.build/contrib/test_decoding/results/rewrite.out 2022-02-16 07:42:18.000000000 +0000 @@ -126,6 +126,7 @@ table public.replication_example: INSERT: id[integer]:4 somedata[integer]:3 text[character varying]:null testcolumn1[integer]:null table public.replication_example: INSERT: id[integer]:5 somedata[integer]:4 text[character varying]:null testcolumn1[integer]:2 testcolumn2[integer]:1 COMMIT + sequence public.replication_example_id_seq: transactional:0 last_value: 38 log_cnt: 0 is_called:1 BEGIN table public.replication_example: INSERT: id[integer]:6 somedata[integer]:5 text[character varying]:null testcolumn1[integer]:3 testcolumn2[integer]:null COMMIT @@ -133,7 +134,7 @@ table public.replication_example: INSERT: id[integer]:7 somedata[integer]:6 text[character varying]:null testcolumn1[integer]:4 testcolumn2[integer]:null table public.replication_example: INSERT: id[integer]:8 somedata[integer]:7 text[character varying]:null testcolumn1[integer]:5 testcolumn2[integer]:null testcolumn3[integer]:1 COMMIT - (15 rows) + (16 rows) -- With Regards, Amit Kapila.
