Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkGfy-0004Jq-An for pgsql-bugs@arkaria.postgresql.org; Wed, 02 Dec 2020 01:11:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kkGfw-0005WP-M0 for pgsql-bugs@arkaria.postgresql.org; Wed, 02 Dec 2020 01:11:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkGfv-0005WB-S7 for pgsql-bugs@lists.postgresql.org; Wed, 02 Dec 2020 01:11:20 +0000 Received: from mx0b-002e3701.pphosted.com ([148.163.143.35]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkGfr-0003rO-O4 for pgsql-bugs@lists.postgresql.org; Wed, 02 Dec 2020 01:11:18 +0000 Received: from pps.filterd (m0134423.ppops.net [127.0.0.1]) by mx0b-002e3701.pphosted.com (8.16.0.42/8.16.0.42) with SMTP id 0B218lvU027036; Wed, 2 Dec 2020 01:11:12 GMT DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hpe.com; h=from : to : cc : subject : date : message-id : references : in-reply-to : content-type : content-transfer-encoding : mime-version; s=pps0720; bh=cNZfLV9nZ2Osi4E+8TTvYeKbmlzF3uL7Cv0jrkRoEcg=; b=iMczRYm8L1NN5wIdyjOs4QAPiWHJ4Yoxd0qfIrq3vsl2/Ij15y3RfT9H0p2kktEPMYvs RRLAXVQXoXiycmHWzZMqExTzYrnQJwlyzWzFK0pdgp8Zjo0Fr19asg71f1HoDyOoPGoW 86u2hU3BxmjNqBGoejMnY0ofbcqtEUtCbdPiY0sE2qkdkA/p0roXJ0m11ANVBn6ZlcfV +hLUZgBmrmJRsPPPz/KtqV9ZNDpddL3E7QXtOQrq+whWzQvYMwzfXqiGza6zVXCCCgqi S85n4J1VfLIbUr9V8MWbudaNB7WQInp+ULSVkeOPY7oBykYVPMd5+jBzM59z25E4ufIw mA== Received: from g4t3426.houston.hpe.com (g4t3426.houston.hpe.com [15.241.140.75]) by mx0b-002e3701.pphosted.com with ESMTP id 355j55fmj9-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Wed, 02 Dec 2020 01:11:10 +0000 Received: from G4W9119.americas.hpqcorp.net (g4w9119.houston.hp.com [16.210.20.214]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-SHA384 (256/256 bits)) (No client certificate requested) by g4t3426.houston.hpe.com (Postfix) with ESMTPS id AD6C24E; Wed, 2 Dec 2020 01:11:09 +0000 (UTC) Received: from G1W8107.americas.hpqcorp.net (2002:10c1:483b::10c1:483b) by G4W9119.americas.hpqcorp.net (2002:10d2:14d6::10d2:14d6) with Microsoft SMTP Server (TLS) id 15.0.1497.2; Wed, 2 Dec 2020 01:11:09 +0000 Received: from NAM02-BL2-obe.outbound.protection.outlook.com (15.241.52.10) by G1W8107.americas.hpqcorp.net (16.193.72.59) with Microsoft SMTP Server (TLS) id 15.0.1497.2 via Frontend Transport; Wed, 2 Dec 2020 01:11:09 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=dQbHELWyVpmaB3qgCiVqTvO4KJM+wqOukDnl9PDPsxHTDEqqQyPOJzXZ7oGxEDnnKyRj53lYazzZROoyM/78Q36RnpYlsJbRTl/tUvbpX1H3wrqigDBIUq/+9EU8cQmObscdJ7g4L0sYIjwXgncX8/sLGJhrRoErHPLlrsB37KBMJIcP1W09lc+BhgN614Q3jyAWBV5aQ8iRNDJ/z07tqJTZMmU3PluLMoL6bCfoeHIkbichgGUBv+XKBDbw7OND7vl3LMFxMEBSlWbPoV5IZGYy3r70R2Vy7KMT7wIt/eu74B5PeS3RQlctBonVCmDV/N0kFZlzg1PQayeRMU1qUw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=cNZfLV9nZ2Osi4E+8TTvYeKbmlzF3uL7Cv0jrkRoEcg=; b=L3PtG9lZK88dkgb2bvRhiMtGcrVjhdPEZLZSHF1rKyB/9ig6GGguB4qqHubtbZJhoN40Ln9JMfJ0y1922FMSQPl875bjmekVUJAZNPOoPj0dj0dJN70JIpv/Z4sfr4AwTruS4qn5gpIv5AO8Cyeb66edF+b/vWe5ksyAc6wMJb/XOQCCKwWeLB/NRmMtDmlN2hTfDmHNM/WSkQjqwNqz8UWYJTVNgfsvcEGqCNUyLGi7fvZ4ZpK1VlSaTNNS1dIQlwr1A6WuOSZjJFS/GiC7UPa3M0QdKrI6MyGXHoZNQGMvkwCPY4RrVpLVWU5m7FKmTiItrwAgROkZeSyYAZPBNA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=hpe.com; dmarc=pass action=none header.from=hpe.com; dkim=pass header.d=hpe.com; arc=none Received: from TU4PR8401MB1152.NAMPRD84.PROD.OUTLOOK.COM (2a01:111:e400:7716::20) by TU4PR8401MB0494.NAMPRD84.PROD.OUTLOOK.COM (2a01:111:e400:7709::17) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3611.25; Wed, 2 Dec 2020 01:11:07 +0000 Received: from TU4PR8401MB1152.NAMPRD84.PROD.OUTLOOK.COM ([fe80::659b:8e33:f193:42e2]) by TU4PR8401MB1152.NAMPRD84.PROD.OUTLOOK.COM ([fe80::659b:8e33:f193:42e2%8]) with mapi id 15.20.3632.017; Wed, 2 Dec 2020 01:11:07 +0000 From: "Shinoda, Noriyoshi (PN Japan FSIP)" To: Tom Lane CC: "pgsql-bugs@lists.postgresql.org" , Andres Freund Subject: RE: BUG #16754: When using LLVM and parallel queries aborted all session by pg_cancel_backend. Thread-Topic: BUG #16754: When using LLVM and parallel queries aborted all session by pg_cancel_backend. Thread-Index: AQHWyCTFfgT2PUQsLUWpfj+WebZG9ani/q3w Date: Wed, 2 Dec 2020 01:11:07 +0000 Message-ID: References: <16754-4a800d382f5cfae9@postgresql.org> <1526097.1606856323@sss.pgh.pa.us> In-Reply-To: <1526097.1606856323@sss.pgh.pa.us> Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: sss.pgh.pa.us; dkim=none (message not signed) header.d=none;sss.pgh.pa.us; dmarc=none action=none header.from=hpe.com; x-originating-ip: [165.225.110.155] x-ms-publictraffictype: Email x-ms-office365-filtering-ht: Tenant x-ms-office365-filtering-correlation-id: ddb3db9e-ea98-4d4a-4074-08d8965f262f x-ms-traffictypediagnostic: TU4PR8401MB0494: x-ms-exchange-transport-forked: True x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:7219; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: QHylg3NAYBA2xg4LDK5FejkUlHNJnYM0wD8JJQAhAQ3D4X6STjYJVaI6UnzO3Zenk1xFHvJqobh7iGPxF1BMN4Te0Z2FhHhBOgmaOvyWUU1IdhXYjJgjEynZM7KAGEHpd14RUVJUvRg3gG+9lKbpqOxy653U0Sgbj2hl+suIdu2ixdRjJe4+1bMCcXNTijf+VkZ+3k6PghI6ZXnVkOuHJG741AzsxlHHOlwYYKWwB3AwATAJKQMbVoFZU3a/JKyORfr835sBAzIaeZFLfgY78+lMYBnRCej/TMLe+oZRngTC2gxYJ0NXVaKv4ZRrIs4J/hV3lCuhujFl2MiyiafEvQ== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TU4PR8401MB1152.NAMPRD84.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(396003)(39860400002)(366004)(136003)(376002)(346002)(66446008)(55016002)(64756008)(66556008)(9686003)(33656002)(66476007)(26005)(66946007)(7696005)(478600001)(86362001)(52536014)(76116006)(6916009)(71200400001)(316002)(2906002)(4326008)(8936002)(8676002)(6506007)(5660300002)(54906003)(186003)(83380400001)(53546011)(55236004);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata: =?us-ascii?Q?kcWmc0gIXuZ6T0LVR8PR+qnWdwg1bX28CJcNtbv3JjcUg0Q8yymSfqwK4Ka8?= =?us-ascii?Q?8A+XtxUk6xzRK2jI52Uw9w+WHBQA2zLGHApPH/SjRQZNkxfzt6Pvhidqw8mT?= =?us-ascii?Q?NyN1OKhlS46GjvF4Qvm6AfqZN5Li8/q4qb8sPHLqfF9StZkmcj3aF477Md1P?= =?us-ascii?Q?XrCDBPS1K2uVMCGxAiMBr4F4chEOUpk8DtFDvHWyvrbnvr9u5rvYbG5x6mZB?= =?us-ascii?Q?O+liNGGK6If+rJDoIyigF+822TFHfBbBzgb3qhNVymAhbLoEP4vHR8Ib6MmX?= =?us-ascii?Q?i/63CkdedBUIRAm1kUhw49YRidnciRDpW7cMq7aMAZsIxQ2twy4o1qp9Gb+L?= =?us-ascii?Q?3/xdAaGIYAwNmD5DVIOu/QE4ODGdXzLJdWp2RbpLrBJk+DyhQfOx8bzLcd2T?= =?us-ascii?Q?C7gKAKvYpCu3rfwSEfK4N+D/6I1seNSPXks2LRRnEh0xxqQbDd7mBGqkvsk8?= =?us-ascii?Q?CBBSBNa30aw/Ownkjx14JBoyXnujVa/Kre4dDxFMsV1qKtwNtrmRVwjVmUES?= =?us-ascii?Q?Me0R+WBPAvL/hQ1LfbF2SH1+VEtRtWn53Kb3P9B6STAv/r/Bp/eNhgG+iwMG?= =?us-ascii?Q?ktHSp41X+8kjLBe9Lco/5I2wmF7fGuFkCo+IeSqkB/mQl+OOIAdMkDFkUqRW?= =?us-ascii?Q?XOFBjIMuDayEjTSiao9Ap9x+8+ce83Zy8sE8IN4yrNHgIAEerVviLQY3FmD6?= =?us-ascii?Q?beS4IhBKkBsidi7X2tA1DgHoptBVImZiLx16rMFhP10WFBKSfbGJbgBXwnDo?= =?us-ascii?Q?7eQjfi2NsvO04SrQcZ5WYQFl+7GQwv5ByyhKh9HeaYCskcm5OhBtzFTRR4XR?= =?us-ascii?Q?P3l/8jajfrMfsGVzURkb1itzkuCC3wz8/W17GP7EpqPuRsD5DYxQEZ9Zu6+F?= =?us-ascii?Q?yF1snKMAxBNcLKA4/fBceYle35WLeqi8Ve3odjmRhmIdemTn5DcFW+lZiIxQ?= =?us-ascii?Q?bKouU5/O/C18zAjfu4+0NUg7dE80RYTsGRNYcQ3K+6I=3D?= Content-Type: text/plain; charset="us-ascii" X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TU4PR8401MB1152.NAMPRD84.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: ddb3db9e-ea98-4d4a-4074-08d8965f262f X-MS-Exchange-CrossTenant-originalarrivaltime: 02 Dec 2020 01:11:07.8656 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 105b2061-b669-4b31-92ac-24d304d195dc X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 5gwVM4ec9tOqNokH9HOnNkbrd/VkKZ9LpjWaj8Vc7TacbZ9ZACU317yb6eh5C6wGr260Qkhoog/6SySsSW9Zw1GSRQGbRVyclbwWxTqpiF0= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TU4PR8401MB0494 X-OriginatorOrg: hpe.com Content-Transfer-Encoding: quoted-printable X-Proofpoint-UnRewURL: 0 URL was un-rewritten MIME-Version: 1.0 X-HPE-SCL: -1 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:6.0.312,18.0.737 definitions=2020-12-01_12:2020-11-30,2020-12-01 signatures=0 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 adultscore=0 phishscore=0 suspectscore=0 bulkscore=0 mlxlogscore=999 mlxscore=0 malwarescore=0 priorityscore=1501 spamscore=0 lowpriorityscore=0 impostorscore=0 clxscore=1011 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2009150000 definitions=main-2012020003 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk > I don't see any plausibly-related commits since 13.1, so it's not somethi= ng we recently fixed. I wonder if this is an LLVM bug fixed since the 7.1 = release you have. Thank you for your comment and test. I tried again with an older version of LLVM below. - PostgreSQL 13.1 - Red Hat Enterprise Linux 7.5 - LLVM 6.0 - cfe 6.0 I couldn't reproduce the problem int the above environment, so maybe it's a= problem in my development environment. Regards, Noriyoshi Shinoda -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20 Sent: Wednesday, December 2, 2020 5:59 AM To: Shinoda, Noriyoshi (PN Japan FSIP) Cc: pgsql-bugs@lists.postgresql.org; Andres Freund Subject: Re: BUG #16754: When using LLVM and parallel queries aborted all s= ession by pg_cancel_backend. PG Bug reporting form writes: > SELECT pg_cancel_backend(130342); > ... > 2020-12-01 14:26:02.337 JST [130270] LOG: background worker "parallel=20 > worker" (PID 130342) was terminated by signal 11: Segmentation fault > 2020-12-01 14:26:02.337 JST [130270] DETAIL: Failed process was running: > EXPLAIN ANALYZE SELECT * FROM data1 d1, data1 d2; FWIW, I failed to reproduce any crash here, using RHEL8 (llvm-10.0.1). I don't see any plausibly-related commits since 13.1, so it's not something= we recently fixed. I wonder if this is an LLVM bug fixed since the 7.1 re= lease you have. regards, tom lane