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

Too many unnecessary log for sync load when stats is not exists #57804

Closed
lilinghai opened this issue Nov 28, 2024 · 3 comments · Fixed by #57803
Closed

Too many unnecessary log for sync load when stats is not exists #57804

lilinghai opened this issue Nov 28, 2024 · 3 comments · Fixed by #57803
Assignees
Labels
affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.5 This bug affects the 8.5.x(LTS) versions. severity/major sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@lilinghai
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

many sysbench tables and run read_write
tidb always print the log but the column pad stats is not collected.

[2024/11/28 11:56:52.620 +00:00] [WARN] [stats_syncload.go:412] ["fail to get hist meta for this histogram, possibly a deleted one"] [table_id=1285152] [hist_id=3] [is_index=false]
[2024/11/28 11:56:52.623 +00:00] [WARN] [stats_syncload.go:412] ["fail to get hist meta for this histogram, possibly a deleted one"] [table_id=1201116] [hist_id=3] [is_index=false]
[2024/11/28 11:56:52.624 +00:00] [WARN] [stats_syncload.go:412] ["fail to get hist meta for this histogram, possibly a deleted one"] [table_id=1306426] [hist_id=3] [is_index=false]
[2024/11/28 11:56:52.629 +00:00] [WARN] [stats_syncload.go:412] ["fail to get hist meta for this histogram, possibly a deleted one"] [table_id=1357610] [hist_id=3] [is_index=false]
[2024/11/28 11:56:52.634 +00:00] [WARN] [stats_syncload.go:412] ["fail to get hist meta for this histogram, possibly a deleted one"] [table_id=1236468] [hist_id=3] [is_index=false]
[2024/11/28 11:56:52.634 +00:00] [WARN] [stats_syncload.go:412] ["fail to get hist meta for this histogram, possibly a deleted one"] [table_id=1393198] [hist_id=3] [is_index=false]
...

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

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

Release Version: v8.5.0-alpha-232-g924784aa3e
Edition: Community
Git Commit Hash: 924784a
Git Branch: HEAD
UTC Build Time: 2024-11-28 02:37:38
GoVersion: go1.23.3
Race Enabled: false

@lilinghai lilinghai added the type/bug The issue is confirmed as a bug. label Nov 28, 2024
@winoros
Copy link
Member

winoros commented Nov 28, 2024

It's should be introduced by #53399 and #53298.
These prs make the status standing for no memory object for one column a complex status. In lite init, no memory object for one column means that the column has no stats.
In non-lite init+currently init, no memory object for the column can also mean that we haven't read it from memory.

@lance6716
Copy link
Contributor

duplicated with #56740

ti-chi-bot bot pushed a commit that referenced this issue Dec 3, 2024
@winoros winoros added affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. labels Dec 3, 2024
@winoros
Copy link
Member

winoros commented Dec 3, 2024

Add these affects labels to see whether we need to pick it back later.

@winoros winoros removed the affects-8.1 This bug affects the 8.1.x(LTS) versions. label Dec 3, 2024
ti-chi-bot bot pushed a commit that referenced this issue Dec 3, 2024
ti-chi-bot bot pushed a commit that referenced this issue Dec 20, 2024
ti-chi-bot bot pushed a commit that referenced this issue Dec 23, 2024
@winoros winoros removed the affects-6.5 This bug affects the 6.5.x(LTS) versions. label Feb 11, 2025
ti-chi-bot bot pushed a commit that referenced this issue Feb 26, 2025
ti-chi-bot bot pushed a commit that referenced this issue Feb 28, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.5 This bug affects the 8.5.x(LTS) versions. severity/major sig/planner SIG: Planner type/bug The issue is confirmed as a bug.
Projects
None yet
3 participants