Re: Pg14 replication issue , recovery stucks in a random file without advancing while streaming from primary

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Jorge Daniel <elgaita(at)hotmail(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>, "geoff(dot)tolley(at)gmail(dot)com" <geoff(dot)tolley(at)gmail(dot)com>
Subject: Re: Pg14 replication issue , recovery stucks in a random file without advancing while streaming from primary
Date: 2026-06-05 11:55:22
Message-ID: 73b83be06076b61cbd462295ce66fe31b4743966.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 Primary Version , then we downgraded the OS version .
> We tried so far this combinations :
>
> * Ubuntu 24.04 + PG 14.23  and with  2 different storage devices (suspecting  about an issue in  the disk layer )
> * Ubuntu 24.04 + PG  14.11
> * Ubuntu 22.04 + PG  14.11 -> Same versions of the Primary
>
> In all these environments  we had the same result : stopped replaying wal-files while still receiving via streaming .
> No log lines about it ,none
>
> We never saw this scenario ever

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%2BJwWBbqSGLcKoG9cvyb6EA%40mail.gmail.com
[2]: https://postgr.es/m/flat/19490-9c59c6a583513b99%40postgresql.org

In response to

Browse pgsql-admin by date

  From Date Subject
Previous Message Jorge Daniel 2026-06-05 10:00:31 Re: Pg14 replication issue , recovery stucks in a random file without advancing while streaming from primary