Search Postgresql Archives

Re: FATAL: SMgrRelation hashtable corrupted

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Daulat Ram <Daulat.Ram@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx

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

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






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux