开发者社区 > 数据库 > 正文

DMS这个任务为啥结束不了?

2023-01-04 10:00:10[GMT+08:00] INFO - Resource Control is active! 2023-01-04 10:00:10[GMT+08:00] INFO - try take resource Lock 2023-01-04 10:00:10[GMT+08:00] INFO - take lock success! lock info:ResourceLock{resourceType=[DATABASE], resourceId=[22916562], waitingJobs=[], runningJobs=[10790760-f_27897-j_74734-5,10801417-f_27892-j_74727-5,10776342-f_27656-j_96318-5,10776342-f_27656-j_76555-5,10776342-f_27656-j_78755-5]} 2023-01-04 10:00:10[GMT+08:00] INFO - Starting job j_74727 at Wed Jan 04 10:00:10 CST 2023 2023-01-04 10:00:10[GMT+08:00] INFO - job JVM args: '-dms.flowid=f_27892' '-dms.execid=10801417' '-dms.jobid=j_74727' 2023-01-04 10:00:10[GMT+08:00] INFO - user.to.proxy property was not set, defaulting to submit user zhulong 2023-01-04 10:00:10[GMT+08:00] INFO - Building sql_job job executor. 2023-01-04 10:00:11[GMT+08:00] INFO - Starting execution of sql job... 2023-01-04 10:00:11[GMT+08:00] INFO - Initialing execution locale of DMS: zh 2023-01-04 10:00:11[GMT+08:00] INFO - Parsing executing sql: /* 请使用当前节点所选择的数据库语法编写SQL */

/********** ofc ***************/ TRUNCATE ods_ofc_trade_fulfill_order_item; TRUNCATE ods_ofc_trade_fulfill_order; TRUNCATE ods_ofc_trade_order_item; TRUNCATE ods_ofc_trade_order; TRUNCATE ods_ofc_trade_sku_fulfillment_conf; TRUNCATE ods_ofc_trade_sku; TRUNCATE ods_ofc_trade_order_pay; TRUNCATE ods_ofc_trade_installment; TRUNCATE ods_ofc_trade_installment_bill; 2023-01-04 10:00:11[GMT+08:00] INFO - Verifying authorization : user[668157] database[22916562] 2023-01-04 10:00:11[GMT+08:00] INFO - Adding sql_job to DMS executing queue .. 2023-01-04 10:00:11[GMT+08:00] INFO - Sql_job id: 47197590 2023-01-04 10:00:11[GMT+08:00] INFO - sql job status is BE_SCHEDULED 2023-01-04 10:00:11[GMT+08:00] INFO - Waiting for next check... Current waiting turn:0 2023-01-04 10:00:21[GMT+08:00] INFO - sql job status is BE_SCHEDULED 2023-01-04 10:00:21[GMT+08:00] INFO - Waiting for next check... Current waiting turn:1 2023-01-04 10:00:31[GMT+08:00] INFO - sql job status is WAITING 2023-01-04 10:00:31[GMT+08:00] INFO - Waiting for next check... Current waiting turn:2 2023-01-04 10:00:41[GMT+08:00] INFO - sql job status is WAITING 2023-01-04 10:00:41[GMT+08:00] INFO - Waiting for next check... Current waiting turn:3 2023-01-04 10:00:51[GMT+08:00] INFO - sql job status is WAITING 2023-01-04 10:00:51[GMT+08:00] INFO - Waiting for next check... Current waiting turn:4"

展开
收起
wenti 2023-01-08 14:53:08 248 0
1 条回答
写回答
取消 提交回答
  • mysql需要注意SQL任务间会有锁,需要等待别的任务执行完才能继续执行——该回答整理自钉群“阿里云DMS数据管理用户交流群“

    2023-01-08 16:17:00
    赞同 展开评论 打赏
问答分类:
问答标签:
问答地址:

数据库领域前沿技术分享与交流

相关电子书

更多
金融行业高频交易数据管理解决方案 立即下载
基于Spark的统一数据管理与数据探索平台 立即下载
INFINIDATA:基于Spark的统一数据管理与探索平台 立即下载