FATAL: SMgrRelation hashtable corrupted

From: Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: FATAL: SMgrRelation hashtable corrupted
Date: 2019-05-17 06:54:59
Message-ID: BL0PR01MB5187D3C3C76CA817560D223A9B0B0@BL0PR01MB5187.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello team

I need your help on this issue.

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:08.989 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2019-05-17 06:41:09.093 UTC [11] LOG: database system was interrupted while in recovery at 2019-05-17 06:40:24 UTC
2019-05-17 06:41:09.093 UTC [11] HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2019-05-17 06:41:11.260 UTC [12] FATAL: the database system is starting up
2019-05-17 06:41:11.673 UTC [13] FATAL: the database system is starting up
2019-05-17 06:41:12.209 UTC [14] FATAL: the database system is starting up
2019-05-17 06:41:12.427 UTC [15] FATAL: the database system is starting up
2019-05-17 06:41:15.425 UTC [16] FATAL: the database system is starting up
2019-05-17 06:41:15.680 UTC [17] FATAL: the database system is starting up
2019-05-17 06:41:16.059 UTC [18] FATAL: the database system is starting up
2019-05-17 06:41:16.263 UTC [19] FATAL: the database system is starting up
2019-05-17 06:41:16.624 UTC [20] FATAL: the database system is starting up
2019-05-17 06:41:17.471 UTC [21] FATAL: the database system is starting up
2019-05-17 06:41:18.739 UTC [22] FATAL: the database system is starting up
2019-05-17 06:41:19.877 UTC [11] LOG: database system was not properly shut down; automatic recovery in progress
2019-05-17 06:41:19.887 UTC [11] LOG: redo starts at 5E/170349E8
2019-05-17 06:41:19.954 UTC [11] FATAL: SMgrRelation hashtable corrupted
2019-05-17 06:41:19.954 UTC [11] CONTEXT: WAL redo at 5E/17061648 for Transaction/COMMIT: 2019-05-17 06:39:46.902988+00; rels: base/59265/105367 base/59265/105349 base/59265/105365 base/59265/105362 base/59265/105360 base/59265/105349 base/59265/105358 base/59265/105355; inval msgs: catcache 50 catcache 49 catcache 50 catcache 49 catcache 50 catcache 49 catcache 50 catcache 49 catcache 50 catcache 49 catcache 50 catcache 49 catcache 50 catcache 49 catcache 50 catcache 49 catcache 50 catcache 49 catcache 50 catcache 49 catcache 50 catcache 49 catcache 50 catcache 49 relcache 105365 relcache 105367 relcache 105367 relcache 105293 relcache 105411 relcache 105411 relcache 105365 relcache 105293 relcache 105358 relcache 105360 relcache 105360 relcache 105285 relcache 105413 relcache 105413 relcache 105358 relcache 105285
2019-05-17 06:41:19.955 UTC [1] LOG: startup process (PID 11) exited with exit code 1
2019-05-17 06:41:19.955 UTC [1] LOG: aborting startup due to startup process failure
2019-05-17 06:41:19.961 UTC [1] LOG: database system is shut down

Regards,
Daulat

Responses

Browse pgsql-general by date

  From Date Subject
Next Message AYahorau 2019-05-17 08:04:58 Re: terminating walsender process due to replication timeout
Previous Message bricklen 2019-05-16 19:01:53 Re: schema change tracking