Re: FATAL: SMgrRelation hashtable corrupted

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: FATAL: SMgrRelation hashtable corrupted
Дата
Msg-id 20190517153416.di2z2e5bijblojap@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: FATAL: SMgrRelation hashtable corrupted  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: FATAL: SMgrRelation hashtable corrupted
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: FATAL: SMgrRelation hashtable corrupted