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 1qtmok-00Dvy7-PC for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Oct 2023 10:33:23 +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 1qtmoi-00GPby-41 for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Oct 2023 10:33:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qtkQU-00Er3l-F0 for pgsql-bugs@lists.postgresql.org; Fri, 20 Oct 2023 08:00:11 +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 1qtkQQ-001gK4-8E for pgsql-bugs@lists.postgresql.org; Fri, 20 Oct 2023 08:00: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=DO1+QFU3cy1RdFKM6jdeuDne+y8iTYtQFIfZwgecS9k=; b=oCFUYEGqzMd1xWTSwCXW65h1c+ rLQ1+YzeuKaADhSNDJBYO6/SMdNZHaeZuvcWbZZ8zbRIZ7yYB/zHo4oHr7SvDk1pULg2A0BezxMVr ml4b6Z2YYJsYrM0UaLV7+6r8kvprBIHO9nhLUSuGiyj5NAkhd5I1VPO8/gnHHAXZYKEJ2KbflbzuE czu1i7tYbAlfubVjJmRW4I4scWp9jhvTpw9/Um8dg/SH3fwc2hpimKYlXWT439OxBJc410V8u1CnG dTXGJq8QsAe2wOv2jfmmK6wSpqv6YG+pQlJt5YBiU9FBUpuRd/Xl79UJiWtTK8CptEiGrauwmlFN0 ebSwpDMA==; 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 1qtkQP-00016K-2G for pgsql-bugs@lists.postgresql.org; Fri, 20 Oct 2023 08:00:05 +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 1qtkQL-005ECu-TV for pgsql-bugs@lists.postgresql.org; Fri, 20 Oct 2023 08:00:03 +0000 Content-Type: multipart/mixed; boundary="===============7860140759851327285==" MIME-Version: 1.0 Subject: BUG #18163: Catcache entry invalidation might be missed when toast processed inside CatalogCacheCreateEntry 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: Fri, 20 Oct 2023 08:00:00 +0000 Message-ID: <18163-859bad19a43edcf6@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 --===============7860140759851327285== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODE2MwpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTYuMApPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKWyBpbnNwaXJlZCBieSBUb20gTGFuZSdzIHN1c3BpY2lvbnMgaW4gdGhlIGRpc2N1c3Np b24gb2YgYnVnICMxODAxNCBdDQoNCldoZW4gYSBjYXRhbG9nIGVudHJ5IGNyZWF0ZWQgaW5zaWRl IENhdGFsb2dDYWNoZUNyZWF0ZUVudHJ5LCBmb3IgdHVwbGVzDQp3aXRoIHRvYXN0ZWQgZmllbGRz IHRoaXMgZnVuY3Rpb24gZmV0Y2hlcyB0b2FzdCB2YWx1ZXMgYW5kIHRodXMgcHJvY2Vzc2VzDQpB Y2NlcHRJbnZhbGlkYXRpb25NZXNzYWdlcyBjYWxscywgdGhhdCBtaWdodCBpbnZhbGlkYXRlIHRo ZSBlbnRyeSBjcmVhdGVkLA0KYnV0IENhdGFsb2dDYWNoZUNyZWF0ZUVudHJ5IHN0aWxsIHJldHVy bnMgdGhlIGVudHJ5IGFzIHZhbGlkLg0KDQpJJ3ZlIGNvbnN0cnVjdGVkIHRoZSBmb2xsb3dpbmcg ZGVtbyBzY3JpcHQgZm9yIHRoZSBpc3N1ZToNCm51bXJhY2VzPTEwDQplY2hvICINClNFTEVDVCBm b3JtYXQoJ0NSRUFURSBST0xFIHVzZXJfJXMnLCBpKSBGUk9NIGdlbmVyYXRlX3NlcmllcygxLCA0 MDAwKSBpDQpcZ2V4ZWMiIHwgcHNxbCA+L2Rldi9udWxsDQoNCmZvciAoKGM9MTtjPD0kbnVtcmFj ZXM7YysrKSk7IGRvDQpjcmVhdGVkYiBkYiRjDQplY2hvICINCkNSRUFURSBET01BSU4gZG9tIEFT IHRleHQ7DQoNClNFTEVDVCBmb3JtYXQoJw0KICBHUkFOVCBVU0FHRSBPTiBUWVBFIGRvbSBUTyB1 c2VyXyVzJywgaSkgRlJPTSBnZW5lcmF0ZV9zZXJpZXMoMSwgNDAwMCkgaQ0KXGdleGVjDQoNCkNS RUFURSBUQUJMRSB0YWIodGltZSB0aW1lc3RhbXAsIGlkIGludCwgY29udGVudCBkb20pOw0KIiB8 IHBzcWwgZGIkYyA+L2Rldi9udWxsDQpkb25lDQoNCmZvciAoKG49MTtuPD0zMDA7bisrKSk7IGRv DQplY2hvICJJVEVSQVRJT04gJG4iDQoNCmZvciAoKGM9MTtjPD0kbnVtcmFjZXM7YysrKSk7IGRv DQplY2hvICINCkJFR0lOOw0KQUxURVIgRE9NQUlOIGRvbSBTRVQgREVGQVVMVCAneCc7DQpTRUxF Q1QgcGdfc2xlZXAoMC4xKTsNCkNPTU1JVDsNClNFTEVDVCBwZ19zbGVlcCgwLjA1ICsgcmFuZG9t KCkgKiAwLjEwKTsgLS0gdHVuaW5nIG1pZ2h0IGJlIG5lZWRlZA0KSU5TRVJUIElOVE8gdGFiIFNF TEVDVCBub3coKSwgMTAxOyBTRUxFQ1QgcGdfc2xlZXAoMC4xKTsNCklOU0VSVCBJTlRPIHRhYiBT RUxFQ1Qgbm93KCksIDEwMjsgU0VMRUNUIHBnX3NsZWVwKDAuMSk7DQpJTlNFUlQgSU5UTyB0YWIg U0VMRUNUIG5vdygpLCAxMDM7IFNFTEVDVCBwZ19zbGVlcCgwLjEpOw0KSU5TRVJUIElOVE8gdGFi IFNFTEVDVCBub3coKSwgMTA0OyBTRUxFQ1QgcGdfc2xlZXAoMC4xKTsNCklOU0VSVCBJTlRPIHRh YiBTRUxFQ1Qgbm93KCksIDEwNTsNCiIgfCBwc3FsIGRiJGMgPi9kZXYvbnVsbCAmDQoNCmVjaG8g Ig0KQkVHSU47DQpTRUxFQ1QgcGdfc2xlZXAoMC4wNSk7DQpTRUxFQ1Qgb2lkIEZST00gcGdfdHlw ZSBXSEVSRSB0eXBuYW1lID0gJ2RvbScgRk9SIFVQREFURTsNClJPTExCQUNLOw0KQUxURVIgRE9N QUlOIGRvbSBTRVQgREVGQVVMVCAneHgnOw0KSU5TRVJUIElOVE8gdGFiIFNFTEVDVCBub3coKSwg MjAxOyBTRUxFQ1QgcGdfc2xlZXAoMC4xKTsNCklOU0VSVCBJTlRPIHRhYiBTRUxFQ1Qgbm93KCks IDIwMjsgU0VMRUNUIHBnX3NsZWVwKDAuMSk7DQpJTlNFUlQgSU5UTyB0YWIgU0VMRUNUIG5vdygp LCAyMDM7IFNFTEVDVCBwZ19zbGVlcCgwLjEpOw0KSU5TRVJUIElOVE8gdGFiIFNFTEVDVCBub3co KSwgMjA0OyBTRUxFQ1QgcGdfc2xlZXAoMC4xKTsNCklOU0VSVCBJTlRPIHRhYiBTRUxFQ1Qgbm93 KCksIDIwNTsNCiIgfCBwc3FsIGRiJGMgPi9kZXYvbnVsbCAmDQpkb25lDQp3YWl0DQoNCmZvciAo KGM9MTtjPD0kbnVtcmFjZXM7YysrKSk7IGRvDQplcnJjbnQ9JCgNCmVjaG8gIg0KU0VMRUNUIENP VU5UKCopIEZST00gdGFiIHQsIHRhYiB0MSwgdGFiIHQyDQogIFdIRVJFIHQxLnRpbWUgPCB0LnRp bWUgQU5EIHQxLmNvbnRlbnQgPD4gdC5jb250ZW50DQogICAgQU5EIHQyLnRpbWUgPiB0LnRpbWUg QU5EIHQyLmNvbnRlbnQgPD4gdC5jb250ZW50Ow0KIiB8IHBzcWwgZGIxIC1BcXQpDQppZiBbWyAk ZXJyY250ID09IDAgXV07IHRoZW4NCiAgcHNxbCBkYiRjIC1jICJUUlVOQ0FURSBUQUJMRSB0YWIi ID4vZGV2L251bGwNCmVsc2UNCiAgZWNobyAiUGFpciAkYyBoYXMgZ290IGluY29uc2lzdGVudCBk b21haW4gZGVmaW5pdGlvbnM6Ig0KICBwc3FsIGRiJGMgLWMgIlNFTEVDVCB0aW1lLCBpZCwgY29u dGVudCBGUk9NIHRhYiBPUkRFUiBCWSB0aW1lIg0KICBicmVhaw0KZmkNCmRvbmUNCg0KW1sgJGVy cmNudCA9PSAwIF1dIHx8IGJyZWFrOw0KZG9uZQ0KDQpJdCBzaG93cyBob3cgdHdvIHNlc3Npb25z IG1pZ2h0IHNlZSB0d28gZGlmZmVyZW50IGxpdmUgY2F0Y2FjaGUgZW50cmllcw0Kc2ltdWx0YW5l b3VzbHk6DQouLi4NCklURVJBVElPTiAyMA0KUGFpciAxIGhhcyBnb3QgaW5jb25zaXN0ZW50IGRv bWFpbiBkZWZpbml0aW9uczoNCiAgICAgICAgICAgIHRpbWUgICAgICAgICAgICB8IGlkICB8IGNv bnRlbnQgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tKy0tLS0tLS0tLQ0KIDIw MjMtMTAtMjAgMTA6MzE6MzAuMjE0MTc5IHwgMTAxIHwgeA0KIDIwMjMtMTAtMjAgMTA6MzE6MzAu MjIyODA4IHwgMjAxIHwgeHgNCiAyMDIzLTEwLTIwIDEwOjMxOjMwLjMyNDc2OCB8IDIwMiB8IHh4 DQogMjAyMy0xMC0yMCAxMDozMTozMC4zMjY5NzYgfCAxMDIgfCB4DQogMjAyMy0xMC0yMCAxMDoz MTozMC40MjY1NSAgfCAyMDMgfCB4eA0KIDIwMjMtMTAtMjAgMTA6MzE6MzAuNDI4Njk4IHwgMTAz IHwgeA0KIDIwMjMtMTAtMjAgMTA6MzE6MzAuNTI3MzgxIHwgMjA0IHwgeHgNCiAyMDIzLTEwLTIw IDEwOjMxOjMwLjUzMDM5NiB8IDEwNCB8IHgNCiAyMDIzLTEwLTIwIDEwOjMxOjMwLjYyOTE1NSB8 IDIwNSB8IHh4DQogMjAyMy0xMC0yMCAxMDozMTozMC42MzIwNDIgfCAxMDUgfCB4DQooMTAgcm93 cykNCg0KSSd2ZSAgcGF0Y2hlZCBjYXRjYWNoZS5jIHRvIGNhdGNoIHRoZSBhbm9tYWx5IGVhc2ll cjoNCkBAIC00MCwyICs0MCwzIEBADQogI2luY2x1ZGUgInV0aWxzL3N5c2NhY2hlLmgiDQorI2lu Y2x1ZGUgInRjb3AvdGNvcHByb3QuaCINCiANCkBAIC0xODEyLDIgKzE4MTMsMyBAQCBDYXRhbG9n Q2FjaGVDcmVhdGVFbnRyeShDYXRDYWNoZSAqY2FjaGUsIEhlYXBUdXBsZQpudHAsIERhdHVtICph cmd1bWVudHMsDQogICAgICAgICBBc3NlcnQoIW5lZ2F0aXZlKTsNCitpZiAoZGVidWdfcXVlcnlf c3RyaW5nICYmICBzdHJzdHIoZGVidWdfcXVlcnlfc3RyaW5nLCAibm93KCksIDEwMSIpICE9Ck5V TEwpIHBnX3VzbGVlcCgxMDAwTCk7DQogDQpidXQgSSBiZWxpZXZlIGl0IGNvdWxkIGJlIHNlZW4g d2l0aG91dCBwYXRjaGluZywgdGhhdCB3b3VsZCBqdXN0IHJlcXVpcmUNCm1vcmUgdGltZS4KCg== --===============7860140759851327285==--