ocp 接管集群失败

OceanBase
, ,
#1

【 使用环境 】测试环境
【 OB or 其他组件 】 observer 3.2.4；ocp 334
【 使用版本 】
【问题描述】

通过ocp平台接管已经创建集群的时候，报错：

image
image2164×1066 185 KB

【复现路径】问题出现前后相关操作
【问题现象及影响】

【附件】

#3

如下是目标端observer的情况：
[admin@OceanBase1 ~]$ obclient -h172.20.22.107 -uroot@sys -P2881 -c -A oceanbase -p
Enter password:
ERROR 1045 (42000): Access denied for user ‘root’@‘xxx.xxx.xxx.xxx’ (using password: YES)
[admin@OceanBase1 ~]$ obclient -h172.20.22.107 -uroot@sys -P2881 -c -A oceanbase -p
Enter password:
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221505116
Server version: OceanBase 3.2.4.1 (r101000052023010822-346aa35c32e99d1b82d713f75f0072c45bdf7aab) (Built Jan 8 2023 22:52:43)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

obclient [oceanbase]> select * from __all_zone where name in (‘idc’,‘region’);
±---------------------------±---------------------------±------±-------±------±----------+
| gmt_create | gmt_modified | zone | name | value | info |
±---------------------------±---------------------------±------±-------±------±----------+
| 2023-06-27 18:47:10.804261 | 2023-06-30 23:23:50.237916 | zone1 | idc | 0 | changhong |
| 2023-06-27 18:47:10.804261 | 2023-06-30 23:23:50.236839 | zone1 | region | 0 | obdemo |
| 2023-06-27 18:47:10.807515 | 2023-06-30 23:23:50.302358 | zone2 | idc | 0 | changhong |
| 2023-06-27 18:47:10.807515 | 2023-06-30 23:23:50.301307 | zone2 | region | 0 | obdemo |
| 2023-06-27 18:47:10.810765 | 2023-06-30 23:23:51.026202 | zone3 | idc | 0 | changhong |
| 2023-06-27 18:47:10.810765 | 2023-06-30 23:23:51.025067 | zone3 | region | 0 | obdemo |
±---------------------------±---------------------------±------±-------±------±----------+
6 rows in set (0.008 sec)

#4

OB 集群节点变更机房属性 - 社区问答- OceanBase社区-分布式数据库

1 个赞
#5

在目标端observer集群手工变更后似乎也不行。

obclient [oceanbase]> ALTER SYSTEM ALTER ZONE zone1 SET REGION=‘chengdou’,IDC=‘changhong’;
ALTER SYSTEM ALTER ZONE zone2 SET REGION=‘chengdou’,IDC=‘changhong’;
ALTER SYSTEM ALTER ZONE zone3 SET REGION=‘chengdou’,IDC=‘changhong’;
Query OK, 0 rows affected (0.011 sec)

obclient [oceanbase]> ALTER SYSTEM ALTER ZONE zone2 SET REGION=‘chengdou’,IDC=‘changhong’;
Query OK, 0 rows affected (0.009 sec)

obclient [oceanbase]> ALTER SYSTEM ALTER ZONE zone3 SET REGION=‘chengdou’,IDC=‘changhong’;
Query OK, 0 rows affected (0.008 sec)

obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]>

#6

已解决，无需回复了。谢谢。