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"
mysql需要注意SQL任务间会有锁,需要等待别的任务执行完才能继续执行——该回答整理自钉群“阿里云DMS数据管理用户交流群“
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。