obdiag display-trace 6f5abf0c-b532-11ef-a796-000c29d56c49
[2024-12-08 15:02:49.306] [DEBUG] - cmd: obdiag gather plan_monitor
[2024-12-08 15:02:49.307] [DEBUG] - opts: {‘inner_config’: None, ‘trace_id’: ‘YB42C0A80840-000628952282B8F4-0-0’, ‘store_dir’: ‘./’, ‘env’: None, ‘c’: ‘/root/.obdiag/config.yml’, ‘config’: None}
[2024-12-08 15:02:49.307] [DEBUG] - mkdir /usr/local/oceanbase-diagnostic-tool/conf/inner_config.yml
[2024-12-08 15:02:49.311] [DEBUG] - mkdir /root/.obdiag/config.yml
[2024-12-08 15:02:49.316] [INFO] gather_plan_monitor start …
[2024-12-08 15:02:49.627] [DEBUG] - connect databse …
[2024-12-08 15:02:49.633] [DEBUG] - Detected MySQL mode successful, Database version: OceanBase_CE 4.3.4.0 (r100000162024110717-82547d6edc6ea98ba710e376a736a9a850499a06) (Built Nov 7 2024 17:28:11)
[2024-12-08 15:02:49.634] [DEBUG] - Use ./obdiag_gather_pack_20241208150249 as pack dir.
[2024-12-08 15:02:49.634] [DEBUG] - mkdir ./obdiag_gather_pack_20241208150249
[2024-12-08 15:02:49.634] [DEBUG] - [cs resource path] : /usr/local/oceanbase-diagnostic-tool/resources
[2024-12-08 15:02:49.635] [DEBUG] - [sql plan monitor report task] start
[2024-12-08 15:02:55.862] [DEBUG] - TraceID : YB42C0A80840-000628952282B8F4-0-0
[2024-12-08 15:02:55.862] [DEBUG] - SQL : /* ApplicationName=DBeaver 23.2.5 - SQLEditor <Script-41.sql> / SELECT DATABASE()
[2024-12-08 15:02:55.862] [DEBUG] - SVR_IP : 192.168.1.164
[2024-12-08 15:02:55.862] [DEBUG] - SVR_PORT : 2882
[2024-12-08 15:02:55.862] [DEBUG] - DB: douyin
[2024-12-08 15:02:55.862] [DEBUG] - PLAN_ID: 659
[2024-12-08 15:02:55.862] [DEBUG] - TENANT_NAME: deep
[2024-12-08 15:02:55.862] [DEBUG] - TENANT_ID: 1002
[2024-12-08 15:02:55.862] [DEBUG] - [sql plan monitor report task] report header
[2024-12-08 15:02:55.863] [DEBUG] - report header complete
[2024-12-08 15:02:55.863] [DEBUG] - [sql plan monitor report task] report sql_audit
[2024-12-08 15:02:55.863] [DEBUG] - select sql_audit from ob with SQL:
[2024-12-08 15:03:01.720] [DEBUG] - sql_audit_result: ±----------------------------------±-----------------------------------------------------------------------------------±------------±---------------------------±---------------------------±-------------±------------±----------±--------±--------±----------±-----------------------------±-------------±---------+
[2024-12-08 15:03:01.722] [DEBUG] - report sql_audit_result to file start …
[2024-12-08 15:03:01.722] [DEBUG] - report sql_audit_result end
[2024-12-08 15:03:01.722] [DEBUG] - [sql plan monitor report task] report plan explain, sql: [/ ApplicationName=DBeaver 23.2.5 - SQLEditor <Script-41.sql> / SELECT DATABASE()]
[2024-12-08 15:03:01.725] [DEBUG] - execute SQL: explain extended / ApplicationName=DBeaver 23.2.5 - SQLEditor <Script-41.sql> */ SELECT DATABASE()
[2024-12-08 15:03:01.725] [DEBUG] - report sql_explain_result_sql complete
[2024-12-08 15:03:01.725] [DEBUG] - report sql_explain_result_sql complete
[2024-12-08 15:03:01.727] [DEBUG] - report sql_explain_result complete
[2024-12-08 15:03:01.727] [DEBUG] - [sql plan monitor report task] report plan cache
[2024-12-08 15:03:01.742] [DEBUG] - select plan_explain from ob complete
[2024-12-08 15:03:01.742] [DEBUG] - report plan_explain_sql complete
[2024-12-08 15:03:01.743] [DEBUG] - report plan_explain complete
[2024-12-08 15:03:01.743] [DEBUG] - [sql plan monitor report task] report table schema
[2024-12-08 15:03:01.763] [DEBUG] - table info file path:./obdiag_tabledump_result_20241208150249.txt
[2024-12-08 15:03:01.763] [WARNING] [Errno 2] No such file or directory: ‘./obdiag_tabledump_result_20241208150249.txt’
[2024-12-08 15:03:02.188] [DEBUG] - init sql plan monitor stat complete
[2024-12-08 15:03:02.188] [DEBUG] - [sql plan monitor report task] report sql_audit details
[2024-12-08 15:03:12.179] [ERROR] command failed. Please contact OceanBase community. e: (2013, ‘Lost connection to MySQL server during query’)
[2024-12-08 15:03:12.179] [INFO] Trace ID: 6f5abf0c-b532-11ef-a796-000c29d56c49
[2024-12-08 15:03:12.180] [INFO] If you want to view detailed obdiag logs, please run: obdiag display-trace 6f5abf0c-b532-11ef-a796-000c29d56c49
obcluster:
ob_cluster_name: obcluster
db_host: 192.168.1.192
db_port: ‘2883’
tenant_sys:
user: root@deep#deep
password: ***
servers:
nodes:
- ip: 192.168.1.164
- ip: 192.168.1.165
- ip: 192.168.1.166
global:
ssh_username: root
ssh_password: ***
ssh_port: ‘22’
ssh_key_file: ‘’
home_path: /root/observer
data_dir: /root/observer/store
redo_dir: /root/observer/store
obproxy:
obproxy_cluster_name: obproxy
servers:
nodes:
- ip: 192.168.1.164
- ip: 192.168.1.165
- ip: 192.168.1.166
global:
ssh_username: root
ssh_password: ***
ssh_port: ‘22’
ssh_key_file: ‘’
home_path: /home/admin/obproxy