【 使用环境 】测试环境
【 OB or 其他组件 】 observer 3.2.4;ocp 334
【 使用版本 】
【问题描述】
通过ocp平台接管已经创建集群的时候,报错:
【复现路径】问题出现前后相关操作
【问题现象及影响】
【附件】
【 使用环境 】测试环境
【 OB or 其他组件 】 observer 3.2.4;ocp 334
【 使用版本 】
【问题描述】
通过ocp平台接管已经创建集群的时候,报错:
【复现路径】问题出现前后相关操作
【问题现象及影响】
【附件】
如下是目标端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)
在目标端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]>
已解决,无需回复了。谢谢。