[Bug]: restore report 'cannot find table by id ****' in ci bvt test.

Ariznawlll commented 3 months ago

Is there an existing issue for the same bug?

[X] I have checked the existing issues.

Branch Name

Ariznawlll

Commit ID

3742636dbdb989d0200d544a68409b0ce0fa0b70

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

job url:https://github.com/matrixorigin/matrixone/actions/runs/9394784752/job/25873053572?pr=16700

log: Standalone-Multi-CN-e2e-BVT-Test-on-Linux-x64(LAUNCH,PROXY)-reports (1).zip

Expected Behavior

No response

Steps to Reproduce

trigger ci test

Additional information

No response

YANGGMM commented 3 months ago

2024/06/06 04:00:04.913839 +0000 INFO cn-service.frontend frontend/snapshot.go:422 start to drop cur fk tables {"uuid": "dd1dccb0-4d3c-41f8-b482-5251dc7a41bf"} 2024/06/06 04:00:04.914159 +0000 INFO cn-service.frontend frontend/snapshot.go:1005 [] start to get table info: pri01 {"uuid": "dd1dccb0-4d3c-41f8-b482-5251dc7a41bf"} 2024/06/06 04:00:04.914192 +0000 INFO cn-service.frontend frontend/snapshot.go:986 [] get table pri01 info sql: show full tables from acc_test02 like 'pri01' {"uuid": "dd1dccb0-4d3c-41f8-b482-5251dc7a41bf"} 2024/06/06 04:00:04.936220 +0000 INFO cn-service.frontend frontend/snapshot.go:1005 [] start to get table info: aff01 {"uuid": "dd1dccb0-4d3c-41f8-b482-5251dc7a41bf"} 2024/06/06 04:00:04.936285 +0000 INFO cn-service.frontend frontend/snapshot.go:986 [] get table aff01 info sql: show full tables from acc_test02 like 'aff01' {"uuid": "dd1dccb0-4d3c-41f8-b482-5251dc7a41bf"} 2024/06/06 04:00:04.948020 +0000 INFO cn-service.frontend frontend/snapshot.go:441 start to drop table: aff01 {"uuid": "dd1dccb0-4d3c-41f8-b482-5251dc7a41bf"} 2024/06/06 04:00:04.950014 +0000 INFO compile/sql_executor.go:354 sql_executor exec {"sql": "delete from mo_catalog.mo_foreign_keys where db_name = 'acc_test02' and table_name = 'aff01'", "txn-id": "018febb42d317c90972aa35367affa2a", "duration": "1.295017ms", "AffectedRows": 1} 2024/06/06 04:00:04.950247 +0000 ERROR disttae/engine.go:482 error: internal error: can not find table by id 290686: accountId: 101 {"span": {"trace_id": "5183a800-3c4b-232a-0322-25907d0a2622", "span_id": "fa6cc86fed0dd375"}}

@ck89119 麻烦看一下

YANGGMM commented 3 months ago

repro ：https://github.com/matrixorigin/matrixone/actions/runs/9396513189/job/25878290399