Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: 看板的流量可视化页面出现了table_9749这个表,但是库里面没有,请问这是啥
[Test Environment for TiDB] Testing
[TiDB Version] V7.5.0
[Reproduction Path] TiDB built-in dashboard - Traffic Visualization
[Encountered Issue: Phenomenon and Impact] Just asking, no issue. I want to know if this name is an internal table name in TiDB? I see that table names are normal elsewhere.
[Resource Configuration] Enter TiDB Dashboard - Traffic Visualization and take a screenshot of this page
[Attachment: Screenshot/Log/Monitoring]
select * from information_schema.tables where table_name =‘xx’
Take a look?
It might be a table that has already been deleted. Try using this 9749 as the table_id to check in the information_schema.tables table.
Have you checked the system tables? We encountered a similar issue before where there were two duplicate system tables, and we needed to restart to resolve it.
Check if there is 9749 in ddl_jobs.
No, bro, take a look at my screenshot below.
I checked within two hours of the restart, it should not be this issue.
How about checking like this: select * from information_schema.ddl_jobs where table_id='9749'
I also see similar table_id tables in my traffic visualization, but I can’t find them using admin show ddl. Looking forward to experts solving the mystery.
Show the issue. If it’s a test environment, try restarting PD. I’m curious too.
I checked the local environment, and it should indeed be the TIDB_TABLE_ID field in INFORMATION_SCHEMA.TABLES. If it is an existing table, the table name will be directly displayed in the heatmap. Could these IDs be temporary tables or empty ones?