Using CDCSOURCE mysql to synchronize to doris reports an error Cannot deserialize value of type `int` from Strin

[wolfewf]

Search before asking

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

What happened

2024-06-12 09:56:46.073 ERROR org.apache.doris.flink.sink.DorisSink(594): Doris FE's response cannot map to schema. res: "errCode=7,detailMessage=unknowntable,tableName=test" org.apache.doris.shaded.com.fasterxml.jackson.databind.exc.InvalidFormatException: Cannot deserialize value of type int from String "errCode=7,detailMessage=unknowntable,tableName=test": not a valid int value

What you expected to happen

2024-06-12 09:56:46.073 ERROR org.apache.doris.flink.sink.DorisSink(594): Doris FE's response cannot map to schema. res: "errCode=7,detailMessage=unknowntable,tableName=test" org.apache.doris.shaded.com.fasterxml.jackson.databind.exc.InvalidFormatException: Cannot deserialize value of type int from String "errCode=7,detailMessage=unknowntable,tableName=test": not a valid int value

How to reproduce

2024-06-12 09:56:46.073 ERROR org.apache.doris.flink.sink.DorisSink(594): Doris FE's response cannot map to schema. res: "errCode=7,detailMessage=unknowntable,tableName=test" org.apache.doris.shaded.com.fasterxml.jackson.databind.exc.InvalidFormatException: Cannot deserialize value of type int from String "errCode=7,detailMessage=unknowntable,tableName=test": not a valid int value

Anything else

No response

Version

1.0.2

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

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

[github-actions[bot]]

Hello @wolfewf, this issue is about CDC/CDCSOURCE, so I assign it to @aiwenmo. If you have any questions, you can comment and reply.

你好 @wolfewf, 这个 issue 是关于 CDC/CDCSOURCE 的，所以我把它分配给了 @aiwenmo。如有任何问题，可以评论回复。

[wolfewf]

@aiwenmo 这个问题有解决吗

[suxinshuo]

@aiwenmo 这个问题有解决吗

@wolfewf mysql 和 doris 的版本是多少，表的结构大概什么样，可以脱敏一下，我想要试试复现一下

[github-actions[bot]]

Hello @wolfewf, we need you to provide reproduction steps so that we can help you troubleshoot the problem. Issues are marked `Need Reproduce`.

你好 @wolfewf, 我们需要你提供复现步骤以便于我们帮你排查问题，Issues 标注为 `Need Reproduce` 。

[aiwenmo]

Use Dinky 1.0.3