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 1kGClX-00061U-7n for pgsql-hackers@arkaria.postgresql.org; Thu, 10 Sep 2020 02:56:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kGClW-0007VY-5L for pgsql-hackers@arkaria.postgresql.org; Thu, 10 Sep 2020 02:56:50 +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 1kGClV-0007VR-Qg for pgsql-hackers@lists.postgresql.org; Thu, 10 Sep 2020 02:56:49 +0000 Received: from esa18.fujitsucc.c3s2.iphmx.com ([216.71.158.38]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kGClS-0002C7-N6 for pgsql-hackers@lists.postgresql.org; Thu, 10 Sep 2020 02:56:48 +0000 IronPort-SDR: IIBZ2QRVNVAH6K94Cjbm7cXmQC6OZG08AS3IQycA9iNI459OXN5yb7QtONR0bxjmFBq5VTvLNb CsZrubqpQ69EUbjMcCWcuKl6dT43tNysSBspTM8dYeL3/X8OWW5rMsQuZmXX5ZnLP3//CfK9Cr DPrSkHR2o7ZsILwZWKp3y4fxeFdwX2u3V2WufDnSGOZUZ3Zaoqjk7NTdBLP/1dLwjWiK5/8Moj cC85IcMOwHSHX1SL04JldY7LdNmc8QeuXObb8fGp1SVAFbdbwTTUahQEObmejEEi5IXggFYXW5 wGQ= X-IronPort-AV: E=McAfee;i="6000,8403,9739"; a="18133897" X-IronPort-AV: E=Sophos;i="5.76,411,1592838000"; d="scan'208";a="18133897" Received: from mail-ty1jpn01lp2052.outbound.protection.outlook.com (HELO JPN01-TY1-obe.outbound.protection.outlook.com) ([104.47.93.52]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 10 Sep 2020 11:56:42 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=UOmR0vv03K5oMOzP/kck1Z881D8oXJ86CCvJPJIfAFHr4RG9JiQ+cx7Siwv6qLVjjVwBe3PQADTc/QeO/KAveEnG5H2oqEl+UYJAQdt4jz/ReKJ1U1UkDDeAfGKwRzfvjPuDR66G1XlrhGwQB/nPNyMZ2M2yf1ErKL9svzlTvuNIEnohgMvn1yPrgbGVA+WpSiG/5JdiJeKhx4spE7rfYCg1g6naeKdm7KyzDuj28lG4iUoo8FTjVtPy2AU0F+MRolTVWDEfc/DSmBY7BdqYSbLUaauJ5SUdOzWzx/kZgPZz3xB/EdhtlEVxcioo5hqcuVQNOrn4cEWuxy7EuItGBw== 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=/0Au7Tf98egWrWYbMlFAV6IhOL8O/+capZVedujIfGo=; b=WzJQoTUanX++m55Imooz7z/QDvxpfoSEWt3OCb3qncUZSy0Zskm8soujKy6eUT+Zveqgih8p3DpcoaLHVCt4Fzn3N1a05fGsQUFri1U0XFLXmZVIUE8fRIPUMgEcTLtuCaFdFeUk0SC8nKHrX3PvabakOR+4eggtWdyrJ00iCmokl5mLhlzDMb4JpH6HAxW0aHjxv0R/t90MSi+D6qjw9Onzp/EMXrppInIyb0gsO3ClgsjgiPpWnHa9f21ob9HwPA78hBBS4ZZ7iPYSBDd9zcDPFb8XrwrqWUWfIzGvpsTC222wbKP9I+UzXwLTm3cfs8FIZtfxgz0r+mKrElsL6g== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fujitsu.com; dmarc=pass action=none header.from=fujitsu.com; dkim=pass header.d=fujitsu.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fujitsu.onmicrosoft.com; s=selector2-fujitsu-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=/0Au7Tf98egWrWYbMlFAV6IhOL8O/+capZVedujIfGo=; b=gqJzj6BPp3HwCuhW5M5VPP2B0zwj6LB3mIWU6Kq2CxEX0nh/KXvjiJNk3dCibXx2x1hoVO+GsN+3mrWEpiqo19gK+rjl8K9WpotAbgHLLb0mdctHlKxjHKfVPTSc5xT58bfX7EDl1jYEZNRwJpCblaMVdeGlcp793KFDQ4uZ1nE= Received: from TYAPR01MB2990.jpnprd01.prod.outlook.com (2603:1096:404:86::19) by TYXPR01MB1504.jpnprd01.prod.outlook.com (2603:1096:403:d::20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3370.16; Thu, 10 Sep 2020 02:56:37 +0000 Received: from TYAPR01MB2990.jpnprd01.prod.outlook.com ([fe80::557a:777:f695:261d]) by TYAPR01MB2990.jpnprd01.prod.outlook.com ([fe80::557a:777:f695:261d%5]) with mapi id 15.20.3370.016; Thu, 10 Sep 2020 02:56:37 +0000 From: "tsunakawa.takay@fujitsu.com" To: 'Tom Lane' CC: "pgsql-hackers@lists.postgresql.org" Subject: RE: SIGQUIT handling, redux Thread-Topic: SIGQUIT handling, redux Thread-Index: AQHWhiiNnAnKXrdCBkG0uCDggpYHoqlhIdgAgAAJvJA= Date: Thu, 10 Sep 2020 02:56:37 +0000 Message-ID: References: <1850884.1599601164@sss.pgh.pa.us> <148145.1599703626@sss.pgh.pa.us> In-Reply-To: <148145.1599703626@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=fujitsu.com; x-originating-ip: [218.44.52.182] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: b6562eed-5e5d-4c3d-992e-08d855352276 x-ms-traffictypediagnostic: TYXPR01MB1504: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:6108; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: MujED6yV25Qrrv/P0aCVr09RLIOeQOb8ChijJgf00q+G76aAJ6yL5AEAK4HUL4TFU/d+JdjzJbZxAJYT9mJ8BaKjHYkiOT3jus3NgfOLy7VCF0JmqU/pOYtek6+nKgt/x25AfrANENzwWI9aOqefHVksW5i1BgJIJyMn2oOvPoCmdd4z2lQwMVUxwWIFjU+fxLtdd4l1z1YXFhlNKBss61mEm9GgY1PjWSzTTILy5q2LcRfImNzmHdDSpinU3aXD14uLmBu5bYBsjCyI0t5/H+bh5PTodoAQcceHQjji+cWkCme5SDau2PXUm31j1yvWweP08cECaV65x8/gk9Tn1+qbxjI6d7ihGlb5c68Y7gMoHrcVz8cFUb0rAvHMWtBt x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TYAPR01MB2990.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(396003)(366004)(136003)(39860400002)(346002)(376002)(186003)(86362001)(85182001)(4326008)(26005)(6916009)(2906002)(478600001)(52536014)(71200400001)(8936002)(5660300002)(8676002)(6506007)(9686003)(55016002)(66946007)(83380400001)(316002)(76116006)(66556008)(64756008)(66446008)(33656002)(7696005)(66476007)(777600001);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: 4zNhRUWWXKBBqMxsCo1N0vKBEBfhomy1w/I2S7LJ9E1II2/dvtz73oZa78Le+p9V1mJ1FXGQfwGumAHunj3WoWwdpBwqo4xxG7g7/izd2uoEchbK5Ir+eSMHSFwrGHqrs9TIiERhZAR/j+kATwtHdraqmpNfIZRan33PBYllTqBbpsIfxo0LsP8qffF1F5v/Csc5VnZ9bhDf/TL/du35fuCgBPCDC+MG+KzpAiEcRf8v968W0SpcOLyiKDQ/CG8KeXifoqDa5mfnyCo2+21avlMq4ywchdiydCi5vtrjOWjjILPLUkJym18rhYGmu22C3MOSwlYbLPXaLcpRiBLrsSvTsyOudcZ9In2BFMRyjQDYJfm4YbHE7elOfJ0M9Z8dbqqd+w1/sUsZIfvj5w5UGJq0doOdnmiD86VxTRTiB/znK9CYuAidXCe1D3kXslTaEt42S5dOco/QxnvJYRPdvH/MZIHdjGyn21mVd0TqOlcKuXpAVrSB3iKuGDyEys3i0AlSy5XbNIF0mgUXB+dPpvGrZE/ho0bllHcuclOmGYJQjR1smEMSCQrR82XpmlBgvz5nHZeiE88Wn3Nl3KZYkSaKzgdym7vkA0PDCLzy6/W1nCXVrHsfX84jcx7NTR65XFE87jdDJgltdod8fb3OYQ== x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TYAPR01MB2990.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: b6562eed-5e5d-4c3d-992e-08d855352276 X-MS-Exchange-CrossTenant-originalarrivaltime: 10 Sep 2020 02:56:37.2170 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: a19f121d-81e1-4858-a9d8-736e267fd4c7 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 7Cger5JN+FY5H+mIHWTLd0322/Ahp9hKvq+TiwWKeAfyTwes5Y8T+d54myuS89sVHcf0EcRPiPuNvmBATMqs28yCp6CFWK4TCdN9diI6dU4= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYXPR01MB1504 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk From: Tom Lane > This is straying a bit from the stated topic of this thread, but ... > I did some further looking around to see whether there were any > unsafe signal handlers besides SIGQUIT ones. The situation is not > too awful, but I did find several issues not already mentioned > in this thread: Wow, your eyes catch this many issues. (I was just wondering about one or = two of them.) I'm not sure if this is related, but I had been wondering if the following = can be what it is now. (1) When logical replication is used, pg_ctl stop with the default fast mode em= its the message about termination of logical replication launcher. Althoug= h it's not FATAL or ERROR, but I was a bit startled when I saw this message= for the first time. Why should this message be emitted while nothing abou= t other postmaster children are reported? The logical rep launcher ignores= SIGINT (SIG_IGN). LOG: received fast shutdown request LOG: aborting any active transactions LOG: background worker "logical replication launcher" (PID 10056) exited w= ith exit code 1 LOG: shutting down LOG: database system is shut down (2) When the physical standby stops, a FATAL message is output. It may be anno= ying to the DBA that monitors messages with high severity. LOG: received fast shutdown request LOG: aborting any active transactions FATAL: terminating walreceiver process due to administrator command LOG: shutting down LOG: database system is shut down (3) When WaitLatch(EXIT_ON_POSTMASTER_DEATH) detects postmaster death, it calls= proc_exit(1). Can we call _exit(1) here likewise? Regards Takayuki Tsunakawa