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 1q9EYx-0001wt-Kf for pgsql-bugs@arkaria.postgresql.org; Wed, 14 Jun 2023 00:40:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q9EYv-0006B2-0F for pgsql-bugs@arkaria.postgresql.org; Wed, 14 Jun 2023 00:40:37 +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 1q9Dm8-0004OK-2I for pgsql-bugs@lists.postgresql.org; Tue, 13 Jun 2023 23:50:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q9Dm4-002E6v-VY for pgsql-bugs@lists.postgresql.org; Tue, 13 Jun 2023 23:50: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=OCKowgTSPb4k0beX1kY02jFWdKINYbSQIs5fRA1m8g8=; b=sp6KzZq+En+fnS4Pk48V26N2j5 aaHDsrUzIfASLcVNtkey6PbRxCde+lNBlYIhE2Y/whgzcQgqlHBhFHy2MrfWpbK99L/4xWq+xgUd3 HgXS+UGq56+xN1XBEoYO+0JqDY2fgIDYgx/+dFXKddDsvN2zVV/apkrVFpDrpLt5rG23aXXDHlTYu nNbHLsNGADEuLj5C0McIrfqQ9n0++11c66EG//h8pfJ4n221CNkXIn+3nlNbfgPXvjj8ZHBeTwt8Z 0DF4egEsgFpKdt2N7TbejzPDB+sca1/gdAF0Iit/LJWdl/Qvd3yBmFbtk2DLbA3O3lPA6eVVoV+A6 CZljHXTA==; 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 1q9Dm3-0003Gc-Mm for pgsql-bugs@lists.postgresql.org; Tue, 13 Jun 2023 23:50:07 +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 1q9Dlx-005lgj-8w for pgsql-bugs@lists.postgresql.org; Tue, 13 Jun 2023 23:50:02 +0000 Content-Type: multipart/mixed; boundary="===============1052536909297235143==" MIME-Version: 1.0 Subject: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: will@extrahop.com Reply-To: will@extrahop.com, pgsql-bugs@lists.postgresql.org Date: Tue, 13 Jun 2023 23:49:27 +0000 Message-ID: <17973-bca1f7d5c14f601e@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 --===============1052536909297235143== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzk3MwpMb2dnZWQgYnk6ICAgICAgICAgIFdpbGwgTW9ydGVuc2VuCkVt YWlsIGFkZHJlc3M6ICAgICAgd2lsbEBleHRyYWhvcC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx NS4zCk9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDIyLjA0CkRlc2NyaXB0aW9uOiAgICAgICAg CgpNeSBjb2xsZWFndWUgSmFjb2IgU3BlaWRlbCAoamFjb2JAZXh0cmFob3AuY29tKSBhbmQgSSBo YXZlIGRpYWdub3NlZCBhIHJhY2UKY29uZGl0aW9uIHRoYXQsIHVuZGVyIGNlcnRhaW4gY29uZGl0 aW9ucywgY2FuIGNhdXNlIHRoZSBhdXRvdmFjdXVtIGRhZW1vbiB0bwpzdG9wIGxhdW5jaGluZyBh dXRvdmFjdXVtIHdvcmtlcnMgdW50aWwgdGhlIGF1dG92YWN1dW0gZGFlbW9uIChvciB0aGUgd2hv bGUKc2VydmVyKSBpcyByZXN0YXJ0ZWQuIFRoaXMgb2J2aW91c2x5IGNhdXNlcyBzZXJpb3VzIHBy b2JsZW1zIGZvciB0aGUKc2VydmVyLg0KDQpXZSd2ZSByZXByb2R1Y2VkIHRoaXMgb24gYm90aCAx NS4yIGFuZCBSRUxfMTVfU1RBQkxFIChnaXQgY29tbWl0CmJkNTkwZDFmZWExYmE5MjQ1Yzc5MWQ1 ODllZWE5NGQyZGJhZDVhMmIpLiBXZSd2ZSBuZXZlciBzZWVuIGEgc2ltaWxhciBpc3N1ZQpvbiAx NCBkZXNwaXRlIHZlcnkgc2ltaWxhciBjb25kaXRpb25zIG9jY3VycmluZyBmcmVxdWVudGx5LiBX ZSBoYXZlbid0IHlldAp0cmllZCBvbiAxNi4NCg0KSW4gSmFjb2IncyByZXBybywgdGhlIHByb2Js ZW0gYmVnaW5zIHdoZW4gQXV0b1ZhY1dvcmtlck1haW4oKSBpcyBpbgpJbml0UG9zdGdyZXMoKSBh bmQgc29tZSBvdGhlciBiYWNrZW5kIGRyb3BzIHRoZSBkYXRhYmFzZS4gU3BlY2lmaWNhbGx5LCB0 aGUKYXV0b3ZhY3V1bSB3b3JrZXIncyBJbml0UG9zdGdyZXMoKSBpcyBqdXN0IGFib3V0IHRvIG9i dGFpbiB0aGUgbG9jayBhdApodHRwczovL2dpdGh1Yi5jb20vcG9zdGdyZXMvcG9zdGdyZXMvYmxv Yi9iZDU5MGQxZmVhMWJhOTI0NWM3OTFkNTg5ZWVhOTRkMmRiYWQ1YTJiL3NyYy9iYWNrZW5kL3V0 aWxzL2luaXQvcG9zdGluaXQuYyNMMTAxMgouIFRoZSBiYWNrZW5kIGRyb3BwaW5nIHRoZSBEQiBt YXJrcyB0aGUgREIncyBwZ3N0YXRzIGVudHJ5IGFzIGRyb3BwZWQgYnV0CmNhbuKAmXQgZnJlZSBp dCBiZWNhdXNlIGl0cyByZWZjb3VudCBpcyBub256ZXJvLCBzbwpBdEVPWGFjdF9QZ1N0YXRfRHJv cHBlZFN0YXRzKCkgY2FsbHMgcGdzdGF0X3JlcXVlc3RfZW50cnlfcmVmc19nYygpLiBUaGUKYXV0 b3ZhY3V1bSB3b3JrZXIncyBJbml0UG9zdGdyZXMoKSBwcm9jZWVkcyB0byBjYWxsIEdldERhdGFi YXNlVHVwbGUoKSBhbmQKbm90aWNlcyB0aGUgZGF0YWJhc2UgaGFzIGJlZW4gZHJvcHBlZCwgYXQg c29tZSBwb2ludCBjYWxsaW5nCnBnc3RhdF9nY19lbnRyeV9yZWZzKCkgdG8gcmVsZWFzZSBpdHMg cmVmZXJlbmNlIHRvIHRoZSBEQidzIHBnc3RhdHMgZW50cnksCmFuZCB0aGUgd29ya2VyIGRlY2lk ZXMgdG8gZXhpdCB3aXRoIGEgZmF0YWwgZXJyb3IuIEJ1dCB3aGlsZSBleGl0aW5nLCBpdApjYWxs cyBwZ3N0YXRfcmVwb3J0X3N0YXQoKSwgd2hpY2ggY2FsbHMgcGdzdGF0X3VwZGF0ZV9kYnN0YXRz KCkgZm9yIHRoZQpkcm9wcGVkIERCLCB3aGljaCBjYWxscyBwZ3N0YXRfcHJlcF9kYXRhYmFzZV9w ZW5kaW5nKCksIHdoaWNoIGNhbGxzCnBnc3RhdF9wcmVwX3BlbmRpbmdfZW50cnkoKSwgd2hpY2gg Y2FsbHMgcGdzdGF0X2dldF9lbnRyeV9yZWYoKSB3aXRoIGNyZWF0ZQo9PSB0cnVlLCB3aGljaCBj YWxscyBwZ3N0YXRfcmVpbml0X2VudHJ5KCkgYWdhaW5zdCB0aGUgREIncyBwZ3N0YXRzIGVudHJ5 LgpUaGlzIHNldHMgZHJvcHBlZCB0byBmYWxzZSBvbiB0aGF0IGVudHJ5LiBGaW5hbGx5LCB0aGUg YXV0b3ZhY3V1bSB3b3JrZXIKZXhpdHMuDQoNClRoZSBmYWN0IHRoYXQgYSBkcm9wcGVkIGRhdGFi YXNlIG5vdyBpbmRlZmluaXRlbHkgaGFzIGEgcGdzdGF0cyBlbnRyeSB3aXRoCmRyb3BwZWQgPT0g ZmFsc2Ugc2VlbWluZ2x5IHZpb2xhdGVzIHNvbWUgYXNzdW1wdGlvbnMgYW5kIGNvbmZ1c2VzIHRo ZQphdXRvdmFjdXVtIGRhZW1vbi4gSW4gcGFydGljdWxhciwgcmVidWlsZF9kYXRhYmFzZV9saXN0 KCkgd2lsbCBmb3JldmVyCmluY2x1ZGUgaXQgaW4gRGF0YWJhc2VMaXN0IGFuZCB0YWtlIGl0IGlu dG8gYWNjb3VudCB3aGVuIGNvbXB1dGluZyB0aGUKYWRsX25leHRfd29ya2VyIGZvciBlYWNoIERC LCBidXQgZG9fc3RhcnRfd29ya2VyKCkgd29u4oCZdCBjb25zaWRlciB0aGUgREIKYmVjYXVzZSBp dCdzIG5ldmVyIHJldHVybmVkIGJ5IGdldF9kYXRhYmFzZV9saXN0KCkuIEluIG91ciByZXByb3Ms IHRoaXMKbWlzbWF0Y2ggY2F1c2VzIGRvX3N0YXJ0X3dvcmtlcigpIHRvIGdldCBzdHVjayBuZXZl ciBwcm9jZXNzaW5nIGFueSBEQjogaW4KcGFydGljdWxhciwgaXQgYWx3YXlzIHNlZXMgdGhhdCBm b3IgZWFjaCBub24tZHJvcHBlZCBkYXRhYmFzZQphZGxfbmV4dF93b3JrZXIgaXMgaW4gdGhlIGZ1 dHVyZSBidXQgd2l0aGluIHRoZSBuZXh0IGF1dG92YWN1dW1fbmFwdGltZSwKaS5lLiBza2lwaXQg PSB0cnVlLiBUaGlzIGNhdXNlcyBkb19zdGFydF93b3JrZXIoKSB0byBjYWxsCnJlYnVpbGRfZGF0 YWJhc2VfbGlzdCgpIGF0IHRoZSBlbmQsIHdoaWNoIGFnYWluIG1pc2NvbXB1dGVzIGFkbF9uZXh0 X3dvcmtlcgphbmQgcHVzaGVzIGl0IGZ1cnRoZXIgaW50byB0aGUgZnV0dXJlLCBzbyB0aGF0IHRo ZSBzaXR1YXRpb24gcmVwZWF0cyBvbiB0aGUKbmV4dCBjYWxsIHRvIGRvX3N0YXJ0X3dvcmtlcigp LCBhbmQgc28gb24gaW5kZWZpbml0ZWx5Lg0KDQpUaGF04oCZcyB0aGUgY3J1eCBvZiBvdXIgaXNz dWUuIFBsZWFzZSBsZXQgdXMga25vdyBpZiBhbnkgY2xhcmlmaWNhdGlvbiBvcgptb3JlIGRldGFp bGVkIHJlcHJvIHN0ZXBzIGFyZSBuZWVkZWQuIE91ciByZXBybyBwYXRjaCBqdXN0IHNsZWVwcyBi ZWZvcmUgYW5kCmFmdGVyIHRoZSBMb2NrU2hhcmVkT2JqZWN0KCkgY2FsbCBpbiBJbml0UG9zdGdy ZXMoKSAodG8gd2lkZW4gdGhlIHJhY2UKd2luZG93cykgYW5kIGFkZHMgYSBsb3Qgb2YgbG9nZ2lu Zy4gKEphY29iIGRpZCA+OTAlIG9mIHRoZSBkZWJ1Z2dpbmcgaGVyZTsgSQptZXJlbHkgZGV0ZXJt aW5lZCBob3cgdGhlIHBnc3RhdHMgZW50cnkgbG9zdCBpdHMgZHJvcHBlZCBmbGFnLikNCg0KV2Ug YXNzdW1lIHRoYXQgb25lIGZpeCB3b3VsZCBiZSB0byBzb21laG93IGVuc3VyZSB0aGF0IHRoZSBk cm9wcGVkIGZsYWcKcmVtYWlucyB0cnVlIG9uIGEgZHJvcHBlZCBkYXRhYmFzZeKAmXMgcGdzdGF0 cyBlbnRyeSB1bnRpbCBpdOKAmXMgZnJlZWQsIGJ1dAphbHNvLCBpdCBzZWVtcyBhIGJpdCBmcmFn aWxlIGZvciBhdXRvdmFjdXVt4oCZcyBkb19zdGFydF93b3JrZXIoKSB0byBzb21ldGltZXMKY2Fs bCByZWJ1aWxkX2RhdGFiYXNlX2xpc3QoKSBhbmQgZGVsYXkgYWxsIHRoZSBhZGxfbmV4dF93b3Jr ZXIgdGltZXMuCldpdGhvdXQgdGhpbmtpbmcgYWJvdXQgaXQgdG9vIGhhcmQsIHdlIHdvbmRlciBp ZiB0aGVyZSB3b3VsZCBzdGlsbCBiZSBhCnBhdHRlcm4gb2Ygb25nb2luZyBEQiBjcmVhdGVzIGFu ZCBkcm9wcyB0aGF0IGNvdWxkIGNhdXNlIGl0IHRvIG1pc2JlaGF2ZSBpbgphIHNpbWlsYXIgd2F5 LCBuZXZlciBkZWNpZGluZyB0byBhdXRvdmFjdXVtIGFueSBkYXRhYmFzZSBldmVuIGlmIG9uZSBs aXZlcwpsb25nIGVub3VnaCB0aGF0IGl0IHNob3VsZCBiZSBhdXRvdmFjdXVtZWQuCgo= --===============1052536909297235143==--