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 1rfIWp-00GlGa-CE for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Feb 2024 11:55:16 +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 1rfIWn-009loP-0u for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Feb 2024 11:55:13 +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 1rfI9W-009d88-Nj for pgsql-bugs@lists.postgresql.org; Wed, 28 Feb 2024 11:31:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfI9Q-001mKz-4M for pgsql-bugs@lists.postgresql.org; Wed, 28 Feb 2024 11:31:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=yFQQoPywVib8pDdRReccUfRyLb9EeQ1H4t+LkagQjHE=; b=DK9b3t0q4pv03QvdRrby9eeucz 7dHPDosVTMqPdGkAW/Lj8vnPHlst957i5DaE7SQ/OXEkTEonISR+SspGwesm8zGD/pfFQg+aZ9sgJ SDaHrzrCEv+qWFSTLSymrssmMqakgRXAEMbyHgL72JL4WtuVG4R5Ii/6TvAiHkIbWXNnHROEWyLtc 0GWCh7YAGTRG99hGgtsnEskJvyOkanGEXE2ruEPo9RuF5SzlGrGKl6TSZoOFX66B6cb/8w+/Iuja2 SnjXr+6Plf76pMiYpa3V9JhkqeDBfCPv/V3rLyugIUsjenkPk4X7hGA9qOVWl57cmuVtpC8gROm8Q nDukEuYQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfI9O-0040Bc-SM for pgsql-bugs@lists.postgresql.org; Wed, 28 Feb 2024 11:31:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rfI9N-00AI4y-A8 for pgsql-bugs@lists.postgresql.org; Wed, 28 Feb 2024 11:31:02 +0000 Content-Type: multipart/mixed; boundary="===============7521921515072122011==" MIME-Version: 1.0 Subject: BUG #18371: There are wrong constraint residues when detach hash partiton concurrently To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: feichanghong@qq.com Reply-To: feichanghong@qq.com, pgsql-bugs@lists.postgresql.org Date: Wed, 28 Feb 2024 11:30:46 +0000 Message-ID: <18371-7fef49f63de13f02@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7521921515072122011== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODM3MQpMb2dnZWQgYnk6ICAgICAgICAgIEZlaSBDaGFuZ2hvbmcKRW1h aWwgYWRkcmVzczogICAgICBmZWljaGFuZ2hvbmdAcXEuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTYuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIE9wZXJhdGluZyBzeXN0ZW06IGNlbnRvcyA3LEtlcm5l bCB2ZXJzaW9uOiA1LjEwLjEzCkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaSBhbGwsDQoNCldoZW4g SSB0cmllZCB0byBpbnNlcnQgZGF0YSBpbnRvIGEgdGFibGUgdGhhdCBoYWQganVzdCBiZWVuIGRl dGFjaGVkLCBJDQplbmNvdW50ZXJlZCBhbiBlcnJvcjogIkVSUk9SOiBjb3VsZCBub3Qgb3BlbiBy ZWxhdGlvbiB3aXRoIE9JRCAxNjM4NCIuDQoNClRoZSBlbnZpcm9ubWVudCBpbmZvcm1hdGlvbiBp cyBhcyBmb2xsb3dzOg0KUG9zdGdyZVNRTCBicmFuY2g6IG1hc3Rlci4NCmNvbW1pdDogYmNkZmE1 ZjJlMmYyNzRjYWVlZDIwYjJmOTg2MDEyYTljYjZhMjU5Yw0KDQpUaGlzIGlzc3VlIGNhbiBiZSBy ZXByb2R1Y2VkIHdpdGggdGhlIGZvbGxvd2luZyBzdGVwczoNCmBgYA0KY3JlYXRlIHRhYmxlIHQo YSBpbnQpIHBhcnRpdGlvbiBieSBoYXNoIChhKTsNCmNyZWF0ZSB0YWJsZSB0X3AxIHBhcnRpdGlv biBvZiB0IGZvciB2YWx1ZXMgd2l0aCAobW9kdWx1cyAyLCByZW1haW5kZXIgMCk7DQphbHRlciB0 YWJsZSB0IGRldGFjaCBwYXJ0aXRpb24gdF9wMSBjb25jdXJyZW50bHkgOw0KZHJvcCB0YWJsZSB0 Ow0KaW5zZXJ0IGludG8gdF9wMSBzZWxlY3QgMTsNCmBgYA0KDQpXaGVuIGRldGFjaGluZyBhIHBh cnRpdGlvbiBjb25jdXJyZW50bHksIHRoZSBmdW5jdGlvbgpEZXRhY2hBZGRDb25zdHJhaW50SWZO ZWVkZWQNCmlzIGNhbGxlZCB0byBjb252ZXJ0IHRoZSBwYXJ0aXRpb24gY29uc3RyYWludCBvZiB0 aGUgZGV0YWNoZWQgcGFydGl0aW9uIGludG8KYSANCnJlZ3VsYXIgY29uc3RyYWludCwgYW5kIGl0 IGlzIG5vdCBkcm9wcGVkIGF0IHRoZSBlbmQgb2YgdGhlIGRldGFjaApwcm9jZXNzLg0KVGhpcyBj YW4gd29yayBub3JtYWxseSBvbiByYW5nZSBwYXJ0aXRpb25zLiBIb3dldmVyLCB0aGUgY29uc3Ry YWludCBvbgpoYXNoDQpwYXJ0aXRpb25zIHVzZXMgc2F0aXNmaWVzX2hhc2hfcGFydGl0aW9uIHdp dGggdGhlIE9JRCBvZiB0aGUgcGFyZW50IHRhYmxlLAphbmQNCnRoZSBuZXdseSBjcmVhdGVkIGNv bnN0cmFpbnQgZG9lcyBub3QgdGFrZSBlZmZlY3QuIEZvciBleGFtcGxlLCBpbiB0aGUKZm9sbG93 aW5nDQpjYXNlLCBhbHRob3VnaCB0aGVyZSBpcyBhIHRfcDFfYV9jaGVjayBjb25zdHJhaW50IG9u IHRfcDEsIGl0IGlzIHN0aWxsCnBvc3NpYmxlDQp0byBwZXJmb3JtIGFuIGluc2VydDoNCmBgYA0K Y3JlYXRlIHRhYmxlIHQoYSBpbnQpIHBhcnRpdGlvbiBieSBoYXNoIChhKTsNCmNyZWF0ZSB0YWJs ZSB0X3AxIHBhcnRpdGlvbiBvZiB0IGZvciB2YWx1ZXMgd2l0aCAobW9kdWx1cyAyLCByZW1haW5k ZXIgMCk7DQphbHRlciB0YWJsZSB0IGRldGFjaCBwYXJ0aXRpb24gdF9wMSBjb25jdXJyZW50bHkg Ow0KcG9zdGdyZXM9IyBcZCsgdF9wMQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgVGFibGUgInB1YmxpYy50X3AxIg0KIENvbHVtbiB8ICBUeXBlICAgfCBDb2xsYXRp b24gfCBOdWxsYWJsZSB8IERlZmF1bHQgfCBTdG9yYWdlIHwgQ29tcHJlc3Npb24gfApTdGF0cyB0 YXJnZXQgfCBEZXNjcmlwdGlvbg0KLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0t LS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tKy0t LS0tLS0tLS0tLS0NCiBhICAgICAgfCBpbnRlZ2VyIHwgICAgICAgICAgIHwgICAgICAgICAgfCAg ICAgICAgIHwgcGxhaW4gICB8ICAgICAgICAgICAgIHwKICAgICAgICAgICAgIHwNCkNoZWNrIGNv bnN0cmFpbnRzOg0KICAgICJ0X3AxX2FfY2hlY2siIENIRUNLIChzYXRpc2ZpZXNfaGFzaF9wYXJ0 aXRpb24oJzE2Mzg0Jzo6b2lkLCAyLCAwLCBhKSkNCkFjY2VzcyBtZXRob2Q6IGhlYXANCnBvc3Rn cmVzPSMgaW5zZXJ0IGludG8gdF9wMSBzZWxlY3QgMTsNCklOU0VSVCAwIDENCnBvc3RncmVzPSMN CmBgYA0KSWYgdGhlIHBhcmVudCB0YWJsZSBoYXMgYWxyZWFkeSBiZWVuIGRyb3BwZWQsIGFuIGVy cm9yIHdpbGwgb2NjdXIgZHVyaW5nDQpjb25zdHJhaW50IGNoZWNraW5nLg0KDQpCYXNlZCBvbiB0 aGUgYW5hbHlzaXMgYWJvdmUsIHNob3VsZCB0aGUgYWRkZWQgY29uc3RyYWludCBmb3IgYSBoYXNo CnBhcnRpdGlvbg0KYmUgZHJvcHBlZCBhZnRlciBkZXRhY2htZW50PwoK --===============7521921515072122011==--