MySQL [oceanbase]> SELECT * FROM oceanbase.CDB_OB_MAJOR_COMPACTION; +-----------+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+------------+----------+--------------+------+ | TENANT_ID | FROZEN_SCN | FROZEN_TIME | GLOBAL_BROADCAST_SCN | LAST_SCN | LAST_FINISH_TIME | START_TIME | STATUS | IS_ERROR | IS_SUSPENDED | INFO | +-----------+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+------------+----------+--------------+------+ | 1 | 1780768803242295820 | 2026-06-07 02:00:03.242296 | 1780768803242295820 | 1780768803242295820 | 2026-06-07 02:04:33.691842 | 2026-06-07 02:00:03.558515 | IDLE | NO | NO | | | 1001 | 1780768800713434480 | 2026-06-07 02:00:00.713434 | 1780768800713434480 | 1780768800713434480 | 2026-06-07 02:03:10.918110 | 2026-06-07 02:00:00.878978 | IDLE | NO | NO | | | 1002 | 1780768803189255053 | 2026-06-07 02:00:03.189255 | 1780768803189255053 | 1780682401315116260 | 2026-06-06 02:14:14.763998 | 2026-06-07 02:00:03.554235 | COMPACTING | NO | NO | | +-----------+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+------------+----------+--------------+------+ 3 rows in set (0.01 sec) MySQL [oceanbase]> select * from __all_virtual_server_compaction_progress where status != 'FINISH'\G *************************** 1. row *************************** svr_ip: 102.168.33.104 svr_port: 2882 zone: zone1 tenant_id: 1002 type: MAJOR_MERGE compaction_scn: 1780768803189255053 status: NODE_RUNNING total_tablet_count: 1022 unfinished_tablet_count: 1 data_size: 665282465431 unfinished_data_size: 0 compression_ratio: 0.32 start_time: 2026-06-07 02:00:03.934664 estimated_finish_time: 2026-06-08 02:00:03.934664 comments: SCHEDULER_LOOP:schedule_stats={schedule_cnt:723, finish_cnt:1021, wait_rs_validate_cnt:0}, 1 row in set (0.02 sec) MySQL [oceanbase]> select * from __all_virtual_tablet_meta_table where tenant_id = 1002 and compaction_scn < 1780768803189255053\G *************************** 1. row *************************** tenant_id: 1002 tablet_id: 1152921504606847159 ls_id: 1002 svr_ip: 192.168.33.104 svr_port: 2882 gmt_create: 2026-06-02 18:41:45.516971 gmt_modified: 2026-06-06 02:35:06.324891 compaction_scn: 1780682401315116260 data_size: 78448332115 required_size: 80308338688 report_scn: 1780682401315116260 status: 0 1 row in set (0.03 sec) MySQL [oceanbase]> select * from __all_virtual_compaction_diagnose_info where tenant_id=1002\G *************************** 1. row *************************** svr_ip: 192.168.33.104 svr_port: 2882 tenant_id: 1002 type: MEDIUM_MERGE ls_id: 1002 tablet_id: 1152921504606847159 status: FAILED create_time: 2026-06-07 02:03:36.905167 diagnose_info: error_no=-4184,last_error_time=1780829110864481,error_trace=YB420A042168-000605AD59DF9E0E-0-0,warning="info="DAG_MAJOR_MERGE";ls_id=1002;tablet_id=1152921504606847159;compaction_scn=1780768803189255053;extra_info="merge_type="MEDIUM_MERGE"";" *************************** 2. row *************************** svr_ip: 192.168.33.104 svr_port: 2882 tenant_id: 1002 type: MAJOR_MERGE ls_id: 1002 tablet_id: 1152921504606847159 status: RS_UNCOMPACTED create_time: 2026-06-07 18:45:11.738090 diagnose_info: server="192.168.33.104:2882",status="compaction_scn_not_update",frozen_scn=1780768803189255053,compaction_scn=1780682401315116260,report_scn=1780682401315116260 2 rows in set (0.04 sec) MySQL [oceanbase]> select * from CDB_OB_TABLE_LOCATIONS where tenant_id=1002 and TABLET_ID = 1152921504606847159\G *************************** 1. row *************************** TENANT_ID: 1002 DATABASE_NAME: tms TABLE_NAME: __AUX_LOB_META_500271_ TABLE_ID: 500271 TABLE_TYPE: LOB AUX TABLE PARTITION_NAME: NULL SUBPARTITION_NAME: NULL INDEX_NAME: NULL DATA_TABLE_ID: 500269 TABLET_ID: 1152921504606847159 LS_ID: 1002 ZONE: zone1 SVR_IP: 192.168.33.104 SVR_PORT: 2882 ROLE: FOLLOWER REPLICA_TYPE: FULL DUPLICATE_SCOPE: NONE OBJECT_ID: 500271 TABLEGROUP_NAME: NULL TABLEGROUP_ID: NULL SHARDING: NULL *************************** 2. row *************************** TENANT_ID: 1002 DATABASE_NAME: tms TABLE_NAME: __AUX_LOB_META_500271_ TABLE_ID: 500271 TABLE_TYPE: LOB AUX TABLE PARTITION_NAME: NULL SUBPARTITION_NAME: NULL INDEX_NAME: NULL DATA_TABLE_ID: 500269 TABLET_ID: 1152921504606847159 LS_ID: 1002 ZONE: zone2 SVR_IP: 192.168.33.105 SVR_PORT: 2882 ROLE: FOLLOWER REPLICA_TYPE: FULL DUPLICATE_SCOPE: NONE OBJECT_ID: 500271 TABLEGROUP_NAME: NULL TABLEGROUP_ID: NULL SHARDING: NULL *************************** 3. row *************************** TENANT_ID: 1002 DATABASE_NAME: tms TABLE_NAME: __AUX_LOB_META_500271_ TABLE_ID: 500271 TABLE_TYPE: LOB AUX TABLE PARTITION_NAME: NULL SUBPARTITION_NAME: NULL INDEX_NAME: NULL DATA_TABLE_ID: 500269 TABLET_ID: 1152921504606847159 LS_ID: 1002 ZONE: zone3 SVR_IP: 192.168.33.106 SVR_PORT: 2882 ROLE: LEADER REPLICA_TYPE: FULL DUPLICATE_SCOPE: NONE OBJECT_ID: 500271 TABLEGROUP_NAME: NULL TABLEGROUP_ID: NULL SHARDING: NULL 3 rows in set (0.02 sec) MySQL [oceanbase]> SELECT * FROM oceanbase.__all_virtual_disk_stat ; +-------------+----------+--------------+--------------+--------------+---------------+---------------------+----------------+ | svr_ip | svr_port | total_size | used_size | free_size | is_disk_valid | disk_error_begin_ts | allocated_size | +-------------+----------+--------------+--------------+--------------+---------------+---------------------+----------------+ | 192.168.33.104 | 2882 | 322122547200 | 322118352896 | 0 | 1 | 0 | 322122547200 | | 192.168.33.106 | 2882 | 322122547200 | 197109219328 | 125009133568 | 1 | 0 | 322122547200 | | 192.168.33.105 | 2882 | 322122547200 | 196945641472 | 125172711424 | 1 | 0 | 322122547200 | +-------------+----------+--------------+--------------+--------------+---------------+---------------------+----------------+ 3 rows in set (0.01 sec)