pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Alexander Lakhin <exclusion@gmail.com>
To: Hayato Kuroda (Fujitsu) <kuroda.hayato@fujitsu.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: Aleksander Alekseev <aleksander@timescale.com>
Subject: Re: BUG: Former primary node might stuck when started as a standby
Date: Thu, 12 Feb 2026 21:00:00 +0200
Message-ID: <cfd35cfb-3216-42b1-814b-cc658fd0f099@gmail.com> (raw)
In-Reply-To: <OS9PR01MB12149E6917AAC1560150B918BF565A@OS9PR01MB12149.jpnprd01.prod.outlook.com>
References: <b0102688-6d6c-c86a-db79-e0e91d245b1a@gmail.com>
	<CAJ7c6TOqnv7cZ53RfBv9towSDzNOUVQ74WzPeN7LwoKMuW4tOA@mail.gmail.com>
	<74ea5e7e-9aa0-4d7a-85df-71a9d200a8d8@gmail.com>
	<CAJ7c6TO-_=rfN0Mb1RrChmrQvLtXoWw9aDezwC9g48-Va3E2EQ@mail.gmail.com>
	<180bf13e-235d-46a9-9788-7d6cee40bcdc@gmail.com>
	<OS9PR01MB12149E6917AAC1560150B918BF565A@OS9PR01MB12149.jpnprd01.prod.outlook.com>

Dear Kuroda-san,

09.02.2026 04:38, Hayato Kuroda (Fujitsu) wrote:
>
> Dear Alexander, Aleksander
>
> Is it enough that we can wait till all WALs are replayed before the promotion?
>
> Like attached.
>
>

Thank you for paying attention to this!

I tried to add
$primary->wait_for_replay_catchup($standby);
in my test (see attached), but that doesn't help -- it still fails as below:
iteration 61
# +++ tap check in src/test/recovery +++
t/099_change_roles.pl .. 1/? make: *** [Makefile:28: check] Terminated

src/test/recovery/tmp_check/log/099_change_roles_node1.log
2026-02-12 20:30:42.953 EET [2716149] LOG:  new timeline 4 forked off current database system timeline 3 before current 
recovery point 0/3025B48

Best regards,
Alexander

Attachments:

  [application/x-perl] 099_change_roles.pl (2.0K, ../cfd35cfb-3216-42b1-814b-cc658fd0f099@gmail.com/3-099_change_roles.pl)
  download

view thread (30+ messages)  latest in thread

Message-ID: <cfd35cfb-3216-42b1-814b-cc658fd0f099@gmail.com>
Permalink:  ../cfd35cfb-3216-42b1-814b-cc658fd0f099@gmail.com/
Also on:    postgresql.org/message-id/cfd35cfb-3216-42b1-814b-cc658fd0f099@gmail.com

 · 

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: pgsql-hackers@postgresql.org
  Cc: exclusion@gmail.com, kuroda.hayato@fujitsu.com, aleksander@timescale.com
  Subject: Re: BUG: Former primary node might stuck when started as a standby
  In-Reply-To: <cfd35cfb-3216-42b1-814b-cc658fd0f099@gmail.com>

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

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