From: | "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> |
---|---|
To: | Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>, Pengchengliu <pengchengliu(at)tju(dot)edu(dot)cn> |
Cc: | Greg Nancarrow <gregn4422(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Parallel scan with SubTransGetTopmostTransaction assert coredump |
Date: | 2021-05-18 11:41:02 |
Message-ID: | OS0PR01MB571668730F78C04A813C6FA9942C9@OS0PR01MB5716.jpnprd01.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> To: Pengchengliu <pengchengliu(at)tju(dot)edu(dot)cn>
> Cc: Greg Nancarrow <gregn4422(at)gmail(dot)com>; Andres Freund <andres(at)anarazel(dot)de>; PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
> Subject: Re: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump
> 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 and long-time-persistent error that is
> surely worth to be fixed.
I followed Liu's reproduce steps and successfully reproduce it in about half an hour running.
My compile option is : " ./configure --enable-cassert --prefix=/home/pgsql".
After applying greg-san's change, the coredump did not happened in two hour(it is still running).
Note, I have not taken a deep look into the change, just provide some test information in advance.
Best regards,
houzj
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2021-05-18 11:59:32 | Re: Forget close an open relation in ReorderBufferProcessTXN() |
Previous Message | Amit Kapila | 2021-05-18 11:31:47 | Re: [HACKERS] logical decoding of two-phase transactions |