[root@HWD ~]# obd obdiag analyze log demo
Get local repositories and plugins ok
The tool oceanbase-diagnostic-tool is already installed the latest version 2.6.0
Open ssh connection ok
analyze_log start ...
analyze nodes's log start. Please wait a moment...
analyze start ok
FileListInfo:
+-----------+--------------------------------------------------------------------------------------------------------------------------------------------+
| Node      | LogList                                                                                                                                    |
+===========+============================================================================================================================================+
| 127.0.0.1 | ['election.log', 'observer.log', 'observer.log.20250227142448984', 'observer.log.20250227144459184', 'observer.log.wf', 'rootservice.log'] |
+-----------+--------------------------------------------------------------------------------------------------------------------------------------------+
Analyze OceanBase Online Log Summary:
+-----------+----------+------------+-------------+-----------+---------+
| Node      | Status   | FileName   | ErrorCode   | Message   | Count   |
+===========+==========+============+=============+===========+=========+
| 127.0.0.1 | PASS     |            |             |           |         |
+-----------+----------+------------+-------------+-----------+---------+
For more details, please run cmd ' cat /root/obdiag_analyze_pack_20250227144955/result_details.txt '
Trace ID: 0da6273a-f4d7-11ef-9575-000c29f3ac8a
If you want to view detailed obdiag logs, please run: /root/oceanbase-diagnostic-tool/obdiag display-trace 0da6273a-f4d7-11ef-9575-000c29f3ac8a

Trace ID: 0c008a74-f4d7-11ef-b07d-000c29f3ac8a
If you want to view detailed obd logs, please run: obd display-trace 0c008a74-f4d7-11ef-b07d-000c29f3ac8a
[root@HWD ~]# cat /root/obdiag_analyze_pack_20250227144955/result_details.txt

Analyze OceanBase Online Log Summary:
+-----------+----------+------------+-------------+-----------+---------+
| Node      | Status   | FileName   | ErrorCode   | Message   | Count   |
+===========+==========+============+=============+===========+=========+
| 127.0.0.1 | PASS     |            |             |           |         |
+-----------+----------+------------+-------------+-----------+---------+

Details:

Node: 127.0.0.1
Status: PASS
FileName: None
ErrorCode: None
Message: None
Count: None
Cause: None
Solution: None
First Found Time: None
Last Found Time: None
Trace_IDS: None

[root@HWD ~]# obd display-trace 0c008a74-f4d7-11ef-b07d-000c29f3ac8a
[2025-02-27 14:49:52.828] [DEBUG] - cmd: ['demo']
[2025-02-27 14:49:52.829] [DEBUG] - opts: {'from': None, 'to': None, 'since': '30m', 'scope': 'all', 'grep': None, 'log_level': None, 'files': None, 'store_dir': './', 'obdiag_dir': '/root/oceanbase-diagnostic-tool'}
[2025-02-27 14:49:52.829] [DEBUG] - mkdir /root/.obd/lock/
[2025-02-27 14:49:52.829] [DEBUG] - set lock mode to NO_LOCK(0)
[2025-02-27 14:49:52.829] [DEBUG] - Get Deploy by name
[2025-02-27 14:49:52.829] [DEBUG] - mkdir /root/.obd/cluster/
[2025-02-27 14:49:52.829] [DEBUG] - mkdir /root/.obd/config_parser/
[2025-02-27 14:49:52.830] [DEBUG] - Get deploy configuration
[2025-02-27 14:49:52.842] [INFO] Get local repositories and plugins
[2025-02-27 14:49:52.843] [DEBUG] - mkdir /root/.obd/repository
[2025-02-27 14:49:52.843] [DEBUG] - Get local repository oceanbase-ce-4.2.5.2-31136fbbde2596cbc15275495a6db0703e0a9b63
[2025-02-27 14:49:52.973] [DEBUG] - mkdir /root/.obd/mirror
[2025-02-27 14:49:52.973] [DEBUG] - mkdir /root/.obd/mirror/remote
[2025-02-27 14:49:52.973] [DEBUG] - mkdir /root/.obd/mirror/local
[2025-02-27 14:49:52.974] [DEBUG] - load repo config: /root/.obd/mirror/remote/OceanBase.repo
[2025-02-27 14:49:52.974] [DEBUG] - open /root/.obd/mirror/remote/OceanBase.repo for r
[2025-02-27 14:49:52.975] [DEBUG] - md5 is None
[2025-02-27 14:49:52.975] [DEBUG] - name is oceanbase-diagnostic-tool
[2025-02-27 14:49:52.975] [DEBUG] - arch is ['ia32e', 'x86_64', 'athlon', 'i686', 'i586', 'i486', 'i386', 'noarch']
[2025-02-27 14:49:52.975] [DEBUG] - release is None
[2025-02-27 14:49:52.975] [DEBUG] - version is None
[2025-02-27 14:49:52.975] [DEBUG] - min_version is None
[2025-02-27 14:49:52.975] [DEBUG] - max_version is None
[2025-02-27 14:49:52.975] [DEBUG] - MirrorRepositoryType.LOCAL mirror local found pkg: name: oceanbase-diagnostic-tool
[2025-02-27 14:49:52.975] [DEBUG] version: 2.6.0
[2025-02-27 14:49:52.975] [DEBUG] release:12024112811.el7
[2025-02-27 14:49:52.976] [DEBUG] arch: x86_64
[2025-02-27 14:49:52.976] [DEBUG] md5: a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.976] [DEBUG] size: 59133272
[2025-02-27 14:49:52.976] [DEBUG] - get RPM package by name: oceanbase-diagnostic-tool
[2025-02-27 14:49:52.976] [DEBUG] version: 2.6.0
[2025-02-27 14:49:52.976] [DEBUG] release:12024112811.el7
[2025-02-27 14:49:52.976] [DEBUG] arch: x86_64
[2025-02-27 14:49:52.976] [DEBUG] md5: a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.976] [DEBUG] size: 59133272
[2025-02-27 14:49:52.976] [DEBUG] - mkdir /root/.obd/repository/oceanbase-diagnostic-tool/2.6.0/a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.979] [DEBUG] - mkdir /root/.obd/plugins
[2025-02-27 14:49:52.979] [DEBUG] - Call plugin oceanbase-diagnostic-tool-py_script_pre_check-1.0 for oceanbase-diagnostic-tool-2.6.0-12024112811.el7-a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.980] [DEBUG] - mkdir /root/.obd/optimize/
[2025-02-27 14:49:52.980] [DEBUG] - mkdir /root/.obd/tool/
[2025-02-27 14:49:52.980] [DEBUG] - import pre_check
[2025-02-27 14:49:52.981] [DEBUG] - add pre_check ref count to 1
[2025-02-27 14:49:52.981] [DEBUG] -- mkdir ./
[2025-02-27 14:49:52.981] [DEBUG] - sub pre_check ref count to 0
[2025-02-27 14:49:52.981] [DEBUG] - export pre_check
[2025-02-27 14:49:52.981] [DEBUG] - plugin oceanbase-diagnostic-tool-py_script_pre_check-1.0 result: True
[2025-02-27 14:49:52.981] [DEBUG] - mkdir /root/.obd/tool/
[2025-02-27 14:49:52.983] [DEBUG] - Search repository oceanbase-diagnostic-tool version: 2.6.0, tag: None, release: None, package_hash: a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.983] [DEBUG] - mkdir /root/.obd/repository/oceanbase-diagnostic-tool
[2025-02-27 14:49:52.983] [DEBUG] - Found repository oceanbase-diagnostic-tool-2.6.0-12024112811.el7-a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.983] [DEBUG] - Try to update oceanbase-diagnostic-tool
[2025-02-27 14:49:52.985] [DEBUG] - Search repository oceanbase-diagnostic-tool version: 2.6.0, tag: None, release: None, package_hash: a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.985] [DEBUG] - Found repository oceanbase-diagnostic-tool-2.6.0-12024112811.el7-a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.986] [DEBUG] - Search repository oceanbase-diagnostic-tool version: 2.6.0, tag: None, release: None, package_hash: a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.986] [DEBUG] - Found repository oceanbase-diagnostic-tool-2.6.0-12024112811.el7-a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.986] [DEBUG] - load repo config: /root/.obd/mirror/remote/OceanBase.repo
[2025-02-27 14:49:52.987] [DEBUG] - md5 is None
[2025-02-27 14:49:52.987] [DEBUG] - name is oceanbase-diagnostic-tool
[2025-02-27 14:49:52.987] [DEBUG] - arch is ['ia32e', 'x86_64', 'athlon', 'i686', 'i586', 'i486', 'i386', 'noarch']
[2025-02-27 14:49:52.987] [DEBUG] - release is None
[2025-02-27 14:49:52.987] [DEBUG] - version is None
[2025-02-27 14:49:52.987] [DEBUG] - min_version is None
[2025-02-27 14:49:52.987] [DEBUG] - max_version is None
[2025-02-27 14:49:52.987] [DEBUG] - MirrorRepositoryType.LOCAL mirror local found pkg: name: oceanbase-diagnostic-tool
[2025-02-27 14:49:52.987] [DEBUG] version: 2.6.0
[2025-02-27 14:49:52.987] [DEBUG] release:12024112811.el7
[2025-02-27 14:49:52.987] [DEBUG] arch: x86_64
[2025-02-27 14:49:52.987] [DEBUG] md5: a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.987] [DEBUG] size: 59133272
[2025-02-27 14:49:52.987] [DEBUG] - get RPM package by name: oceanbase-diagnostic-tool
[2025-02-27 14:49:52.987] [DEBUG] version: 2.6.0
[2025-02-27 14:49:52.987] [DEBUG] release:12024112811.el7
[2025-02-27 14:49:52.987] [DEBUG] arch: x86_64
[2025-02-27 14:49:52.987] [DEBUG] md5: a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.987] [DEBUG] size: 59133272
[2025-02-27 14:49:52.989] [DEBUG] - Search repository oceanbase-diagnostic-tool version: 2.6.0, tag: None, release: None, package_hash: a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.989] [DEBUG] - Found repository oceanbase-diagnostic-tool-2.6.0-12024112811.el7-a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.990] [DEBUG] - Search repository oceanbase-diagnostic-tool version: 2.6.0, tag: None, release: None, package_hash: a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.990] [DEBUG] - Found repository oceanbase-diagnostic-tool-2.6.0-12024112811.el7-a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.990] [INFO] The tool oceanbase-diagnostic-tool is already installed the latest version 2.6.0
[2025-02-27 14:49:52.992] [DEBUG] - Search repository oceanbase-diagnostic-tool version: 2.6.0, tag: None, release: None, package_hash: a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.992] [DEBUG] - Found repository oceanbase-diagnostic-tool-2.6.0-12024112811.el7-a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:52.992] [DEBUG] - Call plugin oceanbase-diagnostic-tool-py_script_generate_config-1.5 for oceanbase-ce-4.2.5.2-102000062025012010.el7-31136fbbde2596cbc15275495a6db0703e0a9b63
[2025-02-27 14:49:52.992] [DEBUG] - mkdir /root/.obd/optimize/
[2025-02-27 14:49:52.993] [INFO] Open ssh connection
[2025-02-27 14:49:53.124] [DEBUG] - import generate_config
[2025-02-27 14:49:53.126] [DEBUG] - add generate_config ref count to 1
[2025-02-27 14:49:53.128] [DEBUG] - sub generate_config ref count to 0
[2025-02-27 14:49:53.128] [DEBUG] - export generate_config
[2025-02-27 14:49:53.129] [DEBUG] - plugin oceanbase-diagnostic-tool-py_script_generate_config-1.5 result: None
[2025-02-27 14:49:53.130] [DEBUG] - Search repository oceanbase-diagnostic-tool version: 2.6.0, tag: None, release: None, package_hash: a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:53.130] [DEBUG] - Found repository oceanbase-diagnostic-tool-2.6.0-12024112811.el7-a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:53.130] [DEBUG] - Call plugin oceanbase-diagnostic-tool-py_script_scene_config-1.6 for oceanbase-ce-4.2.5.2-102000062025012010.el7-31136fbbde2596cbc15275495a6db0703e0a9b63
[2025-02-27 14:49:53.131] [DEBUG] - import scene_config
[2025-02-27 14:49:53.131] [DEBUG] - add scene_config ref count to 1
[2025-02-27 14:49:53.132] [DEBUG] - sub scene_config ref count to 0
[2025-02-27 14:49:53.132] [DEBUG] - export scene_config
[2025-02-27 14:49:53.132] [DEBUG] - plugin oceanbase-diagnostic-tool-py_script_scene_config-1.6 result: True
[2025-02-27 14:49:53.133] [DEBUG] - Search repository oceanbase-diagnostic-tool version: 2.6.0, tag: None, release: None, package_hash: a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:53.133] [DEBUG] - Found repository oceanbase-diagnostic-tool-2.6.0-12024112811.el7-a488eca43f583941b0796de032895ce36fee8fa4
[2025-02-27 14:49:53.133] [DEBUG] - Call plugin oceanbase-diagnostic-tool-py_script_analyze_log-1.3 for oceanbase-ce-4.2.5.2-102000062025012010.el7-31136fbbde2596cbc15275495a6db0703e0a9b63
[2025-02-27 14:49:53.133] [DEBUG] - import analyze_log
[2025-02-27 14:49:53.134] [DEBUG] - add analyze_log ref count to 1
[2025-02-27 14:49:53.134] [DEBUG] -- get option: from value 
[2025-02-27 14:49:53.134] [DEBUG] -- get option: to value 
[2025-02-27 14:49:53.134] [DEBUG] -- get option: scope value all
[2025-02-27 14:49:53.134] [DEBUG] -- get option: since value 30m
[2025-02-27 14:49:53.134] [DEBUG] -- get option: grep value 
[2025-02-27 14:49:53.134] [DEBUG] -- get option: log_level value 
[2025-02-27 14:49:53.135] [DEBUG] -- get option: files value 
[2025-02-27 14:49:53.135] [DEBUG] -- get option: store_dir value ./
[2025-02-27 14:49:53.135] [DEBUG] -- get option: obdiag_dir value /root/oceanbase-diagnostic-tool
[2025-02-27 14:49:53.135] [DEBUG] -- local execute: /root/oceanbase-diagnostic-tool/obdiag 
[2025-02-27 14:49:54.433] [DEBUG] -- exited code 0
[2025-02-27 14:49:54.434] [DEBUG] -- execute cmd: /root/oceanbase-diagnostic-tool/obdiag analyze log --from 2025-02-27 14:19:53 --to 2025-02-27 14:50:53 --scope all --store_dir /root
[2025-02-27 14:49:54.434] [DEBUG] -- local execute: /root/oceanbase-diagnostic-tool/obdiag analyze log --from 2025-02-27 14:19:53 --to 2025-02-27 14:50:53 --scope all --store_dir /root 
[2025-02-27 14:49:55.604] [INFO] analyze_log start ...
[2025-02-27 14:49:55.611] [INFO] analyze nodes's log start. Please wait a moment...
[2025-02-27 14:50:02.432] [INFO] analyze start ok
[2025-02-27 14:50:02.432] [INFO] FileListInfo:
[2025-02-27 14:50:02.432] [INFO] +-----------+--------------------------------------------------------------------------------------------------------------------------------------------+
[2025-02-27 14:50:02.432] [INFO] | Node      | LogList                                                                                                                                    |
[2025-02-27 14:50:02.432] [INFO] +===========+============================================================================================================================================+
[2025-02-27 14:50:02.433] [INFO] | 127.0.0.1 | ['election.log', 'observer.log', 'observer.log.20250227142448984', 'observer.log.20250227144459184', 'observer.log.wf', 'rootservice.log'] |
[2025-02-27 14:50:02.433] [INFO] +-----------+--------------------------------------------------------------------------------------------------------------------------------------------+
[2025-02-27 14:50:02.449] [INFO] Analyze OceanBase Online Log Summary:
[2025-02-27 14:50:02.449] [INFO] +-----------+----------+------------+-------------+-----------+---------+
[2025-02-27 14:50:02.449] [INFO] | Node      | Status   | FileName   | ErrorCode   | Message   | Count   |
[2025-02-27 14:50:02.449] [INFO] +===========+==========+============+=============+===========+=========+
[2025-02-27 14:50:02.449] [INFO] | 127.0.0.1 | PASS     |            |             |           |         |
[2025-02-27 14:50:02.449] [INFO] +-----------+----------+------------+-------------+-----------+---------+
[2025-02-27 14:50:02.450] [INFO] For more details, please run cmd ' cat /root/obdiag_analyze_pack_20250227144955/result_details.txt '
[2025-02-27 14:50:02.450] [INFO] Trace ID: 0da6273a-f4d7-11ef-9575-000c29f3ac8a
[2025-02-27 14:50:02.450] [INFO] If you want to view detailed obdiag logs, please run: /root/oceanbase-diagnostic-tool/obdiag display-trace 0da6273a-f4d7-11ef-9575-000c29f3ac8a
[2025-02-27 14:50:02.580] [DEBUG] -- exit code 0
[2025-02-27 14:50:02.580] [INFO] 
[2025-02-27 14:50:02.581] [DEBUG] - sub analyze_log ref count to 0
[2025-02-27 14:50:02.581] [DEBUG] - export analyze_log
[2025-02-27 14:50:02.581] [DEBUG] - plugin oceanbase-diagnostic-tool-py_script_analyze_log-1.3 result: True
[2025-02-27 14:50:02.581] [INFO] Trace ID: 0c008a74-f4d7-11ef-b07d-000c29f3ac8a
[2025-02-27 14:50:02.581] [INFO] If you want to view detailed obd logs, please run: obd display-trace 0c008a74-f4d7-11ef-b07d-000c29f3ac8a

[root@HWD ~]# 
[root@HWD ~]# obd obdiag analyze log --log_level=INFO demo
Get local repositories and plugins ok
The tool oceanbase-diagnostic-tool is already installed the latest version 2.6.0
Open ssh connection ok
analyze_log start ...
analyze nodes's log start. Please wait a moment...
analyze start ok
FileListInfo:
+-----------+--------------------------------------------------------------------------------------------------------------------------------------------+
| Node      | LogList                                                                                                                                    |
+===========+============================================================================================================================================+
| 127.0.0.1 | ['election.log', 'observer.log', 'observer.log.20250227142448984', 'observer.log.20250227144459184', 'observer.log.wf', 'rootservice.log'] |
+-----------+--------------------------------------------------------------------------------------------------------------------------------------------+
Analyze OceanBase Online Log Summary:
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| Node      | Status    | FileName                                                                      |   ErrorCode | Message                                                                      |   Count |
+===========+===========+===============================================================================+=============+==============================================================================+=========+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/election.log                   |       -4018 | Entry not exist                                                              |     100 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/election.log                   |       -5019 | Table doesn't exist                                                          |       3 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -4000 | Common error                                                                 |     475 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -4006 | The object is not initialized                                                |     682 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -4007 | Not supported feature or function. Compatible Error Code: MySQL: 1235(0A000) |       1 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -4008 | End of iteration                                                             |     537 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -4009 | IO error                                                                     |      88 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -4012 | Timeout                                                                      |      28 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -4016 | Internal error                                                               |      65 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -4018 | Entry not exist                                                              |    8940 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -4023 | Try again                                                                    |    1972 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -4027 | File not exist. Compatible Error Code:MySQL: 1017(HY000)                     |      47 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -4043 | Access denied for user                                                       |   42603 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -4076 | Need wait                                                                    |    4908 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -4152 | Null value                                                                   |     984 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -4179 | Operation not allowed now                                                    |      33 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -4201 | hash map/set entry not exist                                                 |     952 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -4677 | no need to merge                                                             |       8 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -5019 | Table doesn't exist                                                          |    3616 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -5024 | Duplicated primary key                                                       |     265 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -5138 | no plan exist                                                                |       1 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -5154 | Unknown database                                                             |       1 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -5559 | package does not exist                                                       |       2 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -6004 | Shared lock conflict                                                         |     662 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -6005 | Try lock row conflict                                                        |     972 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -6210 | Transaction is timeout                                                       |      12 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log                   |       -6213 | Transaction context does not exist                                           |       2 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -4000 | Common error                                                                 |    1214 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -4002 | Invalid argument                                                             |     424 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -4006 | The object is not initialized                                                |    1798 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -4007 | Not supported feature or function. Compatible Error Code: MySQL: 1235(0A000) |       2 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -4008 | End of iteration                                                             |    1550 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -4009 | IO error                                                                     |      64 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -4018 | Entry not exist                                                              |    4203 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -4023 | Try again                                                                    |      32 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -4027 | File not exist. Compatible Error Code:MySQL: 1017(HY000)                     |     122 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -4043 | Access denied for user                                                       |      45 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -4076 | Need wait                                                                    |   12539 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -4152 | Null value                                                                   |    2551 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -4179 | Operation not allowed now                                                    |      72 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -4201 | hash map/set entry not exist                                                 |    2428 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -4677 | no need to merge                                                             |      20 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -5019 | Table doesn't exist                                                          |    9419 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -5024 | Duplicated primary key                                                       |     859 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -5154 | Unknown database                                                             |       4 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -5207 | Column is ambiguous                                                          |      16 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -5217 | Unknown column                                                               |      57 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -5559 | package does not exist                                                       |       8 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227142448984 |       -6004 | Shared lock conflict                                                         |     165 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4000 | Common error                                                                 |    1210 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4002 | Invalid argument                                                             |     490 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4006 | The object is not initialized                                                |    1798 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4007 | Not supported feature or function. Compatible Error Code: MySQL: 1235(0A000) |       2 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4008 | End of iteration                                                             |    1365 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4009 | IO error                                                                     |      68 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4012 | Timeout                                                                      |      40 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4018 | Entry not exist                                                              |    4178 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4019 | Size overflow                                                                |       8 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4023 | Try again                                                                    |      51 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4027 | File not exist. Compatible Error Code:MySQL: 1017(HY000)                     |     121 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4043 | Access denied for user                                                       |       5 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4076 | Need wait                                                                    |   12496 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4152 | Null value                                                                   |    2740 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4179 | Operation not allowed now                                                    |      52 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4201 | hash map/set entry not exist                                                 |    2420 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -4677 | no need to merge                                                             |      20 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -5019 | Table doesn't exist                                                          |    9342 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -5024 | Duplicated primary key                                                       |    1054 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -5138 | no plan exist                                                                |      11 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -5154 | Unknown database                                                             |       2 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -5207 | Column is ambiguous                                                          |      16 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -5217 | Unknown column                                                               |      71 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -5226 | plan cache memory used reach the high water mark.                            |       2 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -5559 | package does not exist                                                       |       4 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/observer.log.20250227144459184 |       -6004 | Shared lock conflict                                                         |     110 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/rootservice.log                |       -4002 | Invalid argument                                                             |      30 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/rootservice.log                |       -4008 | End of iteration                                                             |    6770 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/rootservice.log                |       -4018 | Entry not exist                                                              |    5111 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/rootservice.log                |       -4023 | Try again                                                                    |     166 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/rootservice.log                |       -4029 | Schema error                                                                 |     830 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/rootservice.log                |       -4076 | Need wait                                                                    |    2268 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/rootservice.log                |       -4109 | Server state or role not the same as expected                                |      10 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/rootservice.log                |       -4152 | Null value                                                                   |      11 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/rootservice.log                |       -5019 | Table doesn't exist                                                          |      15 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/rootservice.log                |       -5024 | Duplicated primary key                                                       |     814 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/rootservice.log                |       -5138 | no plan exist                                                                |       6 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
| 127.0.0.1 | Completed | /root/obdiag_analyze_pack_20250227145254/local/rootservice.log                |       -6004 | Shared lock conflict                                                         |      22 |
+-----------+-----------+-------------------------------------------------------------------------------+-------------+------------------------------------------------------------------------------+---------+
For more details, please run cmd ' cat /root/obdiag_analyze_pack_20250227145254/result_details.txt '
Trace ID: 78352a6a-f4d7-11ef-b0e0-000c29f3ac8a
If you want to view detailed obdiag logs, please run: /root/oceanbase-diagnostic-tool/obdiag display-trace 78352a6a-f4d7-11ef-b0e0-000c29f3ac8a

Trace ID: 768f3eb2-f4d7-11ef-a0b7-000c29f3ac8a
If you want to view detailed obd logs, please run: obd display-trace 768f3eb2-f4d7-11ef-a0b7-000c29f3ac8a