还一个问题,修改他是删除对应unit副本吗?
1 个赞
删掉sys ocp_meta zt_data三个的。是的
1 个赞
学习一下
我删掉了为什么还是不能移出节点?ERROR 4734 (HY000): can not migrate out unit ‘3’, no other available servers on zone ‘zhutang03’, delete server not allowed
该zone的租户资源池也需要删掉
在哪查询?
学习了
参考这篇文档
SELECT * FROM oceanbase.DBA_OB_RESOURCE_POOLS\G
https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000003379709
*************************** 1. row ***************************
RESOURCE_POOL_ID: 1
NAME: sys_pool
TENANT_ID: 1
CREATE_TIME: 2025-03-07 11:19:16.261093
MODIFY_TIME: 2025-03-07 11:19:16.271448
UNIT_COUNT: 1
UNIT_CONFIG_ID: 1
ZONE_LIST: zhutang01;zhutang02;zhutang03
REPLICA_TYPE: FULL
*************************** 2. row ***************************
RESOURCE_POOL_ID: 1001
NAME: ocp_meta_pool
TENANT_ID: 1002
CREATE_TIME: 2025-03-07 14:19:56.760952
MODIFY_TIME: 2025-03-07 14:19:56.820129
UNIT_COUNT: 1
UNIT_CONFIG_ID: 1001
ZONE_LIST: zhutang02;zhutang01;zhutang03
REPLICA_TYPE: FULL
*************************** 3. row ***************************
RESOURCE_POOL_ID: 1002
NAME: pool_zt_data_zhutang02_dpa
TENANT_ID: 1004
CREATE_TIME: 2025-03-07 14:26:46.346035
MODIFY_TIME: 2025-03-07 14:26:46.494943
UNIT_COUNT: 1
UNIT_CONFIG_ID: 1002
ZONE_LIST: zhutang02
REPLICA_TYPE: FULL
*************************** 4. row ***************************
RESOURCE_POOL_ID: 1003
NAME: pool_zt_data_zhutang01_zdd
TENANT_ID: 1004
CREATE_TIME: 2025-03-07 14:26:46.356744
MODIFY_TIME: 2025-03-07 14:26:46.493878
UNIT_COUNT: 1
UNIT_CONFIG_ID: 1004
ZONE_LIST: zhutang01
REPLICA_TYPE: FULL
*************************** 5. row ***************************
RESOURCE_POOL_ID: 1004
NAME: pool_zt_data_zhutang03_lna
TENANT_ID: 1004
CREATE_TIME: 2025-03-07 14:26:46.365319
MODIFY_TIME: 2025-03-07 14:26:47.060427
UNIT_COUNT: 1
UNIT_CONFIG_ID: 1003
ZONE_LIST: zhutang03
REPLICA_TYPE: FULL
*************************** 6. row ***************************
RESOURCE_POOL_ID: 1005
NAME: ocp_monitor_pool
TENANT_ID: 1006
CREATE_TIME: 2025-09-12 10:09:56.362596
MODIFY_TIME: 2025-09-12 10:09:56.909902
UNIT_COUNT: 1
UNIT_CONFIG_ID: 1005
ZONE_LIST: zhutang02;zhutang01
REPLICA_TYPE: FULL
有zhutang03的全部修改掉?
是的
1 个赞