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 1m8oVr-0005E4-Cd for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Jul 2021 18:42:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m8oVq-00034c-CL for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Jul 2021 18:42:38 +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 1m8nqm-00031X-J0 for pgsql-bugs@lists.postgresql.org; Wed, 28 Jul 2021 18:00:13 +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 1m8nqh-0000K5-73 for pgsql-bugs@lists.postgresql.org; Wed, 28 Jul 2021 18:00:11 +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=qDGv6CULuTscO8VP8AlVX8KgxB1els9Z0BWrN27vRAY=; b=mRQRt7Urif/6RDnEhHnnXBs6Rh KJ6UDL9SIliQPFlHVW/BdZUSNhlB2HVZ2Qy5RuEWt6Fh2q+/WiV5MESKQ0AkEoikdgi0Pa6ywyiFs LzsHfHEKaqCflJZGezmw2ve73VG6+STpxJlVjcVA9rgPX3PhZBBxWizQvY7P0RghZHWSRZXapEfZG Fb3/fzLVh6wkKRjN7+UW+gVdwvJt9cbsOOGb5mbxdIsACNimMkjWMvJIOKfYC8BRv9z6fi0QvBt3a BjxkwAg8CfSBwqtkes8kgg/VgwaFr56dUzEAfrtxSf9QUSimN5DA8lhhEbP+Frq9eaWdCVReuxm7Z rcSBC07g==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m8nqg-0001Ty-9S for pgsql-bugs@lists.postgresql.org; Wed, 28 Jul 2021 18:00:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m8nqd-00086n-4L for pgsql-bugs@lists.postgresql.org; Wed, 28 Jul 2021 18:00:03 +0000 Content-Type: multipart/mixed; boundary="===============2609367849811839090==" MIME-Version: 1.0 Subject: BUG #17126: Server crashes on dropping user while enumerating owned objects that are droppped concurrently To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 28 Jul 2021 18:00:00 +0000 Message-ID: <17126-21887f04508cb5c8@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 --===============2609367849811839090== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzEyNgpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogVW5zdXBwb3J0ZWQvVW5rbm93bgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMC4wNApE ZXNjcmlwdGlvbjogICAgICAgIAoKRHJvcHBpbmcgYSB1c2VyIHRoYXQgb3ducyBhIG51bWJlciBv ZiBwcm9jZWR1cmVzLCB3aGlsZSBzb21lIG9mIHRoZW0gYXJlCmJlaW5nIGRyb3BwZWQsIGNhbiBj YXVzZSB0aGUgc2VydmVyIGNyYXNoOg0KDQpDb3JlIHdhcyBnZW5lcmF0ZWQgYnkgYHBvc3RncmVz OiBsYXcgcmVncmVzc2lvbiBbbG9jYWxdIERST1AgUk9MRSAgICAgICAgICAgCiAgICAgICAgICAg ICAgICAgICAgICAgICcuDQpQcm9ncmFtIHRlcm1pbmF0ZWQgd2l0aCBzaWduYWwgU0lHQUJSVCwg QWJvcnRlZC4NCiMwICBfX0dJX3JhaXNlIChzaWc9c2lnQGVudHJ5PTYpIGF0IC4uL3N5c2RlcHMv dW5peC9zeXN2L2xpbnV4L3JhaXNlLmM6NTANCjUwICAgICAgLi4vc3lzZGVwcy91bml4L3N5c3Yv bGludXgvcmFpc2UuYzogTm8gc3VjaCBmaWxlIG9yIGRpcmVjdG9yeS4NCihnZGIpIGJ0DQojMCAg X19HSV9yYWlzZSAoc2lnPXNpZ0BlbnRyeT02KSBhdCAuLi9zeXNkZXBzL3VuaXgvc3lzdi9saW51 eC9yYWlzZS5jOjUwDQojMSAgMHgwMDAwN2YyNjg4ODJiODU5IGluIF9fR0lfYWJvcnQgKCkgYXQg YWJvcnQuYzo3OQ0KIzIgIDB4MDAwMDU1YTIzYTYyODI3NiBpbiBFeGNlcHRpb25hbENvbmRpdGlv bgooY29uZGl0aW9uTmFtZT1jb25kaXRpb25OYW1lQGVudHJ5PTB4NTVhMjNhNzdmZDRkICJwb2lu dGVyICE9IE5VTEwiLCANCiAgICBlcnJvclR5cGU9ZXJyb3JUeXBlQGVudHJ5PTB4NTVhMjNhNjg3 MDBiICJGYWlsZWRBc3NlcnRpb24iLApmaWxlTmFtZT0weDdmZmRmNDQ1OTQ3MCAiV1wyMDJiOlwy NDJVIiwgDQogICAgZmlsZU5hbWVAZW50cnk9MHg1NWEyM2E3ODg2YjAKIi4uLy4uLy4uLy4uL3Ny Yy9pbmNsdWRlL3V0aWxzL21lbXV0aWxzLmgiLApsaW5lTnVtYmVyPWxpbmVOdW1iZXJAZW50cnk9 MTIzKQ0KICAgIGF0IGFzc2VydC5jOjY5DQojMyAgMHgwMDAwNTVhMjNhNjViNDZlIGluIEdldE1l bW9yeUNodW5rQ29udGV4dCAocG9pbnRlcj0weDApIGF0Ci4uLy4uLy4uLy4uL3NyYy9pbmNsdWRl L3V0aWxzL21lbXV0aWxzLmg6MTIzDQojNCAgcGZyZWUgKHBvaW50ZXI9cG9pbnRlckBlbnRyeT0w eDApIGF0IG1jeHQuYzoxMTcxDQojNSAgMHgwMDAwNTVhMjNhMjMyNTRmIGluIHN0b3JlT2JqZWN0 RGVzY3JpcHRpb24KKGRlc2NzPWRlc2NzQGVudHJ5PTB4N2ZmZGY0NDU5OGIwLCB0eXBlPUxPQ0FM X09CSkVDVCwgDQogICAgb2JqZWN0PW9iamVjdEBlbnRyeT0weDU1YTIzYjVlZmUxMCwgZGVwdHlw ZT1TSEFSRURfREVQRU5ERU5DWV9PV05FUiwKY291bnQ9Y291bnRAZW50cnk9MCkgYXQgcGdfc2hk ZXBlbmQuYzoxMjY3DQojNiAgMHgwMDAwNTVhMjNhMjMyOTU1IGluIGNoZWNrU2hhcmVkRGVwZW5k ZW5jaWVzCihjbGFzc0lkPWNsYXNzSWRAZW50cnk9MTI2MCwgb2JqZWN0SWQ9b2JqZWN0SWRAZW50 cnk9MTYzODUsIA0KICAgIGRldGFpbF9tc2c9ZGV0YWlsX21zZ0BlbnRyeT0weDdmZmRmNDQ1OTlm MCwKZGV0YWlsX2xvZ19tc2c9ZGV0YWlsX2xvZ19tc2dAZW50cnk9MHg3ZmZkZjQ0NTk5ZjgpIGF0 IHBnX3NoZGVwZW5kLmM6NzcxDQojNyAgMHgwMDAwNTVhMjNhMzEwYzUxIGluIERyb3BSb2xlIChz dG10PXN0bXRAZW50cnk9MHg1NWEyM2I1YzdlZTgpIGF0CnVzZXIuYzoxMDI4DQojOCAgMHgwMDAw NTVhMjNhNGVkOTIyIGluIHN0YW5kYXJkX1Byb2Nlc3NVdGlsaXR5IChwc3RtdD0weDU1YTIzYjVj ODFmOCwKcXVlcnlTdHJpbmc9MHg1NWEyM2I1Yzc0NTAgIkRST1AgVVNFUiB1OyIsIA0KICAgIHJl YWRPbmx5VHJlZT08b3B0aW1pemVkIG91dD4sIGNvbnRleHQ9UFJPQ0VTU19VVElMSVRZX1RPUExF VkVMLApwYXJhbXM9MHgwLCBxdWVyeUVudj0weDAsIGRlc3Q9MHg1NWEyM2I1YzgyYzgsIA0KICAg IHFjPTB4N2ZmZGY0NDU5ZDkwKSBhdCB1dGlsaXR5LmM6OTAxDQojOSAgMHgwMDAwNTVhMjNhNGVk ZDMxIGluIFByb2Nlc3NVdGlsaXR5IChwc3RtdD1wc3RtdEBlbnRyeT0weDU1YTIzYjVjODFmOCwK cXVlcnlTdHJpbmc9PG9wdGltaXplZCBvdXQ+LCANCiAgICByZWFkT25seVRyZWU9PG9wdGltaXpl ZCBvdXQ+LApjb250ZXh0PWNvbnRleHRAZW50cnk9UFJPQ0VTU19VVElMSVRZX1RPUExFVkVMLCBw YXJhbXM9PG9wdGltaXplZCBvdXQ+LCANCiAgICBxdWVyeUVudj08b3B0aW1pemVkIG91dD4sIGRl c3Q9MHg1NWEyM2I1YzgyYzgsIHFjPTB4N2ZmZGY0NDU5ZDkwKSBhdAp1dGlsaXR5LmM6NTI3DQoj MTAgMHgwMDAwNTVhMjNhNGViMjUxIGluIFBvcnRhbFJ1blV0aWxpdHkKKHBvcnRhbD1wb3J0YWxA ZW50cnk9MHg1NWEyM2I2MjkwOTAsIHBzdG10PXBzdG10QGVudHJ5PTB4NTVhMjNiNWM4MWY4LCAN CiAgICBpc1RvcExldmVsPWlzVG9wTGV2ZWxAZW50cnk9dHJ1ZSwKc2V0SG9sZFNuYXBzaG90PXNl dEhvbGRTbmFwc2hvdEBlbnRyeT1mYWxzZSwgZGVzdD1kZXN0QGVudHJ5PTB4NTVhMjNiNWM4MmM4 LAoNCiAgICBxYz1xY0BlbnRyeT0weDdmZmRmNDQ1OWQ5MCkgYXQgcHF1ZXJ5LmM6MTE0Nw0KIzEx IDB4MDAwMDU1YTIzYTRlYjU1MyBpbiBQb3J0YWxSdW5NdWx0aQoocG9ydGFsPXBvcnRhbEBlbnRy eT0weDU1YTIzYjYyOTA5MCwgaXNUb3BMZXZlbD1pc1RvcExldmVsQGVudHJ5PXRydWUsIA0KICAg IHNldEhvbGRTbmFwc2hvdD1zZXRIb2xkU25hcHNob3RAZW50cnk9ZmFsc2UsCmRlc3Q9ZGVzdEBl bnRyeT0weDU1YTIzYjVjODJjOCwgYWx0ZGVzdD1hbHRkZXN0QGVudHJ5PTB4NTVhMjNiNWM4MmM4 LCANCiAgICBxYz1xY0BlbnRyeT0weDdmZmRmNDQ1OWQ5MCkgYXQgcHF1ZXJ5LmM6MTMwNA0KIzEy IDB4MDAwMDU1YTIzYTRlYjk4NyBpbiBQb3J0YWxSdW4gKHBvcnRhbD1wb3J0YWxAZW50cnk9MHg1 NWEyM2I2MjkwOTAsCmNvdW50PWNvdW50QGVudHJ5PTkyMjMzNzIwMzY4NTQ3NzU4MDcsIA0KICAg IGlzVG9wTGV2ZWw9aXNUb3BMZXZlbEBlbnRyeT10cnVlLCBydW5fb25jZT1ydW5fb25jZUBlbnRy eT10cnVlLApkZXN0PWRlc3RAZW50cnk9MHg1NWEyM2I1YzgyYzgsIA0KICAgIGFsdGRlc3Q9YWx0 ZGVzdEBlbnRyeT0weDU1YTIzYjVjODJjOCwgcWM9MHg3ZmZkZjQ0NTlkOTApIGF0CnBxdWVyeS5j Ojc4Ng0KIzEzIDB4MDAwMDU1YTIzYTRlN2JkNCBpbiBleGVjX3NpbXBsZV9xdWVyeQoocXVlcnlf c3RyaW5nPXF1ZXJ5X3N0cmluZ0BlbnRyeT0weDU1YTIzYjVjNzQ1MCAiRFJPUCBVU0VSIHU7IikN CiAgICBhdCBwb3N0Z3Jlcy5jOjEyMTQNCiMxNCAweDAwMDA1NWEyM2E0ZTliYTYgaW4gUG9zdGdy ZXNNYWluIChhcmdjPWFyZ2NAZW50cnk9MSwKYXJndj1hcmd2QGVudHJ5PTB4N2ZmZGY0NDU5Zjgw LCBkYm5hbWU9PG9wdGltaXplZCBvdXQ+LCANCiAgICB1c2VybmFtZT08b3B0aW1pemVkIG91dD4p IGF0IHBvc3RncmVzLmM6NDQ4Ng0KIzE1IDB4MDAwMDU1YTIzYTQ0MmYxOSBpbiBCYWNrZW5kUnVu IChwb3J0PXBvcnRAZW50cnk9MHg1NWEyM2I1ZWE4NzApIGF0CnBvc3RtYXN0ZXIuYzo0NTA2DQoj MTYgMHgwMDAwNTVhMjNhNDQ2MTJlIGluIEJhY2tlbmRTdGFydHVwIChwb3J0PXBvcnRAZW50cnk9 MHg1NWEyM2I1ZWE4NzApIGF0CnBvc3RtYXN0ZXIuYzo0MjI4DQojMTcgMHgwMDAwNTVhMjNhNDQ2 Mzc1IGluIFNlcnZlckxvb3AgKCkgYXQgcG9zdG1hc3Rlci5jOjE3NDUNCiMxOCAweDAwMDA1NWEy M2E0NDc4YzIgaW4gUG9zdG1hc3Rlck1haW4gKGFyZ2M9MywgYXJndj08b3B0aW1pemVkIG91dD4p IGF0CnBvc3RtYXN0ZXIuYzoxNDE3DQojMTkgMHgwMDAwNTVhMjNhMzg4MjkxIGluIG1haW4gKGFy Z2M9MywgYXJndj0weDU1YTIzYjVjMTRjMCkgYXQgbWFpbi5jOjIwOQ0KKGdkYikgZnJhbWUgNQ0K KGdkYikgcHJpbnQgLWVsZW1lbnRzIHVubGltaXRlZCAtLSBkZXNjcy5kYXRhDQokNyA9IDB4NTVh MjNiNmVmMWMwICJvd25lciBvZiBmdW5jdGlvbiBwMSgpXG4uLi5vd25lciBvZiBmdW5jdGlvbgpw ODgoKVxub3duZXIgb2YgKG51bGwpIg0KDQpUaGUgcmVwcm9kdWNpbmcgc2NyaXB0Og0Kcm0gL3Rt cC9jLnNxbA0KZm9yIGkgaW4gYHNlcSA5MGA7IGRvIGVjaG8gIkNSRUFURSBPUiBSRVBMQUNFIFBS T0NFRFVSRSBwJGkoKSBMQU5HVUFHRSBTUUwKQVMgJ1NFTEVDVCAxJzsiID4+L3RtcC9jLnNxbDsg ZG9uZQ0Kcm0gL3RtcC9kLnNxbA0KZm9yIGkgaW4gYHNlcSA5MCAtMSAyYDsgZG8gZWNobyAiRFJP UCBQUk9DRURVUkUgSUYgRVhJU1RTIHAkaSgpOyIKPj4vdG1wL2Quc3FsOyBkb25lDQoNCnBzcWwg LWMgIkNSRUFURSBVU0VSIHUiOw0KcHNxbCAtVSB1IC1mIC90bXAvYy5zcWwgPnBzcWwwLmxvZyAy PiYxDQpmb3IgbiBpbiBgc2VxIDEwMGA7IGRvDQogIGVjaG8gIml0ZXJhdGlvbiAkbiINCiAgKCB7 IGZvciBmIGluIGBzZXEgMTAwYDsgZG8gZWNobyAiRFJPUCBVU0VSIHU7IFNFTEVDVCBwZ19zbGVl cCgwLjAwMSk7IjsKZG9uZSB9IHwgcHNxbCApID5wc3FsMS5sb2cgMj4mMSAmDQogICggeyBmb3Ig ZiBpbiBgc2VxIDEwYDsgZG8gY2F0IC90bXAvYy5zcWw7IGRvbmUgfSB8IHBzcWwgLVUgdSApID5w c3FsMi5sb2cKMj4mMSAmDQogICggeyBmb3IgZiBpbiBgc2VxIDEwYDsgZG8gY2F0IC90bXAvZC5z cWw7IGRvbmUgfSB8IHBzcWwgLVUgdSApID5wc3FsMy5sb2cKMj4mMSAmDQogIHdhaXQNCiAgc2xl ZXAgMQ0KICBjb3JlZHVtcGN0bCAtLW5vLXBhZ2VyICYmIGJyZWFrOw0KZG9uZQ0KDQooVHVybmlu ZyBmc3luYyBvZmYgaGVscHMgaW4gcmVwcm9kdWNpbmcgZm9yIG1lLikNCkludGVyZXN0aW5nbHkg ZW5vdWdoLCB0aGUgY3Jhc2ggZG9lcyBub3Qgb2NjdXIgd2l0aCB0YWJsZXMgKGJ1dCBvY2N1cnMg d2l0aApmdW5jdGlvbnMpOg0KKA0KLi4uDQpmb3IgaSBpbiBgc2VxIDkwYDsgZG8gZWNobyAiQ1JF QVRFIFRBQkxFIHQkaShpIGludCk7IiA+Pi90bXAvYy5zcWw7IGRvbmUNCi4uLg0KZm9yIGkgaW4g YHNlcSA5MCAtMSAyYDsgZG8gZWNobyAiRFJPUCBUQUJMRSBJRiBFWElTVFMgdCRpOyIgPj4vdG1w L2Quc3FsOwpkb25lDQouLi4NCikNCg0KUmVwcm9kdWNlZCBvbiBtYXN0ZXIgKGFmdGVyIDM3Nzlh YzYyKS4KCg== --===============2609367849811839090==--