开发者社区 > 大数据与机器学习 > 大数据计算 MaxCompute > 正文

MaxCompute中这个sql在本地跑都是ok的,部署好后开始上线补数据了,爆了bug,怎么解决?

dadf8efe4581bd2aa8020378b9a94719.png
PANIC: unprotected error in call to Lua API (/usr/local/aliyun_acjail/config.lua:88: bad argument #1 to 'gsub' (string expected, got nil)) MaxCompute中这个sql在本地跑都是ok的,部署好后,开始上线补数据了,爆了这个bug,怎么解决?文档 2023-05-05 11:29:08 INFO Current task status:RUNNING 2023-05-05 11:29:08 INFO Start execute shell on node sh-base-biz-gateway06.cloud.et15. 2023-05-05 11:29:08 INFO Current working dir /home/admin/alisatasknode/taskinfo/20230505/phoenix/11/29/02/c8iy0bcessow8egaikswp2wr 2023-05-05 11:29:08 INFO Full Command .. 2023-05-05 11:29:08 INFO ------------------------- 2023-05-05 11:29:08 INFO /opt/taobao/tbdpapp/odpswrapper/odpswrapper.py /home/admin/alisatasknode/taskinfo//20230505/phoenix/11/29/02/c8iy0bcessow8egaikswp2wr//行销公司促销核心数据指标表ads_company_activity_key_num key1=20230503 key2=20220503 2023-05-05 11:29:08 INFO ------------------------- 2023-05-05 11:29:08 INFO List of passing environment .. 2023-05-05 11:29:08 INFO ------------------------- 2023-05-05 11:29:08 INFO SKYNET_ENDPOINT=http://service.odps.aliyun.com/api: 2023-05-05 11:29:08 INFO SKYNET_PTYPE=10: 2023-05-05 11:29:08 INFO SKYNET_ACTIONID=1: 2023-05-05 11:29:08 INFO TASK_WHITE_LIST=service.odps.aliyun.com:*,rm-uf607ostxhmf4z433.mysql.rds.aliyuncs.com:3306,101.200.95.248:3306,hnyxym.mysql.polardb.rds.aliyuncs.com:3128,hgprecn-cn-lbj32d0ti00b-cn-shanghai.hologres.aliyuncs.com:80,hgprecn-cn-lbj32d0ti00b-cn-shanghai-internal.hologres.aliyuncs.com:80,hgprecn-cn-lbj32d0ti00b-cn-shanghai-vpc-st.hologres.aliyuncs.com:80: 2023-05-05 11:29:08 INFO SKYNET_RERUN_MODE=1: 2023-05-05 11:29:08 INFO SKYNET_FLOW_PARAVALUE=: 2023-05-05 11:29:08 INFO SKYNET_ONDUTY=201455745671698242: 2023-05-05 11:29:08 INFO SKYNET_SYSTEMID=: 2023-05-05 11:29:08 INFO CALC_ENGINE_IDENTIFIER=ksf_yxlm: 2023-05-05 11:29:08 INFO SKYNET_SOURCEID=800026400058: 2023-05-05 11:29:08 INFO SKYNET_PARAVALUE=key1=20230503 key2=20220503: 2023-05-05 11:29:08 INFO SKYNET_TASKID=809728717781: 2023-05-05 11:29:08 INFO SKYNET_TENANT_ID=438623358341377: 2023-05-05 11:29:08 INFO SKYNET_ID=700005882552: 2023-05-05 11:29:08 INFO SKYNET_JOBID=800262775962: 2023-05-05 11:29:08 INFO SKYNET_NODENAME=行销公司促销核心数据指标表ads_company_activity_key_num: 2023-05-05 11:29:08 INFO SKYNET_CYCTYPE=0: 2023-05-05 11:29:08 INFO SKYNET_DSC_JOB_VERSION=2: 2023-05-05 11:29:08 INFO SKYNET_TASK_INPUT={}: 2023-05-05 11:29:08 INFO SKYNET_FLOWNAME=ATCLOUD_FLOW: 2023-05-05 11:29:08 INFO FILE_ID=700005882552: 2023-05-05 11:29:08 INFO SKYNET_TIMEZONE=GMT+8: 2023-05-05 11:29:08 INFO SKYNET_EXENAME=/opt/taobao/tbdpapp/odpswrapper/odpswrapper.py: 2023-05-05 11:29:08 INFO IS_NEW_SCHEDULE=true: 2023-05-05 11:29:08 INFO SKYNET_DAGTYPE=3: 2023-05-05 11:29:08 INFO FILE_VERSION=2: 2023-05-05 11:29:08 INFO SKYNET_SOURCENAME=group_438623358341377: 2023-05-05 11:29:08 INFO SKYNET_SYSTEM_ENV=prod: 2023-05-05 11:29:08 INFO SKYNET_GMTDATE=20230504: 2023-05-05 11:29:08 INFO SKYNET_ENVTYPE=1: 2023-05-05 11:29:08 INFO SKYNET_BIZDATE=20230503: 2023-05-05 11:29:08 INFO SKYNET_CYCTIME=20230504002100: 2023-05-05 11:29:08 INFO SKYNET_FAILOVER_HANDLER=1: 2023-05-05 11:29:08 INFO SKYNET_DAG_INPUT={}: 2023-05-05 11:29:08 INFO SKYNET_ONDUTY_WORKNO=20145574567169824

展开
收起
冰激凌甜筒 2023-05-07 14:36:43 178 0
1 条回答
写回答
取消 提交回答
  • 代码中的注释去掉一下试试,所有的,因为DataWorks的生产环境会编译这个注释,有影响。e94584ff2318327aedbdae0d578da81d.png这些, 此回答整理自钉群“MaxCompute开发者社区2群”

    2023-05-07 14:42:41
    赞同 展开评论 打赏

MaxCompute(原ODPS)是一项面向分析的大数据计算服务,它以Serverless架构提供快速、全托管的在线数据仓库服务,消除传统数据平台在资源扩展性和弹性方面的限制,最小化用户运维投入,使您经济并高效的分析处理海量数据。

相关产品

  • 云原生大数据计算服务 MaxCompute
  • 相关电子书

    更多
    SQL Server在电子商务中的应用与实践 立即下载
    GeoMesa on Spark SQL 立即下载
    原生SQL on Hadoop引擎- Apache HAWQ 2.x最新技术解密malili 立即下载