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 1qNz4F-006VBe-Bw for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Jul 2023 17:09:55 +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 1qNz4D-00C4bx-U5 for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Jul 2023 17:09:53 +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 1qNz4D-00C4bp-LC for pgsql-hackers@lists.postgresql.org; Mon, 24 Jul 2023 17:09:53 +0000 Received: from mail-oi1-x22a.google.com ([2607:f8b0:4864:20::22a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qNz4A-001LY4-Ur for pgsql-hackers@postgresql.org; Mon, 24 Jul 2023 17:09:52 +0000 Received: by mail-oi1-x22a.google.com with SMTP id 5614622812f47-3a5ad21a1f9so945947b6e.2 for ; Mon, 24 Jul 2023 10:09:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=neon-tech.20221208.gappssmtp.com; s=20221208; t=1690218590; x=1690823390; h=in-reply-to:references:message-id:from:to:subject:date:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=u6eFGqJlourzbM3Go4t9YRF6h9DWqGD9rpHXIZDMBZA=; b=b6NVR/EGcUGgUqfeH5OSYlYcsXtC5GyKE3SpvA3fT0NFpOcvygId7QdfuAIdENPpVQ 92Mx5D+QW9Z67/9zk5dWnvMUL+Xc55SyYqvbRfmQl8/RQNhH6eRiu3eImu7pU0x0l+25 D4B7XBmWPhHGTS9reOxAAD80nZsv3fbE4ITT10r/IxOiB6dFdKEYjnJ1qRh9Xp2ms2eq /O8AzQsgruyUpxVCxkXMP+bx5A9rRicZnMOGAvR/zu9zWG4ldpeqhIVfeNtRO0qAhOhg EK37i7AK68lzfMOEygJueKV40i0iouNg9Vt+MuJA+SST0PsPEhUWeiff8YlIChlARa2U Bnjw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690218590; x=1690823390; h=in-reply-to:references:message-id:from:to:subject:date:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=u6eFGqJlourzbM3Go4t9YRF6h9DWqGD9rpHXIZDMBZA=; b=AnlOruK4ZlTH86xzXSX9GDCTcDOd2qky8xST9+x+hg7hB9HLjrc2JAhxyRMEmN4ElX ykp4yybzS0hfzGVjQ1iHArpQVjHSraU0Hjhl4QzWhnBCoCkmZ4VNmlBbUSj5Jc4cFT2t hBXHM96vloMMdzgi/LpMLSstr7thYXrDFXrcVIKBUyqRRSV83egowDyLFrLhpOmcDG2H 9UgHS/BC8kQguQCkT4Z4/n40kRsKewT9+HTMoSoF4k8Ybriyy7PiKpoQyPJD8+gm5Bzl tUdftygxK70wWTmGKiWmzg1dOkSS3JmD180rQUhJnSs+/gLnyerNhy+QYv9SUucNn8ch G/XQ== X-Gm-Message-State: ABy/qLYcsBqHl7MfPHggTSg+iic3D1FZNtYvQp+eVDeiRbmn6ooAkkN6 BAuuDglKMgBuZOEhj3Ehgc10cgWdlQFfnhLd7o8= X-Google-Smtp-Source: APBJJlGWpLt2qn1DvGHon4Uu/fxiD1YPfxBps6A0y6PVQ1+B1msUWvUAlOv+eYSzX1D8rPBzgh5MlQ== X-Received: by 2002:aca:2102:0:b0:3a1:d3f2:70b7 with SMTP id 2-20020aca2102000000b003a1d3f270b7mr11281071oiz.18.1690218590413; Mon, 24 Jul 2023 10:09:50 -0700 (PDT) Received: from localhost ([2607:fb91:12af:534d:3996:e070:71ee:42fb]) by smtp.gmail.com with ESMTPSA id 15-20020aca210f000000b003a1f444307esm4262751oiz.58.2023.07.24.10.09.49 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 24 Jul 2023 10:09:49 -0700 (PDT) Content-Type: multipart/mixed; boundary=b53659af7b65792048e2ac6452003478e268418aa0b0e4aa55df159e2661 Mime-Version: 1.0 Date: Mon, 24 Jul 2023 12:09:49 -0500 Subject: Re: psql not responding to SIGINT upon db reconnection To: "Tristan Partin" , From: "Tristan Partin" Message-Id: X-Mailer: aerc 0.15.2-105-g00bf476582f7 References: In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --b53659af7b65792048e2ac6452003478e268418aa0b0e4aa55df159e2661 Content-Type: multipart/alternative; boundary=e85002245028f6953d6ab94bc3323bc4a3872aa0aa59d7270f0363a19699 --e85002245028f6953d6ab94bc3323bc4a3872aa0aa59d7270f0363a19699 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Type: text/plain; charset=UTF-8; format=Flowed v2 is attached which fixes a grammatical issue in a comment. --=20 Tristan Partin Neon (https://neon.tech) --e85002245028f6953d6ab94bc3323bc4a3872aa0aa59d7270f0363a19699-- --b53659af7b65792048e2ac6452003478e268418aa0b0e4aa55df159e2661 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=v2-0001-Allow-SIGINT-to-cancel-psql-database-reconnection.patch Content-Type: text/x-patch; charset=utf-8; name=v2-0001-Allow-SIGINT-to-cancel-psql-database-reconnection.patch RnJvbSBiOWNjZmMzYzg0YTI1Yjg2MTZmZDQwNDk1OTU0YmI2Zjc3Nzg4ZTI4IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBUcmlzdGFuIFBhcnRpbiA8dHJpc3RhbkBuZW9uLnRlY2g+CkRh dGU6IE1vbiwgMjQgSnVsIDIwMjMgMTE6MTI6NTkgLTA1MDAKU3ViamVjdDogW1BBVENIIHYyXSBB bGxvdyBTSUdJTlQgdG8gY2FuY2VsIHBzcWwgZGF0YWJhc2UgcmVjb25uZWN0aW9ucwoKQWZ0ZXIg aW5zdGFsbGluZyB0aGUgU0lHSU5UIGhhbmRsZXIgaW4gcHNxbCwgU0lHSU5UIGNhbiBubyBsb25n ZXIgY2FuY2VsCmRhdGFiYXNlIHJlY29ubmVjdGlvbnMuIEZvciBpbnN0YW5jZSwgaWYgdGhlIHVz ZXIgc3RhcnRzIGEgcmVjb25uZWN0aW9uCmFuZCB0aGVuIG5lZWRzIHRvIGRvIHNvbWUgZm9ybSBv ZiBpbnRlcmFjdGlvbiAoaWUgcHNxbCBpcyBwb2xsaW5nKSwKdGhlcmUgaXMgbm8gd2F5IHRvIGNh bmNlbCB0aGUgcmVjb25uZWN0aW9uIHByb2Nlc3MgY3VycmVudGx5LgoKUmVzdG9yZSB0aGUgZGVm YXVsdCBTSUdJTlQgaGFuZGxlciB3aGlsZSBwb2xsaW5nIGluIFBRY29ubmVjdGRiUGFyYW1zKCks CmFuZCBwdXQgdGhlIGN1c3RvbSBoYW5kbGVyIGJhY2sgYWZ0ZXJ3YXJkLgotLS0KIHNyYy9iaW4v cHNxbC9jb21tYW5kLmMgfCAxOSArKysrKysrKysrKysrKysrKysrCiAxIGZpbGUgY2hhbmdlZCwg MTkgaW5zZXJ0aW9ucygrKQoKZGlmZiAtLWdpdCBhL3NyYy9iaW4vcHNxbC9jb21tYW5kLmMgYi9z cmMvYmluL3BzcWwvY29tbWFuZC5jCmluZGV4IDY3MzNmMDA4ZmQuLmU0MDQxM2EyMjkgMTAwNjQ0 Ci0tLSBhL3NyYy9iaW4vcHNxbC9jb21tYW5kLmMKKysrIGIvc3JjL2Jpbi9wc3FsL2NvbW1hbmQu YwpAQCAtNDAsNiArNDAsNyBAQAogI2luY2x1ZGUgImxhcmdlX29iai5oIgogI2luY2x1ZGUgImxp YnBxLWZlLmgiCiAjaW5jbHVkZSAibGlicHEvcHFjb21tLmgiCisjaW5jbHVkZSAibGlicHEvcHFz aWduYWwuaCIKICNpbmNsdWRlICJtYWlubG9vcC5oIgogI2luY2x1ZGUgInBvcnRhYmlsaXR5L2lu c3RyX3RpbWUuaCIKICNpbmNsdWRlICJwcWV4cGJ1ZmZlci5oIgpAQCAtMzUzMCw4ICszNTMxLDEx IEBAIGRvX2Nvbm5lY3QoZW51bSB0cml2YWx1ZSByZXVzZV9wcmV2aW91c19zcGVjaWZpY2F0aW9u LAogCXsKIAkJY29uc3QgY2hhciAqKmtleXdvcmRzID0gcGdfbWFsbG9jKChuY29ubm9wdHMgKyAx KSAqIHNpemVvZigqa2V5d29yZHMpKTsKIAkJY29uc3QgY2hhciAqKnZhbHVlcyA9IHBnX21hbGxv YygobmNvbm5vcHRzICsgMSkgKiBzaXplb2YoKnZhbHVlcykpOworCQlpbnQJCQlyYzsKIAkJaW50 CQkJcGFyYW1udW0gPSAwOwogCQlQUWNvbm5pbmZvT3B0aW9uICpjaTsKKwkJc3RydWN0IHNpZ2Fj dGlvbiBvbGRhY3Q7CisJCXN0cnVjdCBzaWdhY3Rpb24gbmV3YWN0ID0geyAwIH07CiAKIAkJLyoK IAkJICogQ29weSBub24tZGVmYXVsdCBzZXR0aW5ncyBpbnRvIHRoZSBQUWNvbm5lY3RkYlBhcmFt cyBwYXJhbWV0ZXIKQEAgLTM1NzYsOSArMzU4MCwyNCBAQCBkb19jb25uZWN0KGVudW0gdHJpdmFs dWUgcmV1c2VfcHJldmlvdXNfc3BlY2lmaWNhdGlvbiwKIAkJa2V5d29yZHNbcGFyYW1udW1dID0g TlVMTDsKIAkJdmFsdWVzW3BhcmFtbnVtXSA9IE5VTEw7CiAKKwkJLyoKKwkJICogUmVzdG9yZSB0 aGUgZGVmYXVsdCBTSUdJTlQgYmVoYXZpb3Igd2hpbGUgd2l0aGluIGxpYnBxLiBPdGhlcndpc2Us IHdlCisJCSAqIGNhbiBuZXZlciBleGl0IGZyb20gcG9sbGluZyBmb3IgdGhlIGRhdGFiYXNlIGNv bm5lY3Rpb24uIEZhaWx1cmUgdG8KKwkJICogcmVzdG9yZSBpcyBub24tZmF0YWwuCisJCSAqLwor CQluZXdhY3Quc2FfaGFuZGxlciA9IFNJR19ERkw7CisJCXJjID0gc2lnYWN0aW9uKFNJR0lOVCwg Jm5ld2FjdCwgJm9sZGFjdCk7CisKIAkJLyogTm90ZSB3ZSBkbyBub3Qgd2FudCBsaWJwcSB0byBy ZS1leHBhbmQgdGhlIGRibmFtZSBwYXJhbWV0ZXIgKi8KIAkJbl9jb25uID0gUFFjb25uZWN0ZGJQ YXJhbXMoa2V5d29yZHMsIHZhbHVlcywgZmFsc2UpOwogCisJCS8qCisJCSAqIE9ubHkgYXR0ZW1w dCB0byByZXN0b3JlIHRoZSBvbGQgaGFuZGxlciBpZiB3ZSBzdWNjZXNzZnVsbHkgb3Zlcndyb3Rl CisJCSAqIGl0IGluaXRpYWxseS4KKwkJICovCisJCWlmIChyYyA9PSAwKQorCQkJc2lnYWN0aW9u KFNJR0lOVCwgJm9sZGFjdCwgTlVMTCk7CisKIAkJcGdfZnJlZShrZXl3b3Jkcyk7CiAJCXBnX2Zy ZWUodmFsdWVzKTsKIAotLSAKVHJpc3RhbiBQYXJ0aW4KTmVvbiAoaHR0cHM6Ly9uZW9uLnRlY2gp Cgo= --b53659af7b65792048e2ac6452003478e268418aa0b0e4aa55df159e2661--