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 1peRHB-0004Og-Ok for pgsql-committers@arkaria.postgresql.org; Tue, 21 Mar 2023 01:59:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1peRHA-00041K-Mu for pgsql-committers@arkaria.postgresql.org; Tue, 21 Mar 2023 01:59:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peRHA-00041B-F3 for pgsql-committers@lists.postgresql.org; Tue, 21 Mar 2023 01:59:00 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peRH7-0000EI-NW for pgsql-committers@lists.postgresql.org; Tue, 21 Mar 2023 01:59:00 +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=OaWorC9O6V9AE0EiUABK5R5JCkhLx/t3nqt1aoIrHmg=; b=wM36I4p4GT1ZzHkorpIhFR1YBJ SnPr6RmSoI/IM8j+On4880BKm+NG2i2pTrNLiKqw7MU0e9coVAcBi2Vt3nu4kpjYEO4DDGoIdIqjk kFZDoKbSDgwUTaCnYhO2/RvmGDMS72smGM1gTg1bX7fAGB6WOzOUhTiag7rmydtd+nwI7idSvGNm9 S6LJ//Cd8KrgTgqSanI7GpgfaMuM0Iep7tQkBSX8hpk8YiNqz14V+bvAMPfBbfGDa4ieUlpS1CcQh +cezMlQGZM9Kp3BFIZ/zExgIr1ntN0e3rKzsJDiB2t6HA7VyS7BQyDc27scHyvhP6nc7nXkLWiBz2 rTl97Nmw==; 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 1peRH6-00035f-Hx for pgsql-committers@lists.postgresql.org; Tue, 21 Mar 2023 01:58:56 +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 1peRH5-004ZeN-LH for pgsql-committers@lists.postgresql.org; Tue, 21 Mar 2023 01:58:56 +0000 Content-Type: multipart/mixed; boundary="===============4895904531688419801==" 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:58:56 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4895904531688419801== 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 OTYlNDBwYXF1aWVyLnh5egoKQnJhbmNoCi0tLS0tLQpSRUxfMTJfU1RBQkxFCgpEZXRhaWxzCi0t LS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi80NGQ0NGFhOTcx MmYzMTViMTI1YzljNWYyYTE2NDBlYmI3MGUxZDJmCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0t LS0tLQpzcmMvYmFja2VuZC9leGVjdXRvci9ub2RlSGFzaC5jICAgICB8IDUwICsrKysrKysrKysr KysrKysrKysrKysrLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvZXhlY3V0b3Ivbm9kZUhhc2hqb2lu LmMgfCA1NCArKysrKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0tLS0tCnNyYy9pbmNsdWRl L2V4ZWN1dG9yL2hhc2hqb2luLmggICAgIHwgIDMgKystCjMgZmlsZXMgY2hhbmdlZCwgNzQgaW5z ZXJ0aW9ucygrKSwgMzMgZGVsZXRpb25zKC0pCgo= --===============4895904531688419801==--