Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unrelated DDL change cause cache miss and reload in infoschema v2 #54500

Closed
tiancaiamao opened this issue Jul 8, 2024 · 0 comments · Fixed by #54501
Closed

Unrelated DDL change cause cache miss and reload in infoschema v2 #54500

tiancaiamao opened this issue Jul 8, 2024 · 0 comments · Fixed by #54501
Labels
feature/developing the related feature is in development severity/minor sig/sql-infra SIG: SQL Infra type/bug This issue is a bug.

Comments

@tiancaiamao
Copy link
Contributor

tiancaiamao commented Jul 8, 2024

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

As the title says, that kind of behavior is not expected.

For example, if I have a table t1
I do some unrelated DDL operations
Visiting t1 should still always hit cache

2. What did you expect to see? (Required)

create table t1 (id int);
select * from t1; // hit infoschema cache
// evit the schema cache of t1
create table t2 (id int);
select * from t1;
select * from t1; // hit infoschema cache because DDL is on t2, unrelated to t1
create table t3 (id int);
select * from t1; // hit infoschema cache because DDL is on t3, unrelated to t1
create table t4 (id int);
select * from t1;; // hit infoschema cache because DDL is on t4, unrelated to t1

3. What did you see instead (Required)

After the original t1 cache been evicted, the following DDL operation would cause schema cache miss everytime.

4. What is your TiDB version? (Required)

master

@tiancaiamao tiancaiamao added type/bug This issue is a bug. feature/developing the related feature is in development labels Jul 8, 2024
@jebter jebter added the sig/sql-infra SIG: SQL Infra label Jul 9, 2024
@ti-chi-bot ti-chi-bot bot closed this as completed in 05c8119 Jul 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature/developing the related feature is in development severity/minor sig/sql-infra SIG: SQL Infra type/bug This issue is a bug.
2 participants