Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j3G2H-0008QP-Ci for pgsql-bugs@arkaria.postgresql.org; Sun, 16 Feb 2020 09:16:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j3G2D-0004Do-Sg for pgsql-bugs@arkaria.postgresql.org; Sun, 16 Feb 2020 09:16:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j3G2D-00048o-KU for pgsql-bugs@lists.postgresql.org; Sun, 16 Feb 2020 09:16:17 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1j3G22-0002TG-KO for pgsql-bugs@lists.postgresql.org; Sun, 16 Feb 2020 09:16:13 +0000 Content-Type: multipart/mixed; boundary="===============6324703745208678169==" MIME-Version: 1.0 Subject: BUG #16260: Repetitive accessing to partitioned table inside transaction causes server process crash To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mingjuwu0505@gmail.com Reply-To: mingjuwu0505@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sun, 16 Feb 2020 09:15:40 +0000 Message-ID: <16260-ceaef56a5acbf449@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============6324703745208678169== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjI2MApMb2dnZWQgYnk6ICAgICAgICAgIE1pY2hhZWwKRW1haWwgYWRk cmVzczogICAgICBtaW5nanV3dTA1MDVAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTIu MgpPcGVyYXRpbmcgc3lzdGVtOiAgIE1pbnQgTGludXggMTguMwpEZXNjcmlwdGlvbjogICAgICAg IAoKSGVsbG8sDQoNCkFjY2Vzc2luZyB0byBhIHBhcnRpdGlvbmVkIHRhYmxlIHdpdGggbGFyZ2Ug cGFydGl0aW9ucyAoMjBLKSBpbnNpZGUgYQp0cmFuc2FjdGlvbiBjYW4gY2F1c2UgcG9zdGdyZXMg dG8gdXNlIGxhcmdlIGFtb3VudCBvZiBtZW1vcnkgKD4zMEdCKSBhbmQKdWx0aW1hdGVseSBsZWFk aW5nIHRvIHNlcnZlciBwcm9jZXNzIGNyYXNoLiBUaGUgc3lzdGVtIHRoYXQgSSBhbSB1c2luZyBo YXMKNDhHQiBwaHlzaWNhbCBtZW1vcnkgYW5kIDcyR0Igc3dhcC4NCg0KU2V0dXAgYW5kIHN0cmVz cyB0ZXN0aW5ncyBzdGVwcyBhcmUgYXR0YWNoZWQgYmVsb3cuIFdpdGggZGVmYXVsdApjb25maWd1 cmF0aW9uIG9mICJtYXhfbG9ja3NfcGVyX3RyYW5zYWN0aW9uIiwgaXQgd2lsbCBzaG93Og0KDQpF UlJPUjogIG91dCBvZiBzaGFyZWQgbWVtb3J5DQpISU5UOiAgWW91IG1pZ2h0IG5lZWQgdG8gaW5j cmVhc2UgbWF4X2xvY2tzX3Blcl90cmFuc2FjdGlvbi4NCg0KQWZ0ZXIgaW5jcmVhc2luZyAibWF4 X2xvY2tzX3Blcl90cmFuc2FjdGlvbiIgdG8gNjQwMCwgd2hpbGUgc3RyZXNzKCkgaXMKcnVubmlu ZywgdGhlIHBvc3RncmVzIHByb2Nlc3Mgd2lsbCBjb250aW51ZSB0byBjb25zdW1lIG1vcmUgbWVt b3J5LgpVbHRpbWF0ZWx5LCBpbiBwZ0FkbWluIDQsIGNvbnNvbGUgd2lsbCBzaG93ICJDb25uZWN0 aW9uIHRvIHRoZSBzZXJ2ZXIgaGFzCmJlZW4gbG9zdC4iIFRoZSBmb2xsb3dpbmcgbWVzc2FnZXMg Y2FuIGJlIGZvdW5kIGluIHBvc3RncmVzIGxvZzoNCg0KMjAyMC0wMi0xNiAxNzowMTozNS40NDkg Q1NUIFsyMjY1Ml0gTE9HOiAgc2VydmVyIHByb2Nlc3MgKFBJRCAyMzE0OSkgd2FzCnRlcm1pbmF0 ZWQgYnkgc2lnbmFsIDk6IEtpbGxlZA0KMjAyMC0wMi0xNiAxNzowMTozNS40NDkgQ1NUIFsyMjY1 Ml0gREVUQUlMOiAgRmFpbGVkIHByb2Nlc3Mgd2FzIHJ1bm5pbmc6CmNhbGwgc3RyZXNzKCk7DQoy MDIwLTAyLTE2IDE3OjAxOjM1LjQ0OSBDU1QgWzIyNjUyXSBMT0c6ICB0ZXJtaW5hdGluZyBhbnkg b3RoZXIgYWN0aXZlCnNlcnZlciBwcm9jZXNzZXMNCjIwMjAtMDItMTYgMTc6MDE6MzUuNDU4IENT VCBbMjI2NTldIFdBUk5JTkc6ICB0ZXJtaW5hdGluZyBjb25uZWN0aW9uIGJlY2F1c2UKb2YgY3Jh c2ggb2YgYW5vdGhlciBzZXJ2ZXIgcHJvY2Vzcw0KMjAyMC0wMi0xNiAxNzowMTozNS40NTggQ1NU IFsyMjY1OV0gREVUQUlMOiAgVGhlIHBvc3RtYXN0ZXIgaGFzIGNvbW1hbmRlZAp0aGlzIHNlcnZl ciBwcm9jZXNzIHRvIHJvbGwgYmFjayB0aGUgY3VycmVudCB0cmFuc2FjdGlvbiBhbmQgZXhpdCwg YmVjYXVzZQphbm90aGVyIHNlcnZlciBwcm9jZXNzIGV4aXRlZCBhYm5vcm1hbGx5IGFuZCBwb3Nz aWJseSBjb3JydXB0ZWQgc2hhcmVkCm1lbW9yeS4NCjIwMjAtMDItMTYgMTc6MDE6MzUuNDU4IENT VCBbMjI2NTldIEhJTlQ6ICBJbiBhIG1vbWVudCB5b3Ugc2hvdWxkIGJlIGFibGUgdG8KcmVjb25u ZWN0IHRvIHRoZSBkYXRhYmFzZSBhbmQgcmVwZWF0IHlvdXIgY29tbWFuZC4NCjIwMjAtMDItMTYg MTc6MDE6MzUuNDg3IENTVCBbMjI2NjRdIHBvc3RncmVzQDE3cHR0X3Rlc3RfZGIgV0FSTklORzog CnRlcm1pbmF0aW5nIGNvbm5lY3Rpb24gYmVjYXVzZSBvZiBjcmFzaCBvZiBhbm90aGVyIHNlcnZl ciBwcm9jZXNzDQoyMDIwLTAyLTE2IDE3OjAxOjM1LjQ4NyBDU1QgWzIyNjY0XSBwb3N0Z3Jlc0Ax N3B0dF90ZXN0X2RiIERFVEFJTDogIFRoZQpwb3N0bWFzdGVyIGhhcyBjb21tYW5kZWQgdGhpcyBz ZXJ2ZXIgcHJvY2VzcyB0byByb2xsIGJhY2sgdGhlIGN1cnJlbnQKdHJhbnNhY3Rpb24gYW5kIGV4 aXQsIGJlY2F1c2UgYW5vdGhlciBzZXJ2ZXIgcHJvY2VzcyBleGl0ZWQgYWJub3JtYWxseSBhbmQK cG9zc2libHkgY29ycnVwdGVkIHNoYXJlZCBtZW1vcnkuDQoyMDIwLTAyLTE2IDE3OjAxOjM1LjQ4 NyBDU1QgWzIyNjY0XSBwb3N0Z3Jlc0AxN3B0dF90ZXN0X2RiIEhJTlQ6ICBJbiBhCm1vbWVudCB5 b3Ugc2hvdWxkIGJlIGFibGUgdG8gcmVjb25uZWN0IHRvIHRoZSBkYXRhYmFzZSBhbmQgcmVwZWF0 IHlvdXIKY29tbWFuZC4NCjIwMjAtMDItMTYgMTc6MDE6MzUuNDkxIENTVCBbMjI2NTJdIExPRzog IGFsbCBzZXJ2ZXIgcHJvY2Vzc2VzIHRlcm1pbmF0ZWQ7CnJlaW5pdGlhbGl6aW5nDQoyMDIwLTAy LTE2IDE3OjAxOjM1LjY1MiBDU1QgWzQ3NTddIExPRzogIGRhdGFiYXNlIHN5c3RlbSB3YXMgaW50 ZXJydXB0ZWQ7Cmxhc3Qga25vd24gdXAgYXQgMjAyMC0wMi0xNiAxNjo1NjoyNiBDU1QNCjIwMjAt MDItMTYgMTc6MDE6MzUuOTM5IENTVCBbNDc1OF0gcG9zdGdyZXNAMTdwdHRfdGVzdF9kYiBGQVRB TDogIHRoZQpkYXRhYmFzZSBzeXN0ZW0gaXMgaW4gcmVjb3ZlcnkgbW9kZQ0KMjAyMC0wMi0xNiAx NzowMTozNS45NDAgQ1NUIFs0NzU5XSBwb3N0Z3Jlc0AxN3B0dF90ZXN0X2RiIEZBVEFMOiAgdGhl CmRhdGFiYXNlIHN5c3RlbSBpcyBpbiByZWNvdmVyeSBtb2RlDQoyMDIwLTAyLTE2IDE3OjAxOjM4 LjYyMiBDU1QgWzQ3NTddIExPRzogIGRhdGFiYXNlIHN5c3RlbSB3YXMgbm90IHByb3Blcmx5CnNo dXQgZG93bjsgYXV0b21hdGljIHJlY292ZXJ5IGluIHByb2dyZXNzDQoyMDIwLTAyLTE2IDE3OjAx OjM4LjYzMCBDU1QgWzQ3NTddIExPRzogIHJlZG8gc3RhcnRzIGF0IDkvRDUzNTMwMjgNCjIwMjAt MDItMTYgMTc6MDE6MzguNjMwIENTVCBbNDc1N10gTE9HOiAgaW52YWxpZCByZWNvcmQgbGVuZ3Ro IGF0CjkvRDUzNTMxMTA6IHdhbnRlZCAyNCwgZ290IDANCjIwMjAtMDItMTYgMTc6MDE6MzguNjMw IENTVCBbNDc1N10gTE9HOiAgcmVkbyBkb25lIGF0IDkvRDUzNTMwRDgNCjIwMjAtMDItMTYgMTc6 MDE6MzguNjg0IENTVCBbMjI2NTJdIExPRzogIGRhdGFiYXNlIHN5c3RlbSBpcyByZWFkeSB0byBh Y2NlcHQKY29ubmVjdGlvbnMNCg0KSW4gdGhlIHN0cmVzcygpIHByb2NlZHVyZSwgcmVwbGFjaW5n IERFTEVURSB3aXRoIFVQREFURSBzdGF0ZW1lbnQgaGFzIHNhbWUKZWZmZWN0Lg0KDQpCZXN0IFJl Z2FyZHMsDQpNaWNoYWVsDQoNCg0KLS0tLS0tLS0tDQotLSBTRVRVUA0KLS0tLS0tLS0tDQoNCkNS RUFURSBUQUJMRSB0ZXN0X3RhYmxlICgNCglpZCBiaWdpbnQgTk9UIE5VTEwsDQoJY2F0ZWdvcnkg YmlnaW50IE5PVCBOVUxMDQopIFBBUlRJVElPTiBCWSBMSVNUIChjYXRlZ29yeSk7DQoNCkNSRUFU RSBPUiBSRVBMQUNFIFBST0NFRFVSRSBjcmVhdGVfdGVzdF90YWJsZV9wYXJpdGlvbnMoKQ0KQVMg JCQNCkRFQ0xBUkUNCgljb3VudGVyIElOVEVHRVIgOj0gMTsgDQpCRUdJTg0KCVdISUxFIGNvdW50 ZXIgPD0gMjAwMDAgTE9PUA0KCQlFWEVDVVRFICdDUkVBVEUgVEFCTEUgdGVzdF90YWJsZV8nIHx8 IGNvdW50ZXIgfHwgJyBQQVJUSVRJT04gT0YgdGVzdF90YWJsZQpGT1IgVkFMVUVTIElOICgnIHx8 IGNvdW50ZXIgfHwgJyknOw0KCQljb3VudGVyIDo9IGNvdW50ZXIgKyAxOw0KCUVORCBMT09QOw0K RU5EDQokJA0KTEFOR1VBR0UgcGxwZ3NxbDsNCg0KY2FsbCBjcmVhdGVfdGVzdF90YWJsZV9wYXJp dGlvbnMoKTsNCg0KLS0tLS0tLS0tLS0tLS0NCi0tIFNUUkVTUyBURVNUDQotLS0tLS0tLS0tLS0t LQ0KDQpDUkVBVEUgT1IgUkVQTEFDRSBQUk9DRURVUkUgc3RyZXNzKCkNCkFTICQkDQpERUNMQVJF DQoJY291bnRlciBJTlRFR0VSIDo9IDE7IA0KQkVHSU4NCglXSElMRSBjb3VudGVyIDw9IDIwMDAw IExPT1ANCgkJREVMRVRFIEZST00gdGVzdF90YWJsZSBXSEVSRSBjYXRlZ29yeSA9IGNvdW50ZXI7 DQoJCXJhaXNlIG5vdGljZSAnJScsIGNvdW50ZXI7DQoJCWNvdW50ZXIgOj0gY291bnRlciArIDE7 DQoJRU5EIExPT1A7DQpFTkQNCiQkDQpMQU5HVUFHRSBwbHBnc3FsOw0KDQpjYWxsIHN0cmVzcygp OwoK --===============6324703745208678169==--