Feedback-ID: i0fe9450f:Fastmail
Date: Mon, 12 Jun 2023 13:56:21 +0900
From: Michael Paquier <michael@paquier.xyz>
To: srivastavautkarsh8097@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17954: Postgres startup fails with `could not locate a
 valid checkpoint record`
Message-ID: <ZIaldUjDrK8D45db@paquier.xyz>
References: <17954-487d02209af43b14@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="G/tQsVidLiWZNhno"
Content-Disposition: inline
In-Reply-To: <17954-487d02209af43b14@postgresql.org>
Archived-At: 
 <https://www.postgresql.org/message-id/ZIaldUjDrK8D45db%40paquier.xyz>
Precedence: bulk


--G/tQsVidLiWZNhno
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, Jun 01, 2023 at 01:11:20PM +0000, PG Bug reporting form wrote:
> - What could be the root cause of this issue?=20
> - Is this a known issue (I did search the archives but couldn't find it
> though)? If yes, is this fixed in a PG 13, 14, 15?

Hard to say for sure, but it looks like your host has a few problems.
This part from your logs refers to something that should not happen,
to begin with:

> 2023-05-14 05:13:13.678 UTC [1] LOG:  received smart shutdown request
> 2023-05-14 05:13:36.692 UTC [1] LOG:  could not open file "postmaster.pid=
":
> No such file or directory
> 2023-05-14 05:13:36.692 UTC [1] LOG:  performing immediate shutdown becau=
se
> data directory lock file is invalid
> 2023-05-14 05:13:36.692 UTC [1] LOG:  received immediate shutdown request
> 2023-05-14 05:13:36.692 UTC [1] LOG:  could not open file "postmaster.pid=
":
> No such file or directory

This LOG would come from either AddToDataDirLockFile() or
RecheckDataDirLockFile().  Still, the third entry I am quoting refers
to a recheck of the PID file, meaning that the postmaster has bumped
into what looks like a corrupted PID file. =20
--
Michael

--G/tQsVidLiWZNhno
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmSGpXUACgkQnvQgOdby
QH3TwQ/+JYzrPCQBt+WD1/BYgRNyXA5cGZpK5hODfKwB7ALe/YaAcaGrfpyAHVOc
VporVg2gI1fBz1S/QsoUdzHwdCqDvW//U9J7zfRU3g943q8w6wPXiH7bYAFLfkMK
J1Yrm3WtIhbtTrzDTEkgSGuRH4h65OWOs1esp8huYZP9RIfjjcE4naRSe6yxo5kx
zUCjOPVQtbvllat2CenLmckIg67f1eiyFhR3oNzRswFSnbVt34ar2pjuOp3Xkwcp
0smpULKooQ4kR9hivdSrTuvSvw9e4wCNwRG5fz3MWT3UeNRXx83QyyhaSUisyrlW
8Yt8hJbeGAV0l2UQcJqfa9nlyGtZO/Ty3rYiWGOkPrgRz4fv2j/N0pbFMOOytmNb
Li7Y/+XXJqIoth/S0OEsLrCnDOs1H0FUS+PxQLi0E+DsfE6mws2hc0p2NMlPhdYL
LZwMv6VruIH+qYOgsIWlofxGFM7vlzgqlKhcHCh9PWOpDrwo+8kBAHBu4Q1iT991
AnAEzH8r9s0lwYuL4OkIeoG9VEAO/uc1W7RC7Mi3nCMnEOSDEpDv5oFA8WjSqh0w
pbKiITisXv/QaTU+FM3IJvvqpCXPz7ijq0DvRnFDHh0g2ga8EeTQw42dZLeG3Ftm
Mni3dW7EYkdA9O1/pj1xZ53rSf5Y7RCtk6PFkSIhAlVlJSOCX+A=
=dzYl
-----END PGP SIGNATURE-----

--G/tQsVidLiWZNhno--