Content-Type: multipart/alternative;
 boundary="------------SD1xwmDqfePqv2onwddFcTbU"
Message-ID: <a99bd177-00e3-4512-ba7c-29e180926467@gmail.com>
Date: Tue, 17 Mar 2026 08:00:00 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP
 DATABASE
To: =?UTF-8?B?SXdhdGEsIEF5YS/lsqnnlLAg5b2p?= <iwata.aya@fujitsu.com>,
 Michael Paquier <michael@paquier.xyz>
Cc: Peter Smith <smithpb2250@gmail.com>,
 =?UTF-8?B?S3Vyb2RhLCBIYXlhdG8v6buS55SwIOmavOS6ug==?=
 <kuroda.hayato@fujitsu.com>, Pavel Stehule <pavel.stehule@gmail.com>,
 Chao Li <li.evan.chao@gmail.com>,
 pgsql-hackers <pgsql-hackers@postgresql.org>
References: 
 <CAHut+PvP6H2soK05c_0JZC8--=h4nWEtxYE_nJGjRkQr=25F1w@mail.gmail.com>
 <aVs3IpiYjmq3gLEn@paquier.xyz>
 <CAHut+PtSVYKU4vfaRev4FMdbeZ3ukvxRy4X7uK05jv_9WMYafA@mail.gmail.com>
 <OS7PR01MB1196426354C0294148A06AC65EA86A@OS7PR01MB11964.jpnprd01.prod.outlook.com>
 <CAHut+PtZh+B_-z_TzmToUhL4-sBrf7dfH0uAb7VU-jkXFmHQSA@mail.gmail.com>
 <aVyfvgMplnc6aIE2@paquier.xyz>
 <OS3PR01MB8889505E2F3E443CCA4BD72EEA45A@OS3PR01MB8889.jpnprd01.prod.outlook.com>
 <abev_E-SE94zHP0n@paquier.xyz> <abiUQ5MBGG9MDM1h@paquier.xyz>
 <TYRPR01MB12156CA129F54361D19ECAB56F541A@TYRPR01MB12156.jpnprd01.prod.outlook.com>
 <abjRR1bhoa9N8XEa@paquier.xyz>
Content-Language: en-US
From: Alexander Lakhin <exclusion@gmail.com>
In-Reply-To: <abjRR1bhoa9N8XEa@paquier.xyz>
Archived-At: 
 <https://www.postgresql.org/message-id/a99bd177-00e3-4512-ba7c-29e180926467%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------SD1xwmDqfePqv2onwddFcTbU
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Hello Michael and Iwata-san,

17.03.2026 05:57, Michael Paquier wrote:
> On Tue, Mar 17, 2026 at 01:55:05AM +0000, Kuroda, Hayato/黒田 隼人 wrote:
>> I also had a discussion with her off-list, but I could not find neither.
>> Additional idea is to increase the log level to make analysis easier, but not
>> sure what value is appropriate. Is it enough to raise to DEBUG1?
> That would be an option.  Let's do that if we see another failure
> after disabling autovacuum.  Another thing I have noticed is
> debug_parallel_query=regress for this animal, which may encourage
> parallel workers, so I have also disabled it.  Let's see first if we
> get more failures after af8837a10bc7.
> --

I've noticed another failure of the test from widowbird: [1]. But probably
it's not related to f1e251be8 directly, as widowbird failed with a similar
error before: [2]. I couldn't reproduce such failures yet, but keep
trying in the background...

[1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=widowbird&dt=2026-03-16%2009%3A35%3A03
[2] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=widowbird&dt=2025-10-25%2010%3A35%3A03

Best regards,
Alexander
--------------SD1xwmDqfePqv2onwddFcTbU
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">Hello Michael and Iwata-san,<br>
      <br>
      17.03.2026 05:57, Michael Paquier wrote:<br>
    </div>
    <blockquote type="cite" cite="mid:abjRR1bhoa9N8XEa@paquier.xyz">
      <pre wrap="" class="moz-quote-pre">On Tue, Mar 17, 2026 at 01:55:05AM +0000, Kuroda, Hayato/黒田 隼人 wrote:
</pre>
      <blockquote type="cite">
        <pre wrap="" class="moz-quote-pre">I also had a discussion with her off-list, but I could not find neither.
Additional idea is to increase the log level to make analysis easier, but not
sure what value is appropriate. Is it enough to raise to DEBUG1?
</pre>
      </blockquote>
      <pre wrap="" class="moz-quote-pre">
That would be an option.  Let's do that if we see another failure
after disabling autovacuum.  Another thing I have noticed is
debug_parallel_query=regress for this animal, which may encourage
parallel workers, so I have also disabled it.  Let's see first if we
get more failures after af8837a10bc7.
--
</pre>
    </blockquote>
    <br>
    I've noticed another failure of the test from widowbird: [1]. But
    probably<br>
    it's not related to f1e251be8 directly, as widowbird failed with a
    similar<br>
    error before: [2]. I couldn't reproduce such failures yet, but keep<br>
    trying in the background...<br>
    <br>
    [1]
<a class="moz-txt-link-freetext" href="https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=widowbird&amp;dt=2026-03-16%2009%3A35%3A03">https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=widowbird&amp;dt=2026-03-16%2009%3A35%3A03</a><br>
    [2]
<a class="moz-txt-link-freetext" href="https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=widowbird&amp;dt=2025-10-25%2010%3A35%3A03">https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=widowbird&amp;dt=2025-10-25%2010%3A35%3A03</a><br>
    <br>
    Best regards,<br>
    Alexander<br>
  </body>
</html>

--------------SD1xwmDqfePqv2onwddFcTbU--