[root@test ~]# obclient -h127.0.0.1 -P2881 -uroot@test -p'xxxxxxxxxx' -A -c Welcome to the OceanBase. Commands end with ; or \g. Your OceanBase connection id is 3221741705 Server version: OceanBase_CE 4.3.2.1 (r100000102024081217-9b4a349ba1c06965b20a3f2397bd57eb0e52a667) (Built Aug 12 2024 18:11:10) Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. obclient [(none)]> use satp_testc; Database changed obclient [satp_testc]> SET ob_enable_show_trace='ON'; Query OK, 0 rows affected (0.000 sec) obclient [satp_testc]> SELECT /*+ NO_COST_BASED_QUERY_TRANSFORMATION */ -> kh.id_ AS id, -> kh.is_dzh_ AS isDzh, -> kh.zzsnslx_ AS zzsnslx, -> kh.level_ AS level, -> kh.fw_status_ AS fwStatus, -> @currentMonth:=DATE_FORMAT(NOW(), '%Y%m') currKjQj, -> @fwgdLrDate:=(SELECT -> MIN(tr.create_date_) -> FROM -> csp_ht_fwgd fwgd -> INNER JOIN -> csp_ht_fwgd_transfer tr ON fwgd.id_ = tr.new_ht_fwgd_id_ -> WHERE -> fwgd.kh_khxx_id_ = kh.id_ -> AND tr.new_zj_zjxx_id_ = 'h0000000000000498723430515097600') AS fwgdLrDate, -> @fwqxZ:=MAX(IF(ht.status_ != '4', '', ht.fwqx_z_)) AS fwqxZ, -> @fwqxQ:=IFNULL((SELECT -> htxx.fwqx_q_ -> FROM -> ftsp_ht_htxx htxx -> WHERE -> htxx.id_ = hf.ht_htxx_id_), -> MIN(ht.fwqx_q_)) AS fwqxQ, -> @shDate:=MIN(ht.sh_date_) AS shDate, -> @tkwcRq:=(SELECT -> MAX(tk.tkwc_rq_) -> FROM -> ftsp_ht_htxx ht1 -> LEFT JOIN -> ftsp_ht_tkxx tk ON ht1.id_ = tk.ht_id_ AND tk.tkzt_ = 3 -> WHERE -> ht1.kh_khxx_id_ = kh.id_) tkwcRq, -> @wqWcrq:=(SELECT -> IF(MAX(mx.sycs_) <= 0 -> AND GROUP_CONCAT(DISTINCT taskfwsx.status_) = 8, -> MAX(taskfwsx.confirm_time_), -> IF(MAX(mx.sycs_) <= 0 -> AND GROUP_CONCAT(DISTINCT taskfwsx.status_) IS NULL, -> mx.finish_date_, -> NULL)) -> FROM -> ftsp_ht_fwsxmx mx -> INNER JOIN -> ftsp_wq_fwsx wqfwsx ON wqfwsx.id_ = mx.wq_fwsx_id_ -> AND wqfwsx.wqlx_ != 0 -> LEFT JOIN -> ftsp_wq_task_fwsx taskfwsx ON taskfwsx.ht_fwsxmx_id_ = mx.id_ -> LEFT JOIN -> ftsp_ht_tkxx_fwsx tf ON tf.ht_fwsxmx_id_ = mx.id_ -> AND tf.tkzt_ = 3 -> WHERE -> mx.ht_htxx_id_ = ht.id_ -> AND mx.zf_zt_ = 0 -> AND tf.id_ IS NULL) wqWcRq, -> @initialStatus:=IF((init.initial_status_ = '1') -> AND EXISTS( SELECT -> 1 -> FROM -> ftsp_ht_khfw khfw -> WHERE -> kh.id_ = khfw.kh_khxx_id_ AND yjjz_ = 1) -> AND EXISTS( SELECT -> 1 -> FROM -> ftsp_ht_htxx ht -> WHERE -> ht.kh_khxx_id_ = kh.id_ -> AND ht.status_ = 4 -> AND ht.htlx_ IN ('20' , '30', '40') -> AND kh.is_dzh_ != 0), -> 1, -> IF(EXISTS( SELECT -> 1 -> FROM -> ftsp_ht_khfw khfw -> WHERE -> kh.id_ = khfw.kh_khxx_id_ AND yjjz_ = 1) _ -> AND EXISTS( SELECT -> 1 -> FROM -> ftsp_ht_htxx ht -> WHERE -> ht.kh_khxx_id_ = kh.id_ -> AND ht.status_ = 4 -> AND ht.htlx_ IN ('20' , '30', '40') -> AND kh.is_dzh_ != 0), -> 0, -> NULL)) AS initialStatus, -> IF(ht.id_ IS NOT NULL, -> (SELECT -> pj.fxkh_ -> FROM -> ftsp_kh_fwda_khpj pj -> WHERE -> pj.kh_khxx_id_ = kh.id_), -> NULL) AS fxStatus, -> MAX(IF(EXISTS( SELECT -> 1 -> FROM -> ftsp_ht_htxx ht1 -> LEFT JOIN -> ftsp_ht_tkxx tk ON tk.ht_id_ = ht1.id_ -> LEFT JOIN -> ftsp_ht_tkxx_tkyy tkyy ON tk.id_ = tkyy.ht_tkxx_id_ -> LEFT JOIN -> ftsp_ht_xfgt xf ON ht1.id_ = xf.ht_htxx_id_ -> LEFT JOIN -> ftsp_kh_tyxx ty ON ty.kh_khxx_id_ = ht1.kh_khxx_id_ -> WHERE -> ht1.id_ = ht.id_ -> AND (tk.lczt_ = '5' -> AND tkyy.tkyy_code_value_ IN ('0409' , '0410', '0411', '0412') -> OR (xf.xfyx_ = '0' AND xf.bxfzt_ = '3' -> AND ty.ty_yy_label_ IN ('0409' , '0410', '0411', '0412')))), -> 1, -> 0)) AS gwStatus, -> @zhStatus:=IF(hf.wxjz_ = '1' OR hf.yjjz_ = '1', -> 1, -> 0) AS zhStatus, -> @yjjz:=IF(hf.wxjz_ = '1', -> 2, -> IF(hf.yjjz_ = '1', 1, 0)) AS yjjz, -> zh.dfp_zh_ AS dfpZh, -> zh.dfp_jz_ AS dfpJz, -> zh.dfp_status_ AS dfpStatus, -> IF(zt.id_ IS NOT NULL, 1, 0) AS defaultZt, -> IF(@yjjz != 0, -> IF(DATE_FORMAT(hf.yjjz_date_, '%Y%m') = @currentMonth, -> @yjjz, -> NULL), -> NULL) AS dyYzhFs, -> IF(@zhStatus = 0, -> IF(EXISTS( SELECT -> 1 -> FROM -> ftsp_ht_khfw_error er -> WHERE -> er.kh_khxx_id_ = kh.id_), -> 1, -> 0), -> NULL) AS whWzhyyStatus, -> TIMESTAMPDIFF(DAY, -> @shDate, -> IFNULL(hf.yjjz_date_, NOW())) AS zhZq, -> @scgt:=IF(EXISTS( SELECT -> 1 -> FROM -> ftsp_ht_khfw hf1 -> WHERE -> hf1.kh_khxx_id_ = kh.id_ -> AND hf1.scgt_ = 1), -> 1, -> 0), -> IF(@zhStatus = 0, -> IF(zh.hs_qylxr_type_ IN ('1' , '2', '3') -> AND (EXISTS( SELECT -> 1 -> FROM -> ftsp_ht_hsxx hsxx -> WHERE -> hsxx.kh_khxx_id_ = kh.id_) -> OR NOT EXISTS( SELECT -> 1 -> FROM -> ftsp_ht_htxx ht -> INNER JOIN -> ftsp_ht_fwsxmx mx ON ht.id_ = mx.ht_htxx_id_ -> LEFT JOIN -> ftsp_ht_tkxx_fwsx htf ON mx.id_ = htf.ht_fwsxmx_id_ -> AND htf.tkzt_ = 3 -> LEFT JOIN -> ftsp_ht_hsxx hs ON hs.kh_khxx_id_ = ht.kh_khxx_id_ -> AND ht.id_ = hs.ht_htxx_id_ -> WHERE -> mx.kh_khxx_id_ = kh.id_ -> AND ht.status_ IN (4) -> AND htf.id_ IS NULL -> AND hs.hs_type_ IS NULL)), -> 2, -> IF(EXISTS( SELECT -> 1 -> FROM -> ftsp_ht_khfw_error er -> JOIN -> ftsp_infra_code_value value ON er.code_ = value.value1_ -> AND value.infra_code_type_id_ = 'h0000000000000033091146981793793' -> WHERE -> er.kh_khxx_id_ = kh.id_ -> AND value.status_ = '1' -> AND value.value1_ IN ('E031' , 'E100', 'E014', 'E036', 'E103') -> AND er.deal_progress_ NOT IN ('3' , '6', '5') -> AND er.is_jfyc_ = '1'), -> 0, -> 1)), -> 0) AS dzhScgtStatus, -> zh.hs_qylxr_date_ dzhScgtDate, -> (SELECT -> MIN(hsxx.create_date_) -> FROM -> ftsp_ht_hsxx hsxx -> WHERE -> hsxx.kh_khxx_id_ = kh.id_) AS hsHtxxDate, -> IF(@yjjz = 1, -> IF(init.cwscgt_ = 1, 2, 1), -> 0) AS dgwScgtStatus, -> init.cwscgt_date_ AS csScgtDate, -> hf.yjjz_date_ AS zhDate, -> IF(EXISTS( SELECT -> 1 -> FROM -> ftsp_kh_bq -> WHERE -> infra_khbq_id_ = 'h0000000000000417138514390507521' -> AND kh_khxx_id_ = kh.id_), -> 1, -> 0) AS tyd, -> CASE -> WHEN hf.wxjz_ = '1' THEN 4 -> WHEN -> @yjjz = '1' -> THEN -> CASE -> WHEN -> zt.id_ IS NOT NULL -> AND @initialStatus = '1' -> THEN -> 7 -> WHEN -> zt.id_ IS NOT NULL -> AND IFNULL(@initialStatus, '0') != '1' -> THEN -> 6 -> WHEN zt.id_ IS NULL THEN 5 -> END -> WHEN -> kh.is_dzh_ = '1' -> AND IFNULL(hf.yjjz_, '0') = '0' -> THEN -> 1 -> WHEN -> IFNULL(kh.is_dzh_, '0') = '0' -> AND IFNULL(hf.wxjz_, '0') = '0' -> THEN -> 2 -> END AS zhjd, -> IF(EXISTS( SELECT -> 1 -> FROM -> ftsp_ht_htxx ht1 -> WHERE -> ht1.kh_khxx_id_ = kh.id_ -> AND ht1.status_ = 4 -> AND ((ht1.qd_sc_ IS NOT NULL -> AND ht1.qd_sc_ > 0) -> OR (ht1.cxsc_ IS NOT NULL AND ht1.cxsc_ > 0) -> OR (ht1.zssc_ IS NOT NULL AND ht1.zssc_ > 0) -> OR (ht1.lzsc_ IS NOT NULL AND ht1.lzsc_ > 0))), -> 1, -> 0) AS dzlzSc, -> IF(EXISTS( SELECT -> 1 -> FROM -> ftsp_ht_fwsxmx mx -> INNER JOIN -> ftsp_wq_fwsx wf ON wf.id_ = mx.wq_fwsx_id_ -> AND wf.kind_ IN ('04' , '02', '05') -> LEFT JOIN -> ftsp_ht_tkxx_fwsx tk ON mx.id_ = tk.ht_fwsxmx_id_ -> AND tk.tkzt_ = 3 -> WHERE -> tk.id_ IS NULL -> AND mx.kh_khxx_id_ = kh.id_ -> AND (mx.finish_status_ != 1 -> AND mx.zf_zt_ != 1 -> AND (mx.ht_htxx_id_ = '00000000000000000000000000000000' -> OR (EXISTS( SELECT -> 1 -> FROM -> ftsp_ht_htxx h -> WHERE -> h.id_ = mx.ht_htxx_id_ -> AND h.status_ = '4'))))), -> 1, -> 0) AS fwsxType, -> kh.ht_fw_zt_ htFwZt, -> IF(EXISTS( SELECT -> 1 -> FROM -> ftsp_ht_htxx ht1 -> WHERE -> ht1.kh_khxx_id_ = kh.id_ -> AND ht1.status_ IN (4 , 8)), -> 1, -> 0) AS khzhStatus, -> EXISTS( SELECT -> 1 -> FROM -> ftsp_kh_pg pg -> INNER JOIN -> ftsp_infra_user u ON u.id_ = pg.infra_user_id_ -> WHERE -> u.is_delete_ = '0' -> AND u.role_code_ LIKE CONCAT('%', 'PORTAL_ZBKJ_GWS', '%') -> AND pg.kh_khxx_id_ = kh.id_) AS zzkj, -> EXISTS( SELECT -> 1 -> FROM -> ftsp_kh_pg pg -> INNER JOIN -> ftsp_infra_user u ON u.id_ = pg.infra_user_id_ -> WHERE -> u.is_delete_ = '0' -> AND u.role_code_ LIKE CONCAT('%', 'PORTAL_CSGW_GWS', '%') -> AND pg.kh_khxx_id_ = kh.id_) AS csgw, -> (SELECT -> jcxx.sfzxh_ -> FROM -> ftsp_kh_jcxx jcxx -> WHERE -> jcxx.kh_khxx_id_ = kh.id_) AS zxh, -> hf.fw_lx_ fwLx, -> DATE_FORMAT(ty_date_, '%Y%m') tyDate, -> zh.jfyc_status_ jfycStatus, -> IF(EXISTS( SELECT -> 1 -> FROM -> ftsp_ht_khfw_error er -> JOIN -> ftsp_infra_code_value value ON er.code_ = value.value1_ -> AND value.infra_code_type_id_ = 'h0000000000000033091146981793793' -> WHERE -> er.kh_khxx_id_ = kh.id_ -> AND value.status_ = '1' -> AND value.value1_ IN ('E037' , 'E031', 'E100', 'E014', 'E036') -> AND er.deal_progress_ NOT IN ('3' , '6', '5') -> AND er.is_jfyc_ = '1'), -> 1, -> 0) tcJfycStatus, -> IF(EXISTS( SELECT -> 1 -> FROM -> ftsp_ht_khfw_error er -> WHERE -> er.kh_khxx_id_ = kh.id_ -> AND er.deal_progress_ = '5'), -> 1, -> 0) jfycDhs -> FROM -> ftsp_kh_khxx kh -> LEFT JOIN -> ftsp_ht_htxx ht ON ht.kh_khxx_id_ = kh.id_ -> AND ht.status_ = 4 -> LEFT JOIN -> ftsp_kh_zh_work_bench zh ON zh.kh_khxx_id_ = kh.id_ -> LEFT JOIN -> ftsp_ht_khfw hf ON hf.kh_khxx_id_ = kh.id_ -> AND hf.fw_lx_ = '1' -> LEFT JOIN -> ftsp_zt_ztxx zt ON zt.kh_khxx_id_ = kh.id_ -> AND zt.is_default_ = '1' -> LEFT JOIN -> ftsp_kh_initial_work_bench init ON init.kh_khxx_id_ = kh.id_ -> WHERE -> kh.zj_zjxx_id_ = 'h0000000000000498723430515097600' -> AND kh.fw_status_ = '1' -> AND kh.id_ IN ( -> '34236668E4F24A2194078B06A41FB3E9', -> 'h0000000000000723719839150735360', -> 'h0000000000000723721895296237568', -> 'h0000000000000723725015971635200', -> 'h0000000000000723725944125022208', -> 'h0000000000000723727762867486720', -> 'h0000000000000723027926701416448', -> 'FAE0ADFBC45C4CC49A43812C0D85886D', -> 'h0000000000000723740577568088064', -> 'h0000000000000723764224533954560', -> 'h0000000000000414686761562685610', -> 'h0000000000000723770814864670720', -> 'h0000000000000721635630453366784', -> 'A801EC5C41CC4498AFB9CC7C3B99C6FE', -> 'h0000000000000270905798948709064', -> 'h0000000000000723773802352967680', -> 'h0000000000000723777364676009984', -> 'h0000000000000723724900702601216', -> 'h0000000000000723792559037177856', -> 'h0000000000000723793193538904064', -> 'h0000000000000718746453054595072', -> 'h0000000000000723795291613667328', -> 'h0000000000000723809000746622976', -> 'A6A60FD955234A96A18EEE6BECC28340', -> 'h0000000000000723813892685021184', -> 'h0000000000000723819395545972736', -> 'h0000000000000723828924156182528', -> '28F140F099A54CE7820E26C72D0766FB', -> 'D4E8A86271B2444CAEEA782D1BD57662', -> '457A44E783FE424FBDB3A05881842E4A', -> 'h0000000000000302974729383772160', -> 'h0000000000000304426901648629760', -> 'h0000000000000723864891199176704', -> 'h0000000000000304444614374809600', -> 'h0000000000000304445703337730048', -> '3C426DB4C422412487B4B0F257D511A2', -> '9AB2904F320B44F78D380A0EDE8FB777', -> '9424C1F306024F09A43B3D55C5F01998', -> 'h0000000000000304478707036643328', -> 'h0000000000000254492324970897536', -> '13fb3f5c610545d58da169ef29c38b01', -> 'h0000000000000292995586075181067', -> '6F18F2BE57284C6A99D9FA9AFED0761B', -> 'h0000000000000254249655644234017', -> 'h0000000000000304516426437713920', -> 'h0000000000000297169967694233600', -> 'h0000000000000279888233080111591', -> 'h0000000000000297681196213616719', -> 'h0000000000000257686961026138473', -> 'h0000000000000267985696891675845', -> '8B3E36C081254D8CA9591E2558CCE090', -> 'h0000000000000304565098089226240', -> 'h0000000000000304568441587048448', -> 'h0000000000000125535160930034047', -> '0534221B7D4541CCACE6090964500285', -> 'h0000000000000724061446504931328', -> 'h0000000000000034450037090623488', -> 'B22F868B0B764A09A1428AFF5A2CBCBC', -> 'ACAD193F8F5A411595D98F8503E77F99', -> '0CE656BD22AF4C2EB9176EF4BDC458DD', -> 'h0000000000000724154007051550720', -> 'h0000000000000724162090797785088', -> 'h0000000000000542736819524067800', -> 'h0000000000000107032479624822807', -> 'h0000000000000483171988757233664', -> '1C5E142BF6B04498AF1E423B78298F59', -> 'h0000000000000724210513726070784', -> 'h0000000000000304773993869008896', -> 'h0000000000000302634834664579072', -> 'h0000000000000302614239776268288', -> 'h0000000000000142822591766438017', -> '6ECAE3DE7B194C5990D382AFD072F2C8', -> 'h0000000000000170729408827809792', -> '14869805049584908244 ', -> 'E6C0D181AA8947A0AB9982D99E05D8D2', -> 'h0000000000000304843433277054976', -> 'h0000000000000303417233084768256', -> 'h0000000000000269991955040755816', -> 'h0000000000000181081137609793652', -> '14767748520687034455 ', -> 'h0000000000000304864450133286912', -> 'h0000000000000300424046572700153', -> 'h0000000000000304552293726380032', -> '251558c660904d35b1ceb4d4a5d15dea', -> '833E37CADC87456B9A97F8C7D5502091', -> 'h0000000000000304899210738106368', -> 'h0000000000000234191610981548582', -> 'h0000000000000274397987003998301', -> 'h0000000000000230347561999212544', -> 'h0000000000000054110362505454764', -> 'DDCD480FD80845BFA4A6132FB853B161', -> 'h0000000000000304796305745969152', -> 'h0000000000000304931530857717760', -> 'h0000000000000304911545158541312', -> '29A0A978077C4A5F8DDD69E3B294C90B', -> 'h0000000000000294597953715781643', -> 'h0000000000000724440982204850176', -> '2B3FFFD5BFA34E05811FB5F029FF9440', -> 'h0000000000000082753401467142149', -> '4B15260A35644CB68530BF4582A6CD81', -> 'h0000000000000724499642741374976', -> 'h0000000000000724499149424074752', -> 'h0000000000000724507527596654592', -> 'h0000000000000724507481748725760', -> 'h0000000000000724518956118761472', -> 'h0000000000000724520333633077248', -> 'h0000000000000724522237779943424', -> 'E820CD5DBC6D4402A654C755B7BE0DCA', -> 'h0000000000000723507205084266496', -> 'h0000000000000724533114579107840', -> 'h0000000000000724518650917027840', -> 'h0000000000000724536037884149760', -> 'h0000000000000724542432900759552', -> 'h0000000000000722985982956773377', -> '36AD690B50D64E0B98C38CD8ACEEFCDD', -> 'h0000000000000305141955264200704', -> 'h0000000000000275807199836087798', -> 'h0000000000000305157188418486272', -> 'h0000000000000243369829867806815', -> '8F92145936F24BF4B228A73107205F50', -> 'h0000000000000259950636164071424', -> 'h0000000000000305156806963306496', -> 'h0000000000000305164730276208640', -> 'h0000000000000724452729526632448', -> '922f740ff7a24dd58bb97f5718f50fda', -> '5CA449B71CBB4B1D8B41339A1831B78B', -> 'h0000000000000265768311404708555', -> 'h0000000000000305205333475155968', -> 'ABA9023D43F44E15B3F34B15690ABEC9', -> 'h0000000000000304844025307267072', -> 'h0000000000000247329166550860289', -> 'AD76E7089DD7467197C778332D4A9763', -> 'h0000000000000053711454633566664', -> 'h0000000000000241550432005587078', -> 'B89C82C1C91B4F72B4DB99A22D29C22A', -> '2ab24d0af4014775984f30793d9716b2', -> 'h0000000000000305163873877737472', -> 'C869F44C9BA045ACB1C9A627F8E7453E', -> 'h0000000000000305243916105867264', -> 'h0000000000000257420134761022212', -> 'h0000000000000305243144223940608', -> 'h0000000000000305258433409916928', -> 'h0000000000000305211971179347968', -> 'CEEBA0364DCE486FAE36F2796F9223F7', -> 'h0000000000000305274520881037312', -> '9022E50CCFA64F6C859FA7FEEB3CA0DB', -> '9AE506969B2D4C33A0108B245870FDF4', -> '03107BA2FE554DACA9EA2F4066ACE557', -> 'h0000000000000724840477185974272', -> '4734548F09444FA89EF5A316FEF06316', -> 'E390DFF439CC4FE0BD699B43FB0CECA7', -> 'h0000000000000247329166538276896', -> '69995747147646c3a18ef5172c3f9d26', -> 'h0000000000000259217775795143043', -> '4F0E20713D234FF5A27A143B4960C518', -> 'h0000000000000724946731174641664', -> 'h0000000000000304877872127164416', -> 'h0000000000000305535603109724160', -> 'h0000000000000137103803694621229', -> 'h0000000000000305536638385586176', -> 'h0000000000000305547060790624256', -> 'F6E9B1495F1C4B3A8D56F8FF93C46DD9', -> 'h0000000000000289564115418497028', -> 'h0000000000000200775292788171057', -> 'h0000000000000258186906250707028', -> 'h0000000000000305212086354911232', -> 'h0000000000000305574162118172672', -> 'h0000000000000305562146032787456', -> 'h0000000000000302037093272027350', -> 'h0000000000000299805761412096000', -> 'h0000000000000305587154700435456', -> 'h0000000000000304582043475853312', -> 'h0000000000000305564225468047360', -> 'h0000000000000081332275838935040', -> 'h0000000000000305612560690274304', -> 'h0000000000000247326428848955546', -> 'h0000000000000257653388575440966', -> 'h0000000000000297535879455450011', -> 'h0000000000000283193772351971771', -> 'h0000000000000305635742063214592', -> 'FA588DC9A7024174B11D6FABC5DBF555', -> 'h0000000000000125871690378739945', -> 'h0000000000000275772998730514850', -> 'h0000000000000175190294598508906', -> 'C7005C33EF584747A2473AD794B7D33E', -> 'BCCFB1B24C9149E3BC9ECCB07D5795E7', -> 'C38E8719202544B5B88BC8C4E838D3C9', -> '77A7BA60CFAE446D861ACB13255055F2', -> 'F3C0F26450644D6BAFEE2726F9732644', -> 'h0000000000000300197292015042560', -> 'h0000000000000305876303152119808', -> 'h0000000000000305875145008300032', -> 'h0000000000000305875232283377664', -> 'h0000000000000275773011120431136', -> 'h0000000000000260562279752376536', -> 'h0000000000000305892253305888768', -> 'h0000000000000263668641769185803', -> 'DEE56745A6D84C518761DAE721351C68', -> 'h0000000000000305892335417745408', -> 'h0000000000000299333779395903771', -> 'h0000000000000268920993645601632', -> 'h0000000000000305929428810530816', -> 'h0000000000000305892222356094976', -> 'h0000000000000302970516343832576') -> GROUP BY kh.id_; ERROR 4013 (HY001): No memory or reach tenant memory limit obclient [satp_testc]> obclient [satp_testc]> obclient [satp_testc]> obclient [satp_testc]> select last_trace_id(); +-----------------------------------+ | last_trace_id() | +-----------------------------------+ | YB42AC12607E-00062498D82FB100-0-0 | +-----------------------------------+ 1 row in set (0.000 sec) [root@test log]# grep "YB42AC12607E-00062498D82FB100-0-0" observer.log [2024-10-23 12:01:48.323022] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=4][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.323230] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=29][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"hf", column:"ht_htxx_id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.323390] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=15][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.323626] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=10][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"ht", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.323883] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=10][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.323975] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=17][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6b398d8 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.324050] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=13][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"is_dzh_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.324142] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=11][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.324224] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=13][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6b398d8 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.324281] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=9][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"is_dzh_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.324371] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=7][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.324533] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=8][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"ht", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:0, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.324827] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=8][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.324918] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=9][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.325021] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=9][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.325178] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=8][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6b398d8 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.325311] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=8][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6b398d8 0x6b398d8 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.325478] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=8][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.325601] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=9][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.325770] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=9][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.326054] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=9][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.326125] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=10][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"mx", column:"ht_htxx_id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:2, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x6b39b83 0x6b398d8 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.326269] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=22][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.326437] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=8][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.326551] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=9][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.326622] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=8][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.326748] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=8][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6b398d8 0x6b398d8 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.326875] WDIAG [SQL.RESV] resolve_table_column_ref (ob_select_resolver.cpp:5417) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=8][errcode=-5217] resolve table column expr failed(ret=-5217, q_name={database_name:"", table_name:"kh", column:"id_", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:1, is_access_root:true}, lbt()="0x1a275b71 0xd152ac1 0x6a203cb 0x6a1fd69 0x6a1f32c 0x6a1dc2e 0x6a11dac 0x6b39b83 0x6b398d8 0x6a82ea3 0xcf849cc 0x688eff8 0x688cbd5 0xd06ea96 0xd001e74 0xd15577e 0x6a108e8 0x68a06f2 0x68919e7 0x688cbd5 0x1196b2c7 0x68b193e 0x677decc 0x6774d15 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:48.327279] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=7][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.327287] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=8][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.327296] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=6][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.327300] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=4][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.327307] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=currentmonth, ret=-5112) [2024-10-23 12:01:48.327310] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=currentmonth, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.327318] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.327323] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=4][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.327339] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] unknown user variable(var=zhstatus, ret=-5112) [2024-10-23 12:01:48.327342] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=zhstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.327348] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=zhstatus, ret=-5112) [2024-10-23 12:01:48.327351] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=zhstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.327366] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=shdate, ret=-5112) [2024-10-23 12:01:48.327369] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=shdate, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.327376] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=shdate, ret=-5112) [2024-10-23 12:01:48.327379] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=shdate, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.327401] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=zhstatus, ret=-5112) [2024-10-23 12:01:48.327404] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=zhstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.327409] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=zhstatus, ret=-5112) [2024-10-23 12:01:48.327410] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=zhstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.327452] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.327456] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.327462] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.327464] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.327510] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.327514] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=4][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.327530] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=4][errcode=-5112] unknown user variable(var=initialstatus, ret=-5112) [2024-10-23 12:01:48.327533] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=initialstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.327547] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] unknown user variable(var=initialstatus, ret=-5112) [2024-10-23 12:01:48.327558] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=11][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=initialstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331311] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=6][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.331327] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=15][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331340] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=7][errcode=-5112] unknown user variable(var=currentmonth, ret=-5112) [2024-10-23 12:01:48.331343] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=currentmonth, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331347] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.331349] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331364] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] unknown user variable(var=zhstatus, ret=-5112) [2024-10-23 12:01:48.331367] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=zhstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331383] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=shdate, ret=-5112) [2024-10-23 12:01:48.331386] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=shdate, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331411] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=zhstatus, ret=-5112) [2024-10-23 12:01:48.331414] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=zhstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331449] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.331452] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331489] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.331492] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331500] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=initialstatus, ret=-5112) [2024-10-23 12:01:48.331505] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=5][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=initialstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331514] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] unknown user variable(var=initialstatus, ret=-5112) [2024-10-23 12:01:48.331517] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=initialstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331835] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.331840] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=5][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331847] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] unknown user variable(var=currentmonth, ret=-5112) [2024-10-23 12:01:48.331850] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=currentmonth, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331854] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.331856] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331869] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=zhstatus, ret=-5112) [2024-10-23 12:01:48.331871] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=zhstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331884] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=shdate, ret=-5112) [2024-10-23 12:01:48.331887] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=shdate, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331908] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=zhstatus, ret=-5112) [2024-10-23 12:01:48.331911] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=zhstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331940] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.331943] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331975] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.331978] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331985] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] unknown user variable(var=initialstatus, ret=-5112) [2024-10-23 12:01:48.331988] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=initialstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.331995] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=initialstatus, ret=-5112) [2024-10-23 12:01:48.331997] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=initialstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.335122] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.335142] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=20][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.335155] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=7][errcode=-5112] unknown user variable(var=currentmonth, ret=-5112) [2024-10-23 12:01:48.335159] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=4][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=currentmonth, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.335163] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.335165] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.335178] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=zhstatus, ret=-5112) [2024-10-23 12:01:48.335181] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=zhstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.335194] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=shdate, ret=-5112) [2024-10-23 12:01:48.335197] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=shdate, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.335219] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=zhstatus, ret=-5112) [2024-10-23 12:01:48.335222] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=zhstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.335254] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.335257] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.335289] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.335292] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.335299] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] unknown user variable(var=initialstatus, ret=-5112) [2024-10-23 12:01:48.335302] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=initialstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.335309] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=initialstatus, ret=-5112) [2024-10-23 12:01:48.335312] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=initialstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.344574] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.344587] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=11][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.344606] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=12][errcode=-5112] unknown user variable(var=currentmonth, ret=-5112) [2024-10-23 12:01:48.344610] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=currentmonth, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.344614] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.344616] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.344632] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=zhstatus, ret=-5112) [2024-10-23 12:01:48.344635] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=zhstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.344653] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=shdate, ret=-5112) [2024-10-23 12:01:48.344656] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=shdate, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.344685] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] unknown user variable(var=zhstatus, ret=-5112) [2024-10-23 12:01:48.344688] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=zhstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.344728] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.344731] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.344776] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.344779] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.344789] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=initialstatus, ret=-5112) [2024-10-23 12:01:48.344792] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=initialstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.344800] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=initialstatus, ret=-5112) [2024-10-23 12:01:48.344803] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=initialstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.345907] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.345914] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=7][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.345925] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=4][errcode=-5112] unknown user variable(var=currentmonth, ret=-5112) [2024-10-23 12:01:48.345928] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=currentmonth, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.345932] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.345933] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.345948] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=zhstatus, ret=-5112) [2024-10-23 12:01:48.345951] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=zhstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.345966] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=shdate, ret=-5112) [2024-10-23 12:01:48.345968] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=shdate, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.345993] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=zhstatus, ret=-5112) [2024-10-23 12:01:48.345996] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=zhstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.346031] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.346034] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.346074] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.346077] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.346084] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=initialstatus, ret=-5112) [2024-10-23 12:01:48.346087] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=initialstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.346095] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] unknown user variable(var=initialstatus, ret=-5112) [2024-10-23 12:01:48.346098] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=initialstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.356407] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.356419] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=11][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.356433] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=8][errcode=-5112] unknown user variable(var=currentmonth, ret=-5112) [2024-10-23 12:01:48.356437] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=4][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=currentmonth, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.356441] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.356443] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=1][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.356458] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=zhstatus, ret=-5112) [2024-10-23 12:01:48.356460] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=zhstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.356476] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=shdate, ret=-5112) [2024-10-23 12:01:48.356480] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=shdate, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.356506] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=zhstatus, ret=-5112) [2024-10-23 12:01:48.356509] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=zhstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.356548] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.356551] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.356594] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=yjjz, ret=-5112) [2024-10-23 12:01:48.356597] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=4][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=yjjz, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.356606] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=initialstatus, ret=-5112) [2024-10-23 12:01:48.356609] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=initialstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.356617] WDIAG [SQL.SESSION] get_user_variable (ob_basic_session_info.cpp:3840) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-5112] unknown user variable(var=initialstatus, ret=-5112) [2024-10-23 12:01:48.356620] WDIAG [SQL.ENG] calc_result_type1 (ob_expr_get_user_var.cpp:49) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-5112] fail to exec type_ctx.get_session()->get_user_variable(key, session_var)(ret=-5112, key=initialstatus, session_var={meta:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}, value:{"NULL":"NULL"}}) [2024-10-23 12:01:48.382781] WDIAG [SQL.REWRITE] is_key_part (ob_query_range.cpp:4821) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=1][errcode=0] get kay_part_id from hash map failed(ret=0, id.table_id=18446744073709551609, id.column_id=16) [2024-10-23 12:01:48.496597] WDIAG [SQL.REWRITE] is_key_part (ob_query_range.cpp:4821) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=0] get kay_part_id from hash map failed(ret=0, id.table_id=18446744073709551593, id.column_id=58) [2024-10-23 12:01:48.593960] WDIAG [SQL.REWRITE] is_key_part (ob_query_range.cpp:4821) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=0] get kay_part_id from hash map failed(ret=0, id.table_id=18446744073709551593, id.column_id=58) [2024-10-23 12:01:48.671546] WDIAG [SQL.REWRITE] is_key_part (ob_query_range.cpp:4821) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=0] get kay_part_id from hash map failed(ret=0, id.table_id=18446744073709551554, id.column_id=16) [2024-10-23 12:01:48.671617] WDIAG [SQL.REWRITE] is_key_part (ob_query_range.cpp:4821) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=11][errcode=0] get kay_part_id from hash map failed(ret=0, id.table_id=18446744073709551554, id.column_id=16) [2024-10-23 12:01:48.671640] WDIAG [SQL.REWRITE] is_key_part (ob_query_range.cpp:4821) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=4][errcode=0] get kay_part_id from hash map failed(ret=0, id.table_id=18446744073709551554, id.column_id=16) [2024-10-23 12:01:48.671663] WDIAG [SQL.REWRITE] is_key_part (ob_query_range.cpp:4821) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=0] get kay_part_id from hash map failed(ret=0, id.table_id=18446744073709551554, id.column_id=16) [2024-10-23 12:01:58.521708] WDIAG print_tenant_memblock_info (ob_kvcache_store.cpp:762) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=0] [CACHE-SYNC-WASH] len: 69211 tenant sync wash failed, cache memblock info: [2024-10-23 12:01:58.521743] INFO [COMMON] try_flush_washable_mb (ob_kvcache_store.cpp:633) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=33] can not find enough memory block to wash(ret=-4273, size_washed=4194304, size_need_washed=6291456) [2024-10-23 12:01:58.521749] WDIAG [COMMON] alloc_chunk (ob_resource_mgr.cpp:86) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=5][errcode=-4273] sync_wash_mbs failed(ret=-4273, tenant_id=1002, wash_size=6291456) [2024-10-23 12:01:58.521754] WDIAG [COMMON] alloc_chunk (ob_resource_mgr.cpp:113) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=4][errcode=-4273] after wash from cache, still can't alloc chunk from chunk_mgr, maybe alloc by other thread(size=2080768, wash_size=6291456, ret=-4273) [2024-10-23 12:01:58.521757] WDIAG alloc_block (ob_page_manager.h:136) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=0] oops, alloc failed, tenant_id=1002 ctx_id=0 hold=73863962624 limit=9223372036854775807 [2024-10-23 12:01:58.521953] INFO sync_wash (ob_tenant_ctx_allocator.cpp:389) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2] [MEM][WASH] tenant_id: 1002, ctx_id: 18, washed_size: 2056192 [2024-10-23 12:01:58.522987] INFO [COMMON] try_flush_washable_mb (ob_kvcache_store.cpp:633) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=4] can not find enough memory block to wash(ret=-4273, size_washed=0, size_need_washed=6291456) [2024-10-23 12:01:58.522995] WDIAG [COMMON] alloc_chunk (ob_resource_mgr.cpp:86) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=8][errcode=-4273] sync_wash_mbs failed(ret=-4273, tenant_id=1002, wash_size=6291456) [2024-10-23 12:01:58.522999] WDIAG [COMMON] alloc_chunk (ob_resource_mgr.cpp:113) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-4273] after wash from cache, still can't alloc chunk from chunk_mgr, maybe alloc by other thread(size=2080768, wash_size=6291456, ret=-4273) [2024-10-23 12:01:58.523001] WDIAG alloc_block (ob_page_manager.h:136) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=0] oops, alloc failed, tenant_id=1002 ctx_id=0 hold=73870254080 limit=9223372036854775807 [2024-10-23 12:01:58.523017] WARN [LIB] common_realloc (ob_tenant_ctx_allocator.cpp:539) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=6][errcode=-4013] [OOPS]: alloc failed reason is that tenant memory has reached the upper limit(tenant_id: 1002, tenant_hold: 86005424128, tenant_limit: 86006720103, alloc_size: 2097152) [2024-10-23 12:01:58.523019] WDIAG common_realloc (ob_tenant_ctx_allocator.cpp:544) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-4013] oops, alloc failed, tenant_id=1002, ctx_id=0, ctx_name=DEFAULT_CTX_ID, ctx_hold=73870254080, ctx_limit=9223372036854775807, tenant_hold=86005424128, tenant_limit=86006720103 [2024-10-23 12:01:58.523029] WDIAG alloc_new_page (page_arena.h:329) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-4013] cannot allocate memory.sz=245760, pages_=240503,total_=59106017280 [2024-10-23 12:01:58.523031] WDIAG extend_page (page_arena.h:354) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-4013] extend_page sz =245760 cannot alloc new page [2024-10-23 12:01:58.523034] EDIAG [LIB] reserve (ob_se_array.h:367) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-4013] no memory(ret=-4013, new_size=7936, block_size_=7936, count_=8, capacity_=8) BACKTRACE:0x1a275b71 0x684d325 0x6a83624 0x6a83096 0x6a82fd1 0x6a695e0 0x10510691 0x1050fbca 0x103a6afa 0x1039e69e 0x1039bb01 0x10388c0d 0x116f1886 0x116b9da1 0x116ea160 0x10339b83 0x103c23a8 0x115cd875 0xe5ac3e3 0xe5a527c 0x6774e11 0x67725f0 0x65b90be 0x65963d7 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3 [2024-10-23 12:01:58.523052] WDIAG [SQL.OPT] allocate_subplan_filter_as_top (ob_log_plan.cpp:8729) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=17][errcode=-4013] failed to add subquery exprs(ret=-4013) [2024-10-23 12:01:58.523055] WDIAG [SQL.OPT] create_subplan_filter_plan (ob_log_plan.cpp:8274) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-4013] failed to allocate subplan filter as top(ret=-4013) [2024-10-23 12:01:58.523058] WDIAG [SQL.OPT] inner_candi_allocate_subplan_filter (ob_log_plan.cpp:8062) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-4013] failed to create subplan filter plan(ret=-4013) [2024-10-23 12:01:58.523067] WDIAG [SQL.OPT] inner_candi_allocate_subplan_filter (ob_log_plan.cpp:7858) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=6][errcode=-4013] failed to allocate subplan filter(ret=-4013) [2024-10-23 12:01:58.529292] WDIAG [SQL.OPT] candi_allocate_subplan_filter (ob_log_plan.cpp:7797) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-4013] failed to allocate subplan filter(ret=-4013) [2024-10-23 12:01:58.529303] WDIAG [SQL.OPT] candi_allocate_subplan_filter_for_select_item (ob_select_log_plan.cpp:4655) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=8][errcode=-4013] failed to candi allocate subplan filter for exprs(ret=-4013) [2024-10-23 12:01:58.529307] WDIAG [SQL.OPT] allocate_plan_top (ob_select_log_plan.cpp:4474) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-4013] failed to allocate subplan filter for subquery in select item(ret=-4013) [2024-10-23 12:01:58.529310] WDIAG [SQL.OPT] generate_raw_plan_for_plain_select (ob_select_log_plan.cpp:4362) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-4013] failed to allocate top operator of plan tree for plain select(ret=-4013) [2024-10-23 12:01:58.529316] WDIAG [SQL.OPT] generate_raw_plan (ob_log_plan.cpp:10440) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=5][errcode=-4013] fail to generate normal raw plan(ret=-4013) [2024-10-23 12:01:58.529319] WDIAG [SQL.OPT] generate_plan (ob_log_plan.cpp:10398) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-4013] fail to generate raw plan(ret=-4013) [2024-10-23 12:01:58.529322] WDIAG [SQL.OPT] optimize (ob_optimizer.cpp:64) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-4013] failed to perform optimization(ret=-4013) [2024-10-23 12:01:58.529327] WDIAG [SQL] optimize_stmt (ob_sql.cpp:3788) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-4013] Failed to optimize logical plan(ret=-4013) [2024-10-23 12:01:58.529344] WDIAG [SQL] generate_plan (ob_sql.cpp:3423) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=6][errcode=-4013] Failed to optimizer stmt(ret=-4013) [2024-10-23 12:01:58.529347] INFO [SQL] generate_plan (ob_sql.cpp:3474) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2] [SQL MEM USAGE] use too much memory(total_mem_used=59106017280, ObString(parse_result.input_sql_len_, parse_result.input_sql_)=SELECT /*+ NO_COST_BASED_QUERY_TRANSFORMATION */ [2024-10-23 12:01:58.529408] WDIAG [SQL] generate_physical_plan (ob_sql.cpp:3211) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=9][errcode=-4013] failed to generate plan(ret=-4013) [2024-10-23 12:01:58.529418] WDIAG [SQL] handle_physical_plan (ob_sql.cpp:5051) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-4013] Failed to generate plan(ret=-4013, result.get_exec_context().need_disconnect()=false) [2024-10-23 12:01:58.529426] WDIAG [SQL] handle_text_query (ob_sql.cpp:2763) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=3][errcode=-4013] fail to handle physical plan(ret=-4013) [2024-10-23 12:01:58.529434] WDIAG [SQL] stmt_query (ob_sql.cpp:232) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=4][errcode=-4013] fail to handle text query(stmt=SELECT /*+ NO_COST_BASED_QUERY_TRANSFORMATION */ [2024-10-23 12:01:58.529455] WDIAG [SERVER] after_func (ob_query_retry_ctrl.cpp:986) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=2][errcode=-4013] [RETRY] check if need retry(v={force_local_retry:false, stmt_retry_times:0, local_retry_times:0, err_:-4013, err_:"OB_ALLOCATE_MEMORY_FAILED", retry_type:0, client_ret:-4013}, need_retry=false) [2024-10-23 12:01:58.529460] WDIAG [SERVER] do_process (obmp_query.cpp:764) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=5][errcode=-4013] run stmt_query failed, check if need retry(ret=-4013, cli_ret=-4013, retry_ctrl_.need_retry()=0, sql=SELECT /*+ NO_COST_BASED_QUERY_TRANSFORMATION */ [2024-10-23 12:01:58.529470] WDIAG [SERVER] do_process (obmp_query.cpp:890) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=7][errcode=-4013] query failed(ret=-4013, session={this:0x7f62f9032308, id:3221741705, deser:false, tenant:"testc", tenant_id:1002, effective_tenant:"testc", effective_tenant_id:1002, database:"satp_testc", user:"", consistency_level:3, session_state:2, autocommit:true, tx:null}, sql=SELECT /*+ NO_COST_BASED_QUERY_TRANSFORMATION */ [2024-10-23 12:01:58.529486] INFO [SERVER] send_error_packet (obmp_packet_sender.cpp:378) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=9] sending error packet(ob_error=-4013, client error=-4013, extra_err_info=NULL, lbt()="0x1a275b71 0xc8dd700 0xc8879dc 0x659af6d 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:58.530148] WDIAG [SQL.PC] common_free (ob_lib_cache_object_manager.cpp:141) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=4][errcode=0] set logical del time(cache_obj->get_logical_del_time()=3527103390009, cache_obj->added_lc()=false, cache_obj->get_object_id()=252380, cache_obj->get_tenant_id()=1002, lbt()="0x1a275b71 0xe991bce 0x65a4c3f 0x6597b7a 0x65900dd 0x65859b0 0x6582d8d 0x6571d58 0xc6cddc4 0x19db97be 0x7f6fea8e41ca 0x7f6fea53f8d3") [2024-10-23 12:01:58.530200] WDIAG [SERVER.OMT] process_one (ob_worker_processor.cpp:89) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=4][errcode=-4013] process request fail(ret=-4013) [2024-10-23 12:01:58.530206] WDIAG [SERVER.OMT] process (ob_worker_processor.cpp:157) [1917043][T1002_L0_G0][T1002][YB42AC12607E-00062498D82FB100-0-0] [lt=5][errcode=-4013] process request fail(ret=-4013)