obdiag version: 3.4.0 report time: 2025-06-04 10:18:05 observer version: 4.3.4.0 +------------------------------------------------------------------------------------------------+ | fail-tasks-report | +-------------------------------------------+----------------------------------------------------+ | task | task_report | +-------------------------------------------+----------------------------------------------------+ | tenant.macroblock_utilization_rate_tenant | [fail] execute error 'list' object is not callable | +-------------------------------------------+----------------------------------------------------+ +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | critical-tasks-report | +----------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | task | task_report | +----------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | tenant.tenant_min_resource | [critical] [cluster:myoceanbase] there tenant resource pool configuration is less than 2C4G, please check it. tenant_id: 1,1002 | | system.python_version | [critical] node: remote_192_168_0_175 python is not existed | | system.instruction_set_avx | [critical] [remote_192_168_0_175] observer need cpu support avx. If the cpu is not support avx, observer will be crash. | | system.core_pattern | [critical] [remote_192_168_0_175] kernel.core_pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h , is not recommended for configuring functions other than the specified core path | | cluster.data_path_settings | [critical] [remote_192_168_0_175] ip:192.168.0.175 ,data_dir and log_dir_disk are on the same disk. | | bugs.bug_469 | [critical] [remote_192_168_0_175] glibc version need less 2.34. This may cause observer crash. More information： https://github.com/oceanbase/obdiag/issues/469 | | network.TCP-retransmission | [critical] [remote_192_168_0_175] tsar is not installed. we can not check tcp retransmission. | | network.network_speed | [critical] [remote_192_168_0_175] network_speed is null , can not get real speed | +----------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | warning-tasks-report | +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+ | task | task_report | +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+ | err_code.find_err_4013 | [warning] [cluster:myoceanbase] number of sql_error_4013 is 269 | | tenant.parameters_default | [warning] the ha_low_thread_score is not default_value. tenant_ids: 1, value: 4, default_value: 0 | | | [warning] the _bloom_filter_ratio is not default_value. value: 3, default_value: 35 | | | [warning] the large_query_threshold is not default_value. value: 600s, default_value: 5s | | | [warning] the cpu_quota_concurrency is not default_value. tenant_ids: 1, value: 10, default_value: 4 | | | [warning] the system_memory is not default_value. value: 3G, default_value: 0M | | | [warning] the cluster_id is not default_value. value: 1744619897, default_value: 0 | | | [warning] the direct_load_allow_fallback is not default_value. tenant_ids: 1002, value: True, default_value: False | | | [warning] the cluster is not default_value. value: myoceanbase, default_value: obcluster | | | [warning] the local_ip is not default_value. value: 192.168.0.175, default_value: | | | [warning] the devname is not default_value. value: enp125s0f4, default_value: bond0 | | | [warning] the memory_limit is not default_value. value: 18G, default_value: 0M | | | [warning] the datafile_next is not default_value. value: 100G, default_value: 0 | | | [warning] the log_transport_compress_all is not default_value. tenant_ids: 1002, value: True, default_value: False | | | [warning] the datafile_size is not default_value. value: 500G, default_value: 0M | | | [warning] the zone is not default_value. value: zone1, default_value: | | | [warning] the max_syslog_file_count is not default_value. value: 4, default_value: 0 | | | [warning] the __min_full_resource_pool_memory is not default_value. value: 2147483648, default_value: 5368709120 | | | [warning] the rootservice_list is not default_value. value: 192.168.0.175:2882:2881, default_value: | | | [warning] the _enable_dbms_job_package is not default_value. value: False, default_value: True | | | [warning] the all_server_list is not default_value. value: 192.168.0.175:2882, default_value: | | | [warning] the enable_syslog_wf is not default_value. value: False, default_value: True | | | [warning] the _parallel_ddl_control is not default_value. tenant_ids: 1002,1004, value: TRUNCATE_TABLE:ON, default_value: | | | [warning] the enable_syslog_recycle is not default_value. value: True, default_value: False | | | [warning] the log_disk_size is not default_value. value: 200G, default_value: 0M | | | [warning] the cpu_count is not default_value. value: 16, default_value: 0 | | | [warning] the observer_id is not default_value. value: 1, default_value: 0 | | | [warning] the datafile_maxsize is not default_value. value: 2000G, default_value: 0 | | | [warning] the data_dir is not default_value. value: /home/hyzn/admin/myoceanbase/oceanbase/store, default_value: store | | | [warning] the enable_record_trace_log is not default_value. value: False, default_value: True | | system.clock_source_check | [warning] node:remote_192_168_0_175. chronyc command does not exist. | | | [warning] No clock source configuration found. | | system.parameter_tcp_rmem | [warning] [remote_192_168_0_175] net.ipv4.tcp_rmem_max : 6291456. net.ipv4.tcp_rmem_max from net.ipv4.tcp_rmem. recommended: 65536 ≤ max≤ 131072 | | system.tcp_tw_reuse | [warning] node: remote_192_168_0_175 net.ipv4.tcp_tw_reuse is 2. It is recommended to set it to 1 | | system.aio | [warning] [remote_192_168_0_175] fs.aio-max-nr : 65536 . recommended: >1048576 | | system.parameter_ip_local_port_range | [warning] [remote_192_168_0_175] ip_local_port_range_min : 32768. recommended: 3500 | | | [warning] [remote_192_168_0_175] ip_local_port_range_max : 60999. recommended: 65535 | | system.ulimit_parameter | [warning] [remote_192_168_0_175] On ip : 192.168.0.175, ulimit -u as "max user processes" is 10240000 . recommended: 655360. | | | [warning] [remote_192_168_0_175] On ip : 192.168.0.175, ulimit -n as "open files" is 10240000 . recommended: unlimited. | | | [warning] [remote_192_168_0_175] On ip : 192.168.0.175, ulimit -s as "stack size" is 8192 . recommended: unlimited. | | system.instruction_set_avx2 | [warning] Unadapted by version. SKIP | | system.check_command | [warning] node: remote_192_168_0_175 nc is not existed. Network connection tool. Suggested installation | | | [warning] node: remote_192_168_0_175 nslookup is not existed. bind-utls DNS toolset. Suggested installation | | | [warning] node: remote_192_168_0_175 tc is not existed. iproute Network Management Toolkit. Suggested installation | | | [warning] node: remote_192_168_0_175 mtr is not existed. Network testing tools. Suggested installation | | system.parameter_tcp_wmem | [warning] [remote_192_168_0_175] net.ipv4.tcp_wmem_default : 16384. recommended: is 65536 ≤ default≤ 131072 | | | [warning] [remote_192_168_0_175] net.ipv4.tcp_wmem_max : 4194304. recommended: 8388608 ≤ max≤ 16777216 | | system.parameter | [warning] [remote_192_168_0_175] net.ipv4.tcp_slow_start_after_idle: 1. recommended: 0. | | | [warning] [remote_192_168_0_175] net.core.rmem_max : 229376. recommended: 8388608 ≤ value ≤ 16777216. | | | [warning] [remote_192_168_0_175] fs.aio-max-nr : 65536. recommended: 65536 is ≥ 1048576. | | | [warning] [remote_192_168_0_175] fs.pipe-user-pages-soft : 16384. recommended: 0. | | | [warning] [remote_192_168_0_175] net.ipv4.ip_forward : 1. recommended: 0. | | | [warning] [remote_192_168_0_175] net.core.wmem_max: 229376. recommended: 8388608 ≤ value ≤ 16777216. | | | [warning] [remote_192_168_0_175] vm.swappiness : 10. recommended: 0 | | cluster.cpu_quota_concurrency | [warning] tenant_id: 1, svr_ip: 192.168.0.175. cpu_quota_concurrency is 10, recommended value is 2-4. | | cluster.ob_enable_plan_cache_bad_version | [warning] Unadapted by version. SKIP | | cluster.observer_port | [warning] node: remote_192_168_0_175. nc command not exist, please install nc command | | cluster.table_history_too_many | [warning] Unadapted by version. SKIP | | cluster.part_trans_action_max | [warning] Unadapted by version. SKIP | | cluster.optimizer_better_inlist_costing_parmmeter | [warning] Unadapted by version. SKIP | | cluster.large_query_threshold | [warning] svr_ip: 192.168.0.175. large_query_threshold is 600s, recommended value is 5s. | | cluster.enable_lock_priority | [warning] observer version is 4.3.4.0, which is more than 4.3.0.0. | | cluster.cgroup | [warning] node: remote_192_168_0_175 cgroup path is not exist. Tenant isolation not enabled. issue #849 | | cluster.auto_increment_cache_size | [warning] tenant_id: 1002 auto_increment_cache_size is 1000000, default value is 1000000 | | | [warning] tenant_id: 1003 auto_increment_cache_size is 1000000, default value is 1000000 | | | [warning] tenant_id: 1004 auto_increment_cache_size is 1000000, default value is 1000000 | | | [warning] tenant_id: 1 auto_increment_cache_size is 1000000, default value is 1000000 | | | [warning] tenant_id: 1001 auto_increment_cache_size is 1000000, default value is 1000000 | | bugs.bug_385 | [warning] Unadapted by version. SKIP | | log.log_size | [warning] node: 192.168.0.175 max_syslog_file_count is 4, please check. the recommended is 0 or over 100 | +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+ +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | all-tasks-report | +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | task | task_report | +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | err_code.find_err_4108 | all pass | | err_code.find_err_4012 | all pass | | err_code.find_err_4015 | all pass | | err_code.find_err_4377 | all pass | | err_code.find_err_4013 | [warning] [cluster:myoceanbase] number of sql_error_4013 is 269 | | err_code.find_err_4001 | all pass | | err_code.find_err_4105 | all pass | | err_code.find_err_4000 | all pass | | err_code.find_err_4103 | all pass | | err_code.find_err_4016 | all pass | | version.bad_version | all pass | | version.old_version | all pass | | tenant.macroblock_utilization_rate_tenant | [fail] execute error 'list' object is not callable | | tenant.tenant_min_resource | [critical] [cluster:myoceanbase] there tenant resource pool configuration is less than 2C4G, please check it. tenant_id: 1,1002 | | tenant.parameters_default | [warning] the ha_low_thread_score is not default_value. tenant_ids: 1, value: 4, default_value: 0 | | | [warning] the _bloom_filter_ratio is not default_value. value: 3, default_value: 35 | | | [warning] the large_query_threshold is not default_value. value: 600s, default_value: 5s | | | [warning] the cpu_quota_concurrency is not default_value. tenant_ids: 1, value: 10, default_value: 4 | | | [warning] the system_memory is not default_value. value: 3G, default_value: 0M | | | [warning] the cluster_id is not default_value. value: 1744619897, default_value: 0 | | | [warning] the direct_load_allow_fallback is not default_value. tenant_ids: 1002, value: True, default_value: False | | | [warning] the cluster is not default_value. value: myoceanbase, default_value: obcluster | | | [warning] the local_ip is not default_value. value: 192.168.0.175, default_value: | | | [warning] the devname is not default_value. value: enp125s0f4, default_value: bond0 | | | [warning] the memory_limit is not default_value. value: 18G, default_value: 0M | | | [warning] the datafile_next is not default_value. value: 100G, default_value: 0 | | | [warning] the log_transport_compress_all is not default_value. tenant_ids: 1002, value: True, default_value: False | | | [warning] the datafile_size is not default_value. value: 500G, default_value: 0M | | | [warning] the zone is not default_value. value: zone1, default_value: | | | [warning] the max_syslog_file_count is not default_value. value: 4, default_value: 0 | | | [warning] the __min_full_resource_pool_memory is not default_value. value: 2147483648, default_value: 5368709120 | | | [warning] the rootservice_list is not default_value. value: 192.168.0.175:2882:2881, default_value: | | | [warning] the _enable_dbms_job_package is not default_value. value: False, default_value: True | | | [warning] the all_server_list is not default_value. value: 192.168.0.175:2882, default_value: | | | [warning] the enable_syslog_wf is not default_value. value: False, default_value: True | | | [warning] the _parallel_ddl_control is not default_value. tenant_ids: 1002,1004, value: TRUNCATE_TABLE:ON, default_value: | | | [warning] the enable_syslog_recycle is not default_value. value: True, default_value: False | | | [warning] the log_disk_size is not default_value. value: 200G, default_value: 0M | | | [warning] the cpu_count is not default_value. value: 16, default_value: 0 | | | [warning] the observer_id is not default_value. value: 1, default_value: 0 | | | [warning] the datafile_maxsize is not default_value. value: 2000G, default_value: 0 | | | [warning] the data_dir is not default_value. value: /home/hyzn/admin/myoceanbase/oceanbase/store, default_value: store | | | [warning] the enable_record_trace_log is not default_value. value: False, default_value: True | | tenant.writing_throttling_trigger_percentage | all pass | | tenant.max_stale_time_for_weak_consistency | all pass | | system.mount_options | all pass | | system.clock_source_check | [warning] node:remote_192_168_0_175. chronyc command does not exist. | | | [warning] No clock source configuration found. | | system.dependent_software_swapon | all pass | | system.parameter_tcp_rmem | [warning] [remote_192_168_0_175] net.ipv4.tcp_rmem_max : 6291456. net.ipv4.tcp_rmem_max from net.ipv4.tcp_rmem. recommended: 65536 ≤ max≤ 131072 | | system.dependent_software | all pass | | system.clock_source | all pass | | system.arm_smmu | all pass | | system.dmesg_log | all pass | | system.tcp_tw_reuse | [warning] node: remote_192_168_0_175 net.ipv4.tcp_tw_reuse is 2. It is recommended to set it to 1 | | system.aio | [warning] [remote_192_168_0_175] fs.aio-max-nr : 65536 . recommended: >1048576 | | system.parameter_ip_local_port_range | [warning] [remote_192_168_0_175] ip_local_port_range_min : 32768. recommended: 3500 | | | [warning] [remote_192_168_0_175] ip_local_port_range_max : 60999. recommended: 65535 | | system.ulimit_parameter | [warning] [remote_192_168_0_175] On ip : 192.168.0.175, ulimit -u as "max user processes" is 10240000 . recommended: 655360. | | | [warning] [remote_192_168_0_175] On ip : 192.168.0.175, ulimit -n as "open files" is 10240000 . recommended: unlimited. | | | [warning] [remote_192_168_0_175] On ip : 192.168.0.175, ulimit -s as "stack size" is 8192 . recommended: unlimited. | | system.instruction_set_avx2 | [warning] Unadapted by version. SKIP | | system.python_version | [critical] node: remote_192_168_0_175 python is not existed | | system.check_command | [warning] node: remote_192_168_0_175 nc is not existed. Network connection tool. Suggested installation | | | [warning] node: remote_192_168_0_175 nslookup is not existed. bind-utls DNS toolset. Suggested installation | | | [warning] node: remote_192_168_0_175 tc is not existed. iproute Network Management Toolkit. Suggested installation | | | [warning] node: remote_192_168_0_175 mtr is not existed. Network testing tools. Suggested installation | | system.instruction_set_avx | [critical] [remote_192_168_0_175] observer need cpu support avx. If the cpu is not support avx, observer will be crash. | | system.parameter_tcp_wmem | [warning] [remote_192_168_0_175] net.ipv4.tcp_wmem_default : 16384. recommended: is 65536 ≤ default≤ 131072 | | | [warning] [remote_192_168_0_175] net.ipv4.tcp_wmem_max : 4194304. recommended: 8388608 ≤ max≤ 16777216 | | system.parameter | [warning] [remote_192_168_0_175] net.ipv4.tcp_slow_start_after_idle: 1. recommended: 0. | | | [warning] [remote_192_168_0_175] net.core.rmem_max : 229376. recommended: 8388608 ≤ value ≤ 16777216. | | | [warning] [remote_192_168_0_175] fs.aio-max-nr : 65536. recommended: 65536 is ≥ 1048576. | | | [warning] [remote_192_168_0_175] fs.pipe-user-pages-soft : 16384. recommended: 0. | | | [warning] [remote_192_168_0_175] net.ipv4.ip_forward : 1. recommended: 0. | | | [warning] [remote_192_168_0_175] net.core.wmem_max: 229376. recommended: 8388608 ≤ value ≤ 16777216. | | | [warning] [remote_192_168_0_175] vm.swappiness : 10. recommended: 0 | | system.getenforce | all pass | | system.kernel_bad_version | all pass | | system.core_pattern | [critical] [remote_192_168_0_175] kernel.core_pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h , is not recommended for configuring functions other than the specified core path | | clog.clog_disk_full | all pass | | cluster.syslog_io_bandwidth_limit | all pass | | cluster.sys_obcon_health | all pass | | cluster.cpu_quota_concurrency | [warning] tenant_id: 1, svr_ip: 192.168.0.175. cpu_quota_concurrency is 10, recommended value is 2-4. | | cluster.no_leader | all pass | | cluster.sys_log_level | all pass | | cluster.ob_enable_plan_cache_bad_version | [warning] Unadapted by version. SKIP | | cluster.observer_port | [warning] node: remote_192_168_0_175. nc command not exist, please install nc command | | cluster.server_permanent_offline_time | all pass | | cluster.table_history_too_many | [warning] Unadapted by version. SKIP | | cluster.mod_too_large | all pass | | cluster.task_opt_stat | all pass | | cluster.tenant_number | all pass | | cluster.upgrade_finished | all pass | | cluster.part_trans_action_max | [warning] Unadapted by version. SKIP | | cluster.default_compress_func | all pass | | cluster.optimizer_better_inlist_costing_parmmeter | [warning] Unadapted by version. SKIP | | cluster.large_query_threshold | [warning] svr_ip: 192.168.0.175. large_query_threshold is 600s, recommended value is 5s. | | cluster.memory_chunk_cache_size | all pass | | cluster.memstore_limit_percentage | all pass | | cluster.freeze_trigger_percentage | all pass | | cluster.global_indexes_too_much | all pass | | cluster.datafile_next | all pass | | cluster.deadlocks | all pass | | cluster.zone_not_active | all pass | | cluster.enable_lock_priority | [warning] observer version is 4.3.4.0, which is more than 4.3.0.0. | | cluster.trace_log_slow_query_watermark | all pass | | cluster.resource_limit_max_session_num | all pass | | cluster.cgroup | [warning] node: remote_192_168_0_175 cgroup path is not exist. Tenant isolation not enabled. issue #849 | | cluster.data_path_settings | [critical] [remote_192_168_0_175] ip:192.168.0.175 ,data_dir and log_dir_disk are on the same disk. | | cluster.clog_sync_time_warn_threshold | all pass | | cluster.ob_enable_prepared_statement | all pass | | cluster.core_file_find | all pass | | cluster.ls_nu | all pass | | cluster.task_opt_stat_gather_fail | all pass | | cluster.memory_limit_percentage | all pass | | cluster.auto_increment_cache_size | [warning] tenant_id: 1002 auto_increment_cache_size is 1000000, default value is 1000000 | | | [warning] tenant_id: 1003 auto_increment_cache_size is 1000000, default value is 1000000 | | | [warning] tenant_id: 1004 auto_increment_cache_size is 1000000, default value is 1000000 | | | [warning] tenant_id: 1 auto_increment_cache_size is 1000000, default value is 1000000 | | | [warning] tenant_id: 1001 auto_increment_cache_size is 1000000, default value is 1000000 | | cluster.autoinc_cache_refresh_interval | all pass | | cluster.major | all pass | | cluster.upper_trans_version | all pass | | cluster.observer_not_active | all pass | | disk.xfs_repair | all pass | | disk.sstable_abnormal_file | all pass | | disk.disk_hole | all pass | | disk.mount_disk_full | all pass | | disk.clog_abnormal_file | all pass | | disk.disk_full | all pass | | disk.disk_iops | all pass | | cpu.oversold | all pass | | bugs.cgroup_kernel_bad_version | all pass | | bugs.bug_469 | [critical] [remote_192_168_0_175] glibc version need less 2.34. This may cause observer crash. More information： https://github.com/oceanbase/obdiag/issues/469 | | bugs.bug_385 | [warning] Unadapted by version. SKIP | | bugs.bug_182 | all pass | | log.log_size_with_ocp | all pass | | log.log_size | [warning] node: 192.168.0.175 max_syslog_file_count is 4, please check. the recommended is 0 or over 100 | | table.macroblock_utilization_rate_table | all pass | | table.information_schema_tables_two_data | all pass | | network.TCP-retransmission | [critical] [remote_192_168_0_175] tsar is not installed. we can not check tcp retransmission. | | network.network_offset | all pass | | network.network_speed | [critical] [remote_192_168_0_175] network_speed is null , can not get real speed | | network.network_drop | all pass | +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+