[BEGIN] 2025/5/8 14:22:36 13 | st2-ob01-ate-obproxy01_128.121 | 192.168.128.121 | 14 | st2-ob01-clr-obproxy02_128.128 | 192.168.128.128 | 15 | st2-ob01-intfc-obproxy01_128.131 | 192.168.128.131 | 16 | st2-ob01-little-obproxy01_128.119 | 192.168.128.119 | 17 | st2-ob01-little-obproxy02_128.120 | 192.168.128.120 | 18 | st2-ob01-mrs-obproxy01_128.115 | 192.168.128.115 | 19 | st2-ob01-rmdm-obproxy02_128.110 | 192.168.128.110 | 20 | st2-ob01-saturn-obproxy02_128.108 | 192.168.128.108 | 21 | st2-ob01-vas-obproxy01_128.129 | 192.168.128.129 | 22 | st2-ob02-app-obproxy01_180.101(cloud) | 192.168.180.101 | 23 | st2-ob02-clr-obproxy01_180.110(cloud) | 192.168.180.110 | 24 | st2-ob02-cpd-obproxy01_180.116(cloud) | 192.168.180.116 | 25 | st2-ob02-hat-obproxy01_180.117(cloud) | 192.168.180.117 | 26 | st2-ob02-little-obproxy01_180.109(cloud) | 192.168.180.109 | 27 | st2-ob02-pss-obproxy01_180.104(cloud) | 192.168.180.104 | 28 | st2-ob02-rmdm-obproxy01_180.108(cloud) | 192.168.180.108 | 29 | st2-ob02-saturn-obproxy01_180.105(cloud) | 192.168.180.105 | 页码：1，每页行数：29，总页数：3，总数量：73 提示：输入资产ID直接登录，二级搜索使用 // + 字段，如：//192 上一页：b 下一页：n 搜索：obpro [Host]> 22 开始连接到 Linux系统用户-sysusr@192.168.180.101 0.1 Register this system with Red Hat Insights: insights-client --register Create an account or view all your systems at https://red.ht/insights-dashboard Last login: Thu May 8 11:20:12 2025 from 192.168.25.67 [14:21:40 sysusr@st2-ob02-app-obproxy01 ~](cloud)$ sudo su - admin Last login: Thu May 8 11:20:14 CST 2025 on pts/0 [14:21:43 admin@st2-ob02-app-obproxy01 ~](cloud)$ ll total 16 -rwxrwxr-x 1 admin admin 380 Feb 7 10:57 login-root@dev_fsc#st2_ob02.sh -rwxrwxr-x 1 admin admin 379 Feb 12 14:22 login-root@sb_fsc#st2_ob02.sh -rwxrwxr-x 1 admin admin 380 Feb 12 14:21 login-root@st2_fsc#st2_ob02.sh -rwxrwxr-x 1 admin admin 376 Jan 9 11:44 login-root@sys#st2_ob02.sh drwxr-xr-x 13 root root 171 Dec 19 14:23 ocp_agent drwxrwxr-x 2 admin admin 87 Dec 31 11:08 soft [14:21:44 admin@st2-ob02-app-obproxy01 ~](cloud)$ ./login-root@sys#st2_ob02.sh obclient -h192.168.180.101 -P2810 -uroot@sys#st2_ob02 -p -cA oceanbase --prompt="root@sys(#st2_ob02) [\d]> " Welcome to the OceanBase. Commands end with ; or \g. Your OceanBase connection id is 7984942 Server version: OceanBase_CE 4.2.5.1 (r101000092024120918-6388bc0561faecba5f75a662c6e11c3dd0598de9) (Built Dec 9 2024 18:57:58) 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. root@sys(#st2_ob02) [oceanbase]> root@sys(#st2_ob02) [oceanbase]> root@sys(#st2_ob02) [oceanbase]> root@sys(#st2_ob02) [oceanbase]> select * from __all_server where svr_ip = '192.168.180.31'; +----------------------------+----------------------------+----------------+----------+------+--------+------------+-----------------+----------+-----------------------+-------------------------------------------------------------------------------------------+-----------+--------------------+--------------+----------------+-------------------+ | gmt_create | gmt_modified | svr_ip | svr_port | id | zone | inner_port | with_rootserver | status | block_migrate_in_time | build_version | stop_time | start_service_time | first_sessid | with_partition | last_offline_time | +----------------------------+----------------------------+----------------+----------+------+--------+------------+-----------------+----------+-----------------------+-------------------------------------------------------------------------------------------+-----------+--------------------+--------------+----------------+-------------------+ | 2025-01-01 16:39:49.594324 | 2025-05-08 10:22:14.471613 | 192.168.180.31 | 2882 | 1 | zone01 | 2881 | 0 | DELETING | 0 | 4.2.5.1_101000092024120918-6388bc0561faecba5f75a662c6e11c3dd0598de9(Dec 9 2024 18:57:58) | 0 | 1746670934169892 | 0 | 1 | 0 | +----------------------------+----------------------------+----------------+----------+------+--------+------------+-----------------+----------+-----------------------+-------------------------------------------------------------------------------------------+-----------+--------------------+--------------+----------------+-------------------+ 1 row in set (0.013 sec) root@sys(#st2_ob02) [oceanbase]> select * from __all_rootservice_job where job_type = 'DELETE_SERVER'; +----------------------------+----------------------------+--------+---------------+------------+-------------+----------+-----------+-------------+-------------+---------------+----------+------------+--------------+----------------+----------+---------+----------------+-------------+----------+------------+------------------+---------------+-----------------+ | gmt_create | gmt_modified | job_id | job_type | job_status | result_code | progress | tenant_id | tenant_name | database_id | database_name | table_id | table_name | partition_id | svr_ip | svr_port | unit_id | rs_svr_ip | rs_svr_port | sql_text | extra_info | resource_pool_id | tablegroup_id | tablegroup_name | +----------------------------+----------------------------+--------+---------------+------------+-------------+----------+-----------+-------------+-------------+---------------+----------+------------+--------------+----------------+----------+---------+----------------+-------------+----------+------------+------------------+---------------+-----------------+ | 2025-05-07 15:56:40.409757 | 2025-05-07 15:56:40.409757 | 26 | DELETE_SERVER | INPROGRESS | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 192.168.180.31 | 2882 | NULL | 192.168.180.32 | 2882 | NULL | NULL | NULL | NULL | NULL | +----------------------------+----------------------------+--------+---------------+------------+-------------+----------+-----------+-------------+-------------+---------------+----------+------------+--------------+----------------+----------+---------+----------------+-------------+----------+------------+------------------+---------------+-----------------+ 1 row in set (0.032 sec) root@sys(#st2_ob02) [oceanbase]> select tenant_id,count(1) from __all_virtual_meta_table where svr_ip = '192.168.180.31' group by 1; ERROR 1146 (42S02): Table 'oceanbase.__all_virtual_meta_table' doesn't exist root@sys(#st2_ob02) [oceanbase]> select * from __all_unit where svr_ip = '192.168.180.31'; Empty set (0.011 sec) [END] 2025/5/8 14:25:10