From: Tom Lane <tgl@sss.pgh.pa.us>
To: Amit Kapila <akapila@postgresql.org>
Cc: pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Test decoding of two-phase transactions during the build of a co
Date: Sat, 09 Jan 2021 00:47:47 -0500
Message-ID: <363512.1610171267@sss.pgh.pa.us> (raw)
In-Reply-To: <E1kwili-0006bK-Ap@gemulon.postgresql.org>
References: <E1kwili-0006bK-Ap@gemulon.postgresql.org>
Amit Kapila <akapila@postgresql.org> writes:
> Test decoding of two-phase transactions during the build of a consistent snapshot.
It seems this test case isn't 100% stable:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=chipmunk&dt=2021-01-08%2023%3A56%3A57
========================== output_iso/regression.diffs ================
inline patch 1: /home/pgbfarm/buildroot/HEAD/pgsql.build/contrib/test_decoding/output_iso/results/twophase_snapshot.out (+6/-0 lines) download inline-1.patchdiff -U3 /home/pgbfarm/buildroot/HEAD/pgsql.build/contrib/test_decoding/expected/twophase_snapshot.out /home/pgbfarm/buildroot/HEAD/pgsql.build/contrib/test_decoding/output_iso/results/twophase_snapshot.out
--- /home/pgbfarm/buildroot/HEAD/pgsql.build/contrib/test_decoding/expected/twophase_snapshot.out 2021-01-07 02:49:30.231809843 +0200+++ /home/pgbfarm/buildroot/HEAD/pgsql.build/contrib/test_decoding/output_iso/results/twophase_snapshot.out 2021-01-09 04:01:26.730510078 +0200@@ -26,6 +26,8 @@
data
BEGIN
+COMMIT +BEGIN
table public.do_write: INSERT: id[integer]:2
COMMIT
step s2cp: COMMIT PREPARED 'test1';
@@ -33,6 +35,10 @@
data
BEGIN
+COMMIT +BEGIN +COMMIT +BEGIN
table public.do_write: INSERT: id[integer]:1
PREPARE TRANSACTION 'test1'
COMMIT PREPARED 'test1'
I think we've seen this extra-transactions symptom before,
but I don't recall the details at this late hour.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: tgl@sss.pgh.pa.us, akapila@postgresql.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Test decoding of two-phase transactions during the build of a co
In-Reply-To: <363512.1610171267@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox