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 ) id 1vxKfs-008sDt-1j for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Mar 2026 08:00:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vxKfq-005O5y-2n for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Mar 2026 08:00:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vxKfq-005O5q-15 for pgsql-hackers@lists.postgresql.org; Tue, 03 Mar 2026 08:00:11 +0000 Received: from mail-wm1-x32d.google.com ([2a00:1450:4864:20::32d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vxKfl-0000000097E-2vw8 for pgsql-hackers@postgresql.org; Tue, 03 Mar 2026 08:00:09 +0000 Received: by mail-wm1-x32d.google.com with SMTP id 5b1f17b1804b1-48371bb515eso80989185e9.1 for ; Tue, 03 Mar 2026 00:00:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1772524803; x=1773129603; 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=ASnhny/0dlQLmoiBk0sPqRwHsVqdjb66cFCeT5V7KiU=; b=TlYYdq+8TgijGdoHuD61YJGqt8uVETeInuocEpsQoQglYIGNa9+H1mCz4aXggOtWkE 8lI/Zs9LFaLfz+wRmvqspZoaB4BOpevR4jRLXfxQlTf8kG2jetIncwYBgCPOibu7x7Oj Oo7ADAfWms6VK7PQuA3WVE1PSdGL8Fxm0onCMK4oBBnwtBAlzCo89tydB0RX99PJlWGV fjWnp3gbVL1WuatZDDux3J9Mlt7oZXZMraN4YlNnzcjjb7ikKjqYYJfRJOSaLNmqMCMx 2vFyFkMqOIw5jbsvhtYuh7uaW6/E41cxdUqqh5/U9Z9WERB/Mt2ASbuxF/xMlqWsTmcd afnQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772524803; x=1773129603; 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=ASnhny/0dlQLmoiBk0sPqRwHsVqdjb66cFCeT5V7KiU=; b=G/oHJQScX9Cg4zmbdPx2XFlIZ8/9AmWFAp4JaFtvwvAe79/Lvq10fx/TmtfUC7dvIm 15unRHjSZ86eBDhdHMwv3xrvlJCYrvw3wH9hM1MEcWZOA0nvd0RnqSuEeRyBNGyW8LqO TbG++OqFKwZL2rC/koFTu3k7IbILzfpz4FVdshI5q7stir0RWZt667Mn4VqtzEP4lwsN fqYpH7KED2qguxowHL+8KZQptn/rHFNA/26jglgt2KoptCfCUsuLj9I2swCMC3K27aER fs8gpSz6O35N44A873B4ngREqTPCJ7quRuOG2aUQOfwpQUikfHoEDJUbPynv6oAiFxyY jcsw== X-Gm-Message-State: AOJu0YywxdLOxxKWlIUUWKh1w2K+R9uOHjgnug3/SObD/H2qrNsO62St /6oYjszp0Sav7i381joCyM2wiNLetFp5tq2JUyIXK37dum7/y+zrtk59Y7jEyf0M X-Gm-Gg: ATEYQzx+WSfcKwhmK4bet4GUcfH29gBpswu3jmKCkQ0PK6JLDzmSKTjkAe/2JEkm0qg TmbJSyuUpufM8FUOYHata/EbhlKkD+2Wi4kSOfStxQ2VQ7kvVt//5YvQh9y6juXuGmqhuuguf0R +Dcafgnuq4vsBNL5Ual0gpxB+9QBVakl8uFH/sUyJ6zV15UEj+9xz8zU5oXicSGNEAJ2odRbnA/ gOA6Mmn3vziDCFWKcxqzgY4u3U+XgpLLrbQS9cmMGeiyCEBiigmOizua0sdpDb9vmxSUM4PcTTy iXAdYIPOE4CitPLzy2YgqFQVT5iD+xq7LlnrDFFkPpN6Y8M8mtR1pE4lcUZ5Xn5CZRBcpOdWcvh 04QPe6ObZbZ4WTpGEl4MjNPpa+131jPi3LuEnMBFxrrSHMkG36Q5OY0Q6Fzz+QJvqe+vGxZ5cYy nMrBmKf/LaYvQlITKFecUNtzceCWNhAdvTPxE= X-Received: by 2002:a05:600c:4748:b0:483:c35d:367f with SMTP id 5b1f17b1804b1-483c9c0ba58mr270148305e9.21.1772524802694; Tue, 03 Mar 2026 00:00:02 -0800 (PST) Received: from [192.168.0.50] ([89.149.93.164]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-485132f202bsm18758635e9.0.2026.03.03.00.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 03 Mar 2026 00:00:02 -0800 (PST) Content-Type: multipart/alternative; boundary="------------xnh0VPbYrXRDVcGu1k2oU0h1" Message-ID: <493401a8-063f-436a-8287-a235d9e065fc@gmail.com> Date: Tue, 3 Mar 2026 10: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: Michael Paquier , "Hayato Kuroda (Fujitsu)" Cc: pgsql-hackers , Aleksander Alekseev References: <63e55743-669e-4300-a561-7b7ff63723b6@gmail.com> <045cab6f-4738-417e-b551-01adba44d6c3@gmail.com> Content-Language: en-US From: Alexander Lakhin In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------xnh0VPbYrXRDVcGu1k2oU0h1 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Hello Michael, 03.03.2026 08:13, Michael Paquier wrote: > + autovacuum = off > + checkpoint_timeout = 1h > > Why do we need these? An explanation seems in order in the shape of a > commit, or these should be removed. > > Is there a different trick than the one posted at [1] to check the > stability of the proposal? I am wondering if I am missing something, > or if that's all. Alexander? > > [1]:https://www.postgresql.org/message-id/e1cf52d2-c344-4dfd-a918-e5f20ff04fa2@gmail.com There was also a separate test (independent of bgwriter, autovacuum, checkpointer,...) at the top of the thread: [1]. FWIW, 004_timeline_switch also failed the past month in the same way [2]. I've just tested 012_subtransactions.pl with the script I proposed at [3] and it passed 100 iterations (because it performs $node_primary->stop; before $node_standby->promote;, I suppose). [1] https://www.postgresql.org/message-id/b0102688-6d6c-c86a-db79-e0e91d245b1a%40gmail.com [2] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=mandrill&dt=2026-02-07%2006%3A33%3A20 [3] https://www.postgresql.org/message-id/045cab6f-4738-417e-b551-01adba44d6c3%40gmail.com Best regards, Alexander --------------xnh0VPbYrXRDVcGu1k2oU0h1 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
Hello Michael,

03.03.2026 08:13, Michael Paquier wrote:
+	autovacuum = off
+	checkpoint_timeout = 1h

Why do we need these?  An explanation seems in order in the shape of a
commit, or these should be removed.

Is there a different trick than the one posted at [1] to check the
stability of the proposal?  I am wondering if I am missing something,
or if that's all.  Alexander?

[1]: https://www.postgresql.org/message-id/e1cf52d2-c344-4dfd-a918-e5f20ff04fa2@gmail.com

There was also a separate test (independent of bgwriter, autovacuum,
checkpointer,...) at the top of the thread: [1].

FWIW, 004_timeline_switch also failed the past month in the same way [2].
I've just tested 012_subtransactions.pl with the script I proposed at [3]
and it passed 100 iterations (because it performs $node_primary->stop;
before $node_standby->promote;, I suppose).

[1] https://www.postgresql.org/message-id/b0102688-6d6c-c86a-db79-e0e91d245b1a%40gmail.com
[2] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=mandrill&dt=2026-02-07%2006%3A33%3A20
[3] https://www.postgresql.org/message-id/045cab6f-4738-417e-b551-01adba44d6c3%40gmail.com

Best regards,
Alexander
--------------xnh0VPbYrXRDVcGu1k2oU0h1--