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.94.2) (envelope-from ) id 1sqp6G-00D7fL-80 for pgsql-committers@arkaria.postgresql.org; Wed, 18 Sep 2024 07:27:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sqp6E-005IuM-TQ for pgsql-committers@arkaria.postgresql.org; Wed, 18 Sep 2024 07:27:42 +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.94.2) (envelope-from ) id 1sqp6E-005IrA-HJ for pgsql-committers@lists.postgresql.org; Wed, 18 Sep 2024 07:27:42 +0000 Received: from mail-ej1-x635.google.com ([2a00:1450:4864:20::635]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sqp6A-001mYy-9R for pgsql-committers@lists.postgresql.org; Wed, 18 Sep 2024 07:27:41 +0000 Received: by mail-ej1-x635.google.com with SMTP id a640c23a62f3a-a8d64b27c45so847594666b.3 for ; Wed, 18 Sep 2024 00:27:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1726644457; x=1727249257; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=id0J1Dxt4t1UFMuiqpRYlm0A2X6siT+d3wAkA5L+Iis=; b=C0DghjIz0ZA5Vd7634lbDe+nFvW1xuOi6a9PHPi5pcdveu0M2c1J4uykU2fHVyEEqo UVoyzsPXfO5cRKyLjGfLkDYfn4sXw4yRz+X1o9inFTOTywsSwXisImFbv5fdAVbXVh/9 +Ayhzv2+WIQjAMp2M67Ti5+Obf7M8BH5EkFBrKyWIKSRJmsCHKHDtMVRt0lALnzy2RK6 lGt1l8IsXKCrbbB0iQgzs4rEsR9bDm8R3N1Q3ZDtcq/4/1e/06Ds3kBEvdTAXuxCqD01 2ZsUKW0lkIXZkfUjDLF2fgkg424JDCIUJCjxJncKfVIOvKYC63wskbfNjTwshi5Q0KYh PXbw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726644457; x=1727249257; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=id0J1Dxt4t1UFMuiqpRYlm0A2X6siT+d3wAkA5L+Iis=; b=tgquBMpvYhX92gb4nfnlVx2AzPcgNlEgVDPC2GcyT4I83lxUWzPqtaj0lLrgfkWTi6 gXhwM93NKCW6DJ/xMe8RN7RjDz7lYcSMBu1CD7/ZPitTzBIE1aQEeQqyUK1k60hRNwsl ZFUjWa4JLp/niX/L7GfgI1pbTuvo6ezZxHSTH8/VyoGokzSQL2sa/yql672ft2gGwdkY n5uCoSicsKnnx8I1N3WTwc5ouN19ssks2wK4dP3ENAi7IyR0EXzbOFzLNQ2xnJpz+H6y d/BDAiLOEb9MO0vMdoCm4XBckqkwZbkfUWxOG1F6ZOMCAHOeoYuf+HPgDGP3esKcoH2T ZZ/w== X-Forwarded-Encrypted: i=1; AJvYcCXFdb23TIRlTn9fXIHyBiQ8m4Swmo0jQhMRgltv1dyn1TaHuWoAPCDId2Fcr9POPASkrpg4MyzSOXWei2lRCLwV@lists.postgresql.org X-Gm-Message-State: AOJu0Yx6yKorKIefkHZKiiTfA5z2hCZnC0vRGWinZHYP2N1VZSlUb/WT mkYfJJ3Mp/+zTnEVwltitzO0X6zLhYBrFYTzexwo9mVX9ARHtjQyoxxLJmUkPD0= X-Google-Smtp-Source: AGHT+IFqKF0qat4M9GPrzhi0JsQuT5g3a5moE2N68dhPEbCx93kYpRMhkQO7YS9qa0XuZHPLh2I/Ow== X-Received: by 2002:a17:907:2d87:b0:a8d:7046:a1bd with SMTP id a640c23a62f3a-a9047d03d80mr1471443066b.28.1726644457149; Wed, 18 Sep 2024 00:27:37 -0700 (PDT) Received: from [10.1.138.108] ([88.116.133.170]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-a90612e1a28sm541510466b.152.2024.09.18.00.27.36 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 18 Sep 2024 00:27:36 -0700 (PDT) Message-ID: <57d244a6a2558b8bed0f0297761e998ff66d5a26.camel@cybertec.at> Subject: Re: pgsql: Don't enter parallel mode when holding interrupts. From: Laurenz Albe To: Noah Misch , pgsql-committers@lists.postgresql.org Date: Wed, 18 Sep 2024 09:27:36 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2024-09-18 at 02:58 +0000, Noah Misch wrote: > Don't enter parallel mode when holding interrupts. >=20 > Doing so caused the leader to hang in wait_event=3DParallelFinish, which > required an immediate shutdown to resolve.=C2=A0 Back-patch to v12 (all > supported versions). >=20 > Francesco Degrassi >=20 > Discussion: https://postgr.es/m/CAC-SaSzHUKT=3DvZJ8MPxYdC_URPfax+yoA1hKTc= F4ROz_Q6z0_Q@mail.gmail.com Does that warrant mention on this page? https://www.postgresql.org/docs/current/when-can-parallel-query-be-used.htm= l Yours, Laurenz Albe