| From: | Noah Misch <noah(at)leadboat(dot)com> |
|---|---|
| To: | Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com> |
| Cc: | PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #17386: btree index corruption after reindex concurrently on write heavy table |
| Date: | 2022-01-29 02:34:18 |
| Message-ID: | 20220129023418.GA2452893@rfd.leadboat.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Fri, Jan 28, 2022 at 04:17:28PM +0200, Maxim Boguk wrote:
> On Fri, Jan 28, 2022 at 3:42 PM PG Bug reporting form <noreply(at)postgresql(dot)org> wrote:
> > PostgreSQL version: 14.1
> Seems something broken in combination of HOT update and REINDEX
> CONCURRENTLY.
Agreed. Can you create a self-contained test case, perhaps by adapting
contrib/amcheck/t/002_cic.pl? If this bug is like the ones fixed between 14.0
and 14.1, the base backup and WAL won't help us, unfortunately. The transient
states are what matter. I did try modifying the test to have elements of your
scenario, including HOT updates, KEY SHARE locks, and frozen tuples. That
didn't reproduce the bug. I'm attaching what I tried.
| Attachment | Content-Type | Size |
|---|---|---|
| repro-reindex-hot-v0.patch | text/plain | 2.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2022-01-29 03:00:31 | Re: BUG #17386: btree index corruption after reindex concurrently on write heavy table |
| Previous Message | Tom Lane | 2022-01-28 23:48:00 | Re: BUG #17387: Working in PG13 but not in PGH14: array_agg(RECORD) |