Postgresql error : PANIC: could not locate a valid checkpoint record

From: "Mahendrakar, Prabhakar - Dell Team" <Prabhakar(dot)Mahendraka(at)dellteam(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Postgresql error : PANIC: could not locate a valid checkpoint record
Date: 2022-06-17 06:35:39
Message-ID: BYAPR19MB2886F1A1C7642D2A8000DAE394AF9@BYAPR19MB2886.namprd19.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Good Morning !

We are facing checkpoint related issues from PostGreSQL 13.4 ( could not locate a valid checkpoint record) and Postgres service fails to come up.
========================================================================================================
LOG: starting PostgreSQL 13.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit
LOG: listening on IPv4 address "127.0.0.1", port 9003
LOG: listening on IPv4 address "10.xx.xx.x..", port 9003
LOG: listening on Unix socket "/tmp/.s.PGSQL.9003"
LOG: database system was shut down at 2022-06-09 10:19:24 CEST
LOG: invalid primary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 8773) was terminated by signal 6: Aborted
LOG: aborting startup due to startup process failure
LOG: database system is shut down

This issue is seen in both Windows and Linux OS platforms.

To Brief on the Scenario: Our product say example with Version A1 uses Postgres 10 and in the latest version of our product (Say A2) we upgraded the Postgres to 13.
When we try to upgrade our Product through InstallAnyWhere from A1 to A2, Postgres service fails with above mentioned error.

Could you please suggest the probable cause of the issue. Let us know if you require any more information.

Thanks,
Prabhakar

Internal Use - Confidential

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bryn Llewellyn 2022-06-17 06:58:23 Re: ERROR: failed to find conversion function from key_vals_nn to record[]
Previous Message Kyotaro Horiguchi 2022-06-17 05:03:43 Re: Any way to understand state after data corruption failures during startup.