Re: pgsql: Test decoding of two-phase transactions during the build of a co

2021-01-09 Thread Amit Kapila
On Sat, Jan 9, 2021 at 1:09 PM Tom Lane wrote: > > Amit Kapila writes: > > I think I know whats going on here. I have responded to the thread on > > pgsql-hackers [1]. > > Ah, yeah, the autovacuum theory fits the facts: chipmunk is pretty > slow, and it's not failed 100% of the time. > I have pu

Re: pgsql: Test decoding of two-phase transactions during the build of a co

2021-01-08 Thread Tom Lane
Amit Kapila writes: > I think I know whats going on here. I have responded to the thread on > pgsql-hackers [1]. Ah, yeah, the autovacuum theory fits the facts: chipmunk is pretty slow, and it's not failed 100% of the time. regards, tom lane

Re: pgsql: Test decoding of two-phase transactions during the build of a co

2021-01-08 Thread Amit Kapila
On Sat, Jan 9, 2021 at 12:18 PM Amit Kapila wrote: > > On Sat, Jan 9, 2021 at 11:17 AM Tom Lane wrote: > > > > > > I think we've seen this extra-transactions symptom before, > > but I don't recall the details at this late hour. > > > > I'll look into it. > I think I know whats going on here. I h

Re: pgsql: Test decoding of two-phase transactions during the build of a co

2021-01-08 Thread Amit Kapila
On Sat, Jan 9, 2021 at 11:17 AM Tom Lane wrote: > > Amit Kapila 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%202

Re: pgsql: Test decoding of two-phase transactions during the build of a co

2021-01-08 Thread Tom Lane
Amit Kapila 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.d

pgsql: Test decoding of two-phase transactions during the build of a co

2021-01-05 Thread Amit Kapila
Test decoding of two-phase transactions during the build of a consistent snapshot. Commit a271a1b50e added the capability to allow decoding at prepare time. This adds an isolation testcase to test that decoding happens at commit time when the consistent snapshot state is reached after prepare but