Re: FATAL: SMgrRelation hashtable corrupted - Mailing list pgsql-general

From Andres Freund
Subject Re: FATAL: SMgrRelation hashtable corrupted
Date
Msg-id 20190517153416.di2z2e5bijblojap@alap3.anarazel.de
Whole thread Raw
In response to Re: FATAL: SMgrRelation hashtable corrupted  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

On 2019-05-17 09:30:05 -0400, Tom Lane wrote:
> The good news is that the underlying ALTER TABLE bug is fixed in 11.3.
> The bad news is that your database is probably toast anyway --- an update
> won't undo the catalog corruption that is causing the WAL replay crash.
> I hope you have a recent backup to restore from.

Should there not be a backup, couldn't weaken the error checks during
replay a bit (locally), to allow replay to progress? The indexes will be
toast, but it ought to allow to recover the table data completely.

Greetings,

Andres Freund



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: FATAL: SMgrRelation hashtable corrupted
Next
From: Alvaro Herrera
Date:
Subject: Re: FATAL: SMgrRelation hashtable corrupted