老师好,目前还是卡住状态,取了相关信息如下,sql查询结果在 major_select.txt
major_select.txt (84.2 KB)
[root@10-186-64-160-ocp ~]# obdiag display-trace ec03bd6e-1970-11ef-9a74-02000aba40a0
[2024-05-24 09:57:05.849] [DEBUG] - cmd: []
[2024-05-24 09:57:05.850] [DEBUG] - opts: {‘scene’: ‘major_hold’, ‘store_dir’: ‘./rca/’, ‘input_parameters’: None, ‘c’: ‘/root/.obdiag/config.yml’}
[2024-05-24 09:57:05.851] [DEBUG] - mkdir /usr/local/oceanbase-diagnostic-tool/conf/inner_config.yml
[2024-05-24 09:57:05.861] [DEBUG] - mkdir /root/.obdiag/config.yml
[2024-05-24 09:57:07.478] [DEBUG] - connect databse …
[2024-05-24 09:57:07.482] [DEBUG] - RCAHandler.init store dir: ./rca/
[2024-05-24 09:57:07.482] [DEBUG] - rca result save_path is :./rca/
[2024-05-24 09:57:07.483] [DEBUG] - start get_observer_version_by_sql . input: {‘ob_cluster_name’: ‘obcluster’, ‘db_host’: ‘10.186.64.161’, ‘db_port’: ‘2883’, ‘tenant_sys’: {‘user’: ‘root@sys#ob4214’, ‘password’: ‘ZZQzzq123!!’}, ‘servers’: [{‘ip’: ‘10.186.64.161’, ‘ssh_username’: ‘root’, ‘ssh_password’: ‘ZZQzzq123’, ‘ssh_port’: ‘22’, ‘home_path’: ‘/home/admin/oceanbase’, ‘data_dir’: ‘/data/1’, ‘redo_dir’: ‘/data/log1’, ‘ssh_key_file’: ‘’, ‘ssh_type’: ‘remote’, ‘container_name’: None, ‘host_type’: ‘OBSERVER’, ‘ssher’: <common.ssh.SshHelper object at 0x7f6521efdc10>}, {‘ip’: ‘10.186.64.162’, ‘ssh_username’: ‘root’, ‘ssh_password’: ‘ZZQzzq123’, ‘ssh_port’: ‘22’, ‘home_path’: ‘/home/admin/oceanbase’, ‘data_dir’: ‘/data/1’, ‘redo_dir’: ‘/data/log1’, ‘ssh_key_file’: ‘’, ‘ssh_type’: ‘remote’, ‘container_name’: None, ‘host_type’: ‘OBSERVER’, ‘ssher’: <common.ssh.SshHelper object at 0x7f6521efdcd0>}, {‘ip’: ‘10.186.64.163’, ‘ssh_username’: ‘root’, ‘ssh_password’: ‘ZZQzzq123’, ‘ssh_port’: ‘22’, ‘home_path’: ‘/home/admin/oceanbase’, ‘data_dir’: ‘/data/1’, ‘redo_dir’: ‘/data/log1’, ‘ssh_key_file’: ‘’, ‘ssh_type’: ‘remote’, ‘container_name’: None, ‘host_type’: ‘OBSERVER’, ‘ssher’: <common.ssh.SshHelper object at 0x7f6521ee7c10>}]}
[2024-05-24 09:57:07.490] [DEBUG] - connect databse …
[2024-05-24 09:57:07.504] [DEBUG] - get_observer_version_by_sql ob_version_info is (‘5.7.25-OceanBase-v4.2.1.4’,)
[2024-05-24 09:57:07.505] [DEBUG] - RCAHandler.init get observer version: 4.2.1.4
[2024-05-24 09:57:07.505] [DEBUG] - RCAHandler.init get observer version: 4.2.1.4
[2024-05-24 09:57:07.505] [DEBUG] - [remote host 10.186.64.161] run cmd = [/home/admin/obproxy/bin/obproxy --version] start …
[2024-05-24 09:57:08.020] [DEBUG] - get obproxy version, run cmd = [/home/admin/obproxy/bin/obproxy --version]
[2024-05-24 09:57:08.021] [DEBUG] - [remote host 10.186.64.161] run cmd = [export LD_LIBRARY_PATH=/home/admin/obproxy/lib && /home/admin/obproxy/bin/obproxy --version] start …
[2024-05-24 09:57:08.113] [DEBUG] - get obproxy version with LD_LIBRARY_PATH,cmd:export LD_LIBRARY_PATH=/home/admin/obproxy/lib && /home/admin/obproxy/bin/obproxy --version, result:/home/admin/obproxy/bin/obproxy --version
[2024-05-24 09:57:08.114] [DEBUG] obproxy (OceanBase 4.1.0.0 20230323104822.el7)
[2024-05-24 09:57:08.114] [DEBUG] REVISION: 20230323104822-f00479cbe865e81c72211d398890b8058e5ea361
[2024-05-24 09:57:08.115] [DEBUG] BUILD_TIME: Mar 23 2023 10:55:16
[2024-05-24 09:57:08.115] [DEBUG] BUILD_FLAGS: -g -O2 -D_OB_VERSION=1000 -D_NO_EXCEPTION -D__STDC_LIMIT_MACROS -D__STDC_CONSTANT_MACROS -DNDEBUG -D__USE_LARGEFILE64 -D_FILE_OFFSET_BITS=64 -D_LARGE_FILE -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE -Wall -Wextra -Wunused-parameter -Wformat -Wconversion -Wno-deprecated -Wno-invalid-offsetof -finline-functions -fno-strict-aliasing -mtune=core2 -Wno-psabi -Wno-sign-compare -Wno-class-memaccess -Wno-deprecated-copy -Wno-ignored-qualifiers -Wno-aligned-new -Wno-format-truncation -Wno-literal-suffix -Wno-format-overflow -Wno-stringop-truncation -Wno-memset-elt-size -Wno-cast-function-type -Wno-address-of-packed-member -fno-omit-frame-pointer -fuse-ld=lld -ffunction-sections -Wl,–no-warn-symbol-ordering,–symbol-ordering-file,//home/admin/252_20230323104822694_475145676_code/rpm_workspace/obproxy-tmp.1388/BUILD/obproxy-4.1.0.0/hotfuncs.txt -DGCC_52 -DSUPPORT_SSE4_2 -DHAVE_SCHED_GETCPU -DHAVE_REALTIME_COARSE -DOB_HAVE_EVENTFD -DHAVE_FALLOCATE -DHAVA_BEYONDTRUST -DHAVE_MINIDUMP -Werror
[2024-05-24 09:57:08.115] [DEBUG]
[2024-05-24 09:57:08.115] [DEBUG] Copyright (c) 2007-2020 Alipay Inc.
[2024-05-24 09:57:08.115] [DEBUG]
[2024-05-24 09:57:08.116] [DEBUG] - RCAHandler.init get obproxy version: 4.1.0.0
[2024-05-24 09:57:08.116] [DEBUG] - RCAHandler.init get obproxy version: 4.1.0.0
[2024-05-24 09:57:08.151] [DEBUG] - RCAHandler init.cluster:obcluster, init.nodes:[{‘ip’: ‘10.186.64.161’, ‘ssh_username’: ‘root’, ‘ssh_port’: ‘22’, ‘home_path’: ‘/home/admin/oceanbase’, ‘data_dir’: ‘/data/1’, ‘redo_dir’: ‘/data/log1’, ‘ssh_key_file’: ‘’, ‘ssh_type’: ‘remote’, ‘container_name’: None, ‘host_type’: ‘OBSERVER’, ‘ssher’: <common.ssh.SshHelper object at 0x7f6521efdc10>}, {‘ip’: ‘10.186.64.162’, ‘ssh_username’: ‘root’, ‘ssh_port’: ‘22’, ‘home_path’: ‘/home/admin/oceanbase’, ‘data_dir’: ‘/data/1’, ‘redo_dir’: ‘/data/log1’, ‘ssh_key_file’: ‘’, ‘ssh_type’: ‘remote’, ‘container_name’: None, ‘host_type’: ‘OBSERVER’, ‘ssher’: <common.ssh.SshHelper object at 0x7f6521efdcd0>}, {‘ip’: ‘10.186.64.163’, ‘ssh_username’: ‘root’, ‘ssh_port’: ‘22’, ‘home_path’: ‘/home/admin/oceanbase’, ‘data_dir’: ‘/data/1’, ‘redo_dir’: ‘/data/log1’, ‘ssh_key_file’: ‘’, ‘ssh_type’: ‘remote’, ‘container_name’: None, ‘host_type’: ‘OBSERVER’, ‘ssher’: <common.ssh.SshHelper object at 0x7f6521ee7c10>}], init.obproxy_nodes:[{‘ip’: ‘10.186.64.161’, ‘ssh_username’: ‘root’, ‘ssh_port’: ‘22’, ‘home_path’: ‘/home/admin/obproxy’, ‘ssh_key_file’: ‘’, ‘ssh_type’: ‘ssh’, ‘container_name’: None, ‘host_type’: ‘OBPROXY’, ‘ssher’: <common.ssh.SshHelper object at 0x7f652043f880>}], init.store_dir:./rca/
[2024-05-24 09:57:08.152] [DEBUG] - major_hold store_dir:./rca//major_hold_20240524095708
[2024-05-24 09:57:08.152] [DEBUG] - major_hold init success
[2024-05-24 09:57:08.526] [WARNING] rca_scene.execute not need execute: MajorHoldScene not need execute