From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: jiangdian_m@163.com
Subject: BUG #18567: ERROR: cache lookup failed for attribute 1 of relation 74580
Date: Mon, 05 Aug 2024 13:25:27 +0000
Message-ID: <18567-1a31eee4c9ca4325@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18567
Logged by: Dian Jiang
Email address: jiangdian_m@163.com
PostgreSQL version: 15.0
Operating system: centos
Description:
SQL:
Process A:
psql:
CREATE TABLE test_table (
id SERIAL PRIMARY KEY,
data TEXT
) WITH (fillfactor = 70);
CREATE INDEX test_index ON test_table (data) WITH (fillfactor = 80);
INSERT INTO test_table (data) VALUES ('sample data');
Attach gdb to process A.
In the pg_get_indexdef_worker() function, set a breakpoint at the line
context = deparse_context_for(get_relation_name(indrelid), indrelid); and
then execute the query in Process A:
SELECT pg_get_indexdef(indexrelid) FROM pg_index WHERE indrelid =
'test_table'::regclass;
Process B:
drop index test_tableļ¼
----------------------------------------------------------------
The query in process A will result in an error:
postgres:# SELECT pg_get_indexdef(indexrelid) FROM pg_index WHERE indrelid =
'test_table'::regclass;
ERROR: cache lookup failed for attribute l of relation 74580
The reason is that context =
deparse_context_for(get_relation_name(indrelid), indrelid); handles
invalidation messages, leading to cache invalidation
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, jiangdian_m@163.com
Subject: Re: BUG #18567: ERROR: cache lookup failed for attribute 1 of relation 74580
In-Reply-To: <18567-1a31eee4c9ca4325@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox