Re: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump

2021-05-24 Thread Greg Nancarrow
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

Re: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump

2021-05-24 Thread Pavel Borisov
пн, 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

Re: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump

2021-05-23 Thread 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 was looking for experts in this snapshot-handling code, to loo

Re: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump

2021-05-23 Thread Michael Paquier
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

Re: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump

2021-05-23 Thread Greg Nancarrow
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

Re: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump

2021-05-19 Thread Greg Nancarrow
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

RE: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump

2021-05-19 Thread Pengchengliu
--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, > >

Re: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump

2021-05-18 Thread Greg Nancarrow
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

Re: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump

2021-05-18 Thread Pavel Borisov
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

RE: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump

2021-05-17 Thread Pengchengliu
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

Re: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump

2021-05-17 Thread Greg Nancarrow
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