+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | critical-tasks-report | +----------------------------+------------------------------------------------------------------------------------------------------------------------------------------------+ | task | task_report | +----------------------------+------------------------------------------------------------------------------------------------------------------------------------------------+ | disk.xfs_repair | [critical] [remote_10.1.46.91] xfs need repair. Please check disk. xfs_repair_log: dmesg: read kernel buffer failed: Operation not permitted | | | [critical] [remote_10.1.46.161] xfs need repair. Please check disk. xfs_repair_log: dmesg: read kernel buffer failed: Operation not permitted | | cluster.data_path_settings | [critical] [remote_10.1.46.161] ip:10.1.46.161 ,data_dir and log_dir_disk are on the same disk. | | | [critical] [remote_10.1.46.91] ip:10.1.46.91 ,data_dir and log_dir_disk are on the same disk. | | | [critical] [local] ip:10.1.46.124 ,data_dir and log_dir_disk are on the same disk. | | network.TCP-retransmission | [critical] [local] tsar is not installed. we can not check tcp retransmission. | | | [critical] [remote_10.1.46.161] tsar is not installed. we can not check tcp retransmission. | | | [critical] [remote_10.1.46.91] tsar is not installed. we can not check tcp retransmission. | | network.network_speed | [critical] [remote_10.1.46.91] network_speed is Speed: Unknown!, can not get real speed | | | [critical] [local] network_speed is Speed: Unknown!, can not get real speed | | | [critical] [remote_10.1.46.161] network_speed is Speed: Unknown!, can not get real speed | +----------------------------+------------------------------------------------------------------------------------------------------------------------------------------------+ +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | warning-tasks-report | +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------+ | task | task_report | +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------+ | system.instruction_set_avx2 | [warning] Unadapted by version. SKIP | | system.parameter_ip_local_port_range | [warning] [local] ip_local_port_range_min : 32768. recommended: 3500 | | | [warning] [remote_10.1.46.91] ip_local_port_range_min : 32768. recommended: 3500 | | | [warning] [remote_10.1.46.91] ip_local_port_range_max : 60999. recommended: 65535 | | | [warning] [local] ip_local_port_range_max : 60999. recommended: 65535 | | | [warning] [remote_10.1.46.161] ip_local_port_range_min : 32768. recommended: 3500 | | | [warning] [remote_10.1.46.161] ip_local_port_range_max : 60999. recommended: 65535 | | system.ulimit_parameter | [warning] [remote_10.1.46.91] On ip : 10.1.46.91, ulimit -s is 10240 . recommended: unlimited. | | | [warning] [remote_10.1.46.161] On ip : 10.1.46.161, ulimit -s is 10240 . recommended: unlimited. | | 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 | | 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 | | err_code.find_err_4012 | [warning] [cluster:obcluster] number of sql_error_4012 is 291 | | bugs.bug_385 | [warning] Unadapted by version. SKIP | +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------+ +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | all-tasks-report | +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------+ | task | task_report | +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------+ | clog.clog_disk_full | 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 | all pass | | disk.xfs_repair | [critical] [remote_10.1.46.91] xfs need repair. Please check disk. xfs_repair_log: dmesg: read kernel buffer failed: Operation not permitted | | | [critical] [remote_10.1.46.161] xfs need repair. Please check disk. xfs_repair_log: dmesg: read kernel buffer failed: Operation not permitted | | system.aio | all pass | | system.clock_source | all pass | | system.core_pattern | all pass | | system.dependent_software | all pass | | system.dependent_software_swapon | all pass | | system.getenforce | all pass | | system.instruction_set_avx | all pass | | system.instruction_set_avx2 | [warning] Unadapted by version. SKIP | | system.parameter | all pass | | system.parameter_ip_local_port_range | [warning] [local] ip_local_port_range_min : 32768. recommended: 3500 | | | [warning] [remote_10.1.46.91] ip_local_port_range_min : 32768. recommended: 3500 | | | [warning] [remote_10.1.46.91] ip_local_port_range_max : 60999. recommended: 65535 | | | [warning] [local] ip_local_port_range_max : 60999. recommended: 65535 | | | [warning] [remote_10.1.46.161] ip_local_port_range_min : 32768. recommended: 3500 | | | [warning] [remote_10.1.46.161] ip_local_port_range_max : 60999. recommended: 65535 | | system.parameter_tcp_rmem | all pass | | system.parameter_tcp_wmem | all pass | | system.ulimit_parameter | [warning] [remote_10.1.46.91] On ip : 10.1.46.91, ulimit -s is 10240 . recommended: unlimited. | | | [warning] [remote_10.1.46.161] On ip : 10.1.46.161, ulimit -s is 10240 . recommended: unlimited. | | cluster.core_file_find | all pass | | cluster.data_path_settings | [critical] [remote_10.1.46.161] ip:10.1.46.161 ,data_dir and log_dir_disk are on the same disk. | | | [critical] [remote_10.1.46.91] ip:10.1.46.91 ,data_dir and log_dir_disk are on the same disk. | | | [critical] [local] ip:10.1.46.124 ,data_dir and log_dir_disk are on the same disk. | | cluster.datafile_next | all pass | | cluster.deadlocks | all pass | | cluster.global_indexes_too_much | all pass | | cluster.major | 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 | | 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 | | err_code.find_err_4000 | all pass | | err_code.find_err_4001 | all pass | | err_code.find_err_4012 | [warning] [cluster:obcluster] number of sql_error_4012 is 291 | | 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_4108 | all pass | | err_code.find_err_4377 | all pass | | table.information_schema_tables_two_data | all pass | | network.TCP-retransmission | [critical] [local] tsar is not installed. we can not check tcp retransmission. | | | [critical] [remote_10.1.46.161] tsar is not installed. we can not check tcp retransmission. | | | [critical] [remote_10.1.46.91] tsar is not installed. we can not check tcp retransmission. | | network.network_speed | [critical] [remote_10.1.46.91] network_speed is Speed: Unknown!, can not get real speed | | | [critical] [local] network_speed is Speed: Unknown!, can not get real speed | | | [critical] [remote_10.1.46.161] network_speed is Speed: Unknown!, can not get real speed | | version.bad_version | all pass | | version.old_version | all pass | | bugs.bug_182 | all pass | | bugs.bug_385 | [warning] Unadapted by version. SKIP | | bugs.bug_469 | all pass | | cpu.oversold | all pass | +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------+