Message-ID: <cfd311ab-692b-4799-9d4c-909d86a267f2@dunslane.net>
Date: Mon, 11 May 2026 08:10:09 -0400
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Random pg_upgrade 004_subscription test failure on drongo
To: Alexander Lakhin <exclusion@gmail.com>
Cc: vignesh C <vignesh21@gmail.com>,
 PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
References: 
 <CALDaNm3tjY44HoSwY84=XGEbTg0ruVfD4hAMTm=TgBqVysH4Qw@mail.gmail.com>
 <644cf995-e3a5-4f69-9398-7db500e2673d@dunslane.net>
 <66fbde27-3c7c-415c-a170-ee52d54190fb@gmail.com>
From: Andrew Dunstan <andrew@dunslane.net>
Content-Language: en-US
Autocrypt: addr=andrew@dunslane.net; keydata=
 xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI
 gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq
 Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C
 eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys
 SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB
 AAHNJEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUubmV0PsLAlwQTAQgAQQIbAwIX
 gAIZAQULCQgHAwUVCgkICwUWAgMBAAIeBRYhBOQ+WEYd/Hy/RGkVpZn6f8tZ/DuBBQJoGNGd
 BQkdEO8nAAoJEJn6f8tZ/DuBq74H/jkTR4Zi3stbw+xC7v2u3QozssK7MYPL2AsVfh7OealS
 h182fiWXpfvmmAB7WUHbhk9GC2RAOnHI/2d2jgKaMLAHsGYOT0YopTVIwRY43fCw/mK67yxc
 wmDcX+zyKfLaivNbf5A7QPLNwda98bEAMSJ8Sn652Uc6cA8t3uKGsVzbRBQOoYzjgvBCfSrE
 9ql3PDNg0l4BfAqabd2f70ZUm9VAMEPrgv/v2xI7M2XiL4g5BVmqLCOwxLM8RMCotCuoweUr
 VO43DeBCIDwLxotMJKvGWDjBzQYlU1NPUAtNcz/gN9ITUe1VUGjyvGj4u1lxBOcQQUw7l1+T
 5moZ4iZxXzvOwE0ETspYWQEIANGc4zQULOxhbqO2dyD51YhqCNRmm9oKWaqf+wmW4tpDe/VV
 cxAnNizd4LWCHfzpb5cHAtGkOPePMfzWVf6nvdF7d3eglbtf59+zG7O7llV0xSSoFiieQBsr
 GvqDInXYX/4mRRXMtyhM353/tixC9RWLs1oofyYmCPPXXY7h9R7en3B8BoVrRFcdzlIY/NFN
 hFGW/9dkEiGjgna2Rk6e15kln4ZvFBWUg23p93w/pqXcxY6+k/8TEk+C4R+M6w7o2PLGOjdZ
 +kPiUcw5H85zf/yZJwQXzisXaNduwWB6Vads9YC9dj6kPR1c4VGRqAaYL++LAEOqrlvm2Tvq
 QqZRtnEAEQEAAcLAfAQYAQgAJgIbDBYhBOQ+WEYd/Hy/RGkVpZn6f8tZ/DuBBQJoGNI2BQkd
 EODdAAoJEJn6f8tZ/DuBfw0IAKTsfD40teP/pp+bsLLMSxPXUYrrprTj7WFB5v61p6dkpSr/
 qXmMlyahdxQFaPmfVgVirB1Vk/kHiWNnnGjfUV9nB2Zg9LI0Xb9/ts3LsUiRWXzG3tkMY6XL
 vsVOxW4XFRND9l2q+WW93aZ1DZl+fqWfYgMvsusFRhmGFOKTRfKPta2Pkv+AhA24N4+PrR5p
 bU4k2MO8PAGiK8eaYKGFG1bHKuAvoDoF7WXJ3FHxuWqLnKEt4dfOLm5pAe3zq1Lt6q8azT9i
 QWGpSAK5vQUWQHBHpiDjdPeqKZ6HiAXIIKfSmb+jrvXBqoP+D6/K7rUjG2aXiRtTIAXms9sm
 VRu7cmw=
In-Reply-To: <66fbde27-3c7c-415c-a170-ee52d54190fb@gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/cfd311ab-692b-4799-9d4c-909d86a267f2%40dunslane.net>
Precedence: bulk


On 2026-05-10 Su 11:00 AM, Alexander Lakhin wrote:
> 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
>
>

The test looked ok as it was on drongo and fairywren, but I have 
loosened it some more on those to see if we can catch the output logs. 
There are other issues with the 004 test at least (The ok test for the 
output directory is wrong if there's a failure). But that can wait for now.


cheers


andrew


--
Andrew Dunstan
EDB: https://www.enterprisedb.com