zone status not match

OceanBase 技术问题
#1

MySQL [oceanbase]> alter system add zone zone4;

ERROR 4017 (HY000): Entry already exist

MySQL [oceanbase]> alter system delete zone zone4;

ERROR 4633 (HY000): zone status not match

MySQL [oceanbase]> alter system delete zone ‘zone4’;

ERROR 4633 (HY000): zone status not match

#2

有做过什么操作吗？是否修改过zone的name属性导致？

#3


你好，做过下面的操作：

alter system delete server '10.11.253.40:6882' zone zone5;

alter system delete server '10.11.253.40:5882' zone zone4;

alter system delete zone 'zone5';

alter system delete zone 'zone4';

#4

我也遇到了同样的问题，不过我发现是我启用了zone，所以不能删除
可以通过
select * from oceanbase.dba_ob_zones;
查看zone的status是不是active状态，如果是需要先
alter system disables zone ‘zonex’ ;
后再删除就可以了