mysql> select /*+ query_timeout(1000000000) */ * from __all_virtual_tablet_compaction_info where max_received_scn > finished_scn and max_received_scn > 0; +-----------------+----------+-----------+-------+-----------+---------------------+---------------------+---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | svr_ip | svr_port | tenant_id | ls_id | tablet_id | finished_scn | wait_check_scn | max_received_scn | serialize_scn_list | +-----------------+----------+-----------+-------+-----------+---------------------+---------------------+---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 192.168.140.174 | 2982 | 1001 | 1 | 370 | 1693476747012845786 | 0 | 1693480544981708870 | {size:1, last_compaction_type:0, wait_check_flag:0, last_medium_scn:1693476747012845786, info_list:{[0]:compaction_type:"MEDIUM_COMPACTION", medium_snapshot_:1693480544981708870, parallel_merge_info:{list_size:0, }}} | | 192.168.140.175 | 2982 | 1001 | 1 | 370 | 1693476747012845786 | 1693476747012845786 | 1693480544981708870 | {size:1, last_compaction_type:0, wait_check_flag:1, last_medium_scn:1693476747012845786, info_list:{[0]:compaction_type:"MEDIUM_COMPACTION", medium_snapshot_:1693480544981708870, parallel_merge_info:{list_size:0, }}} | | 192.168.140.177 | 2982 | 1001 | 1 | 370 | 1693476747012845786 | 1693476747012845786 | 1693480544981708870 | {size:1, last_compaction_type:0, wait_check_flag:1, last_medium_scn:1693476747012845786, info_list:{[0]:compaction_type:"MEDIUM_COMPACTION", medium_snapshot_:1693480544981708870, parallel_merge_info:{list_size:0, }}} | +-----------------+----------+-----------+-------+-----------+---------------------+---------------------+---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 3 rows in set (0.02 sec) mysql> select * from __all_table where tablet_id=370; +----------------------------+----------------------------+-----------+----------+------------------------+-------------+------------+-----------+----------+-------------------+------------------+--------------------+-------------------+----------------+-----------+------------------+--------------------+------------------+--------------------+---------+------------+----------------+---------------+--------------+---------------+-----------------------+------------+------------+----------------+----------------+----------+--------------------+--------------------+--------------+------------------+-----------------+-------------------+-------------------+------------------+-------------+----------------------+-------------+---------+------------------+--------------------------+------------+------------+------------------+--------------------+--------------+-----------------+-------------------------+------------------------+------------+------------+---------------+-------------------------+-----+----------------------+----------------------+----------------+-----------+----------------------+-----------+------------------------+----------------+------------------+--------------------+----------------+------------------+---------------+-------------+------------------+ | gmt_create | gmt_modified | tenant_id | table_id | table_name | database_id | table_type | load_type | def_type | rowkey_column_num | index_column_num | max_used_column_id | autoinc_column_id | auto_increment | read_only | rowkey_split_pos | compress_func_name | expire_condition | is_use_bloomfilter | comment | block_size | collation_type | data_table_id | index_status | tablegroup_id | progressive_merge_num | index_type | part_level | part_func_type | part_func_expr | part_num | sub_part_func_type | sub_part_func_expr | sub_part_num | schema_version | view_definition | view_check_option | view_is_updatable | index_using_type | parser_name | index_attributes_set | tablet_size | pctfree | partition_status | partition_schema_version | session_id | pk_comment | sess_active_time | row_store_type | store_format | duplicate_scope | progressive_merge_round | storage_format_version | table_mode | encryption | tablespace_id | sub_part_template_flags | dop | character_set_client | collation_connection | auto_part_size | auto_part | association_table_id | tablet_id | max_dependency_version | define_user_id | transition_point | b_transition_point | interval_range | b_interval_range | object_status | table_flags | truncate_version | +----------------------------+----------------------------+-----------+----------+------------------------+-------------+------------+-----------+----------+-------------------+------------------+--------------------+-------------------+----------------+-----------+------------------+--------------------+------------------+--------------------+---------+------------+----------------+---------------+--------------+---------------+-----------------------+------------+------------+----------------+----------------+----------+--------------------+--------------------+--------------+------------------+-----------------+-------------------+-------------------+------------------+-------------+----------------------+-------------+---------+------------------+--------------------------+------------+------------+------------------+--------------------+--------------+-----------------+-------------------------+------------------------+------------+------------+---------------+-------------------------+-----+----------------------+----------------------+----------------+-----------+----------------------+-----------+------------------------+----------------+------------------+--------------------+----------------+------------------+---------------+-------------+------------------+ | 2023-07-20 18:44:51.409466 | 2023-07-20 18:44:51.409466 | 0 | 370 | __all_ls_recovery_stat | 201001 | 0 | 0 | 0 | 2 | 0 | 23 | 0 | 1 | 0 | 0 | none | | 0 | | 16384 | 45 | 0 | 1 | 202001 | 0 | 0 | 0 | 0 | | 1 | 0 | | 0 | 1689849891410088 | | 0 | 0 | 0 | NULL | 0 | 134217728 | 10 | 0 | 0 | 0 | | 0 | encoding_row_store | DYNAMIC | 0 | 1 | 3 | 0 | | -1 | 0 | 1 | 0 | 0 | 0 | 0 | -1 | 370 | -1 | -1 | NULL | NULL | NULL | NULL | 1 | 0 | -1 | +----------------------------+----------------------------+-----------+----------+------------------------+-------------+------------+-----------+----------+-------------------+------------------+--------------------+-------------------+----------------+-----------+------------------+--------------------+------------------+--------------------+---------+------------+----------------+---------------+--------------+---------------+-----------------------+------------+------------+----------------+----------------+----------+--------------------+--------------------+--------------+------------------+-----------------+-------------------+-------------------+------------------+-------------+----------------------+-------------+---------+------------------+--------------------------+------------+------------+------------------+--------------------+--------------+-----------------+-------------------------+------------------------+------------+------------+---------------+-------------------------+-----+----------------------+----------------------+----------------+-----------+----------------------+-----------+------------------------+----------------+------------------+--------------------+----------------+------------------+---------------+-------------+------------------+ 1 row in set (0.12 sec) mysql> 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 | 1693418400883742799 | 2023-08-31 02:00:00.883743 | 1693418400883742799 | 1693418400883742799 | 2023-08-31 02:01:15.890161 | 2023-08-31 02:00:01.004329 | IDLE | NO | YES | | | 1001 | 1693418401706628243 | 2023-08-31 02:00:01.706628 | 1693418401706628243 | 1693418401706628243 | 2023-08-31 02:00:55.955022 | 2023-08-31 02:00:01.820150 | IDLE | NO | YES | | | 1002 | 1693418400634533452 | 2023-08-31 02:00:00.634533 | 1693418400634533452 | 1693418400634533452 | 2023-08-31 02:00:50.327629 | 2023-08-31 02:00:00.690944 | IDLE | NO | YES | | +-----------+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+--------+----------+--------------+------+ 3 rows in set (0.01 sec) mysql> SELECT * FROM oceanbase.GV$OB_TABLET_COMPACTION_PROGRESS where TABLET_ID='1693476747012845786'; Empty set (0.01 sec) mysql> SELECT * FROM oceanbase.GV$OB_TABLET_COMPACTION_PROGRESS where TABLET_ID='370'; Empty set (0.00 sec) mysql> select * from dba_ob_tenants; +-----------+-------------+-------------+----------------------------+----------------------------+-------------------+---------------------------------------------+-------------------+--------------------+--------+---------------+--------+-------------+-------------------+------------------+---------------------+---------------------+---------------------+---------------------+--------------+----------------------------+ | TENANT_ID | TENANT_NAME | TENANT_TYPE | CREATE_TIME | MODIFY_TIME | PRIMARY_ZONE | LOCALITY | PREVIOUS_LOCALITY | COMPATIBILITY_MODE | STATUS | IN_RECYCLEBIN | LOCKED | TENANT_ROLE | SWITCHOVER_STATUS | SWITCHOVER_EPOCH | SYNC_SCN | REPLAYABLE_SCN | READABLE_SCN | RECOVERY_UNTIL_SCN | LOG_MODE | ARBITRATION_SERVICE_STATUS | +-----------+-------------+-------------+----------------------------+----------------------------+-------------------+---------------------------------------------+-------------------+--------------------+--------+---------------+--------+-------------+-------------------+------------------+---------------------+---------------------+---------------------+---------------------+--------------+----------------------------+ | 1 | sys | SYS | 2023-07-20 18:44:55.364123 | 2023-07-20 18:45:55.514010 | zone1;zone2,zone3 | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | NULL | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | NULL | NULL | NULL | NULL | NOARCHIVELOG | DISABLED | | 1001 | META$1002 | META | 2023-07-20 19:22:49.725846 | 2023-08-31 19:14:34.465355 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | NULL | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | NULL | NULL | NULL | NULL | NOARCHIVELOG | DISABLED | | 1002 | telnet_test | USER | 2023-07-20 19:22:49.731376 | 2023-08-31 19:14:34.458441 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | NULL | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | 1693810843886381911 | 1693810843886381911 | 1693810843744841147 | 4611686018427387903 | NOARCHIVELOG | DISABLED | +-----------+-------------+-------------+----------------------------+----------------------------+-------------------+---------------------------------------------+-------------------+--------------------+--------+---------------+--------+-------------+-------------------+------------------+---------------------+---------------------+---------------------+---------------------+--------------+----------------------------+ 3 rows in set (0.01 sec)