Postgres Pro
Downloads
Home   >   mailing lists

Re: MarkBufferDirty Assert held LW_EXCLUSIVE lock fail when ginFinishSplit - Mailing list pgsql-bugs

From feichanghong
Subject Re: MarkBufferDirty Assert held LW_EXCLUSIVE lock fail when ginFinishSplit
Date
Msg-id tencent_4EB9BF2B6644750A7D909A3873F022A8290A@qq.com
Whole thread Raw
In response to Re: MarkBufferDirty Assert held LW_EXCLUSIVE lock fail when ginFinishSplit  (Heikki Linnakangas <hlinnaka@iki.fi>)
List pgsql-bugs
Tree view
Dear hlinnaka,

I once attempted to construct a scenario with multiple backends concurrently
performing the split that leads to gin index corruption. Unfortunately, I did
not succeed. The reason is that ginInsertCleanup requires an Exclusive Lock
on METAPAGE, preventing multiple processes from simultaneously executing the
cleanup. 

Maybe I missed something. hlinnaka, do you have any suggestions?
Best Regards,
Fei Changhong
Alibaba Cloud Computing Ltd.
 

pgsql-bugs by date:

Previous
From: Sandeep Thakkar
Date:
Subject: Re: BUG #18395: Checksum verification failed for: deb_postgis_3_4_pg16.app.zip
Next
From: feichanghong
Date:
Subject: Re: ReplicationSlotRelease may set the statusFlags of other processes in PG14