| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133 |
- 2022-08-07 10:46:33.141 [main] INFO VMInfo - VMInfo# operatingSystem class => com.sun.management.internal.OperatingSystemImpl
- 2022-08-07 10:46:33.149 [main] INFO Engine - the machine info =>
- osInfo: Ubuntu 11 11.0.16+8-post-Ubuntu-0ubuntu120.04
- jvmInfo: Linux amd64 5.13.0-52-generic
- cpu num: 8
- totalPhysicalMemory: -0.00G
- freePhysicalMemory: -0.00G
- maxFileDescriptorCount: -1
- currentOpenFileDescriptorCount: -1
- GC Names [G1 Young Generation, G1 Old Generation]
- MEMORY_NAME | allocation_size | init_size
- CodeHeap 'profiled nmethods' | 117.21MB | 2.44MB
- G1 Old Gen | 1,024.00MB | 970.00MB
- G1 Survivor Space | -0.00MB | 0.00MB
- CodeHeap 'non-profiled nmethods' | 117.22MB | 2.44MB
- Compressed Class Space | 1,024.00MB | 0.00MB
- Metaspace | -0.00MB | 0.00MB
- G1 Eden Space | -0.00MB | 54.00MB
- CodeHeap 'non-nmethods' | 5.57MB | 2.44MB
- 2022-08-07 10:46:33.160 [main] INFO Engine -
- {
- "content":[
- {
- "reader":{
- "name":"mysqlreader",
- "parameter":{
- "connection":[
- {
- "jdbcUrl":[
- "jdbc:mysql://192.168.2.2:3306/gene"
- ],
- "querySql":[
- "select%2*%2from%2gene.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-08-07 10:46:33.170 [main] WARN Engine - prioriy set to 0, because NumberFormatException, the value is: null
- 2022-08-07 10:46:33.171 [main] INFO PerfTrace - PerfTrace traceId=job_-1, isEnable=false, priority=0
- 2022-08-07 10:46:33.171 [main] INFO JobContainer - DataX jobContainer starts job.
- 2022-08-07 10:46:33.172 [main] INFO JobContainer - Set jobId = 0
- 2022-08-07 10:46:33.401 [job-0] INFO OriginalConfPretreatmentUtil - Available jdbcUrl:jdbc:mysql://192.168.2.2:3306/gene?yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true.
- 2022-08-07 10:46:33.525 [job-0] INFO OriginalConfPretreatmentUtil - table:[xxx] all columns:[
- GeneName
- ].
- 2022-08-07 10:46:33.525 [job-0] WARN OriginalConfPretreatmentUtil - 您的配置文件中的列配置信息存在风险. 因为您配置的写入数据库表的列为*，当您的表字段个数、类型有变动时，可能影响任务正确性甚至会运行出错。请检查您的配置并作出修改.
- 2022-08-07 10:46:33.526 [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-08-07 10:46:33.527 [job-0] INFO JobContainer - jobContainer starts to do prepare ...
- 2022-08-07 10:46:33.527 [job-0] INFO JobContainer - DataX Reader.Job [mysqlreader] do prepare work .
- 2022-08-07 10:46:33.527 [job-0] INFO JobContainer - DataX Writer.Job [mysqlwriter] do prepare work .
- 2022-08-07 10:46:33.528 [job-0] INFO JobContainer - jobContainer starts to do split ...
- 2022-08-07 10:46:33.528 [job-0] INFO JobContainer - Job set Channel-Number to 2 channels.
- 2022-08-07 10:46:33.529 [job-0] INFO JobContainer - DataX Reader.Job [mysqlreader] splits to [1] tasks.
- 2022-08-07 10:46:33.529 [job-0] INFO JobContainer - DataX Writer.Job [mysqlwriter] splits to [1] tasks.
- 2022-08-07 10:46:33.538 [job-0] INFO JobContainer - jobContainer starts to do schedule ...
- 2022-08-07 10:46:33.540 [job-0] INFO JobContainer - Scheduler starts [1] taskGroups.
- 2022-08-07 10:46:33.542 [job-0] INFO JobContainer - Running by standalone Mode.
- 2022-08-07 10:46:33.546 [taskGroup-0] INFO TaskGroupContainer - taskGroupId=[0] start [1] channels for [1] tasks.
- 2022-08-07 10:46:33.553 [taskGroup-0] INFO Channel - Channel set byte_speed_limit to -1, No bps activated.
- 2022-08-07 10:46:33.553 [taskGroup-0] INFO Channel - Channel set record_speed_limit to -1, No tps activated.
- 2022-08-07 10:46:33.562 [taskGroup-0] INFO TaskGroupContainer - taskGroup[0] taskId[0] attemptCount[1] is started
- 2022-08-07 10:46:33.564 [0-0-0-reader] INFO CommonRdbmsReader$Task - Begin to read record by Sql: [select%2*%2from%2gene.test
- ] jdbcUrl:[jdbc:mysql://192.168.2.2:3306/gene?yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true].
- 2022-08-07 10:46:33.584 [0-0-0-reader] ERROR ReaderRunner - Reader runner Received Exceptions:
- com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-07], Description:[读取数据库数据失败. 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为: select%2*%2from%2gene.test 具体错误信息为：com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: #42000
- at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:26) ~[datax-common-0.0.1-SNAPSHOT.jar:na]
- at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:81) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
- at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:220) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
- at com.alibaba.datax.plugin.reader.mysqlreader.MysqlReader$Task.startRead(MysqlReader.java:81) ~[mysqlreader-0.0.1-SNAPSHOT.jar:na]
- at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:57) ~[datax-core-0.0.1-SNAPSHOT.jar:na]
- at java.base/java.lang.Thread.run(Thread.java:829) ~[na:na]
- 2022-08-07 10:46:43.557 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00%
- 2022-08-07 10:46:43.558 [job-0] ERROR JobContainer - 运行scheduler 模式[standalone]出错.
- 2022-08-07 10:46:43.562 [job-0] ERROR JobContainer - Exception when job run
- com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-07], Description:[读取数据库数据失败. 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为: select%2*%2from%2gene.test 具体错误信息为：com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: #42000
- at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:26) ~[datax-common-0.0.1-SNAPSHOT.jar:na]
- at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:81) ~[na:na]
- at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:220) ~[na:na]
- at com.alibaba.datax.plugin.reader.mysqlreader.MysqlReader$Task.startRead(MysqlReader.java:81) ~[na:na]
- at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:57) ~[datax-core-0.0.1-SNAPSHOT.jar:na]
- at java.base/java.lang.Thread.run(Thread.java:829) ~[na:na]
- 2022-08-07 10:46:43.564 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00%
- 2022-08-07 10:46:43.566 [job-0] ERROR Engine -
- 经DataX智能分析,该任务最可能的错误原因是:
- com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-07], Description:[读取数据库数据失败. 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为: select%2*%2from%2gene.test 具体错误信息为：com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: #42000
- at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:26)
- at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:81)
- at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:220)
- at com.alibaba.datax.plugin.reader.mysqlreader.MysqlReader$Task.startRead(MysqlReader.java:81)
- at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:57)
- at java.base/java.lang.Thread.run(Thread.java:829)
|
