obdiag version: 3.7.2
gather_scenes_run start ...
gather from_time: 2025-12-08 16:42:22, to_time: 2025-12-08 17:13:22
execute tasks: observer.base
run scene excute yaml mode in node: 192.168.0.138 start
run scene excute yaml mode in node: 192.168.0.138 end
run scene excute yaml mode in node: 192.168.0.26 start
run scene excute yaml mode in node: 192.168.0.26 end
run scene excute yaml mode in node: 192.168.0.33 start
run scene excute yaml mode in node: 192.168.0.33 end
No time option provided, default processing is based on the last 30 minutes
gather log from_time: 2025-12-08 16:42:25, to_time: 2025-12-08 17:13:25
gather start ok
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|                                                             Gather observer Log Summary on 2025-12-08 17:12:30                                                             |
+---------------------+---------+--------+-----------------------------------------------------------------------------------------------------------------------------------+
|         Node        |  Status |  Size  |                                                                info                                                               |
+---------------------+---------+--------+-----------------------------------------------------------------------------------------------------------------------------------+
| remote_192_168_0_26 | Success | 5.565K | file save in /root/obdiag_gather_pack_20251208171222/observer_log_remote_192_168_0_26_20251208164225_20251208171325_c809a2.tar.gz |
+---------------------+---------+--------+-----------------------------------------------------------------------------------------------------------------------------------+

For result details, please run cmd ' cat /root/obdiag_gather_pack_20251208171222/result_summary.txt '

[WARN] obproxy nodes is None. Skipping gathering obproxy log.
cprint.t_order_file -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=NO
cprint.t_order_file -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=NO
cprint.t_order_file -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=NO
cprint.t_order -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=NO
cprint.t_set -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=NO
cprint.t_set_security_policy -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=NO
cprint.t_security_policy -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=YES
execute SQL: SELECT DBMS_XPLAN.DISPLAY_CURSOR(136483, 'all', '192.168.0.26',  2882, 1002) FROM DUAL
table count (('t_order_file', 19236902),)
data size (('192.168.0.138', 'cprint', 't_order_file', 'USER TABLE', Decimal('1944.20'), Decimal('1944.20')), ('192.168.0.138', 'cprint', '', 'INDEX', Decimal('823.02'), Decimal('823.02')), ('192.168.0.26', 'cprint', 't_order_file', 'USER TABLE', Decimal('1944.20'), Decimal('1944.20')), ('192.168.0.26', 'cprint', '', 'INDEX', Decimal('823.02'), Decimal('823.02')), ('192.168.0.33', 'cprint', 't_order_file', 'USER TABLE', Decimal('1944.20'), Decimal('1944.20')), ('192.168.0.33', 'cprint', '', 'INDEX', Decimal('823.02'), Decimal('823.02')))
table count (('t_order_file', 19236902),)
data size (('192.168.0.138', 'cprint', 't_order_file', 'USER TABLE', Decimal('1944.20'), Decimal('1944.20')), ('192.168.0.138', 'cprint', '', 'INDEX', Decimal('823.02'), Decimal('823.02')), ('192.168.0.26', 'cprint', 't_order_file', 'USER TABLE', Decimal('1944.20'), Decimal('1944.20')), ('192.168.0.26', 'cprint', '', 'INDEX', Decimal('823.02'), Decimal('823.02')), ('192.168.0.33', 'cprint', 't_order_file', 'USER TABLE', Decimal('1944.20'), Decimal('1944.20')), ('192.168.0.33', 'cprint', '', 'INDEX', Decimal('823.02'), Decimal('823.02')))
table count (('t_order_file', 19236902),)
data size (('192.168.0.138', 'cprint', 't_order_file', 'USER TABLE', Decimal('1944.20'), Decimal('1944.20')), ('192.168.0.138', 'cprint', '', 'INDEX', Decimal('823.02'), Decimal('823.02')), ('192.168.0.26', 'cprint', 't_order_file', 'USER TABLE', Decimal('1944.20'), Decimal('1944.20')), ('192.168.0.26', 'cprint', '', 'INDEX', Decimal('823.02'), Decimal('823.02')), ('192.168.0.33', 'cprint', 't_order_file', 'USER TABLE', Decimal('1944.20'), Decimal('1944.20')), ('192.168.0.33', 'cprint', '', 'INDEX', Decimal('823.02'), Decimal('823.02')))
table count (('t_order', 14148572),)
data size (('192.168.0.138', 'cprint', 't_order', 'USER TABLE', Decimal('289.07'), Decimal('289.07')), ('192.168.0.138', 'cprint', '', 'INDEX', Decimal('868.57'), Decimal('868.57')), ('192.168.0.26', 'cprint', 't_order', 'USER TABLE', Decimal('289.07'), Decimal('289.07')), ('192.168.0.26', 'cprint', '', 'INDEX', Decimal('868.57'), Decimal('868.57')), ('192.168.0.33', 'cprint', 't_order', 'USER TABLE', Decimal('289.07'), Decimal('289.07')), ('192.168.0.33', 'cprint', '', 'INDEX', Decimal('868.57'), Decimal('868.57')))
table count (('t_set', 363),)
data size (('192.168.0.138', 'cprint', '__AUX_LOB_META_502312_', 'LOB AUX TABLE', Decimal('0.00'), Decimal('0.00')), ('192.168.0.138', 'cprint', 't_set', 'USER TABLE', Decimal('0.03'), Decimal('0.04')), ('192.168.0.138', 'cprint', '', 'INDEX', Decimal('0.00'), Decimal('0.00')), ('192.168.0.26', 'cprint', '__AUX_LOB_META_502312_', 'LOB AUX TABLE', Decimal('0.00'), Decimal('0.00')), ('192.168.0.26', 'cprint', 't_set', 'USER TABLE', Decimal('0.03'), Decimal('0.04')), ('192.168.0.26', 'cprint', '', 'INDEX', Decimal('0.00'), Decimal('0.00')), ('192.168.0.33', 'cprint', '__AUX_LOB_META_502312_', 'LOB AUX TABLE', Decimal('0.00'), Decimal('0.00')), ('192.168.0.33', 'cprint', 't_set', 'USER TABLE', Decimal('0.03'), Decimal('0.04')), ('192.168.0.33', 'cprint', '', 'INDEX', Decimal('0.00'), Decimal('0.00')))
table count (('t_set_security_policy', 334),)
data size (('192.168.0.138', 'cprint', 't_set_security_policy', 'USER TABLE', Decimal('0.00'), Decimal('0.00')), ('192.168.0.138', 'cprint', '', 'INDEX', Decimal('0.00'), Decimal('0.00')), ('192.168.0.26', 'cprint', 't_set_security_policy', 'USER TABLE', Decimal('0.00'), Decimal('0.00')), ('192.168.0.26', 'cprint', '', 'INDEX', Decimal('0.00'), Decimal('0.00')), ('192.168.0.33', 'cprint', 't_set_security_policy', 'USER TABLE', Decimal('0.00'), Decimal('0.00')), ('192.168.0.33', 'cprint', '', 'INDEX', Decimal('0.00'), Decimal('0.00')))
table count (('t_security_policy', 6),)
data size (('192.168.0.138', 'cprint', 't_security_policy', 'USER TABLE', Decimal('0.00'), Decimal('0.00')), ('192.168.0.26', 'cprint', 't_security_policy', 'USER TABLE', Decimal('0.00'), Decimal('0.00')), ('192.168.0.33', 'cprint', 't_security_policy', 'USER TABLE', Decimal('0.00'), Decimal('0.00')))

Gather Sql Plan Monitor Summary:
+-----------+-----------+--------+-----------------------------------------+
| Cluster   | Status    | Time   | PackPath                                |
+===========+===========+========+=========================================+
|           | Completed | 102 s  | /root/obdiag_gather_pack_20251208171222 |
+-----------+-----------+--------+-----------------------------------------+
execute dbms_xplan.enable_opt_trace start ...
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
call dbms_xplan.enable_opt_trace();
call dbms_xplan.set_opt_trace_parameter(identifier=>'obdiag_eNfKrw', `level`=>3);
explain SELECT /*ligang1710*/
        a.order_id,
        a.use_type,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        (h.sensi_flag is null OR h.sensi_flag in (1,1000))) unfinished_count,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        h.sensi_flag in (2,96,97) ) sensi_count,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        h.sensi_flag in (98,99)) black_count,
        u.censor_flag,u.sensi_handle_flag
        FROM
        t_order a
        LEFT JOIN t_set s ON a.set_id = s.set_id
        LEFT JOIN t_set_security_policy t on s.set_id = t.set_id
        LEFT JOIN t_security_policy u on t.policy_id = u.policy_id
        WHERE
        a.state_date > DATE_ADD(now(),INTERVAL - 3 HOUR) and a.r_tenant_id = 'woqu'
        AND a.state_date  <  DATE_ADD(now(),INTERVAL - 60 SECOND)
        AND a.state = '00'
        AND a.checked_flag is null
call dbms_xplan.disable_opt_trace();
execute dbms_xplan.enable_opt_trace end
[WARN] failed to gather dbms_xplan.enable_opt_trace, wait to retry
execute dbms_xplan.enable_opt_trace start ...
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
call dbms_xplan.enable_opt_trace();
call dbms_xplan.set_opt_trace_parameter(identifier=>'obdiag_eNfKrw', `level`=>3);
explain SELECT /*ligang1710*/
        a.order_id,
        a.use_type,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        (h.sensi_flag is null OR h.sensi_flag in (1,1000))) unfinished_count,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        h.sensi_flag in (2,96,97) ) sensi_count,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        h.sensi_flag in (98,99)) black_count,
        u.censor_flag,u.sensi_handle_flag
        FROM
        t_order a
        LEFT JOIN t_set s ON a.set_id = s.set_id
        LEFT JOIN t_set_security_policy t on s.set_id = t.set_id
        LEFT JOIN t_security_policy u on t.policy_id = u.policy_id
        WHERE
        a.state_date > DATE_ADD(now(),INTERVAL - 3 HOUR) and a.r_tenant_id = 'woqu'
        AND a.state_date  <  DATE_ADD(now(),INTERVAL - 60 SECOND)
        AND a.state = '00'
        AND a.checked_flag is null
call dbms_xplan.disable_opt_trace();
execute dbms_xplan.enable_opt_trace end
[WARN] failed to gather dbms_xplan.enable_opt_trace, wait to retry
execute dbms_xplan.enable_opt_trace start ...
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
call dbms_xplan.enable_opt_trace();
call dbms_xplan.set_opt_trace_parameter(identifier=>'obdiag_eNfKrw', `level`=>3);
explain SELECT /*ligang1710*/
        a.order_id,
        a.use_type,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        (h.sensi_flag is null OR h.sensi_flag in (1,1000))) unfinished_count,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        h.sensi_flag in (2,96,97) ) sensi_count,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        h.sensi_flag in (98,99)) black_count,
        u.censor_flag,u.sensi_handle_flag
        FROM
        t_order a
        LEFT JOIN t_set s ON a.set_id = s.set_id
        LEFT JOIN t_set_security_policy t on s.set_id = t.set_id
        LEFT JOIN t_security_policy u on t.policy_id = u.policy_id
        WHERE
        a.state_date > DATE_ADD(now(),INTERVAL - 3 HOUR) and a.r_tenant_id = 'woqu'
        AND a.state_date  <  DATE_ADD(now(),INTERVAL - 60 SECOND)
        AND a.state = '00'
        AND a.checked_flag is null
call dbms_xplan.disable_opt_trace();
execute dbms_xplan.enable_opt_trace end
[WARN] failed to gather dbms_xplan.enable_opt_trace, wait to retry
execute dbms_xplan.enable_opt_trace start ...
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
call dbms_xplan.enable_opt_trace();
call dbms_xplan.set_opt_trace_parameter(identifier=>'obdiag_eNfKrw', `level`=>3);
explain SELECT /*ligang1710*/
        a.order_id,
        a.use_type,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        (h.sensi_flag is null OR h.sensi_flag in (1,1000))) unfinished_count,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        h.sensi_flag in (2,96,97) ) sensi_count,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        h.sensi_flag in (98,99)) black_count,
        u.censor_flag,u.sensi_handle_flag
        FROM
        t_order a
        LEFT JOIN t_set s ON a.set_id = s.set_id
        LEFT JOIN t_set_security_policy t on s.set_id = t.set_id
        LEFT JOIN t_security_policy u on t.policy_id = u.policy_id
        WHERE
        a.state_date > DATE_ADD(now(),INTERVAL - 3 HOUR) and a.r_tenant_id = 'woqu'
        AND a.state_date  <  DATE_ADD(now(),INTERVAL - 60 SECOND)
        AND a.state = '00'
        AND a.checked_flag is null
call dbms_xplan.disable_opt_trace();
execute dbms_xplan.enable_opt_trace end
[WARN] failed to gather dbms_xplan.enable_opt_trace, wait to retry
execute dbms_xplan.enable_opt_trace start ...
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
call dbms_xplan.enable_opt_trace();
call dbms_xplan.set_opt_trace_parameter(identifier=>'obdiag_eNfKrw', `level`=>3);
explain SELECT /*ligang1710*/
        a.order_id,
        a.use_type,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        (h.sensi_flag is null OR h.sensi_flag in (1,1000))) unfinished_count,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        h.sensi_flag in (2,96,97) ) sensi_count,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        h.sensi_flag in (98,99)) black_count,
        u.censor_flag,u.sensi_handle_flag
        FROM
        t_order a
        LEFT JOIN t_set s ON a.set_id = s.set_id
        LEFT JOIN t_set_security_policy t on s.set_id = t.set_id
        LEFT JOIN t_security_policy u on t.policy_id = u.policy_id
        WHERE
        a.state_date > DATE_ADD(now(),INTERVAL - 3 HOUR) and a.r_tenant_id = 'woqu'
        AND a.state_date  <  DATE_ADD(now(),INTERVAL - 60 SECOND)
        AND a.state = '00'
        AND a.checked_flag is null
call dbms_xplan.disable_opt_trace();
execute dbms_xplan.enable_opt_trace end
[WARN] failed to gather dbms_xplan.enable_opt_trace, wait to retry
execute dbms_xplan.enable_opt_trace start ...
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
call dbms_xplan.enable_opt_trace();
call dbms_xplan.set_opt_trace_parameter(identifier=>'obdiag_eNfKrw', `level`=>3);
explain SELECT /*ligang1710*/
        a.order_id,
        a.use_type,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        (h.sensi_flag is null OR h.sensi_flag in (1,1000))) unfinished_count,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        h.sensi_flag in (2,96,97) ) sensi_count,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        h.sensi_flag in (98,99)) black_count,
        u.censor_flag,u.sensi_handle_flag
        FROM
        t_order a
        LEFT JOIN t_set s ON a.set_id = s.set_id
        LEFT JOIN t_set_security_policy t on s.set_id = t.set_id
        LEFT JOIN t_security_policy u on t.policy_id = u.policy_id
        WHERE
        a.state_date > DATE_ADD(now(),INTERVAL - 3 HOUR) and a.r_tenant_id = 'woqu'
        AND a.state_date  <  DATE_ADD(now(),INTERVAL - 60 SECOND)
        AND a.state = '00'
        AND a.checked_flag is null
call dbms_xplan.disable_opt_trace();
execute dbms_xplan.enable_opt_trace end
[WARN] failed to gather dbms_xplan.enable_opt_trace, wait to retry
execute dbms_xplan.enable_opt_trace start ...
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
call dbms_xplan.enable_opt_trace();
call dbms_xplan.set_opt_trace_parameter(identifier=>'obdiag_eNfKrw', `level`=>3);
explain SELECT /*ligang1710*/
        a.order_id,
        a.use_type,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        (h.sensi_flag is null OR h.sensi_flag in (1,1000))) unfinished_count,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        h.sensi_flag in (2,96,97) ) sensi_count,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        h.sensi_flag in (98,99)) black_count,
        u.censor_flag,u.sensi_handle_flag
        FROM
        t_order a
        LEFT JOIN t_set s ON a.set_id = s.set_id
        LEFT JOIN t_set_security_policy t on s.set_id = t.set_id
        LEFT JOIN t_security_policy u on t.policy_id = u.policy_id
        WHERE
        a.state_date > DATE_ADD(now(),INTERVAL - 3 HOUR) and a.r_tenant_id = 'woqu'
        AND a.state_date  <  DATE_ADD(now(),INTERVAL - 60 SECOND)
        AND a.state = '00'
        AND a.checked_flag is null
call dbms_xplan.disable_opt_trace();
execute dbms_xplan.enable_opt_trace end
[WARN] failed to gather dbms_xplan.enable_opt_trace, wait to retry
execute dbms_xplan.enable_opt_trace start ...
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
call dbms_xplan.enable_opt_trace();
call dbms_xplan.set_opt_trace_parameter(identifier=>'obdiag_eNfKrw', `level`=>3);
explain SELECT /*ligang1710*/
        a.order_id,
        a.use_type,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        (h.sensi_flag is null OR h.sensi_flag in (1,1000))) unfinished_count,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        h.sensi_flag in (2,96,97) ) sensi_count,
        ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND
        h.sensi_flag in (98,99)) black_count,
        u.censor_flag,u.sensi_handle_flag
        FROM
        t_order a
        LEFT JOIN t_set s ON a.set_id = s.set_id
        LEFT JOIN t_set_security_policy t on s.set_id = t.set_id
        LEFT JOIN t_security_policy u on t.policy_id = u.policy_id
        WHERE
        a.state_date > DATE_ADD(now(),INTERVAL - 3 HOUR) and a.r_tenant_id = 'woqu'
        AND a.state_date  <  DATE_ADD(now(),INTERVAL - 60 SECOND)
        AND a.state = '00'
        AND a.checked_flag is null
call dbms_xplan.disable_opt_trace();
execute dbms_xplan.enable_opt_trace end
[WARN] failed to gather dbms_xplan.enable_opt_trace, wait to retry
[ERROR] get dbms_xplan result failed, error: No active exception to reraise

Gather scene results stored in this directory: /root/obdiag_gather_pack_20251208171222

Trace ID: 00f6bc56-d416-11f0-b3a2-fa163eec445e
If you want to view detailed obdiag logs, please run: obdiag display-trace 00f6bc56-d416-11f0-b3a2-fa163eec445e