Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17268: Possible corruption in toast index after reindex index concurrently - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #17268: Possible corruption in toast index after reindex index concurrently
Date
Msg-id 20211108180833.5sph7vrnrv5zjrj3@alap3.anarazel.de
Whole thread Raw
In response to Re: BUG #17268: Possible corruption in toast index after reindex index concurrently  (Maxim Boguk <maxim.boguk@gmail.com>)
List pgsql-bugs
Tree view 
Hi,

On 2021-11-04 22:01:44 +0200, Maxim Boguk wrote:
> 2021-11-02 13:15:45.469 UTC 2379 postgres@*** from [local] [vxid:24/0
> txid:0] [REINDEX] LOG:  duration: 1719120.441 ms  statement: REINDEX
> INDEX CONCURRENTLY pg_toast.pg_toast_2624976286_index
> and the problem entry had been created at 2021-11-02 13:04:22.192125 UTC.

Another question on this. Are you running multiple reindexes concurrently? Other
maintenance commands?

Greetings,

Andres Freund

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #17268: Possible corruption in toast index after reindex index concurrently
Next
From: Peter Geoghegan
Date:
Subject: Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum