Date: Tue, 16 Mar 2021 17:40:17 +0900
From: Michael Paquier <michael@paquier.xyz>
To: =?utf-8?B?0K/RgNC+0YHQu9Cw0LIg0J/QsNGI0LjQvdGB0LrQuNC5?=
 <yarik97.6@gmail.com>
Cc: Postgres bugs <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #16927: Postgres can`t access WAL files
Message-ID: <YFBu8b4dH32kQwDG@paquier.xyz>
References: <16927-67c570d968c99567@postgresql.org>
 <YFAH1LbeUeXTFcEM@paquier.xyz>
 <CADLmToLD6a=eXvh+b6u+Ju5Bm2ZvtCHBnCqY_d8U9we+315HZg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="gNxEmBrGWnZ0t2Zz"
Content-Disposition: inline
In-Reply-To: 
 <CADLmToLD6a=eXvh+b6u+Ju5Bm2ZvtCHBnCqY_d8U9we+315HZg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/YFBu8b4dH32kQwDG%40paquier.xyz>
Precedence: bulk


--gNxEmBrGWnZ0t2Zz
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

(Please keep pgsql-bugs in CC of this thread)

On Tue, Mar 16, 2021 at 10:16:29AM +0200, =D0=AF=D1=80=D0=BE=D1=81=D0=BB=D0=
=B0=D0=B2 =D0=9F=D0=B0=D1=88=D0=B8=D0=BD=D1=81=D0=BA=D0=B8=D0=B9 wrote:
> 2021-03-15 00:08:20.563 EET [9936] LOG:  could not rename temporary
> statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat":
> Permission denied

This pattern is new.

> I got this error also after updating from 9.6 to 13.2

Oh, sorry, I did not understand your last message as you used the word
"updating", which sounded like you ran a set of minor updates for
multiple servers and saw the same issue across all those versions.
But what you mean is that you did one major upgrade, from 9.6 to 13.

> So, the solution could be to rollback to 9.6 and then update to 12.X
> version?

There has been a collection of reports lately with 13.X misbehaving
when it comes to the recycling of WAL segments:
https://www.postgresql.org/message-id/3861ff1e-0923-7838-e826-094cc9bef737@=
hot.ee
https://www.postgresql.org/message-id/16874-c3eecd319e36a2bf@postgresql.org
https://www.postgresql.org/message-id/095ccf8d-7f58-d928-427c-b17ace23cae6@=
burgess.co.nz

Your report is the 4th one of its kind, and based on the data
collected up to now, 12.X or older major versions do not see the
issue.  I have begun a thread about the problem on -hackers, that's
too much to be a coincidence, and more than one version of Windows
sees the problem:
https://www.postgresql.org/message-id/YFBcRbnBiPdGZvfW@paquier.xyz
--
Michael

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

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

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmBQbvEACgkQnvQgOdby
QH0b2Q//V5KmeyMia7f/N6wQ13nh+wuelanotz97VXHktXOf2ZyiKwm+7zAdbjoB
3+Nky16TliXeVFyJg7N0nqFd4o9GEKxdfUNTI4xsAA4LDxS3E9auZhnGsvCGJjA7
r9SdSfwzJMwRJEIUi7dDU6iTJsEoWE+E+23iRZzIYoC0WJGOU7FFvqUu8IEuyc2k
DoYl428JbIEPO242mZxVewhKWX/N2USOu/MlnMel0p5jpNEYEjx376y04BW9NfT1
L967xgsW5h7YHBiv+SozaH7XrESAl30QSQwkqi62dzHu9kM8XS+C0Orkdsac8Oyh
Z6eSq0go86Zw20hbjt/8BYPLif7L77tJUXmfuKKXvHXqg6ZD6Nbzz/hkPrHAGVwt
FoWa4QfLp+kgW2uD/SWcuV6h/LAp9vEQbAiM2LE7mvBZvwXg9uwV40OqA4TPuUoF
iAbY6OGdaz6dOdKc1IZvigyn3YQTpe8Zgt3Ofmn8YCJFtaJYRljna2c9stzGTbfL
k/Vc8T4iedEobLlwCA5/w6XdkdLuPfrVyx7Yl4XceptdLwXNQ07mb2HUvw07gJlC
1lNGoupf8i4FDHUi+tvpA8bGO+tnXWj63dprKeuf35PcnpSM+Bo7+FiPe01r4/Wl
fCsoJm1w0c0iPFcrk+f3QP4JH2CCaOhJ19donGQcc5mPsuoQnG0=
=3GSp
-----END PGP SIGNATURE-----

--gNxEmBrGWnZ0t2Zz--