Re: Pg14 replication issue , recovery stucks in a random file without advancing while streaming from primary
Re: Pg14 replication issue , recovery stucks in a random file without advancing while streaming from primary
От:
Laurenz Albe <laurenz.albe@cybertec.at>
Дата:
On Thu, 2026-06-04 at 21:13 +0000, Jorge Daniel wrote: > server_version | 14.11 (Ubuntu 14.11-0ubuntu0.22.04.1) Try again with 14.23. Yours, Laurenz Albe
Re: Pg14 replication issue , recovery stucks in a random file without advancing while streaming from primary
От:
Jorge Daniel <elgaita@hotmail.com>
Дата:
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 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