public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jorge Daniel <[email protected]>
To: Laurenz Albe <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Pg14  replication issue , recovery stucks in a random file without advancing  while streaming from primary
Date: Mon, 8 Jun 2026 10:28:42 +0000
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

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 <[email protected]> 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

view thread (6+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Pg14  replication issue , recovery stucks in a random file without advancing  while streaming from primary
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox