+-----------------------------------------------------------------------------------------------------------------------------------------------+ | critical-tasks-report | +----------------------------+------------------------------------------------------------------------------------------------------------------+ | task | task_report | +----------------------------+------------------------------------------------------------------------------------------------------------------+ | cluster.data_path_settings | [critical] [remote_192.168.80.1] data_dir_path is null . Please check your nodes.data_dir need absolute Path | | disk.sstable_abnormal_file | [critical] [remote_192.168.80.1] sstable_dir_path is null . Please check your nodes.data_dir need absolute Path | | network.TCP-retransmission | [critical] [remote_192.168.80.1] tsar is not installed. we can not check tcp retransmission. | +----------------------------+------------------------------------------------------------------------------------------------------------------+ +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | warning-tasks-report | +---------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | task | task_report | +---------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | bugs.bug_385 | [warning] Unadapted by version. SKIP | | cluster.deadlocks | [warning] [cluster:StandAlone] There is a deadlock. Please check on the oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | | cluster.ob_enable_plan_cache_bad_version | [warning] Unadapted by version. SKIP | | cluster.optimizer_better_inlist_costing_parmmeter | [warning] Unadapted by version. SKIP | | cluster.part_trans_action_max | [warning] Unadapted by version. SKIP | | cluster.table_history_too_many | [warning] Unadapted by version. SKIP | | system.dependent_software | [warning] [remote_192.168.80.1] firewalld is Running ,It is recommended to disable firewalld or add allow rules for each service in the OceanBase cluster to avoid firewall interception. | | system.instruction_set_avx2 | [warning] Unadapted by version. SKIP | | system.parameter | [warning] [remote_192.168.80.1] net.core.rmem_max : 2097152. recommended: 8388608 ≤ value ≤ 16777216. | | | [warning] [remote_192.168.80.1] net.ipv4.ip_forward : 1. recommended: 0. | | | [warning] [remote_192.168.80.1] kernel.numa_balancing : 1. recommended: 0. | | | [warning] [remote_192.168.80.1] vm.swappiness : 10. recommended: 0 | | | [warning] [remote_192.168.80.1] net.core.wmem_max: 2097152. recommended: 8388608 ≤ value ≤ 16777216. | | | [warning] [remote_192.168.80.1] net.ipv4.tcp_slow_start_after_idle: 1. recommended: 0. | | | [warning] [remote_192.168.80.1] net.core.somaxconn : 512. recommended: 2048 ≤ value ≤ 16384. | | | [warning] [remote_192.168.80.1] fs.pipe-user-pages-soft : 16384. recommended: 0. | | system.parameter_ip_local_port_range | [warning] [remote_192.168.80.1] ip_local_port_range_min : 32768. recommended: 3500 | | | [warning] [remote_192.168.80.1] ip_local_port_range_max : 60999. recommended: 65535 | | system.parameter_tcp_rmem | [warning] [remote_192.168.80.1] net.ipv4.tcp_rmem_max : 6291456. net.ipv4.tcp_rmem_max from net.ipv4.tcp_rmem. recommended: 65536 ≤ max≤ 131072 | | system.parameter_tcp_wmem | [warning] [remote_192.168.80.1] net.ipv4.tcp_wmem_max : 4194304. recommended: 8388608 ≤ max≤ 16777216 | | | [warning] [remote_192.168.80.1] net.ipv4.tcp_wmem_default : 16384. recommended: is 65536 ≤ default≤ 131072 | | system.ulimit_parameter | [warning] [remote_192.168.80.1] On ip : 192.168.80.1, ulimit -s is 8192 . recommended: unlimited. | | | [warning] [remote_192.168.80.1] On ip : 192.168.80.1, ulimit -u is 252332 . recommended: 655360. | +---------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | all-tasks-report | +---------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | task | task_report | +---------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | bugs.bug_182 | all pass | | bugs.bug_385 | [warning] Unadapted by version. SKIP | | bugs.bug_469 | all pass | | clog.clog_disk_full | all pass | | cluster.core_file_find | all pass | | cluster.data_path_settings | [critical] [remote_192.168.80.1] data_dir_path is null . Please check your nodes.data_dir need absolute Path | | cluster.deadlocks | [warning] [cluster:StandAlone] There is a deadlock. Please check on the oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | | cluster.global_indexes_too_much | all pass | | cluster.major | all pass | | cluster.mod_too_large | all pass | | cluster.ob_enable_plan_cache_bad_version | [warning] Unadapted by version. SKIP | | cluster.observer_not_active | all pass | | cluster.optimizer_better_inlist_costing_parmmeter | [warning] Unadapted by version. SKIP | | cluster.part_trans_action_max | [warning] Unadapted by version. SKIP | | cluster.resource_limit_max_session_num | all pass | | cluster.sys_log_level | all pass | | cluster.table_history_too_many | [warning] Unadapted by version. SKIP | | cluster.task_opt_stat | all pass | | cluster.task_opt_stat_gather_fail | all pass | | cluster.tenant_number | all pass | | cpu.oversold | all pass | | disk.clog_abnormal_file | all pass | | disk.disk_full | all pass | | disk.disk_hole | all pass | | disk.disk_iops | all pass | | disk.sstable_abnormal_file | [critical] [remote_192.168.80.1] sstable_dir_path is null . Please check your nodes.data_dir need absolute Path | | disk.xfs_repair | all pass | | err_code.find_err_4000 | all pass | | err_code.find_err_4001 | all pass | | err_code.find_err_4012 | all pass | | err_code.find_err_4013 | all pass | | err_code.find_err_4015 | all pass | | err_code.find_err_4016 | all pass | | err_code.find_err_4103 | all pass | | err_code.find_err_4105 | all pass | | err_code.find_err_4377 | all pass | | network.TCP-retransmission | [critical] [remote_192.168.80.1] tsar is not installed. we can not check tcp retransmission. | | system.aio | all pass | | system.clock_source | all pass | | system.core_pattern | all pass | | system.dependent_software | [warning] [remote_192.168.80.1] firewalld is Running ,It is recommended to disable firewalld or add allow rules for each service in the OceanBase cluster to avoid firewall interception. | | system.dependent_software_swapon | all pass | | system.getenforce | all pass | | system.instruction_set_avx2 | [warning] Unadapted by version. SKIP | | system.parameter | [warning] [remote_192.168.80.1] net.core.rmem_max : 2097152. recommended: 8388608 ≤ value ≤ 16777216. | | | [warning] [remote_192.168.80.1] net.ipv4.ip_forward : 1. recommended: 0. | | | [warning] [remote_192.168.80.1] kernel.numa_balancing : 1. recommended: 0. | | | [warning] [remote_192.168.80.1] vm.swappiness : 10. recommended: 0 | | | [warning] [remote_192.168.80.1] net.core.wmem_max: 2097152. recommended: 8388608 ≤ value ≤ 16777216. | | | [warning] [remote_192.168.80.1] net.ipv4.tcp_slow_start_after_idle: 1. recommended: 0. | | | [warning] [remote_192.168.80.1] net.core.somaxconn : 512. recommended: 2048 ≤ value ≤ 16384. | | | [warning] [remote_192.168.80.1] fs.pipe-user-pages-soft : 16384. recommended: 0. | | system.parameter_ip_local_port_range | [warning] [remote_192.168.80.1] ip_local_port_range_min : 32768. recommended: 3500 | | | [warning] [remote_192.168.80.1] ip_local_port_range_max : 60999. recommended: 65535 | | system.parameter_tcp_rmem | [warning] [remote_192.168.80.1] net.ipv4.tcp_rmem_max : 6291456. net.ipv4.tcp_rmem_max from net.ipv4.tcp_rmem. recommended: 65536 ≤ max≤ 131072 | | system.parameter_tcp_wmem | [warning] [remote_192.168.80.1] net.ipv4.tcp_wmem_max : 4194304. recommended: 8388608 ≤ max≤ 16777216 | | | [warning] [remote_192.168.80.1] net.ipv4.tcp_wmem_default : 16384. recommended: is 65536 ≤ default≤ 131072 | | system.ulimit_parameter | [warning] [remote_192.168.80.1] On ip : 192.168.80.1, ulimit -s is 8192 . recommended: unlimited. | | | [warning] [remote_192.168.80.1] On ip : 192.168.80.1, ulimit -u is 252332 . recommended: 655360. | | table.information_schema_tables_two_data | all pass | | version.bad_version | all pass | | version.old_version | all pass | +---------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+