[root@iZuf65rmf8lyj0pbl7m513Z data1]# ./ob-gather.sh obdiag version: 3.6.0 gather_scenes_run start ... gather from_time: 2025-09-23 14:50:56, to_time: 2025-09-23 15:21:56 execute tasks: observer.base run scene excute yaml mode in node: 172.17.172.84 start run scene excute yaml mode in node: 172.17.172.84 end run scene excute yaml mode in node: 172.17.172.85 start run scene excute yaml mode in node: 172.17.172.85 end run scene excute yaml mode in node: 172.17.172.86 start run scene excute yaml mode in node: 172.17.172.86 end No time option provided, default processing is based on the last 30 minutes gather log from_time: 2025-09-23 14:50:58, to_time: 2025-09-23 15:21:58 gather start ok +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Gather observer Log Summary on 2025-09-23 15:21:05 | +----------------------+---------+--------+-------------------------------------------------------------------------------------------------------------------------------------+ | Node | Status | Size | info | +----------------------+---------+--------+-------------------------------------------------------------------------------------------------------------------------------------+ | remote_172_17_172_84 | Success | 6.657K | file save in /data1/obdiag_gather_pack_20250923152056/observer_log_remote_172_17_172_84_20250923145058_20250923152158_6fbf06.tar.gz | +----------------------+---------+--------+-------------------------------------------------------------------------------------------------------------------------------------+ For result details, please run cmd ' cat /data1/obdiag_gather_pack_20250923152056/result_summary.txt ' [WARN] obproxy nodes is None. Skipping gathering obproxy log. cprint.( -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=NO cprint.t_cust -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=YES cprint.t_total_set -> 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_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_msg -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=NO cprint.t_order_return -> 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_station -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=YES cprint.t_device -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=YES cprint.t_set -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=NO cprint.t_merchant -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=NO cprint.t_pay -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=NO cprint.t_order_file_msg -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=NO cprint.t_order_return -> oceanbase.DBA_OB_TABLE_STAT_STALE_INFO IS_STALE=NO execute SQL: SELECT DBMS_XPLAN.DISPLAY_CURSOR(627102, 'all', '172.17.172.84', 2882, 1002) FROM DUAL table count (('t_cust', 3811082),) data size (('172.17.172.84', 'cprint', 't_cust', 'USER TABLE', Decimal('75.75'), Decimal('75.75')), ('172.17.172.84', 'cprint', '', 'INDEX', Decimal('74.74'), Decimal('74.74')), ('172.17.172.85', 'cprint', 't_cust', 'USER TABLE', Decimal('75.75'), Decimal('75.75')), ('172.17.172.85', 'cprint', '', 'INDEX', Decimal('74.74'), Decimal('74.74')), ('172.17.172.86', 'cprint', 't_cust', 'USER TABLE', Decimal('75.75'), Decimal('75.75')), ('172.17.172.86', 'cprint', '', 'INDEX', Decimal('74.74'), Decimal('74.74'))) table count (('t_total_set', 211),) data size (('172.17.172.84', 'cprint', 't_total_set', 'USER TABLE', Decimal('0.01'), Decimal('0.01')), ('172.17.172.85', 'cprint', 't_total_set', 'USER TABLE', Decimal('0.01'), Decimal('0.01')), ('172.17.172.86', 'cprint', 't_total_set', 'USER TABLE', Decimal('0.01'), Decimal('0.01'))) table count (('t_order_file', 17230673),) data size (('172.17.172.84', 'cprint', 't_order_file', 'USER TABLE', Decimal('1754.68'), Decimal('1754.68')), ('172.17.172.84', 'cprint', '', 'INDEX', Decimal('713.58'), Decimal('713.58')), ('172.17.172.85', 'cprint', 't_order_file', 'USER TABLE', Decimal('1754.68'), Decimal('1754.68')), ('172.17.172.85', 'cprint', '', 'INDEX', Decimal('713.58'), Decimal('713.58')), ('172.17.172.86', 'cprint', 't_order_file', 'USER TABLE', Decimal('1754.68'), Decimal('1754.68')), ('172.17.172.86', 'cprint', '', 'INDEX', Decimal('713.58'), Decimal('713.58'))) table count (('t_order_file', 17230673),) data size (('172.17.172.84', 'cprint', 't_order_file', 'USER TABLE', Decimal('1754.68'), Decimal('1754.68')), ('172.17.172.84', 'cprint', '', 'INDEX', Decimal('713.58'), Decimal('713.58')), ('172.17.172.85', 'cprint', 't_order_file', 'USER TABLE', Decimal('1754.68'), Decimal('1754.68')), ('172.17.172.85', 'cprint', '', 'INDEX', Decimal('713.58'), Decimal('713.58')), ('172.17.172.86', 'cprint', 't_order_file', 'USER TABLE', Decimal('1754.68'), Decimal('1754.68')), ('172.17.172.86', 'cprint', '', 'INDEX', Decimal('713.58'), Decimal('713.58'))) table count (('t_order_file', 17230673),) data size (('172.17.172.84', 'cprint', 't_order_file', 'USER TABLE', Decimal('1754.68'), Decimal('1754.68')), ('172.17.172.84', 'cprint', '', 'INDEX', Decimal('713.58'), Decimal('713.58')), ('172.17.172.85', 'cprint', 't_order_file', 'USER TABLE', Decimal('1754.68'), Decimal('1754.68')), ('172.17.172.85', 'cprint', '', 'INDEX', Decimal('713.58'), Decimal('713.58')), ('172.17.172.86', 'cprint', 't_order_file', 'USER TABLE', Decimal('1754.68'), Decimal('1754.68')), ('172.17.172.86', 'cprint', '', 'INDEX', Decimal('713.58'), Decimal('713.58'))) table count (('t_order_file', 17230673),) data size (('172.17.172.84', 'cprint', 't_order_file', 'USER TABLE', Decimal('1754.68'), Decimal('1754.68')), ('172.17.172.84', 'cprint', '', 'INDEX', Decimal('713.58'), Decimal('713.58')), ('172.17.172.85', 'cprint', 't_order_file', 'USER TABLE', Decimal('1754.68'), Decimal('1754.68')), ('172.17.172.85', 'cprint', '', 'INDEX', Decimal('713.58'), Decimal('713.58')), ('172.17.172.86', 'cprint', 't_order_file', 'USER TABLE', Decimal('1754.68'), Decimal('1754.68')), ('172.17.172.86', 'cprint', '', 'INDEX', Decimal('713.58'), Decimal('713.58'))) table count (('t_order_file_msg', 591109),) data size (('172.17.172.84', 'cprint', 't_order_file_msg', 'USER TABLE', Decimal('9.70'), Decimal('9.70')), ('172.17.172.84', 'cprint', '', 'INDEX', Decimal('6.23'), Decimal('6.23')), ('172.17.172.85', 'cprint', 't_order_file_msg', 'USER TABLE', Decimal('9.70'), Decimal('9.70')), ('172.17.172.85', 'cprint', '', 'INDEX', Decimal('6.23'), Decimal('6.23')), ('172.17.172.86', 'cprint', 't_order_file_msg', 'USER TABLE', Decimal('9.70'), Decimal('9.70')), ('172.17.172.86', 'cprint', '', 'INDEX', Decimal('6.23'), Decimal('6.23'))) table count (('t_order_return', 1020661),) data size (('172.17.172.84', 'cprint', 't_order_return', 'USER TABLE', Decimal('30.48'), Decimal('30.48')), ('172.17.172.84', 'cprint', '', 'INDEX', Decimal('16.06'), Decimal('16.06')), ('172.17.172.85', 'cprint', 't_order_return', 'USER TABLE', Decimal('30.48'), Decimal('30.48')), ('172.17.172.85', 'cprint', '', 'INDEX', Decimal('16.06'), Decimal('16.06')), ('172.17.172.86', 'cprint', 't_order_return', 'USER TABLE', Decimal('30.48'), Decimal('30.48')), ('172.17.172.86', 'cprint', '', 'INDEX', Decimal('16.06'), Decimal('16.06'))) table count (('t_order', 6768587),) data size (('172.17.172.84', 'cprint', 't_order', 'USER TABLE', Decimal('262.40'), Decimal('262.40')), ('172.17.172.84', 'cprint', '', 'INDEX', Decimal('720.78'), Decimal('720.78')), ('172.17.172.85', 'cprint', 't_order', 'USER TABLE', Decimal('262.40'), Decimal('262.40')), ('172.17.172.85', 'cprint', '', 'INDEX', Decimal('720.78'), Decimal('720.78')), ('172.17.172.86', 'cprint', 't_order', 'USER TABLE', Decimal('262.40'), Decimal('262.40')), ('172.17.172.86', 'cprint', '', 'INDEX', Decimal('720.78'), Decimal('720.78'))) table count (('t_station', 2205),) data size (('172.17.172.84', 'cprint', 't_station', 'USER TABLE', Decimal('0.16'), Decimal('0.33')), ('172.17.172.84', 'cprint', '', 'INDEX', Decimal('0.01'), Decimal('0.01')), ('172.17.172.85', 'cprint', 't_station', 'USER TABLE', Decimal('0.16'), Decimal('0.33')), ('172.17.172.85', 'cprint', '', 'INDEX', Decimal('0.01'), Decimal('0.01')), ('172.17.172.86', 'cprint', 't_station', 'USER TABLE', Decimal('0.16'), Decimal('0.33')), ('172.17.172.86', 'cprint', '', 'INDEX', Decimal('0.01'), Decimal('0.01'))) table count (('t_device', 2215),) data size (('172.17.172.84', 'cprint', '__AUX_LOB_META_504053_', 'LOB AUX TABLE', Decimal('0.00'), Decimal('0.00')), ('172.17.172.84', 'cprint', 't_device', 'USER TABLE', Decimal('0.14'), Decimal('0.27')), ('172.17.172.84', 'cprint', '', 'INDEX', Decimal('0.01'), Decimal('0.01')), ('172.17.172.85', 'cprint', '__AUX_LOB_META_504053_', 'LOB AUX TABLE', Decimal('0.00'), Decimal('0.00')), ('172.17.172.85', 'cprint', 't_device', 'USER TABLE', Decimal('0.14'), Decimal('0.27')), ('172.17.172.85', 'cprint', '', 'INDEX', Decimal('0.01'), Decimal('0.01')), ('172.17.172.86', 'cprint', '__AUX_LOB_META_504053_', 'LOB AUX TABLE', Decimal('0.00'), Decimal('0.00')), ('172.17.172.86', 'cprint', 't_device', 'USER TABLE', Decimal('0.14'), Decimal('0.27')), ('172.17.172.86', 'cprint', '', 'INDEX', Decimal('0.01'), Decimal('0.01'))) table count (('t_set', 333),) data size (('172.17.172.84', 'cprint', '__AUX_LOB_META_504217_', 'LOB AUX TABLE', Decimal('0.00'), Decimal('0.00')), ('172.17.172.84', 'cprint', 't_set', 'USER TABLE', Decimal('0.03'), Decimal('0.03')), ('172.17.172.84', 'cprint', '', 'INDEX', Decimal('0.00'), Decimal('0.00')), ('172.17.172.85', 'cprint', '__AUX_LOB_META_504217_', 'LOB AUX TABLE', Decimal('0.00'), Decimal('0.00')), ('172.17.172.85', 'cprint', 't_set', 'USER TABLE', Decimal('0.03'), Decimal('0.03')), ('172.17.172.85', 'cprint', '', 'INDEX', Decimal('0.00'), Decimal('0.00')), ('172.17.172.86', 'cprint', '__AUX_LOB_META_504217_', 'LOB AUX TABLE', Decimal('0.00'), Decimal('0.00')), ('172.17.172.86', 'cprint', 't_set', 'USER TABLE', Decimal('0.03'), Decimal('0.03')), ('172.17.172.86', 'cprint', '', 'INDEX', Decimal('0.00'), Decimal('0.00'))) table count (('t_merchant', 58),) data size (('172.17.172.84', 'cprint', 't_merchant', 'USER TABLE', Decimal('0.01'), Decimal('0.01')), ('172.17.172.85', 'cprint', 't_merchant', 'USER TABLE', Decimal('0.01'), Decimal('0.01')), ('172.17.172.86', 'cprint', 't_merchant', 'USER TABLE', Decimal('0.01'), Decimal('0.01'))) table count (('t_pay', 10516137),) data size (('172.17.172.84', 'cprint', 't_pay', 'USER TABLE', Decimal('519.70'), Decimal('519.70')), ('172.17.172.84', 'cprint', '', 'INDEX', Decimal('450.10'), Decimal('450.10')), ('172.17.172.85', 'cprint', 't_pay', 'USER TABLE', Decimal('519.70'), Decimal('519.70')), ('172.17.172.85', 'cprint', '', 'INDEX', Decimal('450.10'), Decimal('450.10')), ('172.17.172.86', 'cprint', 't_pay', 'USER TABLE', Decimal('519.70'), Decimal('519.70')), ('172.17.172.86', 'cprint', '', 'INDEX', Decimal('450.10'), Decimal('450.10'))) table count (('t_order_file_msg', 591109),) data size (('172.17.172.84', 'cprint', 't_order_file_msg', 'USER TABLE', Decimal('9.70'), Decimal('9.70')), ('172.17.172.84', 'cprint', '', 'INDEX', Decimal('6.23'), Decimal('6.23')), ('172.17.172.85', 'cprint', 't_order_file_msg', 'USER TABLE', Decimal('9.70'), Decimal('9.70')), ('172.17.172.85', 'cprint', '', 'INDEX', Decimal('6.23'), Decimal('6.23')), ('172.17.172.86', 'cprint', 't_order_file_msg', 'USER TABLE', Decimal('9.70'), Decimal('9.70')), ('172.17.172.86', 'cprint', '', 'INDEX', Decimal('6.23'), Decimal('6.23'))) table count (('t_order_return', 1020661),) data size (('172.17.172.84', 'cprint', 't_order_return', 'USER TABLE', Decimal('30.48'), Decimal('30.48')), ('172.17.172.84', 'cprint', '', 'INDEX', Decimal('16.06'), Decimal('16.06')), ('172.17.172.85', 'cprint', 't_order_return', 'USER TABLE', Decimal('30.48'), Decimal('30.48')), ('172.17.172.85', 'cprint', '', 'INDEX', Decimal('16.06'), Decimal('16.06')), ('172.17.172.86', 'cprint', 't_order_return', 'USER TABLE', Decimal('30.48'), Decimal('30.48')), ('172.17.172.86', 'cprint', '', 'INDEX', Decimal('16.06'), Decimal('16.06'))) Gather Sql Plan Monitor Summary: +-----------+-----------+--------+------------------------------------------+ | Cluster | Status | Time | PackPath | +===========+===========+========+==========================================+ | | Completed | 67 s | /data1/obdiag_gather_pack_20250923152056 | +-----------+-----------+--------+------------------------------------------+ 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_mshzdf', `level`=>3); explain SELECT /*test092301*/ *, ( CASE WHEN t.if_color_num = 0 THEN 1 WHEN t.order_count = t.if_color_num THEN 2 ELSE 3 END ) color_type FROM ( SELECT a.order_name, a.order_id, a.cust_id, a.use_type, a.state, a.create_time, a.state_date, a.dev_id, a.print_class, a.exec_print_flag, a.checked_flag, a.station_ver, g.pay_method, g.amount, g.bean_amt, g.channel_amt, (SELECT mobile FROM t_cust cust WHERE cust.cust_id = a.cust_id) mobile, d.station_id, d.station_name, d.merchant_id, d.set_id, e.merchant_name, e.merchant_short_name, g.return_amt AS return_fee, s.set_name, a.checked_ops_name, a.checked_time, a.print_mode, ( SELECT w.total_set_name FROM t_total_set w WHERE w.total_set_id = s.total_set_id ) total_set_name, ( SELECT SUM( g.printed_page ) FROM t_order_file g WHERE g.order_id = a.order_id ) printed_page, ( SELECT SUM(CEILING(g.page_num / g.shrink_plate_num) * g.copy_num) FROM t_order_file g WHERE g.order_id = a.order_id ) page_num, ( SELECT SUM( g.if_color ) FROM t_order_file g WHERE g.order_id = a.order_id ) if_color_num, ( SELECT COUNT( 1 ) FROM t_order_file g WHERE g.order_id = a.order_id ) order_count, '' AS startPage, '' AS endPage, ( SELECT GROUP_CONCAT(CONCAT(t.file_id, ':', t.err_msg) SEPARATOR ';$$$') FROM t_order_file_msg t WHERE t.order_id = a.order_id AND err_msg != '') errMsgConcat, ( SELECT GROUP_CONCAT(CONCAT('退款描述',t.return_id,':', t.problem_desc) SEPARATOR ';$$$') FROM t_order_return t WHERE t.order_id = a.order_id AND problem_desc != '') problemDescConcat FROM t_order a LEFT JOIN t_station d ON a.station_id = d.station_id LEFT JOIN t_device c ON a.dev_id = c.dev_id LEFT JOIN t_set s ON a.set_id = s.set_id LEFT JOIN t_merchant e ON s.merchant_id = e.merchant_id LEFT JOIN t_pay g ON a.pay_id = g.pay_id WHERE 1 = 1 AND a.create_time >= '2025-09-23 00:00:00' AND a.create_time <= '2025-09-23 23:59:59' AND ( EXISTS (SELECT 1 FROM t_order_file_msg s WHERE s.order_id = a.order_id AND s.err_msg!='' AND s.err_msg LIKE CONCAT('%','重复','%')) OR EXISTS (SELECT 1 FROM t_order_return s WHERE s.order_id = a.order_id AND s.problem_desc!='' AND s.problem_desc LIKE CONCAT('%','重复','%')) ) AND a.station_id IS NOT NULL ) t WHERE 1=1 ORDER BY create_time DESC, order_id DESC LIMIT 0,30 call dbms_xplan.disable_opt_trace(); execute dbms_xplan.enable_opt_trace end Gather dbms_xplan.enable_opt_trace: +---------------+-----------+--------+--------+--------------------------------------------------------------------------------------------------+ | Node | Status | Size | Time | PackPath | +===============+===========+========+========+==================================================================================================+ | 172.17.172.84 | Completed | 1.603M | 0 s | /data1/obdiag_gather_pack_20250923152056/172_17_172_84_optimizer_trace_lrs6L2_obdiag_mshzdf.trac | +---------------+-----------+--------+--------+--------------------------------------------------------------------------------------------------+ | 172.17.172.85 | Completed | 0.000B | 0 s | | +---------------+-----------+--------+--------+--------------------------------------------------------------------------------------------------+ | 172.17.172.86 | Completed | 0.000B | 0 s | | +---------------+-----------+--------+--------+--------------------------------------------------------------------------------------------------+ Gather scene results stored in this directory: /data1/obdiag_gather_pack_20250923152056 Trace ID: d86e9758-984d-11f0-b103-00163e001663 If you want to view detailed obdiag logs, please run: obdiag display-trace d86e9758-984d-11f0-b103-00163e001663 obdiag latest version is 3.7.0, current version is 3.6.0, please update obdiag to the latest version