[Bug] [k8s app] submit job with k8s app ha mode,flink have the same jobid,submit and cancle job throw error

[zhengtingxue]

Search before asking

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

What happened

submit job with k8s app ha mode,flink have the same jobid,like 0000000006924de00000000000000000;submit job throw error "Duplicate entry 'test20000000006924de00000000000000000-1' for key 'cluster_un_idx1'" when the old flink instance still exists,and cancle job throw error "Expected one result (or null) to be returned by selectOne(), but found: 5" because of the same id;

What you expected to happen

submit job and cancle job work well

How to reproduce

submit job with k8s app ha mode,

Anything else

No response

Version

1.0.0

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

[github-actions]

Hello @zhengtingxue, this issue is about K8S, so I assign it to @gaoyan1998 and @zackyoungh. If you have any questions, you can comment and reply.

你好 @zhengtingxue, 这个 issue 是关于 K8S 的，所以我把它分配给了 @gaoyan1998 和 @zackyoungh。如有任何问题，可以评论回复。

[gaoyan1998]

mysql表内可以试着取消name唯一约束，这个不影响任务，后续会修复此问题

[github-actions]

Hello @, this issue has not been active for more than 30 days. This issue will be closed in 7 days if there is no response. If you have any questions, you can comment and reply.

你好 @, 这个 issue 30 天内没有活跃，7 天后将关闭，如需回复，可以评论回复。