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 1peRHL-0004PE-QQ for pgsql-committers@arkaria.postgresql.org; Tue, 21 Mar 2023 01:59:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1peRHK-0004X5-LF for pgsql-committers@arkaria.postgresql.org; Tue, 21 Mar 2023 01:59:10 +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 1peRHK-0004Wu-DP for pgsql-committers@lists.postgresql.org; Tue, 21 Mar 2023 01:59:10 +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 1peRHH-0000P2-CO for pgsql-committers@lists.postgresql.org; Tue, 21 Mar 2023 01:59:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=fOhfX1ckFTXCcwOFmzMvx513y5++tZnrpCcMc9VJ2pM=; b=lVj888UL+yAxPk5Dpdt834iJEy v3rZNl9Jq2JUVLlKVuw3hcmuzyvnE1vMV+XNp2mFjq9bqsbglI9oUVrZJTfqrMbM+RS4WnpHhnHA4 2L71bTvnwvB4WJLbp2hcRaKbaXieG4mM3YDpiliiI/H9z3cM7yDGWpA0WItzp01wBCXQOua9vUmGu 9ix9zjbXNMtzpzvveK1o9XjoI21GXB/CxhkQQX8nNpA/8pFfpDvOGyTAp/IEiRESCTUCjGD4vyuBC mFEwXX0/i97wv7FvUN5lTaJx0Bru+TyjNQLjBn13ORH7g5m1RCeo6lfpbz63+0HBKXKsY8lQuVDCQ 7BuOABmA==; 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 1peRHH-000367-3l for pgsql-committers@lists.postgresql.org; Tue, 21 Mar 2023 01:59:07 +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 1peRHG-004Zf2-7y for pgsql-committers@lists.postgresql.org; Tue, 21 Mar 2023 01:59:06 +0000 Content-Type: multipart/mixed; boundary="===============6604242034617358777==" MIME-Version: 1.0 From: Thomas Munro To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix race in parallel hash join batch cleanup, take II. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 21 Mar 2023 01:59:06 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6604242034617358777== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHJhY2UgaW4gcGFyYWxsZWwgaGFzaCBqb2luIGJhdGNoIGNsZWFudXAsIHRha2UgSUkuCgpX aXRoIHVubHVja3kgdGltaW5nIGFuZCBwYXJhbGxlbF9sZWFkZXJfcGFydGljaXBhdGlvbj1vZmYg KG5vdCB0aGUKZGVmYXVsdCksIFBISiBjb3VsZCBhdHRlbXB0IHRvIGFjY2VzcyBwZXItYmF0Y2gg c2hhcmVkIHN0YXRlIGp1c3QgYXMgaXQKd2FzIGJlaW5nIGZyZWVkLiAgVGhlcmUgd2FzIGNvZGUg aW50ZW5kZWQgdG8gcHJldmVudCB0aGF0IGJ5IGNoZWNraW5nCmZvciBhIGNsZWFyZWQgcG9pbnRl ciwgYnV0IGl0IHdhcyByYWN5LiAgRml4LCBieSBpbnRyb2R1Y2luZyBhbiBleHRyYQpiYXJyaWVy IHBoYXNlLiAgVGhlIG5ldyBwaGFzZSBQSEpfQlVJTERfUlVOTklORyBtZWFucyB0aGF0IGl0J3Mg c2FmZSB0bwphY2Nlc3MgdGhlIHBlci1iYXRjaCBzdGF0ZSB0byBmaW5kIGEgYmF0Y2ggdG8gaGVs cCB3aXRoLCBhbmQKUEhKX0JVSUxEX0RPTkUgbWVhbnMgdGhhdCBpdCBpcyB0b28gbGF0ZS4gIFRo ZSBsYXN0IHRvIGRldGFjaCB3aWxsIGZyZWUKdGhlIGFycmF5IG9mIHBlci1iYXRjaCBzdGF0ZSBh cyBiZWZvcmUsIGJ1dCBub3cgaXQgd2lsbCBhbHNvIGF0b21pY2FsbHkKYWR2YW5jZSB0aGUgcGhh c2UsIHNvIHRoYXQgbGF0ZSBhdHRhY2hlcnMgY2FuIGF2b2lkIHRoZSBoYXphcmQuICBUaGlzCm1p cnJvcnMgdGhlIHdheSBwZXItYmF0Y2ggaGFzaCB0YWJsZXMgYXJlIGZyZWVkIChzZWUgcGhhc2Vz ClBISl9CQVRDSF9QUk9CSU5HIGFuZCBQSEpfQkFUQ0hfRE9ORSkuCgpBbiBlYXJsaWVyIGF0dGVt cHQgdG8gZml4IHRoaXMgKGNvbW1pdCAzYjg5ODFiNiwgbGF0ZXIgcmV2ZXJ0ZWQpIG1pc3NlZApv bmUgc3BlY2lhbCBjYXNlLiAgV2hlbiB0aGUgaW5uZXIgc2lkZSBpcyBlbXB0eSAodGhlICJlbXB0 eSBpbm5lcgpvcHRpbWl6YXRpb24pLCB0aGUgYnVpbGQgYmFycmllciB3b3VsZCBvbmx5IG1ha2Ug aXQgdG8KUEhKX0JVSUxEX0hBU0hJTkdfSU5ORVIgcGhhc2UgYmVmb3JlIHdvcmtlcnMgYXR0ZW1w dGVkIHRvIGRldGFjaCBmcm9tCnRoZSBoYXNodGFibGUuICBJbiB0aGF0IGNhc2UsIGZhc3QtZm9y d2FyZCB0aGUgYnVpbGQgYmFycmllciB0bwpQSEpfQlVJTERfUlVOTklORyBiZWZvcmUgcHJvY2Vl ZGluZywgc28gdGhhdCBvdXIgbGF0ZXIgYXNzZXJ0aW9ucyBob2xkCmFuZCB3ZSBjYW4gc3RpbGwg bmVnb3RpYXRlIHdobyBpcyBjbGVhbmluZyB1cC4KClJldmVhbGVkIGJ5IGJ1aWxkIGZhcm0gZmFp bHVyZXMsIHdoZXJlIEJhcnJpZXJBdHRhY2goKSBmYWlsZWQgYSBzYW5pdHkKY2hlY2sgYXNzZXJ0 aW9uLCBiZWNhdXNlIHRoZSBtZW1vcnkgaGFkIGJlZW4gY2xvYmJlcmVkIGJ5IGRzYV9mcmVlKCku CkluIG5vbi1hc3NlcnQgYnVpbGRzLCB0aGUgcmVzdWx0IGNvdWxkIGJlIGEgc2VnbWVudGF0aW9u IGZhdWx0LgoKQmFjay1wYXRjaCB0byBhbGwgc3VwcG9ydGVkIHJlbGVhc2VzLgoKQXV0aG9yOiBU aG9tYXMgTXVucm8gPHRob21hcy5tdW5yb0BnbWFpbC5jb20+CkF1dGhvcjogTWVsYW5pZSBQbGFn ZW1hbiA8bWVsYW5pZXBsYWdlbWFuQGdtYWlsLmNvbT4KUmVwb3J0ZWQtYnk6IE1pY2hhZWwgUGFx dWllciA8bWljaGFlbEBwYXF1aWVyLnh5ej4KUmVwb3J0ZWQtYnk6IERhdmlkIEdlaWVyIDxnZWlk YXYucGdAZ21haWwuY29tPgpUZXN0ZWQtYnk6IERhdmlkIEdlaWVyIDxnZWlkYXYucGdAZ21haWwu Y29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzIwMjAwOTI5MDYxMTQyLkdBMjkw OTYlNDBwYXF1aWVyLnh5egoKQnJhbmNoCi0tLS0tLQpSRUxfMTFfU1RBQkxFCgpEZXRhaWxzCi0t LS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9lZjE2ZDI3MjQ1 ZjYxNjdhY2Q4NzhiZWE0OWNkZGUwYThkY2VjNDljCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0t LS0tLQpzcmMvYmFja2VuZC9leGVjdXRvci9ub2RlSGFzaC5jICAgICB8IDUwICsrKysrKysrKysr KysrKysrKysrKysrLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvZXhlY3V0b3Ivbm9kZUhhc2hqb2lu LmMgfCA1NCArKysrKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0tLS0tCnNyYy9pbmNsdWRl L2V4ZWN1dG9yL2hhc2hqb2luLmggICAgIHwgIDMgKystCjMgZmlsZXMgY2hhbmdlZCwgNzQgaW5z ZXJ0aW9ucygrKSwgMzMgZGVsZXRpb25zKC0pCgo= --===============6604242034617358777==--