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

Thanks for the help Laurenz

After researching on those bugs (this was not exactly the same conditions but the recovery stopped ) we made another try with a minor version from the primary (14.11) and installed 14.09.
The result was different with the primary connected and streaming 100% on the secondary , with 100% replay achieved , ie :recovery didn't stop working!!

state | streaming
sent_lsn | 8F32/C9A72F18
write_lsn | 8F32/C9A72F18
flush_lsn | 8F32/C9A72F18
replay_lsn | 8F32/C9A72F18

It was running the whole weekend normally without hanging up on syncing, but we detect that one particular table was not synced (the others seems to being updated normally)

Primary

pmx=# select now(), * from tstamp;
-[ RECORD 1 ]-------------------------
now | 2026-06-07 04:27:25.443001-07
tstamp | 2026-06-07 04:27:01.9337-07 ———>here

Secondary
pmx=# select now(), max(time) from activity_log;
-[ RECORD 1 ]----------------------
now | 2026-06-07 04:27:01.368247-07
tstamp | 2026-06-04 18:02:02.446899-07———>here

Did we hit another bug?

> El 5 jun 2026, a las 13:55, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> escribió:
>
> 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