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 1qNz5r-006VFp-6J for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Jul 2023 17:11:35 +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 1qNz5p-00C6fC-DS for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Jul 2023 17:11:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qNz5p-00C6f4-4D for pgsql-hackers@lists.postgresql.org; Mon, 24 Jul 2023 17:11:33 +0000 Received: from mail-oo1-xc33.google.com ([2607:f8b0:4864:20::c33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qNz5m-0003hx-NM for pgsql-hackers@postgresql.org; Mon, 24 Jul 2023 17:11:32 +0000 Received: by mail-oo1-xc33.google.com with SMTP id 006d021491bc7-565db4666d7so2859745eaf.0 for ; Mon, 24 Jul 2023 10:11:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=neon-tech.20221208.gappssmtp.com; s=20221208; t=1690218689; x=1690823489; h=in-reply-to:references:message-id:from:to:subject:date:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=7dN6Szzz0JBjf3A8cwr+9OE/rJIjHHUnpw1YWWpILUQ=; b=eLwdJdO0g4t5ui9Nfl59ZsVsz5qfrqFSiQ8VNXOt2zbN/EQXqdW6p9PtB5c2neCV2F KmYbTpyBCfhEK1MF54AVWZ4wQ0xq4RnEXkrKwbjnwnfIyUIj0M5HEHYeNhvYQMnCW3t/ AYiMyMv4wSyQ4thsaFMbZxf47XvYIGzAt1bD3EmeCpGc4ffzirjlwiSyzMmzzN3MyFTb 3iKgQ5Y/Sf0z8lFdCdXYh7Ko5Du77skf86iKIYiRnNPPRUdTJTTir2ifIj8APvEZIzze 8yGa3xD30+c/0jms3+dE4FA29rYxVxKOQM21HP6ELAdHoAQtpJ58c+FzOfMglbkFXIQn 0X3Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690218689; x=1690823489; 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=7dN6Szzz0JBjf3A8cwr+9OE/rJIjHHUnpw1YWWpILUQ=; b=PgzAfcmFCkAy0QnAziF54kRB2/0xpmZdjIpU5KvUd3CYIzyxoHllZkk+im3sJWtyhv 6m/oKzOeFwqlVdG7+QZCpHaKm3AtQMXVniLgkDwpvFkQAMdtGXqGVMSNnqKeLhLZg5HL PSDBgDX8UfOiivXlsEF5zZDXmUZmUNS2Vfy8E8hxo1Qzw3fDWERu3S6WkVwRyxWKPK+t eIKnzmvVQX9iRvTwfkXCfS/BkxQRtJBKBTeTaWQ9MhmySM2BS4b5lilVLUw1juxzEh2G lVtbkEKkx0Yz8BiXqRmepQbjUWImdn2iyjNpTFpaK4fi2CpnZL5WgN/I2VqUPFlfGEbD BYMQ== X-Gm-Message-State: ABy/qLYPKu/QYQ2SR+IahMUC7BJamIVujoLqkMnQrEp9G16VuMwfQq8K Pd4zrr4lLqjalFoVYRxWTL0bUiG1twS61Cxyf0k= X-Google-Smtp-Source: APBJJlGiyh1P8NrjEqNeOu6c6VoPK2CRVMovMWbfgCSafaMdn72RaabZI0T0/NepYZYQXEP7h5PtRA== X-Received: by 2002:a05:6808:bc3:b0:3a1:f0dc:def3 with SMTP id o3-20020a0568080bc300b003a1f0dcdef3mr12281710oik.41.1690218689065; Mon, 24 Jul 2023 10:11:29 -0700 (PDT) Received: from localhost ([2607:fb91:12af:534d:3996:e070:71ee:42fb]) by smtp.gmail.com with ESMTPSA id q2-20020a0568080a8200b003a3fa4a7b5bsm4247978oij.27.2023.07.24.10.11.28 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 24 Jul 2023 10:11:28 -0700 (PDT) Content-Type: multipart/mixed; boundary=96e3ee5cf51ba1e57bfe7e358b49e107b004cf3446e714b36f7df5300976 Mime-Version: 1.0 Date: Mon, 24 Jul 2023 12:11:27 -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 --96e3ee5cf51ba1e57bfe7e358b49e107b004cf3446e714b36f7df5300976 Content-Type: multipart/alternative; boundary=8e9e74abfe68a5105258351a28c59cbc70a261433ffd3cddb4846fec0b59 --8e9e74abfe68a5105258351a28c59cbc70a261433ffd3cddb4846fec0b59 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Type: text/plain; charset=UTF-8; format=Flowed v3 is attached which fixes up some code comments I added which I hadn't=20 attached to the commit already, sigh. --=20 Tristan Partin Neon (https://neon.tech) --8e9e74abfe68a5105258351a28c59cbc70a261433ffd3cddb4846fec0b59-- --96e3ee5cf51ba1e57bfe7e358b49e107b004cf3446e714b36f7df5300976 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=v3-0001-Allow-SIGINT-to-cancel-psql-database-reconnection.patch Content-Type: text/x-patch; charset=utf-8; name=v3-0001-Allow-SIGINT-to-cancel-psql-database-reconnection.patch RnJvbSA3Zjk1NTQ5NDQ5MTFjNzdhYTFhMTkwMDUzN2E5MWUxZTdiZDc1ZDkzIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBUcmlzdGFuIFBhcnRpbiA8dHJpc3RhbkBuZW9uLnRlY2g+CkRh dGU6IE1vbiwgMjQgSnVsIDIwMjMgMTE6MTI6NTkgLTA1MDAKU3ViamVjdDogW1BBVENIIHYzXSBB bGxvdyBTSUdJTlQgdG8gY2FuY2VsIHBzcWwgZGF0YWJhc2UgcmVjb25uZWN0aW9ucwoKQWZ0ZXIg aW5zdGFsbGluZyB0aGUgU0lHSU5UIGhhbmRsZXIgaW4gcHNxbCwgU0lHSU5UIGNhbiBubyBsb25n ZXIgY2FuY2VsCmRhdGFiYXNlIHJlY29ubmVjdGlvbnMuIEZvciBpbnN0YW5jZSwgaWYgdGhlIHVz ZXIgc3RhcnRzIGEgcmVjb25uZWN0aW9uCmFuZCB0aGVuIG5lZWRzIHRvIGRvIHNvbWUgZm9ybSBv ZiBpbnRlcmFjdGlvbiAoaWUgcHNxbCBpcyBwb2xsaW5nKSwKdGhlcmUgaXMgbm8gd2F5IHRvIGNh bmNlbCB0aGUgcmVjb25uZWN0aW9uIHByb2Nlc3MgY3VycmVudGx5LgoKUmVzdG9yZSB0aGUgZGVm YXVsdCBTSUdJTlQgaGFuZGxlciB3aGlsZSBwb2xsaW5nIGluIFBRY29ubmVjdGRiUGFyYW1zKCks CmFuZCBwdXQgdGhlIGN1c3RvbSBoYW5kbGVyIGJhY2sgYWZ0ZXJ3YXJkLgotLS0KIHNyYy9iaW4v cHNxbC9jb21tYW5kLmMgfCAxOSArKysrKysrKysrKysrKysrKysrCiAxIGZpbGUgY2hhbmdlZCwg MTkgaW5zZXJ0aW9ucygrKQoKZGlmZiAtLWdpdCBhL3NyYy9iaW4vcHNxbC9jb21tYW5kLmMgYi9z cmMvYmluL3BzcWwvY29tbWFuZC5jCmluZGV4IDY3MzNmMDA4ZmQuLjExZGVkYmI0YzYgMTAwNjQ0 Ci0tLSBhL3NyYy9iaW4vcHNxbC9jb21tYW5kLmMKKysrIGIvc3JjL2Jpbi9wc3FsL2NvbW1hbmQu YwpAQCAtNDAsNiArNDAsNyBAQAogI2luY2x1ZGUgImxhcmdlX29iai5oIgogI2luY2x1ZGUgImxp YnBxLWZlLmgiCiAjaW5jbHVkZSAibGlicHEvcHFjb21tLmgiCisjaW5jbHVkZSAibGlicHEvcHFz aWduYWwuaCIKICNpbmNsdWRlICJtYWlubG9vcC5oIgogI2luY2x1ZGUgInBvcnRhYmlsaXR5L2lu c3RyX3RpbWUuaCIKICNpbmNsdWRlICJwcWV4cGJ1ZmZlci5oIgpAQCAtMzUzMCw4ICszNTMxLDEx IEBAIGRvX2Nvbm5lY3QoZW51bSB0cml2YWx1ZSByZXVzZV9wcmV2aW91c19zcGVjaWZpY2F0aW9u LAogCXsKIAkJY29uc3QgY2hhciAqKmtleXdvcmRzID0gcGdfbWFsbG9jKChuY29ubm9wdHMgKyAx KSAqIHNpemVvZigqa2V5d29yZHMpKTsKIAkJY29uc3QgY2hhciAqKnZhbHVlcyA9IHBnX21hbGxv YygobmNvbm5vcHRzICsgMSkgKiBzaXplb2YoKnZhbHVlcykpOworCQlpbnQJCQlyYzsKIAkJaW50 CQkJcGFyYW1udW0gPSAwOwogCQlQUWNvbm5pbmZvT3B0aW9uICpjaTsKKwkJc3RydWN0IHNpZ2Fj dGlvbiBvbGRhY3Q7CisJCXN0cnVjdCBzaWdhY3Rpb24gbmV3YWN0ID0geyAwIH07CiAKIAkJLyoK IAkJICogQ29weSBub24tZGVmYXVsdCBzZXR0aW5ncyBpbnRvIHRoZSBQUWNvbm5lY3RkYlBhcmFt cyBwYXJhbWV0ZXIKQEAgLTM1NzYsOSArMzU4MCwyNCBAQCBkb19jb25uZWN0KGVudW0gdHJpdmFs dWUgcmV1c2VfcHJldmlvdXNfc3BlY2lmaWNhdGlvbiwKIAkJa2V5d29yZHNbcGFyYW1udW1dID0g TlVMTDsKIAkJdmFsdWVzW3BhcmFtbnVtXSA9IE5VTEw7CiAKKwkJLyoKKwkJICogUmVzdG9yZSB0 aGUgZGVmYXVsdCBTSUdJTlQgYmVoYXZpb3Igd2hpbGUgd2l0aGluIGxpYnBxLiBPdGhlcndpc2Us CisJCSAqIFNJR0lOVCBjYW4gbmV2ZXIgZXhpdCBmcm9tIHBvbGxpbmcgZm9yIHRoZSBkYXRhYmFz ZSBjb25uZWN0aW9uLgorCQkgKiBGYWlsdXJlIHRvIHJlc3RvcmUgdGhlIGRlZmF1bHQgaXMgbm9u LWZhdGFsLgorCQkgKi8KKwkJbmV3YWN0LnNhX2hhbmRsZXIgPSBTSUdfREZMOworCQlyYyA9IHNp Z2FjdGlvbihTSUdJTlQsICZuZXdhY3QsICZvbGRhY3QpOworCiAJCS8qIE5vdGUgd2UgZG8gbm90 IHdhbnQgbGlicHEgdG8gcmUtZXhwYW5kIHRoZSBkYm5hbWUgcGFyYW1ldGVyICovCiAJCW5fY29u biA9IFBRY29ubmVjdGRiUGFyYW1zKGtleXdvcmRzLCB2YWx1ZXMsIGZhbHNlKTsKIAorCQkvKgor CQkgKiBPbmx5IGF0dGVtcHQgdG8gcmVzdG9yZSB0aGUgb2xkIGhhbmRsZXIgaWYgd2Ugc3VjY2Vz c2Z1bGx5IG92ZXJyb2RlCisJCSAqIGl0IGluaXRpYWxseS4KKwkJICovCisJCWlmIChyYyA9PSAw KQorCQkJc2lnYWN0aW9uKFNJR0lOVCwgJm9sZGFjdCwgTlVMTCk7CisKIAkJcGdfZnJlZShrZXl3 b3Jkcyk7CiAJCXBnX2ZyZWUodmFsdWVzKTsKIAotLSAKVHJpc3RhbiBQYXJ0aW4KTmVvbiAoaHR0 cHM6Ly9uZW9uLnRlY2gpCgo= --96e3ee5cf51ba1e57bfe7e358b49e107b004cf3446e714b36f7df5300976--