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 1oLhT1-0002QK-IY for pgsql-bugs@arkaria.postgresql.org; Wed, 10 Aug 2022 08:53:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oLhSz-0000Bc-QO for pgsql-bugs@arkaria.postgresql.org; Wed, 10 Aug 2022 08:53:29 +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 1oLgxj-0006iH-3r for pgsql-bugs@lists.postgresql.org; Wed, 10 Aug 2022 08:21:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oLgxe-0007Yi-GT for pgsql-bugs@lists.postgresql.org; Wed, 10 Aug 2022 08:21:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=KqNPL5LvNQqeMZjwsy7Qp0KlMrwgHONsCpkTF/q0+vk=; b=S6OV6v7gnLngGgIjgTN2Xq92mD wgbIctO7kqGwIiiAJOWN7GjfOGRa5QYiHtOjlpLOHQEmmwTEa8pJk6fKlCCUTfSdkNHV8+kiuHoJ3 JiV1ctu+a4MVcNzWwQLYfoWD/H6dARYlRJa+czc/CT+H2o3e2kC/yb35xJ5sBK8lNEuRwRLqC/Gy9 vAFMUATTBFTv2H4TAtsAeI6PS+dSoRIQ1kvlss9RQWJK3a8+ROpyYK3CINmPiLqBlALODf9PVWk2l Q4FRth2bgeNoC2UT5hJcGPSdwqc7nNYLcaiQ54lHlJrs8BRLhPZTjAqx0f1l8XVzRQnk2zls2na8r 50nlyI6g==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oLgxc-00079W-KI for pgsql-bugs@lists.postgresql.org; Wed, 10 Aug 2022 08:21:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1oLgxa-004ZqR-MV for pgsql-bugs@lists.postgresql.org; Wed, 10 Aug 2022 08:21:02 +0000 Content-Type: multipart/mixed; boundary="===============6846368953421046126==" MIME-Version: 1.0 Subject: BUG #17580: use pg_terminate_backend to terminate a wal sender process may wait a long time To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: 13207961@qq.com Reply-To: 13207961@qq.com, pgsql-bugs@lists.postgresql.org Date: Wed, 10 Aug 2022 08:20:30 +0000 Message-ID: <17580-849c1d5b6d7eb422@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6846368953421046126== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzU4MApMb2dnZWQgYnk6ICAgICAgICAgIHdoYWxlIHNvbmcKRW1haWwg YWRkcmVzczogICAgICAxMzIwNzk2MUBxcS5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMC41Ck9w ZXJhdGluZyBzeXN0ZW06ICAgY2VudG9zCkRlc2NyaXB0aW9uOiAgICAgICAgCgoxKSBDcmVhdGUg YSB0YWJsZSBmb3IgdGVzdA0KY3JlYXRlIHRhYmxlIHRlc3Q2NjYoaWQgaW50IHByaW1hcnkga2V5 LCBudW1iZXIgaW50KTsNCg0KMikgVXNlIHBnX3JlY3Zsb2dpY2FsIHRvIHN1YnNjcmliZQ0KMi4x KSBDcmVhdGUgYSByZXBsaWNhdGUgc2xvdA0KcGdfcmVjdmxvZ2ljYWwgLWggOS4yMjMuMjguMTc2 IC1wIDExMDAyIC1kIHRlc3QgLVUgdGJhc2UgLS1zbG90CndhbDJqc29uX3BnX3Rlc3QwMiAtLWNy ZWF0ZS1zbG90IC1QIHdhbDJqc29uDQoyLjIpIFN0YXJ0IHRvIHN1YnNjcmliZSwgYW5kIHVzZSBm aWx0ZXItdGFibGVzIHRvIGZpbHRlciB0ZXN0IHRhYmxlCnRlc3Q2NjYNCnBnX3JlY3Zsb2dpY2Fs IC1oIDkuMjIzLjI4LjE3NiAtcCAxMTAwMiAtZCB0ZXN0IC1VIHRiYXNlIC0tc2xvdAp3YWwyanNv bl9wZ190ZXN0MDIgLS1zdGFydCAtbyBwcmV0dHktcHJpbnQ9MSAtbyBmb3JtYXQtdmVyc2lvbj0y IC1vCmZpbHRlci10YWJsZXM9InB1YmxpYy50ZXN0NjY2IiAgLWYgLQ0KDQozKSBJbnNlcnQgYSBs b3Qgb2YgZGF0YSB0byB0aGUgdGFibGUgaW4gb25lIHRyYW5zYWN0aW9uDQppbnNlcnQgaW50byB0 ZXN0NjY2IHZhbHVlcyAoZ2VuZXJhdGVfc2VyaWVzKDEwMDAwMDAwMDEsMjAwMDAwMDAwMCksCmdl bmVyYXRlX3NlcmllcygxMDAwMDAwMDAxLDIwMDAwMDAwMDApKTsNCkl0IG1heSBjYXVzZSBhIGxv bmcgdGltZSwgbWF5YmUgNTAgbWludXRlcy4NCg0KNCkgIFVzZSBwZ19yZXBsaWNhdGlvbl9zbG90 cyB0byBnZXQgd2FsIHNlbmRlciBwcm9jZXNzIHBpZChhY3RpdmVfcGlkKQ0Kc2VsZWN0ICoscGdf Y3VycmVudF93YWxfbHNuKCkgZnJvbSBwZ19yZXBsaWNhdGlvbl9zbG90cyA7DQoNCjUpIFdoZW4g c3RlcCAzIGZpbmlzaCwgdXNlIHBzdGFjayB0byB3YXRjaCB3YWwgc2VuZGVyIHByb2Nlc3Mgc3Rh Y2ssIHdoZW4gaXQKaXMgbG9vcCBpbiBSZW9yZGVyQnVmZmVyQ29tbWl0LCBraWxsIHBnX3JlY3Zs b2dpY2FsIHdoaWNoIHN0YXJ0IGluIHN0ZXAKMi4yDQogcHN0YWNrIDgwNzQzDQojMCAweDAwMDAw MDAwMDBjNDAwZDkgaW4gUmVzb3VyY2VBcnJheUFkZCAocmVzYXJyPTB4MTU3Njk3MCwKdmFsdWU9 MTM5OTQxNTk5MjQwODk2KSBhdCByZXNvd25lci5jOjM1OQ0KIzEgMHgwMDAwMDAwMDAwYzNmZWY0 IGluIFJlc291cmNlQXJyYXlFbmxhcmdlIChyZXNhcnI9MHgxNTc2OTcwKSBhdApyZXNvd25lci5j OjI1Mg0KIzIgMHgwMDAwMDAwMDAwYzQxMWY0IGluIFJlc291cmNlT3duZXJFbmxhcmdlUmVsYXRp b25SZWZzIChvd25lcj0weDE1NzY4ZjApCmF0IHJlc293bmVyLmM6MTEyOQ0KIzMgMHgwMDAwMDAw MDAwYmUwODk5IGluIFJlbGF0aW9uSW5jcmVtZW50UmVmZXJlbmNlQ291bnQKKHJlbD0weDdmNDZi MTRmZTJjMCkgYXQgcmVsY2FjaGUuYzoyNTg5DQojNCAweDAwMDAwMDAwMDBiZTA1ZGEgaW4gUmVs YXRpb25JZEdldFJlbGF0aW9uIChyZWxhdGlvbklkPTExNzc3ODUpIGF0CnJlbGNhY2hlLmM6MjQ1 MQ0KIzUgMHgwMDAwN2Y0ZTBkNjQ5YjllIGluIHBnX2RlY29kZV93cml0ZV90dXBsZSAoY3R4PTB4 MTNmYzVhOCwKcmVsYXRpb249MHg3ZjQ2YjE0ZmNmMzgsIHR1cGxlPTB4MzE1YjkxMCwga2luZD1Q R09VVFBVVEpTT05fSURFTlRJVFkpIGF0CndhbDJqc29uLmM6MTUwMw0KIzYgMHgwMDAwN2Y0ZTBk NjRhNTE0IGluIHBnX2RlY29kZV93cml0ZV9jaGFuZ2UgKGN0eD0weDEzZmM1YTgsCnR4bj0weDE1 OTU3YTgsIHJlbGF0aW9uPTB4N2Y0NmIxNGZjZjM4LCBjaGFuZ2U9MHgzM2JjOWY4KSBhdAp3YWwy anNvbi5jOjE3NDcNCiM3IDB4MDAwMDdmNGUwZDY0YTlkYiBpbiBwZ19kZWNvZGVfY2hhbmdlX3Yy IChjdHg9MHgxM2ZjNWE4LCB0eG49MHgxNTk1N2E4LApyZWxhdGlvbj0weDdmNDZiMTRmY2YzOCwg Y2hhbmdlPTB4MzNiYzlmOCkgYXQgd2FsMmpzb24uYzoxODY1DQojOCAweDAwMDA3ZjRlMGQ2NDhi MmIgaW4gcGdfZGVjb2RlX2NoYW5nZSAoY3R4PTB4MTNmYzVhOCwgdHhuPTB4MTU5NTdhOCwKcmVs YXRpb249MHg3ZjQ2YjE0ZmNmMzgsIGNoYW5nZT0weDMzYmM5ZjgpIGF0IHdhbDJqc29uLmM6MTA5 OA0KIzkgMHgwMDAwMDAwMDAwOWNmM2QxIGluIGNoYW5nZV9jYl93cmFwcGVyIChjYWNoZT0weDE0 MTBmYjgsIHR4bj0weDE1OTU3YTgsCnJlbGF0aW9uPTB4N2Y0NmIxNGZjZjM4LCBjaGFuZ2U9MHgz M2JjOWY4KSBhdCBsb2dpY2FsLmM6NzMwDQojMTAgMHgwMDAwMDAwMDAwOWQ3NWRmIGluIFJlb3Jk ZXJCdWZmZXJDb21taXQgKHJiPTB4MTQxMGZiOCwgeGlkPTE3NDAyODgwMSwKY29tbWl0X2xzbj00 NDU3OTEzNTE0ODg3MiwgZW5kX2xzbj00NDU3OTEzNTE0ODkzNiwKY29tbWl0X3RpbWU9NzEyMjIy NjY5MTg4OTQ3LCBvcmlnaW5faWQ9MCwgb3JpZ2luX2xzbj0wKSBhdApyZW9yZGVyYnVmZmVyLmM6 MTQ0NQ0KIzExIDB4MDAwMDAwMDAwMDljYjE1YiBpbiBEZWNvZGVDb21taXQgKGN0eD0weDEzZmM1 YTgsIGJ1Zj0weDdmZmYyNTc0ZDYwMCwKcGFyc2VkPTB4N2ZmZjI1NzRkNTMwLCB4aWQ9MTc0MDI4 ODAxKSBhdCBkZWNvZGUuYzo3MTMNCiMxMiAweDAwMDAwMDAwMDA5Y2E3NmIgaW4gRGVjb2RlWGFj dE9wIChjdHg9MHgxM2ZjNWE4LCBidWY9MHg3ZmZmMjU3NGQ2MDApCmF0IGRlY29kZS5jOjMzNQ0K IzEzIDB4MDAwMDAwMDAwMDljYTQwMSBpbiBMb2dpY2FsRGVjb2RpbmdQcm9jZXNzUmVjb3JkIChj dHg9MHgxM2ZjNWE4LApyZWNvcmQ9MHgxM2ZjODgwKSBhdCBkZWNvZGUuYzoxNzUNCiMxNCAweDAw MDAwMDAwMDA5ZWFkNDUgaW4gWExvZ1NlbmRMb2dpY2FsICgpIGF0IHdhbHNlbmRlci5jOjMxNTIN CiMxNSAweDAwMDAwMDAwMDA5ZWEwOWYgaW4gV2FsU25kTG9vcCAoc2VuZF9kYXRhPTB4OWVhY2E5 IDxYTG9nU2VuZExvZ2ljYWw+KQphdCB3YWxzZW5kZXIuYzoyNTIwDQojMTYgMHgwMDAwMDAwMDAw OWU4YWVkIGluIFN0YXJ0TG9naWNhbFJlcGxpY2F0aW9uIChjbWQ9MHgxNTFiYjQ4KSBhdAp3YWxz ZW5kZXIuYzoxNDQ1DQojMTcgMHgwMDAwMDAwMDAwOWU5NDRlIGluIGV4ZWNfcmVwbGljYXRpb25f Y29tbWFuZCAoY21kX3N0cmluZz0weDE1MjA0MDgKIlNUQVJUX1JFUExJQ0FUSU9OIFNMT1Qgc3Vi c19mNTI0cDIxN2I3X2RuMDAwMSBMT0dJQ0FMIDI4NUMvRjhGRkVBNTAgKApcImZvcm1hdC12ZXJz aW9uXCIgJzInICkiKSBhdCB3YWxzZW5kZXIuYzoxODg3DQojMTggMHgwMDAwMDAwMDAwYTcxZWQ4 IGluIFBvc3RncmVzTWFpbiAoYXJnYz0xLCBhcmd2PTB4MTQxOWY1OCwKZGJuYW1lPTB4MTQxOWYy OCAicHJkX2p4Y2FyZF9saW5nd2FuZyIsIHVzZXJuYW1lPTB4MTQxOWYwOCAibWluZ2NoZW5fcmVh ZCIpCmF0IHBvc3RncmVzLmM6NjExOA0KIzE5IDB4MDAwMDAwMDAwMDliMGZhYSBpbiBCYWNrZW5k UnVuIChwb3J0PTB4MTQxMzViMCkgYXQgcG9zdG1hc3Rlci5jOjUwNzENCiMyMCAweDAwMDAwMDAw MDA5YjA3NTMgaW4gQmFja2VuZFN0YXJ0dXAgKHBvcnQ9MHgxNDEzNWIwKSBhdApwb3N0bWFzdGVy LmM6NDc0Mw0KIzIxIDB4MDAwMDAwMDAwMDlhYzNhZSBpbiBTZXJ2ZXJMb29wICgpIGF0IHBvc3Rt YXN0ZXIuYzoxOTk1DQojMjIgMHgwMDAwMDAwMDAwOWFiYTM1IGluIFBvc3RtYXN0ZXJNYWluIChh cmdjPTUsIGFyZ3Y9MHgxM2RjNzcwKSBhdApwb3N0bWFzdGVyLmM6MTYwMw0KIzIzIDB4MDAwMDAw MDAwMDg3OGM0NCBpbiBtYWluIChhcmdjPTUsIGFyZ3Y9MHgxM2RjNzcwKSBhdCBtYWluLmM6MjMz DQoNCjYpIFVzZSBwZ19yZXBsaWNhdGlvbl9zbG90cyB0byBxdWVyeSB0aGUgcmVwbGljYXRpb24g c2xvdHMgaW5mb21hdGlvbiwgdGhlCmFjdGl2ZV9waWQgaXMgc3RpbGwgYWN0aXZlLiBVc2UgcGdf dGVybWluYXRlX2JhY2tlbmQgdG8gdGVybWluYXRlCmFjdGl2ZV9waWQsIGl0IHJldHVybnMgdHJ1 ZSwgYnV0IHRoZSBhY3RpdmVfcGlkIGlzIHN0aWxsIGFjdGl2ZS4NCg0KNykgVGhlIGFjdGl2ZV9w aWQgd2FsIHNlbmRlciBwcm9jZXNzIGV4aXQgYWZ0ZXIgYSBsb25nIHRpbWUgd2FpdGluZw0KDQpJ IHRoaW5rIG1heWJlIHdlIHNob3VsZCBhZGQgYSBDSEVDS19GT1JfSU5URVJSVVBUUyBpbiB0aGUg bG9vcCBjb2RlIG9mIHRoZQpSZW9yZGVyQnVmZmVyQ29tbWl0IGZ1bmN0aW9uLg0KTGlrZXM6DQoN CnZvaWQNClJlb3JkZXJCdWZmZXJDb21taXQo4oCm4oCm4oCm4oCmKQ0Kew0KCeKApuKApuKApuKA pg0KDQoNCglQR19UUlkoKTsNCgl7DQoJCeKApuKApuKApuKApg0KDQoJCXdoaWxlICgoY2hhbmdl ID0gUmVvcmRlckJ1ZmZlckl0ZXJUWE5OZXh0KHJiLCBpdGVyc3RhdGUpKSAhPSBOVUxMKQ0KCQl7 DQoJCQlSZWxhdGlvbglyZWxhdGlvbiA9IE5VTEw7DQoJCQlPaWQJCQlyZWxvaWQ7DQoNCgkJCS8q IEFkZCBhIENIRUNLX0ZPUl9JTlRFUlJVUFRTIGhlcmU/ICovDQoNCgkJCeKApuKApuKApuKApg0K CQl9DQoNCgnigKbigKbigKbigKYNCn0KCg== --===============6846368953421046126==--