【 使用环境 】测试环境
【 OB or 其他组件 】OB
【 使用版本 】4.3.0
【问题描述】OB 操作删除节点后，从dba_ob_servers已经看不到删除的节点，但从服务器上看observer的进程还在
【复现路径】
1.执行删除节点的操作
obclient [oceanbase]> ALTER SYSTEM DELETE SERVER “10.0.22.11:2882” zone=‘zone1’;
Query OK, 0 rows affected (0.221 sec)
2.查看节点状态
obclient [oceanbase]> select SVR_IP,ZONE,WITH_ROOTSERVER,STATUS,START_SERVICE_TIME,STOP_TIME from dba_ob_servers;
±-----------±------±----------------±---------±---------------------------±----------+
| SVR_IP | ZONE | WITH_ROOTSERVER | STATUS | START_SERVICE_TIME | STOP_TIME |
±-----------±------±----------------±---------±---------------------------±----------+
| 10.0.22.11 | zone1 | NO | DELETING | 2024-05-21 15:51:46.648650 | NULL |
| 10.0.22.12 | zone2 | YES | ACTIVE | 2024-05-21 15:51:46.789412 | NULL |
| 10.0.22.13 | zone3 | NO | ACTIVE | 2024-05-23 15:40:13.186066 | NULL |
| 10.0.22.30 | zone1 | NO | ACTIVE | 2024-05-23 17:32:42.309396 | NULL |
±-----------±------±----------------±---------±---------------------------±----------+
4 rows in set (0.002 sec)
3.多次查看后
obclient [oceanbase]> select SVR_IP,ZONE,WITH_ROOTSERVER,STATUS,START_SERVICE_TIME,STOP_TIME from dba_ob_servers;
±-----------±------±----------------±-------±---------------------------±----------+
| SVR_IP | ZONE | WITH_ROOTSERVER | STATUS | START_SERVICE_TIME | STOP_TIME |
±-----------±------±----------------±-------±---------------------------±----------+
| 10.0.22.12 | zone2 | YES | ACTIVE | 2024-05-21 15:51:46.789412 | NULL |
| 10.0.22.13 | zone3 | NO | ACTIVE | 2024-05-23 15:40:13.186066 | NULL |
| 10.0.22.30 | zone1 | NO | ACTIVE | 2024-05-23 17:32:42.309396 | NULL |
±-----------±------±----------------±-------±---------------------------±----------+
3 rows in set (0.002 sec)
4.登录删除节点的服务，执行netstat
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接（右键跳转查看）：