[root@host-19-135-100-238 .obdiag]# obdiag display-trace 087797b4-2c58-11ef-96fc-fa163e4fd9ae [2024-06-17 11:16:48.257] [DEBUG] - cmd: [] [2024-06-17 11:16:48.258] [DEBUG] - opts: {'scene': 'lock_conflict', 'store_dir': './rca/', 'input_parameters': None, 'c': '/root/.obdiag/config.yml'} [2024-06-17 11:16:48.258] [DEBUG] - mkdir /usr/local/oceanbase-diagnostic-tool/conf/inner_config.yml [2024-06-17 11:16:48.261] [DEBUG] - mkdir /root/.obdiag/config.yml [2024-06-17 11:17:18.891] [DEBUG] - connect databse ... [2024-06-17 11:17:18.891] [DEBUG] - RCAHandler.init store dir: ./rca/ [2024-06-17 11:17:18.891] [DEBUG] - rca result save_path is :./rca/ [2024-06-17 11:17:18.891] [DEBUG] - start get_observer_version_by_sql . input: {'ob_cluster_name': 'smzOB', 'db_host': '19.135.100.159', 'db_port': '2883', 'tenant_sys': {'user': 'root@sys#smzOB', 'password': ''}, 'servers': [{'ip': '19.135.100.159', 'ssh_username': 'root', 'ssh_password': '', 'ssh_port': '65181', 'home_path': '/data/smzOB/', 'data_dir': '/root/observer/store', 'redo_dir': '/root/observer/store', 'ssh_key_file': '', 'ssh_type': 'remote', 'container_name': None, 'host_type': 'OBSERVER', 'ssher': }, {'ip': '19.135.101.147', 'ssh_username': 'root', 'ssh_password': '', 'ssh_port': '65181', 'home_path': '/data/smzOB/', 'data_dir': '/root/observer/store', 'redo_dir': '/root/observer/store', 'ssh_key_file': '', 'ssh_type': 'remote', 'container_name': None, 'host_type': 'OBSERVER', 'ssher': }, {'ip': '19.135.101.168', 'ssh_username': 'root', 'ssh_password': '', 'ssh_port': '65181', 'home_path': '/data/smzOB/', 'data_dir': '/root/observer/store', 'redo_dir': '/root/observer/store', 'ssh_key_file': '', 'ssh_type': 'remote', 'container_name': None, 'host_type': 'OBSERVER', 'ssher': }]} [2024-06-17 11:17:18.894] [DEBUG] - connect databse ... [2024-06-17 11:17:18.895] [DEBUG] - get_observer_version_by_sql ob_version_info is ('5.7.25-OceanBase_CE-v4.2.1.3',) [2024-06-17 11:17:18.895] [DEBUG] - RCAHandler.init get observer version: 4.2.1.3 [2024-06-17 11:17:18.895] [DEBUG] - RCAHandler.init get observer version: 4.2.1.3 [2024-06-17 11:17:18.895] [DEBUG] - [remote host 19.135.101.168] run cmd = [/data/smzOBProxy/obproxy/bin/obproxy --version] start ... [2024-06-17 11:17:18.986] [DEBUG] - get obproxy version, run cmd = [/data/smzOBProxy/obproxy/bin/obproxy --version] [2024-06-17 11:17:18.986] [DEBUG] - [remote host 19.135.101.168] run cmd = [export LD_LIBRARY_PATH=/data/smzOBProxy/obproxy/lib && /data/smzOBProxy/obproxy/bin/obproxy --version] start ... [2024-06-17 11:17:19.059] [DEBUG] - get obproxy version with LD_LIBRARY_PATH,cmd:export LD_LIBRARY_PATH=/data/smzOBProxy/obproxy/lib && /data/smzOBProxy/obproxy/bin/obproxy --version, result:/data/smzOBProxy/obproxy/bin/obproxy --version [2024-06-17 11:17:19.059] [DEBUG] obproxy (OceanBase 4.2.1.0 11) [2024-06-17 11:17:19.060] [DEBUG] REVISION: 1-local-6599462fc897a4a46734d64585906ea80975a656 [2024-06-17 11:17:19.060] [DEBUG] BUILD_TIME: Oct 12 2023 21:03:30 [2024-06-17 11:17:19.060] [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 -Wno-unused-parameter -Wformat -Wno-conversion -Wno-deprecated -Wno-invalid-offsetof -Wno-unused-result -Wno-format-security -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 -Wl,-z,noexecstack,-z,relro,-z,now,-z,notext -fPIC -DGCC_52 -D_GLIBCXX_USE_CXX11_ABI=0 -DSUPPORT_SSE4_2 -DHAVE_SCHED_GETCPU -DHAVE_REALTIME_COARSE -DOB_HAVE_EVENTFD -DHAVE_FALLOCATE -I/home/jenkins/agent/workspace/rpm-obproxy-ce-4.2.1.0-1.1.18/ob_source_code_dir/deps/3rd/usr/local/oceanbase/deps/devel/include -I/home/jenkins/agent/workspace/rpm-obproxy-ce-4.2.1.0-1.1.18/ob_source_code_dir/deps/3rd/usr/local/oceanbase/deps/devel/include/mariadb -I/home/jenkins/agent/workspace/rpm-obproxy-ce-4.2.1.0-1.1.18/ob_source_code_dir/deps/3rd/usr/include -Werror [2024-06-17 11:17:19.060] [DEBUG] [2024-06-17 11:17:19.060] [DEBUG] Copyright (c) 2021 OceanBase [2024-06-17 11:17:19.060] [DEBUG] OceanBase Database Proxy(ODP) is licensed under Mulan PubL v2. [2024-06-17 11:17:19.060] [DEBUG] You can use this software according to the terms and conditions of the Mulan PubL v2. [2024-06-17 11:17:19.060] [DEBUG] You may obtain a copy of Mulan PubL v2 at: [2024-06-17 11:17:19.060] [DEBUG] http://license.coscl.org.cn/MulanPubL-2.0 [2024-06-17 11:17:19.060] [DEBUG] THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND, [2024-06-17 11:17:19.060] [DEBUG] EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT, [2024-06-17 11:17:19.060] [DEBUG] MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE. [2024-06-17 11:17:19.060] [DEBUG] See the Mulan PubL v2 for more details. [2024-06-17 11:17:19.060] [DEBUG] [2024-06-17 11:17:19.060] [DEBUG] - RCAHandler.init get obproxy version: 4.2.1.0 [2024-06-17 11:17:19.060] [DEBUG] - RCAHandler.init get obproxy version: 4.2.1.0 [2024-06-17 11:17:19.069] [DEBUG] - RCAHandler init.cluster:smzOB, init.nodes:[{'ip': '19.135.100.159', 'ssh_username': 'root', 'ssh_port': '65181', 'home_path': '/data/smzOB/', 'data_dir': '/root/observer/store', 'redo_dir': '/root/observer/store', 'ssh_key_file': '', 'ssh_type': 'remote', 'container_name': None, 'host_type': 'OBSERVER', 'ssher': }, {'ip': '19.135.101.147', 'ssh_username': 'root', 'ssh_port': '65181', 'home_path': '/data/smzOB/', 'data_dir': '/root/observer/store', 'redo_dir': '/root/observer/store', 'ssh_key_file': '', 'ssh_type': 'remote', 'container_name': None, 'host_type': 'OBSERVER', 'ssher': }, {'ip': '19.135.101.168', 'ssh_username': 'root', 'ssh_port': '65181', 'home_path': '/data/smzOB/', 'data_dir': '/root/observer/store', 'redo_dir': '/root/observer/store', 'ssh_key_file': '', 'ssh_type': 'remote', 'container_name': None, 'host_type': 'OBSERVER', 'ssher': }], init.obproxy_nodes:[{'ip': '19.135.101.168', 'ssh_username': 'root', 'ssh_port': '65181', 'home_path': '/data/smzOBProxy/obproxy', 'ssh_key_file': '', 'ssh_type': 'ssh', 'container_name': None, 'host_type': 'OBPROXY', 'ssher': }, {'ip': '19.135.100.159', 'ssh_username': 'root', 'ssh_port': '65181', 'home_path': '/data/smzOBProxy/obproxy', 'ssh_key_file': '', 'ssh_type': 'ssh', 'container_name': None, 'host_type': 'OBPROXY', 'ssher': }, {'ip': '19.135.101.147', 'ssh_username': 'root', 'ssh_port': '65181', 'home_path': '/data/smzOBProxy/obproxy', 'ssh_key_file': '', 'ssh_type': 'ssh', 'container_name': None, 'host_type': 'OBPROXY', 'ssher': }], init.store_dir:./rca/ [2024-06-17 11:17:19.069] [DEBUG] - lock_conflict store_dir:./rca//lock_conflict_20240617111719 [2024-06-17 11:17:19.069] [DEBUG] - lock_conflict init success [2024-06-17 11:17:19.081] [WARNING] rca_scene.execute not need execute: No block lock found. [2024-06-17 11:17:19.081] [DEBUG] - save record to ./rca//lock_conflict_20240617111719/record [2024-06-17 11:17:19.081] [INFO] rca finished. For more details, the result on './rca//lock_conflict_20240617111719' [2024-06-17 11:17:19.081] [INFO] You can get the suggest by 'cat ./rca//lock_conflict_20240617111719/record' [2024-06-17 11:17:19.082] [INFO] Trace ID: 087797b4-2c58-11ef-96fc-fa163e4fd9ae [2024-06-17 11:17:19.082] [INFO] If you want to view detailed obdiag logs, please run: obdiag display-trace 087797b4-2c58-11ef-96fc-fa163e4fd9ae