Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vqbv6-00EJU3-2t
	for pgsql-hackers@arkaria.postgresql.org;
	Thu, 12 Feb 2026 19:00:10 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vqbv5-00AXIF-0j
	for pgsql-hackers@arkaria.postgresql.org;
	Thu, 12 Feb 2026 19:00:08 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <exclusion@gmail.com>)
	id 1vqbv4-00AXI5-2g
	for pgsql-hackers@lists.postgresql.org;
	Thu, 12 Feb 2026 19:00:07 +0000
Received: from mail-wm1-x335.google.com ([2a00:1450:4864:20::335])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.98.2)
	(envelope-from <exclusion@gmail.com>)
	id 1vqbv3-00000000Mbg-1Z8S
	for pgsql-hackers@postgresql.org;
	Thu, 12 Feb 2026 19:00:07 +0000
Received: by mail-wm1-x335.google.com with SMTP id
 5b1f17b1804b1-4807068eacbso1279735e9.2
        for <pgsql-hackers@postgresql.org>;
 Thu, 12 Feb 2026 11:00:04 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1770922803; x=1771527603;
 darn=postgresql.org;
        h=in-reply-to:from:content-language:references:cc:to:subject
         :user-agent:mime-version:date:message-id:from:to:cc:subject:date
         :message-id:reply-to;
        bh=/nUv4N6fZRs22bJV/3wxpppkZymr94Xrp/2NIhtCdmo=;
        b=XeWY1HSk51eEYjyshj0KXH4JHxVXK7/1KVki9tQCKQ7q8wkCSY/1ZMPf6Y1ef6r9/j
         Elt61XQuqkcRlGRxujRfZ0P9+OwFXRZASqf4OjLkgb3k6PKfzpRTzaO2x20f7DrZ8Aq2
         haMsM7GCr7xK2dA7oLmWwDqIV6m4EeSJDUMcQ5baZgq2YAkD4WbZSDK4Qmm5SSm98YjF
         A9rVcUHJ+foD+BYy1oUydphMkOJcntADx+NetjOg6sqIXjavdOFD0zU2eC7FbVqcgKQK
         f3PHJ1D8NXFw69JOXBMBJQayrqUCuHfPrNXSie465xu6MD2k3LxilI7Uq1LasL3zYA76
         PAmg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1770922803; x=1771527603;
        h=in-reply-to:from:content-language:references:cc:to:subject
         :user-agent:mime-version:date:message-id:x-gm-gg:x-gm-message-state
         :from:to:cc:subject:date:message-id:reply-to;
        bh=/nUv4N6fZRs22bJV/3wxpppkZymr94Xrp/2NIhtCdmo=;
        b=tZZgId9WTVOBznojSmME6sT1deggKKsLoLfLxQTGqRsxp598AAMBQvccI5aWeE2bYc
         qKtToYdKJILGQqbD8wb6zjB9IjR3Me9T1/VshBnWlKBYw8Kpo2gN1h8a8614yUis4LXu
         DaqcSaukNgr8tbo2oHre97XbBmhd5ndP2bRDAqPA9pJ9f+Q3qJzWoGZPxQcfi1XrLw/O
         YOLuIvM+9eNh+dyu7YkQNCO4TQSKG7B+R0RVusEYus6pLvOPiCAA3rRqc+Rr5X5qQCSW
         HtUonhmbGDa2tff7E5tqRk20CGMWHxlYSo6v9xNUMbDKOCbYenZgtxxVlH8PhLwaVbGd
         KdOQ==
X-Gm-Message-State: AOJu0Yy0J+NbqvIElNxkKE7lmydHmet54c9vBCTMI/Bo3xJXGXLx1ex/
	s8Cg9clMY7JGJoI+k/tl+AEkdtF0GEKV+KmmCPIG+iiUz/fQlsYt3uYs
X-Gm-Gg: AZuq6aJVWazPUM0wCHWGvR3XFqXlsuGQOInQaxfk3L/Rux/QOViUPh6c3ebS3XeVaY8
	eF1NEPUCR2m9XIrDpcuIAvCCHymupFXp9zf0OzHfkCEPL+DqTrHIkZ/KViaik3Y+Rf7QkY1DPwX
	td2LwWbquWBrUWQDD2VKLyfxdIwWAUQHXAh0y4RndrWOEeHp0GBY1tgrOHR4tSv+iPT04ZVn8DG
	2KAeB4UizMmCmWt+4TMOO5dgMRNO79R2EKKFf/G7Uygnf0IuSkfMYqiv4nKr7xueGMUfn7P8tCN
	Ae9JQR3/qs8XcxfhfvuZBTINGH+Tx4cIX9IPqTwb9rdIEY0g1jolGMT9CtRIH9pYMtprAGiK98T
	OL9sUU5NRxpuvSNGF3FvKLs7TcwM2r1NqCrVhn/j3pwMMc1dxZt2Ffuh4g+SR1ZUUslbl8+UDN+
	2iRl9sEb68LU88BU/P9FOJrDg7
X-Received: by 2002:a05:600c:1c12:b0:480:6ab1:ed0d with SMTP id
 5b1f17b1804b1-48370e21259mr2877835e9.9.1770922802602;
        Thu, 12 Feb 2026 11:00:02 -0800 (PST)
Received: from [192.168.0.50] ([89.149.93.164])
        by smtp.gmail.com with ESMTPSA id
 5b1f17b1804b1-4834d5d77f9sm227899305e9.3.2026.02.12.11.00.01
        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);
        Thu, 12 Feb 2026 11:00:01 -0800 (PST)
Content-Type: multipart/mixed; boundary="------------qkZKJHNb7cv2tDSvEXdQyJeg"
Message-ID: <cfd35cfb-3216-42b1-814b-cc658fd0f099@gmail.com>
Date: Thu, 12 Feb 2026 21:00:00 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: BUG: Former primary node might stuck when started as a standby
To: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>,
 Aleksander Alekseev <aleksander@timescale.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>
Content-Language: en-US
From: Alexander Lakhin <exclusion@gmail.com>
In-Reply-To: 
 <OS9PR01MB12149E6917AAC1560150B918BF565A@OS9PR01MB12149.jpnprd01.prod.outlook.com>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/cfd35cfb-3216-42b1-814b-cc658fd0f099%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------qkZKJHNb7cv2tDSvEXdQyJeg
Content-Type: multipart/alternative;
 boundary="------------wauAxdmhPNwswW5PTu2eyd1j"

--------------wauAxdmhPNwswW5PTu2eyd1j
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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
--------------wauAxdmhPNwswW5PTu2eyd1j
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">Dear Kuroda-san,<br>
      <br>
      09.02.2026 04:38, Hayato Kuroda (Fujitsu) wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:OS9PR01MB12149E6917AAC1560150B918BF565A@OS9PR01MB12149.jpnprd01.prod.outlook.com">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <meta name="Generator"
        content="Microsoft Word 15 (filtered medium)">
      <style>@font-face
	{font-family:"ＭＳ ゴシック";
	panose-1:2 11 6 9 7 2 5 8 2 4;}@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
	{font-family:游ゴシック;
	panose-1:2 11 4 0 0 0 0 0 0 0;}@font-face
	{font-family:"ＭＳ Ｐゴシック";
	panose-1:2 11 6 0 7 2 5 8 2 4;}@font-face
	{font-family:"\@ＭＳ Ｐゴシック";}@font-face
	{font-family:"\@游ゴシック";
	panose-1:2 11 4 0 0 0 0 0 0 0;}@font-face
	{font-family:"\@ＭＳ ゴシック";
	panose-1:2 11 6 9 7 2 5 8 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0mm;
	font-size:12.0pt;
	font-family:"ＭＳ Ｐゴシック";}.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;
	mso-ligatures:none;}div.WordSection1
	{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026">
<v:textbox inset="5.85pt,.7pt,5.85pt,.7pt" />
</o:shapedefaults></xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal"><span lang="EN-US"
            style="font-size:11.0pt;font-family:游ゴシック">Dear Alexander,
            Aleksander<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"
            style="font-size:11.0pt;font-family:游ゴシック"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"
            style="font-size:11.0pt;font-family:游ゴシック">Is it enough that
            we can wait till all WALs are replayed before the promotion?<o:p></o:p></span></p>
        <p class="MsoNormal"><span lang="EN-US"
            style="font-size:11.0pt;font-family:游ゴシック">Like attached.<o:p></o:p></span></p>
        <p class="MsoNormal"><br>
        </p>
      </div>
    </blockquote>
    <br>
    Thank you for paying attention to this!<br>
    <br>
    I tried to add<br>
    $primary-&gt;wait_for_replay_catchup($standby);<br>
    in my test (see attached), but that doesn't help -- it still fails
    as below:<br>
    iteration 61<br>
    # +++ tap check in src/test/recovery +++<br>
    t/099_change_roles.pl .. 1/? make: *** [Makefile:28: check]
    Terminated<br>
    <br>
    src/test/recovery/tmp_check/log/099_change_roles_node1.log<br>
    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<br>
    <br>
    Best regards,<br>
    Alexander<br>
  </body>
</html>

--------------wauAxdmhPNwswW5PTu2eyd1j--

--------------qkZKJHNb7cv2tDSvEXdQyJeg
Content-Type: application/x-perl; name="099_change_roles.pl"
Content-Disposition: attachment; filename="099_change_roles.pl"
Content-Transfer-Encoding: 7bit

use strict;
use warnings FATAL => 'all';

use PostgreSQL::Test::Cluster;
use PostgreSQL::Test::Utils;
use Test::More;

use IPC::Run;
use threads;
use threads::shared;

sub bgactivity
{
	my @args = @_;
	my ($n, $port, $db_name) = @args;
	$SIG{'KILL'} = sub { print("Thread killed.\n"); threads->exit(); };

	my $try = 1;
	while (1)
	{
		my ($stdout, $stderr);
		my $cmd = [ 'psql', '-h', $ENV{'PGHOST'}, '-p', $port, '-d', $db_name, '-c', "INSERT INTO t VALUES (1000 * $n + $try, 'background activity');" ];
		my $result = IPC::Run::run($cmd, '>', \$stdout, '2>', \$stderr);
		$try += 1;
		sleep(0.001);
	}
}

# Set up two replication nodes, which will switch roles.

my $node1 = PostgreSQL::Test::Cluster->new("node1");
$node1->init(allows_streaming => 1);
$node1->start;
$node1->backup('initial_backup');

my $node2 = PostgreSQL::Test::Cluster->new('node2');
$node2->init_from_backup($node1, 'initial_backup', has_streaming => 1);
$node2->start;

$node1->psql('postgres', "ALTER SYSTEM SET synchronous_standby_names = 'node2'; SELECT pg_reload_conf()");
$node2->psql('postgres', "ALTER SYSTEM SET synchronous_standby_names = 'node1'; SELECT pg_reload_conf()");

$node1->psql('postgres', "CREATE TABLE t(id int, message text)");

my $numthreads = 2;
my @threads;
foreach my $ti (1 .. $numthreads)
{
    push @threads, threads->create('bgactivity', $ti, $node1->port, 'postgres');
}

for (my $i = 1; $i <= 20; $i++)
{
my ($primary, $standby) = ($node1, $node2);

$primary->safe_psql('postgres', "INSERT INTO t VALUES ($i, 'inserted on node1');");

# change roles
$primary->wait_for_replay_catchup($standby);
$primary->teardown_node;
$standby->promote;

$primary->enable_streaming($standby);
$primary->start;

($primary, $standby) = ($node2, $node1);

$primary->safe_psql('postgres', "INSERT INTO t VALUES ($i, 'inserted on node2');");

# change roles back
$primary->wait_for_replay_catchup($standby);
$primary->teardown_node;
$standby->promote;

$primary->enable_streaming($standby);
$primary->start;

ok(1);
}

for my $thread (@threads)
{
	$thread->kill('KILL')->detach;
}

done_testing();

--------------qkZKJHNb7cv2tDSvEXdQyJeg--