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 1ogTiv-00043S-Ec for pgsql-committers@arkaria.postgresql.org; Thu, 06 Oct 2022 16:27:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ogTiu-00016v-BO for pgsql-committers@arkaria.postgresql.org; Thu, 06 Oct 2022 16:27:48 +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 1ogTiu-00016m-4S for pgsql-committers@lists.postgresql.org; Thu, 06 Oct 2022 16:27:48 +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 1ogTir-00049s-Hw for pgsql-committers@lists.postgresql.org; Thu, 06 Oct 2022 16:27:47 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ogTir-0002qF-6Q for pgsql-committers@lists.postgresql.org; Thu, 06 Oct 2022 16:27:45 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ogTip-001BHB-RN for pgsql-committers@lists.postgresql.org; Thu, 06 Oct 2022 16:27:44 +0000 Content-Type: multipart/mixed; boundary="===============0842419153858552848==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Take care to de-duplicate entries in standby.c's table of locks. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 06 Oct 2022 16:27:44 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0842419153858552848== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGFrZSBjYXJlIHRvIGRlLWR1cGxpY2F0ZSBlbnRyaWVzIGluIHN0YW5kYnkuYydzIHRhYmxlIG9m IGxvY2tzLgoKVGhlIFJlY292ZXJ5TG9ja0xpc3RzIGRhdGEgc3RydWN0dXJlLCB3aGljaCB0cmFj a3MgYWxsIGV4Y2x1c2l2ZQpsb2NrcyB0aGF0IHRoZSBzdGFydHVwIHByb2Nlc3MgaXMgaG9sZGlu ZyBvbiBiZWhhbGYgb2YgdHJhbnNhY3Rpb25zCmJlaW5nIHJlcGxheWVkLCBkaWQgbm90IGhhdmUg YW55IHByb3Zpc2lvbiBmb3IgYXZvaWRpbmcgZHVwbGljYXRlCmVudHJpZXMgZm9yIHRoZSBzYW1l IGxvY2suICBNYXliZSB0aGF0IHdhcyBva2F5IHdoZW4gdGhlIGNvZGUgd2FzCmZpcnN0IHdyaXR0 ZW4uICBIb3dldmVyLCBtb2Rlcm4gcHJhY3RpY2UgaXMgZm9yIGNoZWNrcG9pbnRzIHRvCndyaXRl IGZyZXNoIGxpc3RzIG9mIGFsbCBhY3RpdmUgZXhjbHVzaXZlIGxvY2tzIGludG8gdGhlIFdBTC4K VGh1cywgYW4gZXhjbHVzaXZlIGxvY2sgdGhhdCBzdXJ2aXZlcyBhY3Jvc3MgbXVsdGlwbGUgY2hl Y2twb2ludHMKY2F1c2VzIGJsb2F0IGluIHN0YW5kYnlzJyBzdGFydHVwIHByb2Nlc3Nlcy4gIElm IHRoZXJlIGFyZSBhIGxvdApvZiBzdWNoIGxvY2tzIHRoaXMgY2FuIGxvb2sgbGlrZSBhIG1lbW9y eSBsZWFrLCBhbmQgaXQncyBldmVuCnBvc3NpYmxlIHRvIGRyaXZlIHRoZSBzdGFydHVwIHByb2Nl c3MgaW50byBhIHBhbGxvYyBmYWlsdXJlIGZyb20KYW4gb3Zlci1sZW5ndGggTGlzdC4KClRvIGZp eCwgdXNlIGEgaGFzaCB0YWJsZSBpbnN0ZWFkIG9mIHNpbXBsZSBsaXN0cyB0byB0cmFjayB0aGUK bG9ja3MgYmVpbmcgaGVsZC4gIEFsbG93aW5nIGZvciBkeW5haGFzaCBvdmVyaGVhZCwgdGhpcyBy ZXF1aXJlcwphIGxpdHRsZSBtb3JlIHNwYWNlIHBlciBsb2NrIHRoYW4gdGhlIG9sZCB3YXkgKGFs dGhvdWdoIGl0J3MgdGhlCnNhbWUgc2l6ZSBhcyB3aGF0IHdlIHdlcmUgYWxsb2NhdGluZyBwcmlv ciB0byBjNmUwZmUxZjIpLiAgSXQncwpwcm9iYWJseSBhIHNoYWRlIHNsb3dlciB0b28uICBIb3dl dmVyLCB0ZXN0aW5nIGluZGljYXRlcyB0aGF0IHRoZQpwZW5hbHR5IGlzIG5lZ2xpZ2libGUgb24g b3JkaW5hcnkgd29ya2xvYWRzLCBzbyBsZXQncyBtYWtlIHRoaXMKY2hhbmdlIHRvIGltcHJvdmUg cm9idXN0bmVzcyBpbiBleHRyZW1lIGNhc2VzLgoKUGF0Y2ggYnkgbWUsIHBlciByZXBvcnQgZnJv bSBEbWl0cml5IEt1em1pbi4gIE5vIGJhY2stcGF0Y2gKKGZvciBub3cgYW55d2F5KSwgc2luY2Ug aXQgc2VlbXMgdGhhdCBhIHNpZ25pZmljYW50IGltcHJvdmVtZW50CndvdWxkIG9ubHkgb2NjdXIg aW4gY29ybmVyIGNhc2VzLgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQUhMRHQ9 X3RzMEE3QWduPWhDcFVoK1JDRmt4ZCtHNnV1VD1rY1RmcUZ0R3VyMGRwPUFAbWFpbC5nbWFpbC5j b20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9z dGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi82NmMyOTIyZTc2YmFlZjA3ZTA1NzYzNzU5ZDI5MTJj MDcwMWE1NTkzCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9zdG9y YWdlL2lwYy9zdGFuZGJ5LmMgfCAxNzEgKysrKysrKysrKysrKysrKysrKysrKystLS0tLS0tLS0t LS0tLS0KMSBmaWxlIGNoYW5nZWQsIDEwNiBpbnNlcnRpb25zKCspLCA2NSBkZWxldGlvbnMoLSkK Cg== --===============0842419153858552848==--