[2024-10-28 09:06:52 CST] [130] [INFO] Start task, id=130. [2024-10-28 09:06:52 CST] [130] [INFO] Init task parameters success, id=130. [2024-10-28 09:06:52 CST] [130] [INFO] Cloud object storage not supported [2024-10-28 09:06:52 CST] [130] [INFO] get MetaDB configuration, config=ConnectionConfig(id=null, ownerId=null, organizationId=null, creatorId=null, creatorName=null, name=null, serviceName=null, sid=null, userRole=null, catalogName=null, type=OB_MYSQL, visibleScope=ORGANIZATION, host=10.52.6.108, port=2883, clusterName=metadb, tenantName=odc_meta, username=root, setTop=false, labelIds=null, sysTenantUsername=null, readonlyUsername=null, defaultSchema=odc, queryTimeoutSeconds=10, createTime=null, updateTime=null, lastAccessTime=null, enabled=true, passwordSaved=true, properties=null, cipher=null, copyFromId=null, permittedActions=null, status=null, temp=false, supportedOperations=null, endpoint=null, OBTenantName=odc_meta, instanceType=null, instanceRoleType=null, attributes=null, sslConfig=ConnectionConfig.SSLConfig(enabled=false, clientCertObjectId=null, clientKeyObjectId=null, CACertObjectId=null), environmentId=null, environmentName=null, environmentStyle=null, projectId=null, projectName=null, dbObjectLastSyncTime=null) [2024-10-28 09:06:52 CST] [130] [INFO] Init data-archive job env succeed,jobIdentity=130 [2024-10-28 09:06:52 CST] [130] [INFO] Update task status, id=130, status=RUNNING. [2024-10-28 09:06:52 CST] [130] [INFO] Sample plugin is started [2024-10-28 09:06:52 CST] [130] [INFO] Begin to create dlm job,params=HistoryJob(id=MIGRATE-47-90-0, jobType=MIGRATE, jobParameter=DlmTableUnitParameters(syncDBObjectType=[]), tableId=-1, sourceDs=null, targetDs=null, printSqlTrace=false, taskGeneratorId=null, dateStart=null, dateEnd=null, sourceTable=T_UMP_SUPPLIER_STATUS_VIEW, targetTable=TEST1, logicTableId=null, childJobs=[], shardingParametersMap=null) [2024-10-28 09:06:53 CST] [130] [INFO] set sleep time = 50 [2024-10-28 09:06:53 CST] [130] [WARN] Get table entry failed,tableName=TEST1,errorMsg=Query table partition failure. table: TEST1 [2024-10-28 09:06:53 CST] [130] [INFO] set primary table meta use source table meta [2024-10-28 09:06:53 CST] [130] [INFO] The list of partitions to be processed by the task is as follows:[P201904, SYS_P102880, SYS_P102895, SYS_P102910, SYS_P102924, SYS_P102955, SYS_P102981, SYS_P102998, SYS_P103015, SYS_P103032, SYS_P103047, SYS_P103063, SYS_P103081, SYS_P103095, SYS_P103112, SYS_P103128, SYS_P103143, SYS_P103158, SYS_P103173, SYS_P103188, SYS_P103203, SYS_P103219, SYS_P103234, SYS_P103249, SYS_P103264, SYS_P103279, SYS_P103295, SYS_P103310, SYS_P103325, SYS_P103340, SYS_P103355, SYS_P103370, SYS_P103385, SYS_P103400, SYS_P103415, SYS_P103430, SYS_P103451, SYS_P103467, SYS_P103482, SYS_P103497, SYS_P103513, SYS_P103528, SYS_P103543, SYS_P103558, SYS_P103574, SYS_P103589, SYS_P103604, SYS_P103624, SYS_P103650, SYS_P103664, SYS_P103680, SYS_P103695, SYS_P103711, SYS_P103735, SYS_P103754, SYS_P103775, SYS_P103789, SYS_P103815, SYS_P103835, SYS_P103855, SYS_P103869, SYS_P103895, SYS_P103909] [2024-10-28 09:06:53 CST] [130] [INFO] Load task generator failed.jobId=MIGRATE-47-90-0 [2024-10-28 09:06:53 CST] [130] [INFO] report statistic, jobMeta = MIGRATE-47-90-0,MIGRATE,JobStat[dataSize=0,rowCount=0,readRowCount=0,avgDataSize=0,avgRowCount=0,avgReadRowCount=0,putWaitTimeUs=0,takeWaitTimeUs=0,putRowLimitWaitTimeUs=0,putSizeLimitWaitTimeUs=0,taskRowLimitWaitTimeUs=0,taskSizeLimitWaitTimeUs=0,totalAvgDataSize=0],CREATE_DATE null,count = 0 [2024-10-28 09:06:53 CST] [130] [INFO] Init task generator success,strategy = FIXED_LENGTH [2024-10-28 09:06:53 CST] [130] [INFO] Job[MIGRATE-47-90-0] get Table TotalRowCount:0 [2024-10-28 09:06:53 CST] [130] [INFO] Update rate limit success,dataSizeLimit=5120 [2024-10-28 09:06:53 CST] [130] [INFO] Update rate limit success,rowLimit=10000 [2024-10-28 09:06:53 CST] [130] [INFO] report statistic, jobMeta = MIGRATE-47-90-0,MIGRATE,JobStat[dataSize=0,rowCount=0,readRowCount=0,avgDataSize=0,avgRowCount=0,avgReadRowCount=0,putWaitTimeUs=0,takeWaitTimeUs=0,putRowLimitWaitTimeUs=0,putSizeLimitWaitTimeUs=0,taskRowLimitWaitTimeUs=0,taskSizeLimitWaitTimeUs=0,totalAvgDataSize=0],CREATE_DATE null,avg cost=2,max cost=2,total cost=2 [2024-10-28 09:06:53 CST] [130] [INFO] Partition is finished,partitionName=P201904 [2024-10-28 09:06:53 CST] [130] [INFO] Next partitionName=SYS_P102880 [2024-10-28 09:06:53 CST] [130] [INFO] Init key iterator success,strategy = FIXED_LENGTH,range = null -> null,count = 0 [2024-10-28 09:06:53 CST] [130] [INFO] Trace sql=SELECT "ID" FROM (SELECT RECON,"ID" FROM (SELECT ROWNUM AS RECON,"ID" FROM (SELECT "ID" FROM "TESTUSER"."T_UMP_SUPPLIER_STATUS_VIEW" PARTITION(SYS_P102880) ORDER BY "ID" ASC) T1 WHERE ROWNUM <= 1) T2 ORDER BY RECON DESC) WHERE ROWNUM = 1 [2024-10-28 09:06:53 CST] [130] [INFO] Execution cost 122 millis. [2024-10-28 09:06:53 CST] [130] [INFO] Trace sql=SELECT "ID" FROM (SELECT RECON,"ID" FROM (SELECT ROWNUM AS RECON,"ID" FROM (SELECT "ID" FROM "TESTUSER"."T_UMP_SUPPLIER_STATUS_VIEW" PARTITION(SYS_P102880) WHERE ( (("ID" >= '000005a2-8311-4cdc-960a-a305865a179f' ))) ORDER BY "ID" ASC) T1 WHERE ROWNUM <= 100000) T2 ORDER BY RECON DESC) WHERE ROWNUM = 1 [2024-10-28 09:06:55 CST] [130] [INFO] Execution cost 1304 millis. [2024-10-28 09:06:55 CST] [130] [INFO] Get next range success,lowerBound=[STRING,000005a2-8311-4cdc-960a-a305865a179f],true,upperBound=[STRING,158f3b62-67ba-484f-a95d-be24db150869],true [2024-10-28 09:06:55 CST] [130] [INFO] task is ready to run, taskMeta = TaskMeta(jobMeta=MIGRATE-47-90-0,MIGRATE,JobStat[dataSize=0,rowCount=0,readRowCount=0,avgDataSize=0,avgRowCount=0,avgReadRowCount=0,putWaitTimeUs=0,takeWaitTimeUs=0,putRowLimitWaitTimeUs=0,putSizeLimitWaitTimeUs=0,taskRowLimitWaitTimeUs=0,taskSizeLimitWaitTimeUs=0,totalAvgDataSize=0],CREATE_DATE '158f3b62-67ba-484f-a95d-be24db150869' ))) ORDER BY "ID" ASC) T1 WHERE ROWNUM <= 100000) T2 ORDER BY RECON DESC) WHERE ROWNUM = 1 [2024-10-28 09:06:55 CST] [130] [INFO] Init key iterator success,strategy = FIXED_LENGTH,range = [STRING,000005a2-8311-4cdc-960a-a305865a179f],true -> [STRING,158f3b62-67ba-484f-a95d-be24db150869],true,count = 0 [2024-10-28 09:07:02 CST] [130] [INFO] Execution cost 7040 millis. [2024-10-28 09:07:02 CST] [130] [INFO] Get next range success,lowerBound=[STRING,158f3b62-67ba-484f-a95d-be24db150869],false,upperBound=[STRING,2b0885bd-02d4-4dc4-bb9a-143f5ab710f8],true [2024-10-28 09:07:02 CST] [130] [INFO] Trace sql=SELECT "ID" FROM (SELECT RECON,"ID" FROM (SELECT ROWNUM AS RECON,"ID" FROM (SELECT "ID" FROM "TESTUSER"."T_UMP_SUPPLIER_STATUS_VIEW" PARTITION(SYS_P102880) WHERE ( (("ID" > '2b0885bd-02d4-4dc4-bb9a-143f5ab710f8' ))) ORDER BY "ID" ASC) T1 WHERE ROWNUM <= 100000) T2 ORDER BY RECON DESC) WHERE ROWNUM = 1 [2024-10-28 09:07:02 CST] [130] [INFO] task is ready to run, taskMeta = TaskMeta(jobMeta=MIGRATE-47-90-0,MIGRATE,JobStat[dataSize=1055344,rowCount=7800,readRowCount=7800,avgDataSize=0,avgRowCount=0,avgReadRowCount=0,putWaitTimeUs=309,takeWaitTimeUs=15642009,putRowLimitWaitTimeUs=1350,putSizeLimitWaitTimeUs=126,taskRowLimitWaitTimeUs=0,taskSizeLimitWaitTimeUs=1328,totalAvgDataSize=105534],CREATE_DATE [STRING,2b0885bd-02d4-4dc4-bb9a-143f5ab710f8],true,count = 0 [2024-10-28 09:07:03 CST] [130] [INFO] Update rate limit success,dataSizeLimit=5120 [2024-10-28 09:07:03 CST] [130] [INFO] Update rate limit success,rowLimit=10000 [2024-10-28 09:07:03 CST] [130] [INFO] report statistic, jobMeta = MIGRATE-47-90-0,MIGRATE,JobStat[dataSize=1326028,rowCount=9800,readRowCount=9800,avgDataSize=132602,avgRowCount=980,avgReadRowCount=980,putWaitTimeUs=885089,takeWaitTimeUs=15642153,putRowLimitWaitTimeUs=1476,putSizeLimitWaitTimeUs=164,taskRowLimitWaitTimeUs=0,taskSizeLimitWaitTimeUs=1407,totalAvgDataSize=66301],CREATE_DATE '2b0885bd-02d4-4dc4-bb9a-143f5ab710f8' ))) ORDER BY "ID" ASC) T1 WHERE ROWNUM <= 100000) T2 ORDER BY RECON DESC) WHERE ROWNUM = 1 [2024-10-28 09:07:13 CST] [130] [INFO] Update rate limit success,dataSizeLimit=5120 [2024-10-28 09:07:13 CST] [130] [INFO] Update rate limit success,rowLimit=10000 [2024-10-28 09:07:13 CST] [130] [INFO] report statistic, jobMeta = MIGRATE-47-90-0,MIGRATE,JobStat[dataSize=3085058,rowCount=22800,readRowCount=22800,avgDataSize=175903,avgRowCount=1300,avgReadRowCount=1300,putWaitTimeUs=10170475,takeWaitTimeUs=15643122,putRowLimitWaitTimeUs=1923,putSizeLimitWaitTimeUs=257,taskRowLimitWaitTimeUs=0,taskSizeLimitWaitTimeUs=1806,totalAvgDataSize=102835],CREATE_DATE