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

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

From
Pragati Agarwal
Date:
The following error "could not locate a valid checkpoint record" occurs on a datastore server running on postgreSQL 13.1. 
Datastore is hosted on windows 2016 and the system has McAfee virus scan installed.
This error occurs when server start is attempted.
[7804] LOG:  starting PostgreSQL 13.1, compiled by Visual C++ build 1914, 64-bit
[8812] LOG:  invalid primary checkpoint record
[8812] PANIC:  could not locate a valid checkpoint record
[7804] LOG:  startup process (PID 8812) was terminated by exception 0xC0000409
[7804] HINT:  See C include file "ntstatus.h" for a description of the hexadecimal value.
[7804] LOG:  aborting startup due to startup process failure
[7804] LOG:  database system is shut down

Thanks,
Pragati

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

From
Pragati Agarwal
Date:
Could you please suggest the possible resolution.

Thanks,
Pragati

On Fri, 28 Jan 2022, 14:11 Pragati Agarwal, <pragatiagarwal121@gmail.com> wrote:
The following error "could not locate a valid checkpoint record" occurs on a datastore server running on postgreSQL 13.1. 
Datastore is hosted on windows 2016 and the system has McAfee virus scan installed.
This error occurs when server start is attempted.
[7804] LOG:  starting PostgreSQL 13.1, compiled by Visual C++ build 1914, 64-bit
[8812] LOG:  invalid primary checkpoint record
[8812] PANIC:  could not locate a valid checkpoint record
[7804] LOG:  startup process (PID 8812) was terminated by exception 0xC0000409
[7804] HINT:  See C include file "ntstatus.h" for a description of the hexadecimal value.
[7804] LOG:  aborting startup due to startup process failure
[7804] LOG:  database system is shut down

Thanks,
Pragati

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

From
Julien Rouhaud
Date:
Hi,

On Wed, Feb 02, 2022 at 11:29:45PM +0530, Pragati Agarwal wrote:
> 
> > The following error "could not locate a valid checkpoint record" occurs on
> > a datastore server running on postgreSQL 13.1.
> > Datastore is hosted on windows 2016 and the system has McAfee virus scan
> > installed.
> > This error occurs when server start is attempted.
> >
> > [7804] LOG:  starting PostgreSQL 13.1, compiled by Visual C++ build 1914, 64-bit
> > [8812] LOG:  invalid primary checkpoint record
> > [8812] PANIC:  could not locate a valid checkpoint record
> > [7804] LOG:  startup process (PID 8812) was terminated by exception 0xC0000409
> > [7804] HINT:  See C include file "ntstatus.h" for a description of the hexadecimal value.
> > [7804] LOG:  aborting startup due to startup process failure
> > [7804] LOG:  database system is shut down

Did you experience some hardware failure, or do the previous logs show any
other problems?

Can you send the output of

pg_controldata.exe -D $PGDATA

where $PGDATA is the directory where the instance is stored.

The needed command line is likely to be:

"C:\Program Files\Postgresql\13\bin\pg_controldata.exe -D "C:\Program Files\Postgresql\13\data"

Also, there will be a line of the form:

Latest checkpoint's REDO WAL file:    XXXXXXXXXXXXXXXXXXXXXXXX

Can you check if the reported files exists in your pg_wal directory (it's a
subdirectory of the $PGDATA directory), and if its size is 16MB?

If yes, please check that the permission on the files allows the user starting
the postgres service.  You could also temporarily disable your antivirus to
check if it's blocking access.



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

From
Juan José Santamaría Flecha
Date:

On Thu, Feb 3, 2022 at 5:14 AM Julien Rouhaud <rjuju123@gmail.com> wrote:
On Wed, Feb 02, 2022 at 11:29:45PM +0530, Pragati Agarwal wrote:
>
> > The following error "could not locate a valid checkpoint record" occurs on
> > a datastore server running on postgreSQL 13.1.
> > Datastore is hosted on windows 2016 and the system has McAfee virus scan
> > installed.
> > This error occurs when server start is attempted.
> >
> > [7804] LOG:  starting PostgreSQL 13.1, compiled by Visual C++ build 1914, 64-bit
> > [8812] LOG:  invalid primary checkpoint record
> > [8812] PANIC:  could not locate a valid checkpoint record
> > [7804] LOG:  startup process (PID 8812) was terminated by exception 0xC0000409
> > [7804] HINT:  See C include file "ntstatus.h" for a description of the hexadecimal value.
> > [7804] LOG:  aborting startup due to startup process failure
> > [7804] LOG:  database system is shut down

Did you experience some hardware failure, or do the previous logs show any
other problems?

Is this error generating a minidump? Please check the location "C:\Users\<USER>\AppData\Local\CrashDumps", where <USER> is the login starting the DB.

Regards,

Juan José Santamaría Flecha

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

From
"Silaparasetti, Ramesh"
Date:
Thank you Julien for your response. We will get back to you once we get this data.

Really appreciate your help !

Best Regards,
Ramesh


Internal Use - Confidential

-----Original Message-----
From: Julien Rouhaud <rjuju123@gmail.com>
Sent: Thursday, February 3, 2022 9:45 AM
To: Pragati Agarwal
Cc: pgsql-bugs@lists.postgresql.org; Silaparasetti, Ramesh; Kishore, Nanda - Dell Team
Subject: Re: Postgresql error : PANIC: could not locate a valid checkpoint record


[EXTERNAL EMAIL]

Hi,

On Wed, Feb 02, 2022 at 11:29:45PM +0530, Pragati Agarwal wrote:
>
> > The following error "could not locate a valid checkpoint record"
> > occurs on a datastore server running on postgreSQL 13.1.
> > Datastore is hosted on windows 2016 and the system has McAfee virus
> > scan installed.
> > This error occurs when server start is attempted.
> >
> > [7804] LOG:  starting PostgreSQL 13.1, compiled by Visual C++ build
> > 1914, 64-bit [8812] LOG:  invalid primary checkpoint record [8812]
> > PANIC:  could not locate a valid checkpoint record [7804] LOG:
> > startup process (PID 8812) was terminated by exception 0xC0000409
> > [7804] HINT:  See C include file "ntstatus.h" for a description of the hexadecimal value.
> > [7804] LOG:  aborting startup due to startup process failure [7804]
> > LOG:  database system is shut down

Did you experience some hardware failure, or do the previous logs show any other problems?

Can you send the output of

pg_controldata.exe -D $PGDATA

where $PGDATA is the directory where the instance is stored.

The needed command line is likely to be:

"C:\Program Files\Postgresql\13\bin\pg_controldata.exe -D "C:\Program Files\Postgresql\13\data"

Also, there will be a line of the form:

Latest checkpoint's REDO WAL file:    XXXXXXXXXXXXXXXXXXXXXXXX

Can you check if the reported files exists in your pg_wal directory (it's a subdirectory of the $PGDATA directory), and
ifits size is 16MB? 

If yes, please check that the permission on the files allows the user starting the postgres service.  You could also
temporarilydisable your antivirus to check if it's blocking access.