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

sync load cannot load common column when to concurrently init stats #57544

Closed
hawkingrei opened this issue Nov 20, 2024 · 1 comment
Closed
Labels
affects-7.5 This bug affects the 7.5.x(LTS) versions. report/customer Customers have encountered this bug. severity/major sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@hawkingrei
Copy link
Member

hawkingrei commented Nov 20, 2024

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

we need to set the tidb config as following.

[performance]
lite-init-stats = false

force-init-stats = true

concurrently-init-stats = true

operate as following

tiup Playground: Start a 7.5.4 cluster, remember to add --tag.


create table t(a int, b int);
insert into t value(1,1),(2,2),(3,3);

Stop the cluster, then start it again.

analyze table t;
create table tt(a int, b int);
insert into tt value(1,1),(2,2),(3,3);

Stop the cluster again, then start it again.
Wait for 15 seconds.

analyze table tt;

Stop the cluster again, then start it again.

explain select * from t where a = 1;

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

we cannot see any pseudo stats

3. What did you see instead (Required)

we can see a pseudo stats

4. What is your TiDB version? (Required)

only for v7.5

@seiya-annie
Copy link

/report customer

@ti-chi-bot ti-chi-bot bot added the report/customer Customers have encountered this bug. label Jan 9, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-7.5 This bug affects the 7.5.x(LTS) versions. report/customer Customers have encountered this bug. severity/major sig/planner SIG: Planner type/bug The issue is confirmed as a bug.
Projects
None yet
Development

No branches or pull requests

4 participants