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

[Ariznawlll]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

Ariznawlll

Commit ID

3742636

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]

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]

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

[ck89119]

在看

[sukki37]

repro:
https://github.com/matrixorigin/matrixone/actions/runs/9469713064/job/26089622933
https://github.com/matrixorigin/matrixone/actions/runs/9467497510/job/26082346834

[ck89119]

看行为和 #16273 类似，待补充日志确认

[YANGGMM]

repo in https://github.com/matrixorigin/ci-test/actions/runs/10071881088

[ck89119]

存储同事说mo_database/tables/columns 3张表做过一次大的重构，先转测试继续观察有没有复现

[Ariznawlll]

main上观察了下，没再出现

[matrix-meow]

Hello @Ariznawlll. The bug issue in the BVT test code has not been removed,issues automatically open.

[Ariznawlll]

1.2-dev还存在这个问题，继续跟进。

[triump2020]

@Ariznawlll 有比较稳定的复现方式么？好像不是必现的问题.

[triump2020]

Not working on this.

[triump2020]

Working on other S-1 issue.

[triump2020]

Not working on this .

[triump2020]

Being try to reproduce it.

[triump2020]

No repro.

[triump2020]

No repro.

[triump2020]

No repro.

[Ariznawlll]

这个问题main上没有了，1.2-dev还有

[triump2020]

@Ariznawlll Could u pls close it ? since it hasn't reproduced on main branch.

[Ariznawlll]

1.2-dev的tag没去，没办法关闭

[Ariznawlll]

1.2-dev的tag没去，没办法关闭，降级到s1跟踪