| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
| Cc: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Peter Geoghegan <pg(at)bowt(dot)ie>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, iijima(dot)yun(at)koumakan(dot)jp |
| Subject: | Re: BUG #17245: Index corruption involving deduplicated entries |
| Date: | 2021-10-28 21:42:09 |
| Message-ID: | 20211028214209.kbv4ulehz36up6kq@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hi,
On 2021-10-25 09:43:18 +0100, Andrew Gierth wrote:
> >>>>> "Alvaro" == Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
>
> Alvaro> Do you happen to have WAL traffic for this table and index?
>
> Unfortunately there's no WAL archiving, and no available WAL files from
> before the state was known to be corrupt. We'll look into enabling
> archiving in case the problem recurs or can be reproduced.
Any chance autovacuum logging was enabled and that those logs still exist? Not
quite as good as still having the WAL, but it still might allow us to
reconstruct the index / vacuum scans, and the horizons used.
Greetings,
Andres Freund
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kamigishi Rei | 2021-10-28 21:46:29 | Re: BUG #17245: Index corruption involving deduplicated entries |
| Previous Message | Pavel Borisov | 2021-10-28 21:39:50 | Re: BUG #17245: Index corruption involving deduplicated entries |