Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wVT96-001z5o-3D for pgsql-admin@arkaria.postgresql.org; Fri, 05 Jun 2026 11:55:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wVT95-00C5t0-31 for pgsql-admin@arkaria.postgresql.org; Fri, 05 Jun 2026 11:55:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wVT95-00C5sr-1q for pgsql-admin@lists.postgresql.org; Fri, 05 Jun 2026 11:55:27 +0000 Received: from mail-wm1-x343.google.com ([2a00:1450:4864:20::343]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wVT92-00000001EOo-44EB for pgsql-admin@lists.postgresql.org; Fri, 05 Jun 2026 11:55:26 +0000 Received: by mail-wm1-x343.google.com with SMTP id 5b1f17b1804b1-490be03d47bso15056835e9.0 for ; Fri, 05 Jun 2026 04:55:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1780660523; x=1781265323; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=U1uDp8MHJyCD9e3+LOofHmSjWla1uEolqPJQxu4/o1s=; b=B9RvkDDqWcjihC6nj50RVK5ZJdNDGPafUjbwoGbEl90ltfxQxSv1PoThRp3546tCys RJ9o25+K6XR99qegfHgpu7EmJeg+pKCZNnwYWxKfhejBR8prJuYqnr1wo4d+V4FQ3fsL w2tI8r5A77RXVlwS0VWbN9sbg9tNCFHVLvpSlCrxVrSW28q6EW0lBoQUQXq3YbCiv6Vb czO8FtLuI6NjdQ+SeD0CCWARnyQRkpssDDSFzgr94gCBftkysP0Ci1Knyyi3IJrwiE7B P48Cx/gLBB4Fe4z5E2SlWhhr0pJdcsZ2qITsxS074EgSat7PLbyInpTon9oE/efdM6JT lzlA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1780660523; x=1781265323; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=U1uDp8MHJyCD9e3+LOofHmSjWla1uEolqPJQxu4/o1s=; b=fZ9U3FrNeUuiFI7aj7XPbiE+woBv/5+vDzfYTkrgSUGZ+BsRBT0v5iUFQcXZNAx95m pGqXhSBwwiGBBt2D/z/l65v73245X6bOLX3CO/UOfxsfhUxc+eYWrIiQKkJa2ijHu4dJ K2F8U1FwsFMNbP6l9EORDXJ1Uj9epZgKR54TCLD6r5tVlyxdChHy2mzyxy+kOFacSW/C NRfk2irBG6PI7U0O7e90pQbK9NiOZAarMNRoPdTwK/nPwNtqJe1CD0PgLvSq/kYmcbib Q3R/Z3720+QMj+c/ryPl5jc8CsBS56Kanr3H0rGSrrgBS2jUwDz+aEguNzNoTX/OA3jH /fHQ== X-Gm-Message-State: AOJu0Yz5D9NrOGupdki1yJhJxzIrise5AAQuV4TkKagqaaenFTwF5gO+ nsz5bdKUbJ1uFlhwUs7f2oh7V6QZ/Ab4AXcxSQSX1B5BbR2vszDh1dwkyLhYdJcTgGw= X-Gm-Gg: Acq92OGTGOfoVx0cKV5i92jPJHZqs4kdWaMCNpbV2ptBjJ+ZsVZtho4PrDOJmGB4dWO tydkt3SYvBPZHaTB0gpCyI8d4zcI1xy02IhpFrSsupzJbhdOVc1i4bH9WafmwCuOZt+ltKpU2sB LoLMPWUF8g16oS4549Fxtgqo5fbHBFmnBd7f9WyW49lAV2c3Q+RZmhP7YYGEYjSZAWTpqlVXM9w V442dbplBFJroWCrDHoBUz9RJQ+QOYCY6CUOTCKhM/kdYeDWADQ+4+lPpB+CV2RxJkD3CHEoBSL K7/umeTffOyNPWxzFrG7YhM4H9foaA5OuJj8Eo3j5MzZoB0A88tfVbKtDZaYjmyn4xFdX5GlOEX cneaNAKcdR4mU4VPtD4zuudDiqWc7K4WM3ZzGRRgDOullyeTFYYFG6SX4rX0JRH9ZEcoPNgexIX moUrplJf0Ooibl0EXYdudqo3lbDiUp+bbntomlgMh8OMDY/TW6xsmvKV71WHCY0LY= X-Received: by 2002:a05:600c:4ec7:b0:490:b8ee:d6a5 with SMTP id 5b1f17b1804b1-490c2589927mr51400055e9.6.1780660523449; Fri, 05 Jun 2026 04:55:23 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:3566:69f0:47da:1ef3:b40f]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-4601f35133csm24803367f8f.25.2026.06.05.04.55.22 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 05 Jun 2026 04:55:23 -0700 (PDT) Message-ID: <73b83be06076b61cbd462295ce66fe31b4743966.camel@cybertec.at> Subject: Re: Pg14 replication issue , recovery stucks in a random file without advancing while streaming from primary From: Laurenz Albe To: Jorge Daniel Cc: "pgsql-admin@lists.postgresql.org" , "geoff.tolley@gmail.com" Date: Fri, 05 Jun 2026 13:55:22 +0200 In-Reply-To: <1E10296C-9491-464F-86EC-8A9357AAB12F@hotmail.com> References: <1E10296C-9491-464F-86EC-8A9357AAB12F@hotmail.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2026-06-05 at 10:00 +0000, Jorge Daniel wrote: > We tried on our first 3 attempts, then we downgraded to mirror the Primar= y Version , then we downgraded the OS version .=20 > We tried so far this combinations :=20 >=20 > * Ubuntu 24.04 + PG 14.23=C2=A0 and with=C2=A0 2 different storage device= s (suspecting=C2=A0 about an issue in=C2=A0 the disk layer ) > * Ubuntu 24.04 + PG=C2=A0 14.11=20 > * Ubuntu 22.04 + PG=C2=A0 14.11 -> Same versions of the Primary=20 >=20 > In all these environments=C2=A0 we had the same result : stopped replayin= g wal-files while still receiving via streaming .=20 > No log lines about it ,none >=20 > We never saw this scenario ever=20 Perhaps you are suffering from this bug [1] up to 14.22 and from this bug [= 2] in 12.23 (which was introduced by the previous bugfix). Yours, Laurenz Albe [1]: https://postgr.es/m/flat/CACV2tSw3VYS7d27ftO_cs%2BaF3M54%2BJwWBbqSGLc= KoG9cvyb6EA%40mail.gmail.com [2]: https://postgr.es/m/flat/19490-9c59c6a583513b99%40postgresql.org