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

FAQ