【 使用环境 】测试环境
【 OB or 其他组件 】OB 及 OCP
【 使用版本 】ceanbase-ce-4.4.1.0
【问题描述】
OB 集群有3个zone, 每个zone有一个OBServer，zone1不可用、zone1中的OBServer也不可用。
请问如果修复?
obclient(root@sys)[oceanbase]> SELECT
-> TENANT_ID,
-> TENANT_NAME,
-> TENANT_TYPE,
-> PRIMARY_ZONE,
-> LOCALITY,
-> COMPATIBILITY_MODE,
-> STATUS,
-> LOCKED,
-> TENANT_ROLE,
-> LOG_MODE,
-> UNIT_NUM,
-> COMPATIBLE
-> FROM DBA_OB_TENANTS;
+-----------+-------------+-------------+--------------+---------------------------------------------+--------------------+--------+--------+-------------+--------------+----------+------------+
| TENANT_ID | TENANT_NAME | TENANT_TYPE | PRIMARY_ZONE | LOCALITY | COMPATIBILITY_MODE | STATUS | LOCKED | TENANT_ROLE | LOG_MODE | UNIT_NUM | COMPATIBLE |
+-----------+-------------+-------------+--------------+---------------------------------------------+--------------------+--------+--------+-------------+--------------+----------+------------+
| 1 | sys | SYS | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | MYSQL | NORMAL | NO | PRIMARY | NOARCHIVELOG | 1 | 4.4.1.0 |
| 1001 | META$1002 | META | RANDOM | FULL{1}@zone2, FULL{1}@zone3 | MYSQL | NORMAL | NO | PRIMARY | NOARCHIVELOG | 1 | 4.4.1.0 |
| 1002 | testdb | USER | RANDOM | FULL{1}@zone2, FULL{1}@zone3 | MYSQL | NORMAL | NO | PRIMARY | NOARCHIVELOG | 1 | 4.4.1.0 |
+-----------+-------------+-------------+--------------+---------------------------------------------+--------------------+--------+--------+-------------+--------------+----------+------------+
3 rows in set (0.157 sec)
obclient(root@sys)[oceanbase]> select * from dba_ob_zones;
+-------+----------------------------+----------------------------+----------+-------------+---------------+-----------+
| ZONE | CREATE_TIME | MODIFY_TIME | STATUS | IDC | REGION | TYPE |
+-------+----------------------------+----------------------------+----------+-------------+---------------+-----------+
| zone1 | 2025-11-24 18:57:28.929224 | 2026-01-15 09:06:47.471260 | INACTIVE | default_idc | deault_region | ReadWrite |
| zone2 | 2025-11-24 18:57:28.930257 | 2025-11-24 18:57:51.498694 | ACTIVE | default_idc | deault_region | ReadWrite |
| zone3 | 2025-11-24 18:57:28.930257 | 2025-11-24 18:57:51.510357 | ACTIVE | default_idc | deault_region | ReadWrite |
+-------+----------------------------+----------------------------+----------+-------------+---------------+-----------+
3 rows in set (0.024 sec)
obclient(root@sys)[oceanbase]> select * from dba_ob_servers;
+--------------+----------+------+-------+----------+-----------------+----------+----------------------------+----------------------------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+----------------------------+
| SVR_IP | SVR_PORT | ID | ZONE | SQL_PORT | WITH_ROOTSERVER | STATUS | START_SERVICE_TIME | STOP_TIME | BLOCK_MIGRATE_IN_TIME | CREATE_TIME | MODIFY_TIME | BUILD_VERSION | LAST_OFFLINE_TIME |
+--------------+----------+------+-------+----------+-----------------+----------+----------------------------+----------------------------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+----------------------------+
| 10.100.0.136 | 2882 | 2 | zone2 | 2881 | NO | ACTIVE | 2025-11-24 19:01:05.644914 | NULL | NULL | 2025-11-24 18:57:29.837549 | 2025-11-24 19:01:07.396673 | 4.4.1.0_100000032025101610-70824e90816ed333c56f3dd1af34ffec43d0fa88(Oct 16 2025 10:13:47) | NULL |
| 10.100.0.154 | 2882 | 1 | zone1 | 2881 | NO | INACTIVE | NULL | 2026-01-01 01:33:49.490554 | NULL | 2025-11-24 18:57:29.821977 | 2026-01-14 19:11:36.885995 | 4.4.1.0_100000032025101610-70824e90816ed333c56f3dd1af34ffec43d0fa88(Oct 16 2025 10:13:47) | 2026-01-14 19:11:36.883075 |
| 10.100.0.71 | 2882 | 3 | zone3 | 2881 | YES | ACTIVE | 2025-11-24 19:01:03.522323 | NULL | NULL | 2025-11-24 18:57:29.852415 | 2025-11-24 19:01:05.376291 | 4.4.1.0_100000032025101610-70824e90816ed333c56f3dd1af34ffec43d0fa88(Oct 16 2025 10:13:47) | NULL |
+--------------+----------+------+-------+----------+-----------------+----------+----------------------------+----------------------------+-----------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+----------------------------+
3 rows in set (0.008 sec)