Message-ID: <66fbde27-3c7c-415c-a170-ee52d54190fb@gmail.com>
Date: Sun, 10 May 2026 18:00:00 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Random pg_upgrade 004_subscription test failure on drongo
To: Andrew Dunstan <andrew@dunslane.net>
References: 
 <CALDaNm3tjY44HoSwY84=XGEbTg0ruVfD4hAMTm=TgBqVysH4Qw@mail.gmail.com>
 <644cf995-e3a5-4f69-9398-7db500e2673d@dunslane.net>
Content-Language: en-US
From: Alexander Lakhin <exclusion@gmail.com>
Cc: vignesh C <vignesh21@gmail.com>,
 PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
In-Reply-To: <644cf995-e3a5-4f69-9398-7db500e2673d@dunslane.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/66fbde27-3c7c-415c-a170-ee52d54190fb%40gmail.com>
Precedence: bulk

Hello Andrew,

13.03.2025 14:19, Andrew Dunstan wrote:
>
> On 2025-03-13 Th 5:04 AM, vignesh C wrote:
>>
>> Unfortunately we don't have pg_upgrade_output.d contents in buildfarm
>> to see what is the exact reason.
>
>
> That's not supposed to happen. I am testing a fix to see if I can make it collect the logs, but for now we'll have to 
> wait till the next failure ..

Windows animals still produce mysterious pg_upgrade/004_subscription
failures: [1] and [2] (and 006_transfer_modes also failed similarly since
then: [3] and [4]). Unluckily, pg_upgrade_output.d/ content is still not
shown in the failure logs, so we can only guess why the tests failed. I
could not reproduce something alike locally, unfortunately — tried
different approaches for several days, but without success, so if we could
see the error/failure reason in the log it would be useful, I hope.

Regarding 006_transfer_modes, I thought the reason we have no
pg_upgrade_output.d/ is that the test removes it explicitly: [5], but I
see no clean_node in 004_subscription, so maybe the log collection is yet
to be fixed in the buildfarm client.

Could you have a look, please?

[1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-05-03%2014%3A03%3A12
[2] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2026-01-12%2000%3A09%3A37
[3] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=drongo&dt=2025-12-28%2003%3A43%3A24
[4] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fairywren&dt=2026-01-14%2010%3A52%3A35
[5] https://www.postgresql.org/message-id/61d3ce85-9c7b-4eea-bf83-81272cab00c3%40gmail.com

Best regards,
Alexander