The traffic visualization page of the Kanban shows the table_9749 table, but it is not in the database. What is this?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 看板的流量可视化页面出现了table_9749这个表,但是库里面没有,请问这是啥

| username: 云雨雪风

[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]
image

| username: DBAER | Original post link

select * from information_schema.tables where table_name =‘xx’
Take a look?

| username: 小龙虾爱大龙虾 | Original post link

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.

| username: xiaoqiao | Original post link

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.

| username: Soysauce520 | Original post link

Check if there is 9749 in ddl_jobs.

| username: 云雨雪风 | Original post link

No, I’m also confused.

| username: 云雨雪风 | Original post link

No, bro, take a look at my screenshot below.

| username: 云雨雪风 | Original post link

I checked within two hours of the restart, it should not be this issue.

| username: DBAER | Original post link

admin show ddl to check?

| username: 小龙虾爱大龙虾 | Original post link

9749 is tidb_table_id

| username: zhanggame1 | Original post link

Use table_id to check

| username: Soysauce520 | Original post link

How about checking like this: select * from information_schema.ddl_jobs where table_id='9749'

| username: stephanie | Original post link

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.

| username: TIDB-Learner | Original post link

Show the issue. If it’s a test environment, try restarting PD. I’m curious too.

| username: Kongdom | Original post link

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?