canal.admin-1.1.6创建同名Instance报Error[Duplicate entry 'Instancename' for key 'name_UNIQUE'] - Githubissues

alibaba / canal

阿里巴巴 MySQL binlog 增量订阅&消费组件

Apache License 2.0

28.44k stars 7.6k forks source link

canal.admin-1.1.6创建同名Instance报Error[Duplicate entry 'Instancename' for key 'name_UNIQUE'] #5163

Open DK-dzz opened 4 months ago

DK-dzz commented 4 months ago

[ ] I have searched the issues of this repository and believe that this is not a duplicate.
[ ] I have checked the FAQ of this repository and believe that this is not a duplicate.

environment

canal.admin-1.1.6
canal.deployer-1.1.6
mysql-5.7.41-linux-glibc2.12-x86_64

Issue Description

Instance 管理，在不同'集群'内，各创建一个同名的Instance，会提示 Error[Duplicate entry 'Instancename' for key 'name_UNIQUE']

Steps to reproduce

ms_financial_app_data

name_UNIQUE2

bugsql

name_UNIQUE

Expected behaviour

SUCCESS

Actual behaviour

Error[Duplicate entry 'Instancename' for key 'name_UNIQUE']

If there is an exception, please attach the exception trace:

<img width="765" alt="bugsql" src="https://github.com/alibaba/canal/assets/45681331/594c98ed-7d5b-4aec-813a-0464f75fa17b">

agapple commented 3 months ago

之前设计上要求全局唯一，避免instance在多集群简切换