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 1pUl7U-0005p1-IR for pgsql-bugs@arkaria.postgresql.org; Wed, 22 Feb 2023 09:09:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pUl7T-0007UP-Fu for pgsql-bugs@arkaria.postgresql.org; Wed, 22 Feb 2023 09:08:59 +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 1pUiAi-0005zC-Ac for pgsql-bugs@lists.postgresql.org; Wed, 22 Feb 2023 06:00:08 +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 1pUiAf-0006Xq-Qj for pgsql-bugs@lists.postgresql.org; Wed, 22 Feb 2023 06:00:07 +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=qKqLXQ8i1UpPBIf6SSZMu9/uG46PlUmG4rDw3q4z3/c=; b=AYHen+L+L15rYG3H3r7mbRYK0h LjcjWYa4A3YFv5sxLto8aMl+7EiP2MvLxroqUqarBHVvVAPugfDB+pc6dx5+9TO3jZqZAJCN39bK9 KrJNFoU/pYobHdhcFLcRLpAZ3YkR6EpJUXF9aZQQqGyvKSTjeNv0RaJGAeEaE5xdsD5ZyEEVcNbxA /Cz1/6v6ZNOQJMJd3woDb/lh3xdA2FTtWJcjamZ6GFGHHTSCN2M/QHh5RXBlbcIDDkklFppbvuGyX cUqvyBPli0J1F0p0qcOgNHBq3iwzgMfN4Nyfpp0NaxXD1d55WoLOIxUdEfqv31l/fms6PC9ljWjyK mbglzzUA==; 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 1pUiAe-0001DB-Rm for pgsql-bugs@lists.postgresql.org; Wed, 22 Feb 2023 06:00: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 1pUiAb-000LaA-M7 for pgsql-bugs@lists.postgresql.org; Wed, 22 Feb 2023 06:00:02 +0000 Content-Type: multipart/mixed; boundary="===============4447813020852912402==" MIME-Version: 1.0 Subject: BUG #17804: Assertion failed in pg_stat after fetching from pg_stat_database and swithing cache->snapshot 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, 22 Feb 2023 06:00:01 +0000 Message-ID: <17804-2a118cd046f2d0e5@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 --===============4447813020852912402== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzgwNApMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTUuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKVGhlIGZvbGxvd2luZyB0cmFuc2FjdGlvbjoNCkJFR0lOOw0KU0VUIExPQ0FMIHN0YXRz X2ZldGNoX2NvbnNpc3RlbmN5ID0gY2FjaGU7DQpTRUxFQ1QgKiBGUk9NIHBnX3N0YXRfZGF0YWJh c2U7DQpTRVQgTE9DQUwgc3RhdHNfZmV0Y2hfY29uc2lzdGVuY3kgPSBzbmFwc2hvdDsNClNFTEVD VCBwZ19zdGF0X2dldF9mdW5jdGlvbl9jYWxscygwKTsNCg0KcmFpc2VzIGFuIGFzc2VydGlvbiBm YWlsdXJlIHdpdGggdGhlIGZvbGxvd2luZyBzdGFjazoNCkNvcmUgd2FzIGdlbmVyYXRlZCBieSBg cG9zdGdyZXM6IGxhdyByZWdyZXNzaW9uIFtsb2NhbF0gU0VMRUNUICAgICAgICAgICAgICAKICAg ICAgICAgICAgICAgICAgICAgICAgJy4NClByb2dyYW0gdGVybWluYXRlZCB3aXRoIHNpZ25hbCBT SUdBQlJULCBBYm9ydGVkLg0KDQp3YXJuaW5nOiBTZWN0aW9uIGAucmVnLXhzdGF0ZS8xMzU1Nzgy JyBpbiBjb3JlIGZpbGUgdG9vIHNtYWxsLg0KIzAgIF9fcHRocmVhZF9raWxsX2ltcGxlbWVudGF0 aW9uIChub190aWQ9MCwgc2lnbm89NiwKdGhyZWFkaWQ9MTQwNjYzNDgyODI0NTEyKSBhdCAuL25w dGwvcHRocmVhZF9raWxsLmM6NDQNCjQ0ICAgICAgLi9ucHRsL3B0aHJlYWRfa2lsbC5jOiBObyBz dWNoIGZpbGUgb3IgZGlyZWN0b3J5Lg0KKGdkYikgYnQNCiMwICBfX3B0aHJlYWRfa2lsbF9pbXBs ZW1lbnRhdGlvbiAobm9fdGlkPTAsIHNpZ25vPTYsCnRocmVhZGlkPTE0MDY2MzQ4MjgyNDUxMikg YXQgLi9ucHRsL3B0aHJlYWRfa2lsbC5jOjQ0DQojMSAgX19wdGhyZWFkX2tpbGxfaW50ZXJuYWwg KHNpZ25vPTYsIHRocmVhZGlkPTE0MDY2MzQ4MjgyNDUxMikgYXQKLi9ucHRsL3B0aHJlYWRfa2ls bC5jOjc4DQojMiAgX19HSV9fX3B0aHJlYWRfa2lsbCAodGhyZWFkaWQ9MTQwNjYzNDgyODI0NTEy LCBzaWdubz1zaWdub0BlbnRyeT02KSBhdAouL25wdGwvcHRocmVhZF9raWxsLmM6ODkNCiMzICAw eDAwMDA3ZmVlYzRhMWE0NzYgaW4gX19HSV9yYWlzZSAoc2lnPXNpZ0BlbnRyeT02KSBhdAouLi9z eXNkZXBzL3Bvc2l4L3JhaXNlLmM6MjYNCiM0ICAweDAwMDA3ZmVlYzRhMDA3ZjMgaW4gX19HSV9h Ym9ydCAoKSBhdCAuL3N0ZGxpYi9hYm9ydC5jOjc5DQojNSAgMHgwMDAwNTU1Y2YwNjAzMzE1IGlu IEV4Y2VwdGlvbmFsQ29uZGl0aW9uICgNCiAgICBjb25kaXRpb25OYW1lPTB4NTU1Y2YwN2VjZjM4 ICJwZ1N0YXRMb2NhbC5zbmFwc2hvdC5zdGF0cy0+bWVtYmVycyA9PSAwIiwKDQogICAgZXJyb3JU eXBlPTB4NTU1Y2YwN2VjOTc0ICJGYWlsZWRBc3NlcnRpb24iLCBmaWxlTmFtZT0weDU1NWNmMDdl Y2M4ZgoicGdzdGF0LmMiLCBsaW5lTnVtYmVyPTk0OCkNCiAgICBhdCBhc3NlcnQuYzo2OQ0KIzYg IDB4MDAwMDU1NWNmMDQ1ZTgxNSBpbiBwZ3N0YXRfYnVpbGRfc25hcHNob3QgKCkgYXQgcGdzdGF0 LmM6OTQ4DQojNyAgMHgwMDAwNTU1Y2YwNDVlMzliIGluIHBnc3RhdF9mZXRjaF9lbnRyeSAoa2lu ZD1QR1NUQVRfS0lORF9GVU5DVElPTiwKZGJvaWQ9MTYzODQsIG9iam9pZD0wKQ0KICAgIGF0IHBn c3RhdC5jOjc5OA0KIzggIDB4MDAwMDU1NWNmMDQ2MWZhZSBpbiBwZ3N0YXRfZmV0Y2hfc3RhdF9m dW5jZW50cnkgKGZ1bmNfaWQ9MCkgYXQKcGdzdGF0X2Z1bmN0aW9uLmM6MjQyDQojOSAgMHgwMDAw NTU1Y2YwNTQ0YzY2IGluIHBnX3N0YXRfZ2V0X2Z1bmN0aW9uX2NhbGxzIChmY2luZm89MHg1NTVj ZjE2NGNiNjgpCmF0IHBnc3RhdGZ1bmNzLmM6Mzg0DQojMTAgMHgwMDAwNTU1Y2YwMWI3Mzk2IGlu IEV4ZWNJbnRlcnBFeHByIChzdGF0ZT0weDU1NWNmMTY0Y2E4MCwKZWNvbnRleHQ9MHg1NTVjZjE2 NGM3ODAsIA0KICAgIGlzbnVsbD0weDdmZmU1MGRjMDQwZikgYXQgZXhlY0V4cHJJbnRlcnAuYzo3 NTENCiMxMSAweDAwMDA1NTVjZjAxYjk2NGUgaW4gRXhlY0ludGVycEV4cHJTdGlsbFZhbGlkIChz dGF0ZT0weDU1NWNmMTY0Y2E4MCwKZWNvbnRleHQ9MHg1NTVjZjE2NGM3ODAsIA0KICAgIGlzTnVs bD0weDdmZmU1MGRjMDQwZikgYXQgZXhlY0V4cHJJbnRlcnAuYzoxODI2DQojMTIgMHgwMDAwNTU1 Y2YwMjE3MzE1IGluIEV4ZWNFdmFsRXhwclN3aXRjaENvbnRleHQgKHN0YXRlPTB4NTU1Y2YxNjRj YTgwLAplY29udGV4dD0weDU1NWNmMTY0Yzc4MCwgDQogICAgaXNOdWxsPTB4N2ZmZTUwZGMwNDBm KSBhdCAuLi8uLi8uLi9zcmMvaW5jbHVkZS9leGVjdXRvci9leGVjdXRvci5oOjM0MQ0KIzEzIDB4 MDAwMDU1NWNmMDIxNzM4ZCBpbiBFeGVjUHJvamVjdCAocHJvakluZm89MHg1NTVjZjE2NGNhNzgp DQogICAgYXQgLi4vLi4vLi4vc3JjL2luY2x1ZGUvZXhlY3V0b3IvZXhlY3V0b3IuaDozNzUNCiMx NCAweDAwMDA1NTVjZjAyMTc1ZDcgaW4gRXhlY1Jlc3VsdCAocHN0YXRlPTB4NTU1Y2YxNjRjNjY4 KSBhdApub2RlUmVzdWx0LmM6MTM2DQojMTUgMHgwMDAwNTU1Y2YwMWQwMjJkIGluIEV4ZWNQcm9j Tm9kZUZpcnN0IChub2RlPTB4NTU1Y2YxNjRjNjY4KSBhdApleGVjUHJvY25vZGUuYzo0NjQNCiMx NiAweDAwMDA1NTVjZjAxYzM0ZWUgaW4gRXhlY1Byb2NOb2RlIChub2RlPTB4NTU1Y2YxNjRjNjY4 KSBhdAouLi8uLi8uLi9zcmMvaW5jbHVkZS9leGVjdXRvci9leGVjdXRvci5oOjI1OQ0KIzE3IDB4 MDAwMDU1NWNmMDFjNjNmNSBpbiBFeGVjdXRlUGxhbiAoZXN0YXRlPTB4NTU1Y2YxNjRjNDMwLApw bGFuc3RhdGU9MHg1NTVjZjE2NGM2NjgsIA0KICAgIHVzZV9wYXJhbGxlbF9tb2RlPWZhbHNlLCBv cGVyYXRpb249Q01EX1NFTEVDVCwgc2VuZFR1cGxlcz10cnVlLApudW1iZXJUdXBsZXM9MCwgDQog ICAgZGlyZWN0aW9uPUZvcndhcmRTY2FuRGlyZWN0aW9uLCBkZXN0PTB4NTU1Y2YxNjUxOWEwLCBl eGVjdXRlX29uY2U9dHJ1ZSkKYXQgZXhlY01haW4uYzoxNjM2DQojMTggMHgwMDAwNTU1Y2YwMWMz YzI1IGluIHN0YW5kYXJkX0V4ZWN1dG9yUnVuIChxdWVyeURlc2M9MHg1NTVjZjE2NWJiYTAsCmRp cmVjdGlvbj1Gb3J3YXJkU2NhbkRpcmVjdGlvbiwgDQogICAgY291bnQ9MCwgZXhlY3V0ZV9vbmNl PXRydWUpIGF0IGV4ZWNNYWluLmM6MzYzDQojMTkgMHgwMDAwNTU1Y2YwMWMzYTEwIGluIEV4ZWN1 dG9yUnVuIChxdWVyeURlc2M9MHg1NTVjZjE2NWJiYTAsCmRpcmVjdGlvbj1Gb3J3YXJkU2NhbkRp cmVjdGlvbiwgY291bnQ9MCwgDQogICAgZXhlY3V0ZV9vbmNlPXRydWUpIGF0IGV4ZWNNYWluLmM6 MzA3DQojMjAgMHgwMDAwNTU1Y2YwNDNjYWU2IGluIFBvcnRhbFJ1blNlbGVjdCAocG9ydGFsPTB4 NTU1Y2YxNWVlYjkwLApmb3J3YXJkPXRydWUsIGNvdW50PTAsIGRlc3Q9MHg1NTVjZjE2NTE5YTAp DQogICAgYXQgcHF1ZXJ5LmM6OTI0DQojMjEgMHgwMDAwNTU1Y2YwNDNjNzA0IGluIFBvcnRhbFJ1 biAocG9ydGFsPTB4NTU1Y2YxNWVlYjkwLApjb3VudD05MjIzMzcyMDM2ODU0Nzc1ODA3LCBpc1Rv cExldmVsPXRydWUsIA0KICAgIHJ1bl9vbmNlPXRydWUsIGRlc3Q9MHg1NTVjZjE2NTE5YTAsIGFs dGRlc3Q9MHg1NTVjZjE2NTE5YTAsCnFjPTB4N2ZmZTUwZGMwODEwKSBhdCBwcXVlcnkuYzo3NjgN CiMyMiAweDAwMDA1NTVjZjA0MzU1OTAgaW4gZXhlY19zaW1wbGVfcXVlcnkgKA0KICAgIHF1ZXJ5 X3N0cmluZz0weDU1NWNmMTU4MjU3MCAiU0VMRUNUIHBnX3N0YXRfZ2V0X2Z1bmN0aW9uX2NhbGxz KDApOyIpIGF0CnBvc3RncmVzLmM6MTI1MA0KIzIzIDB4MDAwMDU1NWNmMDQzYTRhZiBpbiBQb3N0 Z3Jlc01haW4gKGRibmFtZT0weDU1NWNmMTVhZWExOCAicmVncmVzc2lvbiIsCnVzZXJuYW1lPTB4 NTU1Y2YxNWFlOWY4ICJsYXciKQ0KICAgIGF0IHBvc3RncmVzLmM6NDU5Mw0KIzI0IDB4MDAwMDU1 NWNmMDM1ZmQyYiBpbiBCYWNrZW5kUnVuIChwb3J0PTB4NTU1Y2YxNWE2MTMwKSBhdApwb3N0bWFz dGVyLmM6NDUxMQ0KIzI1IDB4MDAwMDU1NWNmMDM1ZjViMiBpbiBCYWNrZW5kU3RhcnR1cCAocG9y dD0weDU1NWNmMTVhNjEzMCkgYXQKcG9zdG1hc3Rlci5jOjQyMzkNCiMyNiAweDAwMDA1NTVjZjAz NWI1M2YgaW4gU2VydmVyTG9vcCAoKSBhdCBwb3N0bWFzdGVyLmM6MTgwNg0KIzI3IDB4MDAwMDU1 NWNmMDM1YWM5YyBpbiBQb3N0bWFzdGVyTWFpbiAoYXJnYz0zLCBhcmd2PTB4NTU1Y2YxNTdkYTMw KSBhdApwb3N0bWFzdGVyLmM6MTQ3OA0KIzI4IDB4MDAwMDU1NWNmMDI0ZWJkZCBpbiBtYWluIChh cmdjPTMsIGFyZ3Y9MHg1NTVjZjE1N2RhMzApIGF0IG1haW4uYzoyMDINCg0KSXQgYXBwZWFyZWQg d2l0aCB0aGUgc3RhdHNfZmV0Y2hfY29uc2lzdGVuY3kgaW50cm9kdWN0aW9uICg1ODkxYzdhOGUp Lg0KDQpMb29rcyBsaWtlIHBnc3RhdF9mZXRjaF9lbnRyeSgpIGNhbiBmaWxsIHVwIHRoZSBzbmFw c2hvdC5zdGF0cyBzdHJ1Y3R1cmUNCmFuZCBpdCdzIGNvbnRlbnRzIHByZXNlcnZlZCB3aGVuIHN3 aXRjaGluZyB0aGUgY29uc2lzdGVuY3kgbW9kZSwNCndoYXQgcGdzdGF0X2J1aWxkX3NuYXBzaG90 KCkgZG9lc24ndCBleHBlY3QuCgo= --===============4447813020852912402==--