On Mon, May 24, 2021 at 11:56 PM Pavel Borisov wrote:
>
> Using a recipe similar to what has been described above in the thread, I
> reliably reproduced the bug in many Postgres versions. (v.11, v.13 etc.).
> 1. Make & make install
> 2. Make check
> 3. run SubTransGetTopmostTransaction-rep.sh in
пн, 24 мая 2021 г. в 09:22, Greg Nancarrow :
> On Mon, May 24, 2021 at 2:50 PM Michael Paquier
> wrote:
> >
> > On Mon, May 24, 2021 at 12:04:37PM +1000, Greg Nancarrow wrote:
> > > Keep cfbot happy, use the PG14 patch as latest.
> >
> > This stuff is usually very tricky.
>
> Agreed. That's why I
On Mon, May 24, 2021 at 2:50 PM Michael Paquier wrote:
>
> On Mon, May 24, 2021 at 12:04:37PM +1000, Greg Nancarrow wrote:
> > Keep cfbot happy, use the PG14 patch as latest.
>
> This stuff is usually very tricky.
Agreed. That's why I was looking for experts in this snapshot-handling
code, to loo
On Mon, May 24, 2021 at 12:04:37PM +1000, Greg Nancarrow wrote:
> Keep cfbot happy, use the PG14 patch as latest.
This stuff is usually very tricky. Do we have a way to reliably
reproduce the report discussed here?
--
Michael
signature.asc
Description: PGP signature
On Thu, May 20, 2021 at 4:08 PM Greg Nancarrow wrote:
>
Keep cfbot happy, use the PG14 patch as latest.
Regards,
Greg Nancarrow
Fujitsu Australia
v2-0001-PG14-Fix-parallel-worker-failed-assertion-and-coredump.patch
Description: Binary data
On Thu, May 20, 2021 at 11:18 AM Pengchengliu wrote:
>
> Hi Greg,
>Thanks a lot for you explanation and your fix.
>
>I think your fix can resolve the core dump issue. As with your fix,
> parallel process reset Transaction Xmin from ActiveSnapshot.
>But it will change Transaction snaps
--Original Message-
From: Greg Nancarrow
Sent: 2021年5月18日 17:15
To: Pengchengliu
Cc: Andres Freund ; PostgreSQL-development
Subject: Re: Re: Parallel scan with SubTransGetTopmostTransaction assert
coredump
On Tue, May 18, 2021 at 11:27 AM Pengchengliu wrote:
>
> Hi Greg,
>
>
On Tue, May 18, 2021 at 11:27 AM Pengchengliu wrote:
>
> Hi Greg,
>
>Actually I am very confused about ActiveSnapshot and TransactionSnapshot.
> I don't know why main process send ActiveSnapshot and TransactionSnapshot
> separately. And what is exact difference between them?
>If you kno
I've also seen the reports of the same Assert(TransactionIdFollowsOrEquals(xid,
TransactionXmin)) with a subsequent crash in a parallel worker in
PostgreSQL v11-based build, Though I was unable to investigate deeper and
reproduce the issue. The details above in the thread make me think it is a
real
om: Greg Nancarrow
Sent: 2021年5月17日 20:59
To: 刘鹏程
Cc: Andres Freund ; PostgreSQL-development
Subject: Re: Re: Parallel scan with SubTransGetTopmostTransaction assert
coredump
On Sat, May 15, 2021 at 12:37 PM 刘鹏程 wrote:
>
>
> BTW, I test it in a high performance server. It is verly easily
On Sat, May 15, 2021 at 12:37 PM 刘鹏程 wrote:
>
>
> BTW, I test it in a high performance server. It is verly easily be
> reproduced. My colleague and me use different environment both can reproduce
> it.
>
Hi Pengcheng,
Although the issue won't reproduce easily in my system, I can
certainly se
11 matches
Mail list logo