+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | critical-tasks-report | +------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | task | task_report | +------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | table.information_schema_tables_two_data | [critical] [cluster:obcluster] Find have table found two records in information_schema.tables. the number of err_table_count is : 39. Please get more info by "select * from oceanbase.__all_virtual_table_stat where table_id = partition_id and (tenant_id,table_id) in (select tenant_id, table_id from oceanbase.__all_virtual_table where part_level != 0);". And you can by "delete from __all_table_stat where table_id=partition_id and table_id=${partition table table_id};" and "delete from __all_column_stat where table_id=partition_id and table_id=${partition table table_id};" to fix it. | +------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | warning-tasks-report | +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------+ | task | task_report | +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------+ | disk.disk_hole | [warning] [cluster:obcluster] not warning ,the DATA_SIZE is not 0 . need check sum(REQUIRED_SIZE)/sum(DATA_SIZE) | | cluster.table_history_too_many | [warning] Unadapted by version. SKIP | | cluster.part_trans_action_max | [warning] Unadapted by version. SKIP | | cluster.ob_enable_plan_cache_bad_version | [warning] Unadapted by version. SKIP | | cluster.optimizer_better_inlist_costing_parmmeter | [warning] Unadapted by version. SKIP | | cluster.mod_too_large | [warning] [cluster:obcluster] mod max memory over 10G，Please check on oceanbase.__all_virtual_memory_info to find some large mod | | system.getenforce | [warning] [remote_172.26.49.127] Do not warning. getenforce is exist. We will check SELinux by getenforce | | | [warning] [remote_172.30.224.166] Do not warning. getenforce is exist. We will check SELinux by getenforce | | | [warning] [remote_172.22.146.197] Do not warning. getenforce is exist. We will check SELinux by getenforce | | | [warning] [remote_172.30.224.164] Do not warning. getenforce is exist. We will check SELinux by getenforce | | | [warning] [remote_172.26.49.128] Do not warning. getenforce is exist. We will check SELinux by getenforce | | | [warning] [remote_172.22.146.196] Do not warning. getenforce is exist. We will check SELinux by getenforce | | | [warning] [remote_172.26.49.126] Do not warning. getenforce is exist. We will check SELinux by getenforce | | | [warning] [remote_172.30.224.165] Do not warning. getenforce is exist. We will check SELinux by getenforce | | | [warning] [remote_172.22.146.198] Do not warning. getenforce is exist. We will check SELinux by getenforce | | system.dependent_software_swapon | [warning] [remote_172.26.49.128] Do not warning. swapon is exist. We will check the swap | | | [warning] [remote_172.22.146.198] Do not warning. swapon is exist. We will check the swap | | | [warning] [remote_172.22.146.196] Do not warning. swapon is exist. We will check the swap | | | [warning] [remote_172.30.224.164] Do not warning. swapon is exist. We will check the swap | | | [warning] [remote_172.26.49.126] Do not warning. swapon is exist. We will check the swap | | | [warning] [remote_172.30.224.165] Do not warning. swapon is exist. We will check the swap | | | [warning] [remote_172.26.49.127] Do not warning. swapon is exist. We will check the swap | | | [warning] [remote_172.22.146.197] Do not warning. swapon is exist. We will check the swap | | | [warning] [remote_172.30.224.166] Do not warning. swapon is exist. We will check the swap | +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------+ +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | all-tasks-report | +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | task | task_report | +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | bugs.bug_182 | all pass | | disk.clog_abnormal_file | all pass | | disk.disk_full | all pass | | disk.disk_hole | [warning] [cluster:obcluster] not warning ,the DATA_SIZE is not 0 . need check sum(REQUIRED_SIZE)/sum(DATA_SIZE) | | disk.disk_iops | all pass | | disk.sstable_abnormal_file | all pass | | cluster.task_opt_stat_gather_fail | all pass | | cluster.core_file_find | all pass | | cluster.sys_log_level | all pass | | cluster.global_indexes_too_much | all pass | | cluster.resource_limit_max_session_num | all pass | | cluster.major | all pass | | cluster.observer_not_active | all pass | | cluster.data_path_settings | all pass | | cluster.table_history_too_many | [warning] Unadapted by version. SKIP | | cluster.tenant_number | all pass | | cluster.part_trans_action_max | [warning] Unadapted by version. SKIP | | cluster.ob_enable_plan_cache_bad_version | [warning] Unadapted by version. SKIP | | cluster.optimizer_better_inlist_costing_parmmeter | [warning] Unadapted by version. SKIP | | cluster.deadlocks | all pass | | cluster.mod_too_large | [warning] [cluster:obcluster] mod max memory over 10G，Please check on oceanbase.__all_virtual_memory_info to find some large mod | | system.parameter_tcp_wmem | all pass | | system.instruction_set_avx2 | all pass | | system.getenforce | [warning] [remote_172.26.49.127] Do not warning. getenforce is exist. We will check SELinux by getenforce | | | [warning] [remote_172.30.224.166] Do not warning. getenforce is exist. We will check SELinux by getenforce | | | [warning] [remote_172.22.146.197] Do not warning. getenforce is exist. We will check SELinux by getenforce | | | [warning] [remote_172.30.224.164] Do not warning. getenforce is exist. We will check SELinux by getenforce | | | [warning] [remote_172.26.49.128] Do not warning. getenforce is exist. We will check SELinux by getenforce | | | [warning] [remote_172.22.146.196] Do not warning. getenforce is exist. We will check SELinux by getenforce | | | [warning] [remote_172.26.49.126] Do not warning. getenforce is exist. We will check SELinux by getenforce | | | [warning] [remote_172.30.224.165] Do not warning. getenforce is exist. We will check SELinux by getenforce | | | [warning] [remote_172.22.146.198] Do not warning. getenforce is exist. We will check SELinux by getenforce | | system.dependent_software | all pass | | system.dependent_software_swapon | [warning] [remote_172.26.49.128] Do not warning. swapon is exist. We will check the swap | | | [warning] [remote_172.22.146.198] Do not warning. swapon is exist. We will check the swap | | | [warning] [remote_172.22.146.196] Do not warning. swapon is exist. We will check the swap | | | [warning] [remote_172.30.224.164] Do not warning. swapon is exist. We will check the swap | | | [warning] [remote_172.26.49.126] Do not warning. swapon is exist. We will check the swap | | | [warning] [remote_172.30.224.165] Do not warning. swapon is exist. We will check the swap | | | [warning] [remote_172.26.49.127] Do not warning. swapon is exist. We will check the swap | | | [warning] [remote_172.22.146.197] Do not warning. swapon is exist. We will check the swap | | | [warning] [remote_172.30.224.166] Do not warning. swapon is exist. We will check the swap | | system.clock_source | all pass | | system.core_pattern | all pass | | system.parameter | all pass | | system.parameter_ip_local_port_range | all pass | | system.parameter_tcp_rmem | all pass | | system.aio | all pass | | system.ulimit_parameter | all pass | | clog.clog_disk_full | all pass | | version.old_version | all pass | | version.bad_version | all pass | | cpu.oversold | all pass | | err_code.find_err_4000 | all pass | | err_code.find_err_4016 | all pass | | err_code.find_err_4015 | all pass | | err_code.find_err_4105 | all pass | | err_code.find_err_4012 | all pass | | err_code.find_err_4001 | all pass | | err_code.find_err_4013 | all pass | | err_code.find_err_4103 | all pass | | err_code.find_err_4377 | all pass | | table.information_schema_tables_two_data | [critical] [cluster:obcluster] Find have table found two records in information_schema.tables. the number of err_table_count is : 39. Please get more info by "select * from oceanbase.__all_virtual_table_stat where table_id = partition_id and (tenant_id,table_id) in (select tenant_id, table_id from oceanbase.__all_virtual_table where part_level != 0);". And you can by "delete from __all_table_stat where table_id=partition_id and table_id=${partition table table_id};" and "delete from __all_column_stat where table_id=partition_id and table_id=${partition table table_id};" to fix it. | +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+