Re: Fix orphaned 2pc file which may casue instance restart failed

2024-10-09 Thread ChengWen Wu
Hi Michael, Is there any progress about this problem? I could give more detailed information if you need. Best wishes, Chengwen Wu -- Original -- From:

Re: Fix orphaned 2pc file which may casue instance restart failed

2024-09-30 Thread Michael Paquier
On Wed, Sep 11, 2024 at 06:21:37PM +0900, Michael Paquier wrote: >> If gxact1's local xid is not frozen, the startup process will remove >> the orphaned 2pc file. However, if the xid's corresponding clog file is >> truncated by `vacuum`, the startup process will raise error 'could not >> access s

Re: Fix orphaned 2pc file which may casue instance restart failed

2024-09-11 Thread Michael Paquier
On Sun, Sep 08, 2024 at 01:01:37PM +0800, 清浅 wrote: > Hi all, I found that there is a race condition > between two global transaction, which may cause instance restart > failed with error 'could not access status of transaction > xxx","Could not open file ""pg_xact/xxx"": No such file or > directo