[Bug]: SQL parser error: table \"__mo_index_unique_0192748f-6868-7182-a6de-2e457c2975c6\" does not exist error is returned when running SQL

[DanielZhangQD]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

main

Commit ID

v2.0.0-e08947032-2024-10-09

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

The SQL is executed in account 01927400-16b3-7d3a-b47b-7e405633af0f but returns the following error:

"error":"Error 1064 (HY000): SQL parser error: table \"__mo_index_unique_0192748c-a33a-756d-a04a-92998a6be15d\" does not exist","elapsed":"30.138120565s","rows":0,"sql":"ALTER TABLE `billing_records` MODIFY COLUMN `account_period` varchar(32)"

The application log: https://grafana.cn-dev.matrixone.tech/goto/J7QXHCkNg?orgId=1
The MO log: https://grafana.cn-dev.matrixone.tech/goto/oURjNCkHR?orgId=1

Expected Behavior

SQL succeeds

Steps to Reproduce

See detail in Actual Behavior

Additional information

Cloud dev env

[qingxinhome]

got it

[DanielZhangQD]

The same error is reported continuously in cloud env https://grafana.cn-dev.matrixone.tech/goto/xsuCkxiHg?orgId=1

[qingxinhome]

本地使用gorm程序验证没有复现，持续关注

[qingxinhome]

未复现，本地测试gorm程序能够成功

[qingxinhome]

等待韩枫侧对Relation()接口进行优化

[qingxinhome]

等待韩枫侧对Relation()接口进行优化

[daviszhen]

等hf优化后，再调整代码。2.0.1来不及

[aptend]

处理其它bug中

[qingxinhome]

#20194

[aptend]

pr #20145

[qingxinhome]

The issue has been resolved, please verify and test

[qingxinhome]

2.0.1 QA升级演练时该问题再次出现：
2.0-dev：64e4751dc61602fcdea39eb91247965e3111a172

alter table 报错："SQL parser error: table "__mo_index_secondary_0193b017-3039-759e-8505-f11f4e53838a" does not exist",
日志链接：
https://grafana.cn-qa.matrixone.tech/explore?panes=%7B%22gKl%22:%7B%22datasource%22:%22eb02ea9d-9b26-4289-89ed-4123679bdbe6%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bpod%3D%5C%22freetier-01-s2-6475fc8dcb-cn-6m5nq%5C%22%7D%20%7C%3D%20%60ERROR%60%20%7C%3D%20%60does%20not%20exist%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22eb02ea9d-9b26-4289-89ed-4123679bdbe6%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%221733824800000%22,%22to%22:%221733835599000%22%7D%7D%7D&schemaVersion=1&orgId=1

https://grafana.cn-qa.matrixone.tech/explore?panes=%7B%22gKl%22:%7B%22datasource%22:%22eb02ea9d-9b26-4289-89ed-4123679bdbe6%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bpod%3D%5C%22freetier-01-s2-6475fc8dcb-cn-6m5nq%5C%22%7D%20%7C%3D%20%601cc219936ee29d71180fc63932de007f%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22eb02ea9d-9b26-4289-89ed-4123679bdbe6%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%221733824800000%22,%22to%22:%221733835599000%22%7D%7D%7D&schemaVersion=1&orgId=1

[qingxinhome]

问题原因发生在对目标表的索引表加锁时，无法获取索引表的relation造成：

https://grafana.cn-dev.matrixone.tech/explore?panes=%7B%22jhC%22:%7B%22datasource%22:%22cbb7c841-137c-4165-b7c9-61d57c8ff571%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bmatrixorigin_io_component%3D%5C%22CNSet%5C%22,%20pod%3D%5C%22debug-cn-fbt4h%5C%22%7D%20%7C%3D%20%60ERROR%60%20%7C%3D%20%60__mo_index_unique_0193ce53-5681-7802-b19b-09482e40e3eb%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22cbb7c841-137c-4165-b7c9-61d57c8ff571%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%22now-1h%22,%22to%22:%22now%22%7D%7D%7D&schemaVersion=1&orgId=1