Thanks for the help Laurenz
After researching on those bugs (this was not exactly the same conditions but the recovery stopped ) we made another
trywith 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
wasnot 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.albe@cybertec.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
