Re:BUG #17568: unexpected zero page at block 0 during REINDEX CONCURRENTLY

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: PG Bug reporting form <noreply(at)postgresql(dot)org>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re:BUG #17568: unexpected zero page at block 0 during REINDEX CONCURRENTLY
Date: 2022-08-15 14:02:38
Message-ID: 2462201660572158@iva1-b072565fc81a.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello
Luckily, I found a call of bt_metap function in one query that was definitely called while reindex was running and before these errors started to appear.
Accidentally pilot error.

It would be nice to protect shared buffers from such premature page loading, but it's probably not going to work without performance penalty.

regards, Sergei

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Daniele Varrazzo 2022-08-15 14:57:58 Re: [PATCH] Fix segfault calling PQflush on invalid connection
Previous Message PG Bug reporting form 2022-08-15 11:36:52 BUG #17586: Look like there are an another bug in REINDEX INDEX CONCURRENTLY of pg_toast indexes