backend/app/datax/log/2022-07-17/job_mysql2mysql_json-02_13_51.279.log

2022-07-17 02:13:51.560 [main] INFO  VMInfo - VMInfo# operatingSystem class => sun.management.OperatingSystemImpl
2022-07-17 02:13:51.570 [main] INFO  Engine - the machine info  => 

	osInfo:	Oracle Corporation 1.8 25.262-b10
	jvmInfo:	Linux amd64 3.10.0-957.el7.x86_64
	cpu num:	128

	totalPhysicalMemory:	-0.00G
	freePhysicalMemory:	-0.00G
	maxFileDescriptorCount:	-1
	currentOpenFileDescriptorCount:	-1

	GC Names	[PS MarkSweep, PS Scavenge]

	MEMORY_NAME                    | allocation_size                | init_size                      
	PS Eden Space                  | 256.00MB                       | 256.00MB                       
	Code Cache                     | 240.00MB                       | 2.44MB                         
	Compressed Class Space         | 1,024.00MB                     | 0.00MB                         
	PS Survivor Space              | 42.50MB                        | 42.50MB                        
	PS Old Gen                     | 683.00MB                       | 683.00MB                       
	Metaspace                      | -0.00MB                        | 0.00MB                         


2022-07-17 02:13:51.591 [main] INFO  Engine - 
{
	"content":[
		{
			"reader":{
				"name":"mysqlreader",
				"parameter":{
					"connection":[
						{
							"jdbcUrl":[
								"jdbc:mysql://192.168.2.2:3306/gene"
							],
							"querySql":[
								"select * from gene.test"
							]
						}
					],
					"password":"*********",
					"username":"root"
				}
			},
			"writer":{
				"name":"mysqlwriter",
				"parameter":{
					"column":[
						"*"
					],
					"connection":[
						{
							"jdbcUrl":"jdbc:mysql://192.168.2.2:3306/gene",
							"table":[
								"xxx"
							]
						}
					],
					"password":"**********",
					"session":[],
					"username":"root",
					"writeMode":"insert"
				}
			}
		}
	],
	"setting":{
		"speed":{
			"channel":"2"
		}
	}
}

2022-07-17 02:13:51.611 [main] WARN  Engine - prioriy set to 0, because NumberFormatException, the value is: null
2022-07-17 02:13:51.613 [main] INFO  PerfTrace - PerfTrace traceId=job_-1, isEnable=false, priority=0
2022-07-17 02:13:51.614 [main] INFO  JobContainer - DataX jobContainer starts job.
2022-07-17 02:13:51.616 [main] INFO  JobContainer - Set jobId = 0
2022-07-17 02:13:52.064 [job-0] INFO  OriginalConfPretreatmentUtil - Available jdbcUrl:jdbc:mysql://192.168.2.2:3306/gene?yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true.
2022-07-17 02:13:52.412 [job-0] INFO  OriginalConfPretreatmentUtil - table:[xxx] all columns:[
GeneName
].
2022-07-17 02:13:52.412 [job-0] WARN  OriginalConfPretreatmentUtil - 您的配置文件中的列配置信息存在风险. 因为您配置的写入数据库表的列为*，当您的表字段个数、类型有变动时，可能影响任务正确性甚至会运行出错。请检查您的配置并作出修改.
2022-07-17 02:13:52.414 [job-0] INFO  OriginalConfPretreatmentUtil - Write data [
insert INTO %s (GeneName) VALUES(?)
], which jdbcUrl like:[jdbc:mysql://192.168.2.2:3306/gene?yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true]
2022-07-17 02:13:52.415 [job-0] INFO  JobContainer - jobContainer starts to do prepare ...
2022-07-17 02:13:52.416 [job-0] INFO  JobContainer - DataX Reader.Job [mysqlreader] do prepare work .
2022-07-17 02:13:52.416 [job-0] INFO  JobContainer - DataX Writer.Job [mysqlwriter] do prepare work .
2022-07-17 02:13:52.417 [job-0] INFO  JobContainer - jobContainer starts to do split ...
2022-07-17 02:13:52.418 [job-0] INFO  JobContainer - Job set Channel-Number to 2 channels.
2022-07-17 02:13:52.420 [job-0] INFO  JobContainer - DataX Reader.Job [mysqlreader] splits to [1] tasks.
2022-07-17 02:13:52.421 [job-0] INFO  JobContainer - DataX Writer.Job [mysqlwriter] splits to [1] tasks.
2022-07-17 02:13:52.442 [job-0] INFO  JobContainer - jobContainer starts to do schedule ...
2022-07-17 02:13:52.446 [job-0] INFO  JobContainer - Scheduler starts [1] taskGroups.
2022-07-17 02:13:52.449 [job-0] INFO  JobContainer - Running by standalone Mode.
2022-07-17 02:13:52.458 [taskGroup-0] INFO  TaskGroupContainer - taskGroupId=[0] start [1] channels for [1] tasks.
2022-07-17 02:13:52.469 [taskGroup-0] INFO  Channel - Channel set byte_speed_limit to -1, No bps activated.
2022-07-17 02:13:52.470 [taskGroup-0] INFO  Channel - Channel set record_speed_limit to -1, No tps activated.
2022-07-17 02:13:52.488 [taskGroup-0] INFO  TaskGroupContainer - taskGroup[0] taskId[0] attemptCount[1] is started
2022-07-17 02:13:52.498 [0-0-0-reader] INFO  CommonRdbmsReader$Task - Begin to read record by Sql: [select * from gene.test
] jdbcUrl:[jdbc:mysql://192.168.2.2:3306/gene?yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true].
2022-07-17 02:13:52.531 [0-0-0-reader] INFO  CommonRdbmsReader$Task - Finished read record by Sql: [select * from gene.test
] jdbcUrl:[jdbc:mysql://192.168.2.2:3306/gene?yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true].
2022-07-17 02:13:52.990 [taskGroup-0] INFO  TaskGroupContainer - taskGroup[0] taskId[0] is successed, used[504]ms
2022-07-17 02:13:52.991 [taskGroup-0] INFO  TaskGroupContainer - taskGroup[0] completed it's tasks.
2022-07-17 02:14:02.471 [job-0] INFO  StandAloneJobContainerCommunicator - Total 3 records, 14 bytes | Speed 1B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 0.000s | Percentage 100.00%
2022-07-17 02:14:02.471 [job-0] INFO  AbstractScheduler - Scheduler accomplished all tasks.
2022-07-17 02:14:02.472 [job-0] INFO  JobContainer - DataX Writer.Job [mysqlwriter] do post work.
2022-07-17 02:14:02.472 [job-0] INFO  JobContainer - DataX Reader.Job [mysqlreader] do post work.
2022-07-17 02:14:02.472 [job-0] INFO  JobContainer - DataX jobId [0] completed successfully.
2022-07-17 02:14:02.474 [job-0] INFO  HookInvoker - No hook invoked, because base dir not exists or is a file: /root/yili-datax/datax/hook
2022-07-17 02:14:02.476 [job-0] INFO  JobContainer - 
	 [total cpu info] => 
		averageCpu                     | maxDeltaCpu                    | minDeltaCpu                    
		-1.00%                         | -1.00%                         | -1.00%
                        

	 [total gc info] => 
		 NAME                 | totalGCCount       | maxDeltaGCCount    | minDeltaGCCount    | totalGCTime        | maxDeltaGCTime     | minDeltaGCTime     
		 PS MarkSweep         | 0                  | 0                  | 0                  | 0.000s             | 0.000s             | 0.000s             
		 PS Scavenge          | 0                  | 0                  | 0                  | 0.000s             | 0.000s             | 0.000s             

2022-07-17 02:14:02.477 [job-0] INFO  JobContainer - PerfTrace not enable!
2022-07-17 02:14:02.479 [job-0] INFO  StandAloneJobContainerCommunicator - Total 3 records, 14 bytes | Speed 1B/s, 0 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.000s |  All Task WaitReaderTime 0.000s | Percentage 100.00%
2022-07-17 02:14:02.480 [job-0] INFO  JobContainer - 
任务启动时刻                    : 2022-07-17 02:13:51
任务结束时刻                    : 2022-07-17 02:14:02
任务总计耗时                    :                 10s
任务平均流量                    :                1B/s
记录写入速度                    :              0rec/s
读出记录总数                    :                   3
读写失败总数                    :                   0