[root@db-control1 ~]# obdiag display-trace 8d9edc96-b946-11f0-9a85-fa163e403b9f
obdiag version: 3.4.0
[2025-11-04 14:21:52.348] [DEBUG] - cmd: obdiag gather plan_monitor
[2025-11-04 14:21:52.349] [DEBUG] - opts: {'inner_config': None, 'trace_id': 'YB42AC160559-000642AE838B79C1-0-0', 'store_dir': './', 'env': "{db_connect='-h172.22.5.74 -P2881 -uroot@ob_business -paaAA11__cN -Dmjzcj'}", 'skip': None, 'c': '/root/.obdiag/config.yml', 'config': None}
[2025-11-04 14:21:52.349] [INFO] obdiag version: 3.4.0
[2025-11-04 14:21:52.350] [DEBUG] - mkdir /opt/oceanbase-diagnostic-tool/conf/inner_config.yml
[2025-11-04 14:21:52.357] [DEBUG] - mkdir /root/.obdiag/config.yml
[2025-11-04 14:21:52.367] [INFO] gather_plan_monitor start ...
[2025-11-04 14:21:52.380] [DEBUG] - connect databse ...
[2025-11-04 14:21:52.388] [DEBUG] - connect databse ...
[2025-11-04 14:21:52.412] [DEBUG] - Detected MySQL mode successful, Database version: OceanBase_CE 4.3.5.2 (r102010012025052715-2291c2a4ef1863f12286914f6bb56108fb7bc25c) (Built May 27 2025 15:22:19)
[2025-11-04 14:21:52.412] [DEBUG] - Use ./obdiag_gather_pack_20251104142152 as pack dir.
[2025-11-04 14:21:52.412] [DEBUG] - mkdir ./obdiag_gather_pack_20251104142152
[2025-11-04 14:21:52.413] [DEBUG] - [cs resource path] : /opt/oceanbase-diagnostic-tool/resources
[2025-11-04 14:21:52.422] [DEBUG] - [sql plan monitor report task] start
[2025-11-04 14:21:54.554] [DEBUG] - TraceID : YB42AC160559-000642AE838B79C1-0-0 
[2025-11-04 14:21:54.554] [DEBUG] - SQL : select * from mz_ghb 
[2025-11-04 14:21:54.554] [DEBUG] - SVR_IP : 172.22.5.89 
[2025-11-04 14:21:54.554] [DEBUG] - SVR_PORT : 2882 
[2025-11-04 14:21:54.554] [DEBUG] - DB: mjzcj 
[2025-11-04 14:21:54.554] [DEBUG] - PLAN_ID: 2481 
[2025-11-04 14:21:54.554] [DEBUG] - TENANT_NAME: ob_business 
[2025-11-04 14:21:54.554] [DEBUG] - TENANT_ID: 1006 
[2025-11-04 14:21:54.554] [DEBUG] - [sql plan monitor report task] report header
[2025-11-04 14:21:54.555] [DEBUG] - report header complete
[2025-11-04 14:21:54.555] [DEBUG] - [sql plan monitor report task] report sql_audit
[2025-11-04 14:21:54.555] [DEBUG] - select sql_audit from ob with SQL: 
[2025-11-04 14:21:56.715] [DEBUG] - sql_audit_result: +-----------------------------------+----------------------+-------------+----------------------------+----------------------------+--------------+-------------+-----------+---------+---------+-----------+------------------------------+-------------+----------+
[2025-11-04 14:21:56.716] [DEBUG] - report sql_audit_result to file start ...
[2025-11-04 14:21:56.717] [DEBUG] - report sql_audit_result end
[2025-11-04 14:21:56.717] [DEBUG] - [sql plan monitor report task] report plan explain, sql: [select * from mz_ghb]
[2025-11-04 14:22:05.579] [DEBUG] - execute SQL: explain extended select * from mz_ghb
[2025-11-04 14:22:05.604] [DEBUG] - The statistics are up-to-date. The last collection time for the mz_ghb table is 2025-11-04 10:58:54??No action needed.
[2025-11-04 14:22:05.604] [DEBUG] - the result of optimization_info_warn is None
[2025-11-04 14:22:05.604] [DEBUG] - report sql_explain_result_sql complete
[2025-11-04 14:22:05.604] [DEBUG] - report sql_explain_result_sql complete
[2025-11-04 14:22:05.623] [DEBUG] - report sql_explain_result complete
[2025-11-04 14:22:05.623] [DEBUG] - [sql plan monitor report task] report plan cache
[2025-11-04 14:22:05.658] [DEBUG] - select plan_explain from ob complete
[2025-11-04 14:22:05.658] [DEBUG] - report plan_explain_sql complete
[2025-11-04 14:22:05.660] [DEBUG] - report plan_explain complete
[2025-11-04 14:22:06.067] [DEBUG] - execute SQL: select * from mz_ghb
[2025-11-04 14:22:06.079] [DEBUG] - display_cursor report complete
[2025-11-04 14:22:06.079] [DEBUG] - [sql plan monitor report task] report table schema
[2025-11-04 14:22:06.085] [DEBUG] - connect databse ...
[2025-11-04 14:22:06.092] [DEBUG] - connect databse ...
[2025-11-04 14:22:06.095] [DEBUG] - get observer version, by sql
[2025-11-04 14:22:06.095] [DEBUG] - start get_observer_version_by_sql . input: 172.22.5.74:2881
[2025-11-04 14:22:06.099] [DEBUG] - connect databse ...
[2025-11-04 14:22:06.103] [DEBUG] - get_observer_version_by_sql ob_version_info is ('5.7.25-OceanBase_CE-v4.3.5.2',)
[2025-11-04 14:22:06.115] [ERROR] getTableInfo execute Exception: (1146, "Table 'oceanbase.__all_tenant' doesn't exist")
[2025-11-04 14:22:06.115] [DEBUG] - table info file path:./obdiag_tabledump_result_20251104142152.txt
[2025-11-04 14:22:09.957] [DEBUG] - [ash report task] report ash, sql: [
[2025-11-04 14:22:09.957] [DEBUG]     SELECT SQL_PLAN_LINE_ID OP_ID, IF(EVENT = '', 'CPU + WAIT FOR CPU', EVENT) AS EVENT, WAIT_CLASS, COUNT(1) EVENT_CNT, ROUND(COUNT(1) * 100 / SUM(COUNT(1)) OVER (), 2) AS Percent, MAX(P1TEXT) P1TEXT, MAX(P1) P1, MAX(P2TEXT) P2TEXT,  MAX(P2) P2, MAX(P3TEXT) P3TEXT, MAX(P3) P3
[2025-11-04 14:22:09.957] [DEBUG]      FROM OCEANBASE.GV$ACTIVE_SESSION_HISTORY A WHERE CON_ID = 1006 AND TRACE_ID = 'YB42AC160559-000642AE838B79C1-0-0' GROUP BY A.SQL_PLAN_LINE_ID, A.EVENT, A.WAIT_CLASS ORDER BY 1 ASC, 4 DESC
[2025-11-04 14:22:09.957] [DEBUG]     ]
[2025-11-04 14:22:10.053] [DEBUG] - execute SQL: 
[2025-11-04 14:22:10.055] [DEBUG] - ash report complete
[2025-11-04 14:22:10.071] [DEBUG] - init sql plan monitor stat complete
[2025-11-04 14:22:10.071] [DEBUG] - [sql plan monitor report task] report sql_audit details
[2025-11-04 14:22:15.508] [DEBUG] - report full sql audit complete
[2025-11-04 14:22:15.509] [DEBUG] - [sql plan monitor report task] report sql plan monitor dfo
[2025-11-04 14:22:15.602] [WARNING] failed to find sql_plan_monitor data, please add hint /*+ monitor*/ to your SQL before executing it.
[2025-11-04 14:22:15.602] [DEBUG] - report SQL_PLAN_MONITOR DFO complete
[2025-11-04 14:22:15.662] [DEBUG] - report SQL_PLAN_MONITOR DFO SCHED complete
[2025-11-04 14:22:15.712] [DEBUG] - report SQL_PLAN_MONITOR DFO graph data complete
[2025-11-04 14:22:15.712] [DEBUG] - [db time display task] report db time display
[2025-11-04 14:22:15.769] [DEBUG] - execute SQL: 
[2025-11-04 14:22:15.769] [DEBUG] - DB Time display complete
[2025-11-04 14:22:15.769] [DEBUG] - report db time display complete
[2025-11-04 14:22:15.769] [DEBUG] - [sql plan monitor report task] report sql plan monitor group by server
[2025-11-04 14:22:15.833] [DEBUG] - report SQL_PLAN_MONITOR SQC complete
[2025-11-04 14:22:15.892] [DEBUG] - report SQL_PLAN_MONITOR SQC operator priority start, DATA: <script> var svr_agg_serial_v1 = [{start:0}];</script><p>算子优先视图</p><div class='bar' id='svr_agg_serial_v1'></div>
[2025-11-04 14:22:15.893] [DEBUG] - report SQL_PLAN_MONITOR SQC operator priority complete
[2025-11-04 14:22:15.958] [DEBUG] - report SQL_PLAN_MONITOR SQC operator priority start, DATA: <script> var svr_agg_serial_v2 = [{start:0}];</script><p>算子优先视图</p><div class='bar' id='svr_agg_serial_v2'></div>
[2025-11-04 14:22:15.958] [DEBUG] - report SQL_PLAN_MONITOR SQC server priority complete
[2025-11-04 14:22:15.958] [DEBUG] - report SQL_PLAN_MONITOR fast preview complete
[2025-11-04 14:22:15.959] [DEBUG] - [sql plan monitor report task] sql plan monitor detail operator
[2025-11-04 14:22:16.017] [DEBUG] - report SQL_PLAN_MONITOR details complete
[2025-11-04 14:22:16.063] [DEBUG] - report SQL_PLAN_MONITOR details operator priority complete
[2025-11-04 14:22:16.063] [DEBUG] - [sql plan monitor report task] sql plan monitor group by priority
[2025-11-04 14:22:16.121] [DEBUG] - report SQL_PLAN_MONITOR details server priority complete
[2025-11-04 14:22:16.121] [DEBUG] - report footer complete
[2025-11-04 14:22:16.121] [DEBUG] - [sql plan monitor report task] end
[2025-11-04 14:22:16.122] [INFO] 
[2025-11-04 14:22:16.122] [INFO] Gather Sql Plan Monitor Summary:
[2025-11-04 14:22:16.122] [INFO] +-----------+-----------+--------+-------------------------------------+
[2025-11-04 14:22:16.122] [INFO] | Cluster   | Status    | Time   | PackPath                            |
[2025-11-04 14:22:16.122] [INFO] +===========+===========+========+=====================================+
[2025-11-04 14:22:16.122] [INFO] | obcluster | Completed | 23 s   | ./obdiag_gather_pack_20251104142152 |
[2025-11-04 14:22:16.122] [INFO] +-----------+-----------+--------+-------------------------------------+
[2025-11-04 14:22:16.123] [INFO] Trace ID: 8d9edc96-b946-11f0-9a85-fa163e403b9f
[2025-11-04 14:22:16.123] [INFO] If you want to view detailed obdiag logs, please run: obdiag display-trace 8d9edc96-b946-11f0-9a85-fa163e403b9f