Re: FATAL: SMgrRelation hashtable corrupted

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: FATAL: SMgrRelation hashtable corrupted
Дата
Msg-id 6414.1558099805@sss.pgh.pa.us
обсуждение исходный текст
Ответ на FATAL: SMgrRelation hashtable corrupted  (Daulat Ram <Daulat.Ram@exponential.com>)
Ответы Re: FATAL: SMgrRelation hashtable corrupted  (Andres Freund <andres@anarazel.de>)
Re: FATAL: SMgrRelation hashtable corrupted  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-general
Daulat Ram <Daulat.Ram@exponential.com> writes:
> My Postgres 11.2 container is not started due to the below error message. It is in streaming replication environment.

> 2019-05-17 06:41:19.954 UTC [11] FATAL:  SMgrRelation hashtable corrupted

Yes, this is probably the same issue reported in

https://www.postgresql.org/message-id/15672-b9fa7db32698269f@postgresql.org

https://www.postgresql.org/message-id/15684-4ef33de3271cf929@postgresql.org

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.

            regards, tom lane



В списке pgsql-general по дате отправления:

Предыдущее
От: nigel.andersen@gmx.com
Дата:
Сообщение: Re: Upgrading 9.1.17 to which version?
Следующее
От: Andres Freund
Дата:
Сообщение: Re: FATAL: SMgrRelation hashtable corrupted