Date: Tue, 16 Apr 2024 07:56:35 +0000
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
From: Nicolas Seinlet <nicolas@seinlet.com>
Subject: Re: Failing streaming replication on PostgreSQL 14
Message-ID: <iCjVHvcOYXIzd9YMUrvJkbJoswyKKAs8aQROIv41Oa-2Aj1H4YdvX_WWd_0-5czna8Q44XFZKbW4FFJ7x4dEcgwQ-_egpXN9STRTE1Hd8Yc=@seinlet.com>
In-Reply-To: <202404151649.ypmcghdjuecs@alvherre.pgsql>
References: <202404151649.ypmcghdjuecs@alvherre.pgsql>
Feedback-ID: 32582315:user:proton
MIME-Version: 1.0
Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg=pgp-sha512; boundary="------0c934c9da61ba0f804e9897f907b436cee7f005416799576b2125b5168f175ff"; charset=utf-8
Archived-At: <https://www.postgresql.org/message-id/iCjVHvcOYXIzd9YMUrvJkbJoswyKKAs8aQROIv41Oa-2Aj1H4YdvX_WWd_0-5czna8Q44XFZKbW4FFJ7x4dEcgwQ-_egpXN9STRTE1Hd8Yc%3D%40seinlet.com>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--------0c934c9da61ba0f804e9897f907b436cee7f005416799576b2125b5168f175ff
Content-Type: multipart/mixed;boundary=---------------------f61f82851686f357f294b2c008177224

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

Hello,

> What exactly is "cyphered ZFS"? Can you reproduce the problem with some
> other filesystem? If it's something very unusual, it might well be a
> bug in the filesystem.

The filesystem is openzfs with native aes-256-gcm encryption:
https://openzfs.github.io/openzfs-docs/man/master/7/zfsprops.7.html#encryp=
tion

I've not tested if we get the same issue on another filesystem.

I don't face the issue on Ubuntu 20.04/openzfs 0.8/PostgreSQL 12, but I ha=
ve fewer systems with this deployment.
On Ubuntu 22.04/openzfs 2.1.5/PostgreSQL 14, I face the issue from time to=
 time, without knowing what triggers the error.

thanks for helping,

Nicolas.


-----------------------f61f82851686f357f294b2c008177224
Content-Type: application/pgp-keys; filename="publickey - nicolas@seinlet.com - 0xCAEB7FAF.asc"; name="publickey - nicolas@seinlet.com - 0xCAEB7FAF.asc"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="publickey - nicolas@seinlet.com - 0xCAEB7FAF.asc"; name="publickey - nicolas@seinlet.com - 0xCAEB7FAF.asc"

LS0tLS1CRUdJTiBQR1AgUFVCTElDIEtFWSBCTE9DSy0tLS0tCgp4ak1FWUZIVDJSWUpLd1lCQkFI
YVJ3OEJBUWRBa0NNMkdBOEVFT3BCU0VzZ090NE43VVRMU1JkZFNaaXMKcVZzYk1qb0I3V0xOS1c1
cFkyOXNZWE5BYzJWcGJteGxkQzVqYjIwZ1BHNXBZMjlzWVhOQWMyVnBibXhsCmRDNWpiMjArd284
RUVCWUtBQ0FGQW1CUjA5a0dDd2tIQ0FNQ0JCVUlDZ0lFRmdJQkFBSVpBUUliQXdJZQpBUUFoQ1JD
UnZMTkU1Rnh1QkJZaEJNcnJmNi93QTZwYVZWRXZ5Wkc4czBUa1hHNEVGejBCQUlwNjc1VDcKc3I3
ZXlmM3Y4b1k1aEZPZEd4b3NxOGx1VWdRczdFMlBrRm1NQVB3UDQ1ejFDd3hPdzQ3RWpsV2NaZjNn
CjE5MEN0ZHdpTWRtWVB3UzhNaWpJQnM0NEJHQlIwOWtTQ2lzR0FRUUJsMVVCQlFFQkIwREJGZU5z
QWE2RwoyNHlIbWJhU2lFTk5wRnh3Z3UzbkZzMDFqMVE4Y29obkVRTUJDQWZDZUFRWUZnZ0FDUVVD
WUZIVDJRSWIKREFBaENSQ1J2TE5FNUZ4dUJCWWhCTXJyZjYvd0E2cGFWVkV2eVpHOHMwVGtYRzRF
ZGlNQkFLcE5FWHZTCmErSEo3ZWNKMmhwRmRIRTVXWVArRGcrTHRqQVlQeVVlU1k0ZUFRRFo1cTU4
dkNua3JaNWg3TW1QaUpSdwpDWURhZTZzRjgyN2o0bE83d0FGRUJBPT0KPWV0N0QKLS0tLS1FTkQg
UEdQIFBVQkxJQyBLRVkgQkxPQ0stLS0tLQo=
-----------------------f61f82851686f357f294b2c008177224--

--------0c934c9da61ba0f804e9897f907b436cee7f005416799576b2125b5168f175ff
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: ProtonMail

wnUEARYKACcFgmYeLyMJkJG8s0TkXG4EFiEEyut/r/ADqlpVUS/JkbyzRORc
bgQAAHkAAP0fQUp3r96zdSROJUplJiH3Qh9PTIyaCtSGwuhUTl3tqgEAjY7D
LeF/HrQBl8iJP5yOUlnEgt3JR5iSHFwdsLiddA4=
=EbF3
-----END PGP SIGNATURE-----


--------0c934c9da61ba0f804e9897f907b436cee7f005416799576b2125b5168f175ff--