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.

Sign up for GitHub

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

Jump to bottom

Query infoschema tables in a large cluster may encounter OOM issue #58985

Open
tangenta opened this issue Jan 16, 2025 · 1 comment · May be fixed by #58986
Open

Query infoschema tables in a large cluster may encounter OOM issue #58985

tangenta opened this issue Jan 16, 2025 · 1 comment · May be fixed by #58986
Labels
affects-8.5 This bug affects the 8.5.x(LTS) versions. component/ddl This issue is related to DDL of TiDB. severity/major type/bug The issue is confirmed as a bug.

Comments

@tangenta
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Prepare 1M tables.

select count(1) from information_schema.tables;

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

Return the result or report the error like "Your query has been cancelled due to exceeding the allowed memory limit for a single SQL query. Please try narrowing your query scope or increase the tidb_mem_quota_query limit and try again".

3. What did you see instead (Required)

TiDB OOM and panic.

4. What is your TiDB version? (Required)

1f74ac3
@tangenta tangenta added the type/bug The issue is confirmed as a bug. label Jan 16, 2025
@tangenta
Copy link
Contributor Author

#51455 fixed a similar issue, but as #51455 (comment) said, the memory has been allocated already. We should provide fine-grained memory control.

@tangenta tangenta linked a pull request Jan 16, 2025 that will close this issue
Open
13 tasks
@tangenta tangenta added affects-8.5 This bug affects the 8.5.x(LTS) versions. severity/major labels Jan 16, 2025
@jebter jebter added the component/ddl This issue is related to DDL of TiDB. label Jan 17, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affects-8.5 This bug affects the 8.5.x(LTS) versions. component/ddl This issue is related to DDL of TiDB. severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

executor: make retriever memory tracker fine grained tangenta/tidb
2 participants
@jebter @tangenta