information_schema.tables 里重复垃圾数据 怎么清理

tispark某个库里任何操作都报java.lang.IllegalArgumentException: Multiple entries with same key: - #14,来自 Cong-PingCAP 这里有ddl.txt 下载
每一次ddl 之后 table_id 都会变大 。老的数据应该从系统视图information_schema.tables 删除的, 没删干净 。

select * from information_schema.DDL_JOBS where table_id=29909 limit 1000;
±-------±-----------------±------------------------±---------------±-------------±----------±---------±----------±--------------------±--------------------±-------±---------------------------------------+
| JOB_ID | DB_NAME | TABLE_NAME | JOB_TYPE | SCHEMA_STATE | SCHEMA_ID | TABLE_ID | ROW_COUNT | START_TIME | END_TIME | STATE | QUERY |
±-------±-----------------±------------------------±---------------±-------------±----------±---------±----------±--------------------±--------------------±-------±---------------------------------------+
| 29934 | yixintui_operate | material_creative_count | truncate table | public | 1382 | 29909 | 0 | 2021-11-30 12:11:12 | 2021-11-30 12:11:12 | synced | truncate table Material_creative_count |

(user:tidbdba time: 14:53)[db: yixintui_operate] select * from information_schema.DDL_JOBS where table_id=29944 limit 10000;
±-------±-----------------±------------------------±---------------±-------------±----------±---------±----------±--------------------±--------------------±-------±---------------------------------------+
| JOB_ID | DB_NAME | TABLE_NAME | JOB_TYPE | SCHEMA_STATE | SCHEMA_ID | TABLE_ID | ROW_COUNT | START_TIME | END_TIME | STATE | QUERY |
±-------±-----------------±------------------------±---------------±-------------±----------±---------±----------±--------------------±--------------------±-------±---------------------------------------+
| 29949 | yixintui_operate | material_creative_count | truncate table | public | 1382 | 29944 | 0 | 2021-11-30 17:11:10 | 2021-11-30 17:11:11 | synced | truncate table Material_creative_count |

(user:tidbdba time: 14:53)[db: yixintui_operate] select * from information_schema.DDL_JOBS where table_id=37467 limit 10000;
±-------±-----------------±------------------------±---------------±-------------±----------±---------±----------±--------------------±--------------------±-------±---------------------------------------+
| JOB_ID | DB_NAME | TABLE_NAME | JOB_TYPE | SCHEMA_STATE | SCHEMA_ID | TABLE_ID | ROW_COUNT | START_TIME | END_TIME | STATE | QUERY |
±-------±-----------------±------------------------±---------------±-------------±----------±---------±----------±--------------------±--------------------±-------±---------------------------------------+
| 37494 | yixintui_operate | material_creative_count | truncate table | public | 1382 | 37467 | 0 | 2021-12-15 11:11:18 | 2021-12-15 11:11:18 | synced | truncate table Material_creative_count |