Re: Reproducible GIST index corruption under concurrent updates

Andrey Borodin <x4mmm@yandex-team.ru>

From: Andrey Borodin <x4mmm@yandex-team.ru>

To: Duncan Sands <duncan.sands@deepbluecap.com>

Cc: pgsql-bugs@lists.postgresql.org

Date: 2021-01-19T17:12:39Z

Lists: pgsql-bugs


> 19 янв. 2021 г., в 16:15, Duncan Sands <duncan.sands@deepbluecap.com> написал(а):
> 
> Enjoy!

Thanks!
It reproduces on my machine. Seems like all tuples are indexed, but some root downlinks are not adjusted properly. Probably, after concurrent split.

Best regards, Andrey Borodin.

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix bug in detecting concurrent page splits in GiST insert
- 0326635dd484 12.6 landed
- b8403d140f4e 13.2 landed
- 6b4d3046f422 14.0 landed
Refactor checks for deleted GiST pages.
- e2e992c93145 12.0 cited