[Bug] MaterializationSinkOperatorX failed to find rpc_struct

[abcCL]

Search before asking

• I had searched in the issues and found no similar issues.

Version

4.0.4

建立的 doris catalog 是 4.0.3 版本

What's Wrong?

sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1105, 'errCode = 2, detailMessage = ()[INTERNAL_ERROR]MaterializationSinkOperatorX failed to find rpc_struct, backend_id=13389')

[SQL: WITH logical_rows AS (SELECT statistic_period AS statistic_period,region AS region,score_system AS score_system,indicator_name AS indicator_name,indicator_value AS indicator_value,0 AS __query_deleted FROM foil_external_doris_catalog_1457647042849792.test_foil.bj_finance_statistic_data) SELECT statistic_period,region,score_system,indicator_name,indicator_value FROM logical_rows WHERE __query_deleted = 0 ORDER BY indicator_name ASC LIMIT %s OFFSET %s]

[parameters: (10, 0)]

What You Expected?

正常查询 不报错

How to Reproduce?

构建了一个 doris catalog

WITH logical_rows AS (SELECT statistic_period AS statistic_period,
region AS region,
score_system AS score_system,
indicator_name AS indicator_name,
indicator_value AS indicator_value,
0 AS __query_deleted
FROM foil_external_doris_catalog_1457647042849792.test_foil.bj_finance_statistic_data)
SELECT statistic_period, region, score_system, indicator_name, indicator_value
FROM logical_rows
WHERE __query_deleted = 0
ORDER BY indicator_name ASC;

去掉 order by 后可以查询成功

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct