版本2.5.12，升级之后审计日志中有负数，也有很大的值, 集群从2.5.7版本升级到2.5.12，目前改版本有问题有回滚了，但是发现很多审计日志的统计显示有问题。
fe.audit.log.20230916-1:2023-09-16 21:30:50,659 [query] |Client=10.138.225.201:55263|User=etl_hic|AuthorizedUser=‘etl_hic’@’%’|ResourceGroup=yonghu|Catalog=default_catalog|Db=di_hic|State=EOF|ErrorCode=|Time=43|ScanBytes=463100825974509384|ScanRows=459043442046662286|ReturnRows=0|CpuCostNs=-40431606234793|MemCostBytes=1729777|StmtId=823321|QueryId=40a02030-5495-11ee-8e7b-00163e046b3f|IsQuery=true|feIp=10.163.205.117|Stmt=SELECT DISTINCT b.kdg_account FROM lemc_service_user_action_log a INNER JOIN ( SELECT user_id, max(create_time) AS max_create_time FROM lemc_service_user_action_log WHERE create_time > curdate() and opttype <> ‘DELETE’ AND user_id IN ( SELECT DISTINCT user_id FROM lemc_service_user_action_interval_log WHERE create_time > CURRENT_DATE AND STATUS = ‘1’ and opttype <> ‘DELETE’ ) GROUP BY user_id ) z ON a.user_id = z.user_id inner join lemc_service_user_info b on a.user_id = b.user_id LEFT JOIN lemc_service_function_group_user_rel d ON b.user_id = d.user_id where a.create_time = z.max_create_time AND b.user_enable = 1 AND b.user_deleted = 0 AND user_action = ‘workOut’ and a.opttype <> ‘DELETE’ and b.opt_type <> ‘DELETE’ and d.opttype <> ‘DELETE’ and d.function_group_id IN (‘zhijianetwork’) and remark = ‘offwork’|Digest=|PlanCpuCost=213506.25550460376|PlanMemCost=907.4550419137449
fe.audit.log.20230916-1:2023-09-16 22:20:02,528 [query] |Client=10.138.225.201:53079|User=etl_yh|AuthorizedUser=‘etl_yh’@’%’|ResourceGroup=hwork|Catalog=default_catalog|Db=di_hwork|State=EOF|ErrorCode=|Time=64|ScanBytes=-8049970466623703526|ScanRows=-3585727029210497024|ReturnRows=12|CpuCostNs=9218123517078453298|MemCostBytes=7436234|StmtId=882384|QueryId=20103bc7-549c-11ee-8e7b-00163e046b3f|IsQuery=true|feIp=10.163.205.117|Stmt=SELECT MD.cld_month AS monthly, round(MD.sal_amt_tax / 10000, 2) AS reality, round(MD.sal_amt_tax_mtd_ly / 10000, 2) AS period, round(if((WG.sal_amt_tax_plan_mtd) = 0, NULL, MD.sal_amt_tax / WG.sal_amt_tax_plan_mtd * 100), 2) AS percentageComplete, round(if((WG.sal_amt_tax_mtd_ly_plan_t) = 0, NULL, MD.sal_amt_tax_mtd_ly / WG.sal_amt_tax_mtd_ly_plan * 100), 2) AS percentageCompletePeriod FROM ( SELECT cld_month, sum(sal_amt_tax_plan_mtd) AS sal_amt_tax_plan_mtd, sum(sal_amt_tax_mtd_ly_plan_t) AS sal_amt_tax_mtd_ly_plan_t, sum(sal_amt_tax_mtd_ly_plan) AS sal_amt_tax_mtd_ly_plan FROM dws_tt_trd_rtl_ap_m_sm_t2_wg_d WHERE 1 = 1 AND cld_month BETWEEN ‘202210’ AND ‘202309’ and indstr_code in ( ‘LAA’ ) and pg_code in ( ‘LM’ ) and mainchnl_code in ( ‘M’ ) and xw_code in ( ‘12A02’ ) and wg_code in ( ‘CMI41097’ , ‘CMI41107’ , ‘CMI41952’ , ‘CMI42158’ , ‘CMI42209’ , ‘CMI42252’ , ‘CMI42406’ , ‘CMI42536’ , ‘CMI43012’ , ‘CMI43065’ , ‘CMI43432’ , ‘CMI43563’ , ‘CMI43694’ , ‘CMI43776’ , ‘CMI43863’ , ‘CMI43877’ , ‘CMI43935’ , ‘CMI43984’ , ‘CMI43985’ , ‘CMI44010’ , ‘CMI44012’ , ‘CMI44033’ , ‘CMI44073’ , ‘CMI44272’ , ‘CMI44273’ , ‘CMI44274’ , ‘CMI49207’ , ‘CMI49209’ , ‘CMI49213’ ) and pg_code in ( ‘FE’ , ‘GF’ , ‘AA’ , ‘GD’ , ‘LF’ , ‘GA’ , ‘AB’ , ‘DB’ , ‘LM’ , ‘FB’ , ‘LS’ , ‘GC’ , ‘CA’ , ‘GH’ , ‘GB’ , ‘DA’ , ‘FA’ , ‘LD’ , ‘LH’ , ‘EA’ , ‘FI’ , ‘BB’ ) and mainchnl_code in ( ‘D’ , ‘E’ , ‘Y’ , ‘C’ , ‘T’ , ‘M’ , ‘N’ , ‘Q’ ) GROUP BY cld_month )WG LEFT JOIN ( SELECT cld_month, sum(sal_amt_tax) AS sal_amt_tax, sum(sal_amt_tax_mtd_ly) AS sal_amt_tax_mtd_ly FROM dws_tt_trd_rtl_ap_m_sm_t2_d WHERE 1 = 1 AND cld_month BETWEEN ‘202210’ AND ‘202309’ and indstr_code in ( ‘LAA’ ) and pg_code in ( ‘LM’ ) and mainchnl_code in ( ‘M’ ) and xw_code in ( ‘12A02’ ) and subchnl_code in ( ‘GA001’ , ‘HA001’ , ‘HA002’ , ‘HA003’ , ‘HA005’ , ‘HA006’ , ‘HA007’ , ‘HA009’ , ‘HA011’ , ‘HA012’ , ‘HA013’ , ‘HA015’ , ‘HA016’ , ‘HA017’ , ‘HA018’ , ‘HA019’ , ‘HA021’ , ‘HA022’ , ‘HA023’ , ‘HA024’ , ‘HA025’ , ‘HM001’ , ‘HM002’ , ‘HM003’ , ‘HM005’ , ‘HM006’ , ‘HM009’ , ‘HM010’ , ‘HM011’ , ‘HM012’ , ‘HV001’ , ‘HV002’ , ‘HV003’ , ‘TA001’ , ‘TA002’ , ‘TA003’ , ‘TM001’ , ‘TM002’ , ‘TM012’ ) and src_jyt_code in ( ‘02040500B729’ , ‘02040500B730’ , ‘02040500B731’ , ‘02040500B732’ , ‘02040500B733’ , ‘02040500B734’ , ‘02040500B735’ , ‘02040500B736’ , ‘02040500B737’ , ‘02040500B738’ , ‘02040500B995’ , ‘02040500B996’ , ‘02040500B997’ , ‘02040500B998’ , ‘02040500B999’ , ‘02040500C001’ , ‘02040500C002’ , ‘02040500C056’ , ‘02040500C057’ , ‘02040500C553’ , ‘02040500C554’ , ‘02040501A425’ ) and pg_code in ( ‘FE’ , ‘GF’ , ‘AA’ , ‘GD’ , ‘LF’ , ‘GA’ , ‘AB’ , ‘DB’ , ‘LM’ , ‘FB’ , ‘LS’ , ‘GC’ , ‘CA’ , ‘GH’ , ‘GB’ , ‘DA’ , ‘FA’ , ‘LD’ , ‘LH’ , ‘EA’ , ‘FI’ , ‘BB’ ) and mainchnl_code in ( ‘D’ , ‘E’ , ‘Y’ , ‘C’ , ‘T’ , ‘M’ , ‘N’ , ‘Q’ ) GROUP BY cld_month )MD ON WG.cld_month = MD.cld_month ORDER BY MD.cld_month|Digest=|PlanCpuCost=2041.1468246179566|PlanMemCost=640.1825072733074