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 1uXiFK-00DUi0-EM for pgsql-bugs@arkaria.postgresql.org; Fri, 04 Jul 2025 15:22:38 +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 1uXiFH-001TIZ-Bw for pgsql-bugs@arkaria.postgresql.org; Fri, 04 Jul 2025 15:22:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uXiFG-001TI7-Qq for pgsql-bugs@lists.postgresql.org; Fri, 04 Jul 2025 15:22:35 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1uXiFD-005Yq2-0g for pgsql-bugs@lists.postgresql.org; Fri, 04 Jul 2025 15:22:33 +0000 Received: from [192.168.11.9] (p1696134-ipoe.ipoe.ocn.ne.jp [118.0.93.133]) by oss.nttdata.com (Postfix) with ESMTPSA id 770D561BAD; Sat, 5 Jul 2025 00:22:27 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.103.11 at oss.nttdata.com Content-Type: multipart/mixed; boundary="------------LExQKQEWy7KR2jN30fDf3BWY" Message-ID: Date: Sat, 5 Jul 2025 00:22:26 +0900 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Unexpected behavior when setting "idle_replication_slot_timeout" From: Fujii Masao To: Nisha Moond , Gunnar Morling Cc: pgsql-bugs@lists.postgresql.org References: <30e91649-06dd-453e-8658-5f4acd03a3bd@oss.nttdata.com> Content-Language: en-US In-Reply-To: <30e91649-06dd-453e-8658-5f4acd03a3bd@oss.nttdata.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------LExQKQEWy7KR2jN30fDf3BWY Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 2025/07/04 23:12, Fujii Masao wrote: > But I wonder why the current unit of this GUC is minutes (GUC_UNIT_MIN). > Since at least two users (including myself) tried to set it to a value > less than 1 minute, it might worth considering changing the unit to seconds > (GUC_UNIT_S). Also which would reduces the chance of the reported trouble. Attached patch changes unit of idle_replication_slot_timeout to seconds. Regards, -- Fujii Masao NTT DATA Japan Corporation --------------LExQKQEWy7KR2jN30fDf3BWY Content-Type: text/plain; charset=UTF-8; name="v1-0001-Change-unit-of-idle_replication_slot_timeout-to-s.patch" Content-Disposition: attachment; filename*0="v1-0001-Change-unit-of-idle_replication_slot_timeout-to-s.pa"; filename*1="tch" Content-Transfer-Encoding: base64 RnJvbSBkN2U1MjhjMWFkYWY1MTdiODZlZjk3NDU0YzgwZDM2OWY3YzlmMjNhIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBGdWppaSBNYXNhbyA8ZnVqaWlAcG9zdGdyZXNxbC5v cmc+CkRhdGU6IEZyaSwgNCBKdWwgMjAyNSAyMzozOTo0OCArMDkwMApTdWJqZWN0OiBbUEFU Q0ggdjFdIENoYW5nZSB1bml0IG9mIGlkbGVfcmVwbGljYXRpb25fc2xvdF90aW1lb3V0IHRv IHNlY29uZHMuCgpQcmV2aW91c2x5LCBpZGxlX3JlcGxpY2F0aW9uX3Nsb3RfdGltZW91dCB3 YXMgbWVhc3VyZWQgaW4gbWludXRlcy4KVGhpcyBjb21taXQgY2hhbmdlcyB0aGUgdW5pdCB0 byBzZWNvbmRzLCBhbGxvd2luZyBmaW5lci1ncmFpbmVkCnRpbWVvdXQgc2V0dGluZ3MuCi0t LQogZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sICAgICAgICAgICAgICAgICAgICAgIHwgIDIg Ky0KIHNyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL3Nsb3QuYyAgICAgICAgICAgICAgICB8IDE1 ICsrKysrKy0tLS0tLS0tLQogc3JjL2JhY2tlbmQvdXRpbHMvbWlzYy9ndWNfdGFibGVzLmMg ICAgICAgICAgIHwgIDYgKysrLS0tCiBzcmMvYmFja2VuZC91dGlscy9taXNjL3Bvc3RncmVz cWwuY29uZi5zYW1wbGUgfCAgMiArLQogc3JjL2luY2x1ZGUvcmVwbGljYXRpb24vc2xvdC5o ICAgICAgICAgICAgICAgIHwgIDIgKy0KIDUgZmlsZXMgY2hhbmdlZCwgMTIgaW5zZXJ0aW9u cygrKSwgMTUgZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9zZ21sL2NvbmZp Zy5zZ21sIGIvZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sCmluZGV4IDU5YTA4NzQ1MjhhLi5i ZDEyMjI1Y2JlNCAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sCisrKyBi L2RvYy9zcmMvc2dtbC9jb25maWcuc2dtbApAQCAtNDYyMCw3ICs0NjIwLDcgQEAgcmVzdG9y ZV9jb21tYW5kID0gJ2NvcHkgIkM6XFxzZXJ2ZXJcXGFyY2hpdmVkaXJcXCVmIiAiJXAiJyAg IyBXaW5kb3dzCiAgICAgICAgPHBhcmE+CiAgICAgICAgIEludmFsaWRhdGUgcmVwbGljYXRp b24gc2xvdHMgdGhhdCBoYXZlIHJlbWFpbmVkIGlkbGUgbG9uZ2VyIHRoYW4gdGhpcwogICAg ICAgICBkdXJhdGlvbi4gSWYgdGhpcyB2YWx1ZSBpcyBzcGVjaWZpZWQgd2l0aG91dCB1bml0 cywgaXQgaXMgdGFrZW4gYXMKLSAgICAgICAgbWludXRlcy4gQSB2YWx1ZSBvZiB6ZXJvICh0 aGUgZGVmYXVsdCkgZGlzYWJsZXMgdGhlIGlkbGUgdGltZW91dAorICAgICAgICBzZWNvbmRz LiBBIHZhbHVlIG9mIHplcm8gKHRoZSBkZWZhdWx0KSBkaXNhYmxlcyB0aGUgaWRsZSB0aW1l b3V0CiAgICAgICAgIGludmFsaWRhdGlvbiBtZWNoYW5pc20uIFRoaXMgcGFyYW1ldGVyIGNh biBvbmx5IGJlIHNldCBpbiB0aGUKICAgICAgICAgPGZpbGVuYW1lPnBvc3RncmVzcWwuY29u ZjwvZmlsZW5hbWU+IGZpbGUgb3Igb24gdGhlIHNlcnZlciBjb21tYW5kCiAgICAgICAgIGxp bmUuCmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC9yZXBsaWNhdGlvbi9zbG90LmMgYi9zcmMv YmFja2VuZC9yZXBsaWNhdGlvbi9zbG90LmMKaW5kZXggZjlmZWM1MGFlODguLmE2NTEyMDM0 YmE3IDEwMDY0NAotLS0gYS9zcmMvYmFja2VuZC9yZXBsaWNhdGlvbi9zbG90LmMKKysrIGIv c3JjL2JhY2tlbmQvcmVwbGljYXRpb24vc2xvdC5jCkBAIC0xNTQsNyArMTU0LDcgQEAgaW50 CQkJbWF4X3JlcGxpY2F0aW9uX3Nsb3RzID0gMTA7IC8qIHRoZSBtYXhpbXVtIG51bWJlciBv ZiByZXBsaWNhdGlvbgogICogSW52YWxpZGF0ZSByZXBsaWNhdGlvbiBzbG90cyB0aGF0IGhh dmUgcmVtYWluZWQgaWRsZSBsb25nZXIgdGhhbiB0aGlzCiAgKiBkdXJhdGlvbjsgJzAnIGRp c2FibGVzIGl0LgogICovCi1pbnQJCQlpZGxlX3JlcGxpY2F0aW9uX3Nsb3RfdGltZW91dF9t aW5zID0gMDsKK2ludAkJCWlkbGVfcmVwbGljYXRpb25fc2xvdF90aW1lb3V0X3NlY3MgPSAw OwogCiAvKgogICogVGhpcyBHVUMgbGlzdHMgc3RyZWFtaW5nIHJlcGxpY2F0aW9uIHN0YW5k Ynkgc2VydmVyIHNsb3QgbmFtZXMgdGhhdApAQCAtMTYxMiwxMyArMTYxMiwxMCBAQCBSZXBv cnRTbG90SW52YWxpZGF0aW9uKFJlcGxpY2F0aW9uU2xvdEludmFsaWRhdGlvbkNhdXNlIGNh dXNlLAogCiAJCWNhc2UgUlNfSU5WQUxfSURMRV9USU1FT1VUOgogCQkJewotCQkJCWludAkJ CW1pbnV0ZXMgPSBzbG90X2lkbGVfc2Vjb25kcyAvIFNFQ1NfUEVSX01JTlVURTsKLQkJCQlp bnQJCQlzZWNzID0gc2xvdF9pZGxlX3NlY29uZHMgJSBTRUNTX1BFUl9NSU5VVEU7Ci0KIAkJ CQkvKiB0cmFuc2xhdG9yOiAlcyBpcyBhIEdVQyB2YXJpYWJsZSBuYW1lICovCi0JCQkJYXBw ZW5kU3RyaW5nSW5mbygmZXJyX2RldGFpbCwgXygiVGhlIHNsb3QncyBpZGxlIHRpbWUgb2Yg JWRtaW4gJTAyZHMgZXhjZWVkcyB0aGUgY29uZmlndXJlZCBcIiVzXCIgZHVyYXRpb24gb2Yg JWRtaW4uIiksCi0JCQkJCQkJCSBtaW51dGVzLCBzZWNzLCAiaWRsZV9yZXBsaWNhdGlvbl9z bG90X3RpbWVvdXQiLAotCQkJCQkJCQkgaWRsZV9yZXBsaWNhdGlvbl9zbG90X3RpbWVvdXRf bWlucyk7CisJCQkJYXBwZW5kU3RyaW5nSW5mbygmZXJyX2RldGFpbCwgXygiVGhlIHNsb3Qn cyBpZGxlIHRpbWUgb2YgJWxkcyBleGNlZWRzIHRoZSBjb25maWd1cmVkIFwiJXNcIiBkdXJh dGlvbiBvZiAlZHMuIiksCisJCQkJCQkJCSBzbG90X2lkbGVfc2Vjb25kcywgImlkbGVfcmVw bGljYXRpb25fc2xvdF90aW1lb3V0IiwKKwkJCQkJCQkJIGlkbGVfcmVwbGljYXRpb25fc2xv dF90aW1lb3V0X3NlY3MpOwogCQkJCS8qIHRyYW5zbGF0b3I6ICVzIGlzIGEgR1VDIHZhcmlh YmxlIG5hbWUgKi8KIAkJCQlhcHBlbmRTdHJpbmdJbmZvKCZlcnJfaGludCwgXygiWW91IG1p Z2h0IG5lZWQgdG8gaW5jcmVhc2UgXCIlc1wiLiIpLAogCQkJCQkJCQkgImlkbGVfcmVwbGlj YXRpb25fc2xvdF90aW1lb3V0Iik7CkBAIC0xNjU2LDcgKzE2NTMsNyBAQCBSZXBvcnRTbG90 SW52YWxpZGF0aW9uKFJlcGxpY2F0aW9uU2xvdEludmFsaWRhdGlvbkNhdXNlIGNhdXNlLAog c3RhdGljIGlubGluZSBib29sCiBDYW5JbnZhbGlkYXRlSWRsZVNsb3QoUmVwbGljYXRpb25T bG90ICpzKQogewotCXJldHVybiAoaWRsZV9yZXBsaWNhdGlvbl9zbG90X3RpbWVvdXRfbWlu cyAhPSAwICYmCisJcmV0dXJuIChpZGxlX3JlcGxpY2F0aW9uX3Nsb3RfdGltZW91dF9zZWNz ICE9IDAgJiYKIAkJCSFYTG9nUmVjUHRySXNJbnZhbGlkKHMtPmRhdGEucmVzdGFydF9sc24p ICYmCiAJCQlzLT5pbmFjdGl2ZV9zaW5jZSA+IDAgJiYKIAkJCSEoUmVjb3ZlcnlJblByb2dy ZXNzKCkgJiYgcy0+ZGF0YS5zeW5jZWQpKTsKQEAgLTE3MzQsNyArMTczMSw3IEBAIERldGVy bWluZVNsb3RJbnZhbGlkYXRpb25DYXVzZSh1aW50MzIgcG9zc2libGVfY2F1c2VzLCBSZXBs aWNhdGlvblNsb3QgKnMsCiAJCQkgKiBpZGxlX3JlcGxpY2F0aW9uX3Nsb3RfdGltZW91dCBH VUMuCiAJCQkgKi8KIAkJCWlmIChUaW1lc3RhbXBEaWZmZXJlbmNlRXhjZWVkc1NlY29uZHMo cy0+aW5hY3RpdmVfc2luY2UsIG5vdywKLQkJCQkJCQkJCQkJCSAgaWRsZV9yZXBsaWNhdGlv bl9zbG90X3RpbWVvdXRfbWlucyAqIFNFQ1NfUEVSX01JTlVURSkpCisJCQkJCQkJCQkJCQkg IGlkbGVfcmVwbGljYXRpb25fc2xvdF90aW1lb3V0X3NlY3MpKQogCQkJewogCQkJCSppbmFj dGl2ZV9zaW5jZSA9IHMtPmluYWN0aXZlX3NpbmNlOwogCQkJCXJldHVybiBSU19JTlZBTF9J RExFX1RJTUVPVVQ7CmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC91dGlscy9taXNjL2d1Y190 YWJsZXMuYyBiL3NyYy9iYWNrZW5kL3V0aWxzL21pc2MvZ3VjX3RhYmxlcy5jCmluZGV4IDUx MWRjMzJkNTE5Li5hOTI1YmU4Njk0NCAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvdXRpbHMv bWlzYy9ndWNfdGFibGVzLmMKKysrIGIvc3JjL2JhY2tlbmQvdXRpbHMvbWlzYy9ndWNfdGFi bGVzLmMKQEAgLTMxMDAsMTAgKzMxMDAsMTAgQEAgc3RydWN0IGNvbmZpZ19pbnQgQ29uZmln dXJlTmFtZXNJbnRbXSA9CiAJCQlnZXR0ZXh0X25vb3AoIlNldHMgdGhlIGR1cmF0aW9uIGEg cmVwbGljYXRpb24gc2xvdCBjYW4gcmVtYWluIGlkbGUgYmVmb3JlICIKIAkJCQkJCSAiaXQg aXMgaW52YWxpZGF0ZWQuIiksCiAJCQlOVUxMLAotCQkJR1VDX1VOSVRfTUlOCisJCQlHVUNf VU5JVF9TCiAJCX0sCi0JCSZpZGxlX3JlcGxpY2F0aW9uX3Nsb3RfdGltZW91dF9taW5zLAot CQkwLCAwLCBJTlRfTUFYIC8gU0VDU19QRVJfTUlOVVRFLAorCQkmaWRsZV9yZXBsaWNhdGlv bl9zbG90X3RpbWVvdXRfc2VjcywKKwkJMCwgMCwgSU5UX01BWCwKIAkJY2hlY2tfaWRsZV9y ZXBsaWNhdGlvbl9zbG90X3RpbWVvdXQsIE5VTEwsIE5VTEwKIAl9LAogCmRpZmYgLS1naXQg YS9zcmMvYmFja2VuZC91dGlscy9taXNjL3Bvc3RncmVzcWwuY29uZi5zYW1wbGUgYi9zcmMv YmFja2VuZC91dGlscy9taXNjL3Bvc3RncmVzcWwuY29uZi5zYW1wbGUKaW5kZXggMzQxZjg4 YWRjODcuLmE5ZDgyOTM0NzRhIDEwMDY0NAotLS0gYS9zcmMvYmFja2VuZC91dGlscy9taXNj L3Bvc3RncmVzcWwuY29uZi5zYW1wbGUKKysrIGIvc3JjL2JhY2tlbmQvdXRpbHMvbWlzYy9w b3N0Z3Jlc3FsLmNvbmYuc2FtcGxlCkBAIC0zNDIsNyArMzQyLDcgQEAKIAkJCQkjIChjaGFu Z2UgcmVxdWlyZXMgcmVzdGFydCkKICN3YWxfa2VlcF9zaXplID0gMAkJIyBpbiBtZWdhYnl0 ZXM7IDAgZGlzYWJsZXMKICNtYXhfc2xvdF93YWxfa2VlcF9zaXplID0gLTEJIyBpbiBtZWdh Ynl0ZXM7IC0xIGRpc2FibGVzCi0jaWRsZV9yZXBsaWNhdGlvbl9zbG90X3RpbWVvdXQgPSAw CSMgaW4gbWludXRlczsgMCBkaXNhYmxlcworI2lkbGVfcmVwbGljYXRpb25fc2xvdF90aW1l b3V0ID0gMAkjIGluIHNlY29uZHM7IDAgZGlzYWJsZXMKICN3YWxfc2VuZGVyX3RpbWVvdXQg PSA2MHMJIyBpbiBtaWxsaXNlY29uZHM7IDAgZGlzYWJsZXMKICN0cmFja19jb21taXRfdGlt ZXN0YW1wID0gb2ZmCSMgY29sbGVjdCB0aW1lc3RhbXAgb2YgdHJhbnNhY3Rpb24gY29tbWl0 CiAJCQkJIyAoY2hhbmdlIHJlcXVpcmVzIHJlc3RhcnQpCmRpZmYgLS1naXQgYS9zcmMvaW5j bHVkZS9yZXBsaWNhdGlvbi9zbG90LmggYi9zcmMvaW5jbHVkZS9yZXBsaWNhdGlvbi9zbG90 LmgKaW5kZXggZmZhY2JhOWQyYWUuLjc2YWVlYjkyMjQyIDEwMDY0NAotLS0gYS9zcmMvaW5j bHVkZS9yZXBsaWNhdGlvbi9zbG90LmgKKysrIGIvc3JjL2luY2x1ZGUvcmVwbGljYXRpb24v c2xvdC5oCkBAIC0yNjYsNyArMjY2LDcgQEAgZXh0ZXJuIFBHRExMSU1QT1JUIFJlcGxpY2F0 aW9uU2xvdCAqTXlSZXBsaWNhdGlvblNsb3Q7CiAvKiBHVUNzICovCiBleHRlcm4gUEdETExJ TVBPUlQgaW50IG1heF9yZXBsaWNhdGlvbl9zbG90czsKIGV4dGVybiBQR0RMTElNUE9SVCBj aGFyICpzeW5jaHJvbml6ZWRfc3RhbmRieV9zbG90czsKLWV4dGVybiBQR0RMTElNUE9SVCBp bnQgaWRsZV9yZXBsaWNhdGlvbl9zbG90X3RpbWVvdXRfbWluczsKK2V4dGVybiBQR0RMTElN UE9SVCBpbnQgaWRsZV9yZXBsaWNhdGlvbl9zbG90X3RpbWVvdXRfc2VjczsKIAogLyogc2ht ZW0gaW5pdGlhbGl6YXRpb24gZnVuY3Rpb25zICovCiBleHRlcm4gU2l6ZSBSZXBsaWNhdGlv blNsb3RzU2htZW1TaXplKHZvaWQpOwotLSAKMi40OS4wCgo= --------------LExQKQEWy7KR2jN30fDf3BWY--