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″