场景还原：
1.在MySQL和oceanbase端，都建表job_group
CREATE TABLE job_group (
id int NOT NULL AUTO_INCREMENT,
app_name varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '执行器AppName',
title varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '执行器名称',
order int NOT NULL DEFAULT '0' COMMENT '排序',
address_type tinyint NOT NULL DEFAULT '0' COMMENT '执行器地址类型：0=自动注册、1=手动录入',
address_list varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行器地址列表，多地址逗号分隔',
PRIMARY KEY (id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC
2.执行datax任务
{ "job": { "setting": { "speed": { "channel": 4 }, "errorLimit": { "record": 0, "percentage": 0.1 } }, "content": [ { "reader": { "name": "mysqlreader", "parameter": { "username": "dba", "password": "xxx", "column": [ "*" ], "connection": [ { "table": [ "job_group" ], "jdbcUrl": [ "jdbc:mysql://127.0.0.1:3306/hdb?useUnicode=true&characterEncoding=utf8" ] } ] } }, "writer": { "name": "oceanbasev10writer", "parameter": { "obWriteMode": "insert", "column": [ "*" ], "preSql": [ "truncate table job_group" ], "connection": [ { "jdbcUrl": "jdbc:oceanbase://10.250.37.236:2883/hdb?", "table": [ "job_group" ] } ], "username": "admin@test", "password": "xxx", "writerThreadCount": 10, "batchSize": 1000, "memstoreThreshold": "0.9" } } } ] } }
3.错误如下
2023-04-30 09:52:17 [JobThread.run-130] ----------- datax-web job execute start ----------- ----------- Param:
2023-04-30 09:52:17 [BuildCommand.buildDataXParam-100] ------------------Command parameters:
2023-04-30 09:52:17 [ExecutorJobHandler.execute-57] ------------------DataX process id: 20270
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53]
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] DataX (DATAX-OPENSOURCE-3.0), From Alibaba !
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] Copyright (C) 2010-2017, Alibaba Group. All Rights Reserved.
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53]
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53]
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.396 [main] INFO MessageSource - JVM TimeZone: GMT+08:00, Locale: zh_CN
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.398 [main] INFO MessageSource - use Locale: zh_CN timeZone: sun.util.calendar.ZoneInfo[id="GMT+08:00",offset=28800000,dstSavings=0,useDaylight=false,transitions=0,lastRule=null]
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.423 [main] INFO VMInfo - VMInfo# operatingSystem class => sun.management.OperatingSystemImpl
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.427 [main] INFO Engine - the machine info =>
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53]
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] osInfo: Oracle Corporation 1.8 25.361-b09
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] jvmInfo: Linux amd64 3.10.0-1160.el7.x86_64
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] cpu num: 4
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53]
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] totalPhysicalMemory: -0.00G
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] freePhysicalMemory: -0.00G
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] maxFileDescriptorCount: -1
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] currentOpenFileDescriptorCount: -1
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53]
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] GC Names [PS MarkSweep, PS Scavenge]
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53]
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] MEMORY_NAME | allocation_size | init_size
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] PS Eden Space | 256.00MB | 256.00MB
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] Code Cache | 240.00MB | 2.44MB
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] Compressed Class Space | 1,024.00MB | 0.00MB
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] PS Survivor Space | 42.50MB | 42.50MB
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] PS Old Gen | 683.00MB | 683.00MB
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] Metaspace | -0.00MB | 0.00MB
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53]
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53]
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.444 [main] INFO Engine -
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] {
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "content":[
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] {
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "reader":{
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "name":"mysqlreader",
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "parameter":{
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "column":[
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "*"
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ],
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "connection":[
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] {
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "jdbcUrl":[
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "jdbc:mysql://127.0.0.1:3306/hdb?useUnicode=true&characterEncoding=utf8"
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ],
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "table":[
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "job_group"
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ]
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] }
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ],
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "password":"****",
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "username":"dba"
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] }
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] },
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "writer":{
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "name":"oceanbasev10writer",
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "parameter":{
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "batchSize":1000,
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "column":[
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "*"
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ],
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "connection":[
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] {
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "jdbcUrl":"jdbc:oceanbase://10.250.37.236:2883/hdb?",
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "table":[
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "job_group"
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ]
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] }
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ],
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "memstoreThreshold":"0.9",
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "obWriteMode":"insert",
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "password":"****",
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "preSql":[
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "truncate table jobgroup"
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ],
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "username":"admin@test",
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "writerThreadCount":10
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] }
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] }
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] }
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ],
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "setting":{
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "errorLimit":{
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "percentage":0.1,
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "record":0
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] },
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "speed":{
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "channel":4
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] }
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] }
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] }
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53]
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.459 [main] WARN Engine - prioriy set to 0, because NumberFormatException, the value is: null
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.460 [main] INFO PerfTrace - PerfTrace traceId=job-1, isEnable=false, priority=0
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.460 [main] INFO JobContainer - DataX jobContainer starts job.
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.462 [main] INFO JobContainer - Set jobId = 0
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.960 [job-0] INFO OriginalConfPretreatmentUtil - Available jdbcUrl:jdbc:mysql://127.0.0.1:3306/hdb?useUnicode=true&characterEncoding=utf8&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true.
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.961 [job-0] WARN OriginalConfPretreatmentUtil - 您的配置文件中的列配置存在一定的风险. 因为您未配置读取数据库表的列，当您的表字段个数、类型有变动时，可能影响任务正确性甚至会运行出错。请检查您的配置并作出修改.
2023-04-30 09:52:17 [ProcessCallbackThread.callbackLog-186] ----------- datax-web job callback finish.
2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:18.267 [job-0] INFO DbUtils - value for query [SHOW VARIABLES LIKE 'ob_compatibility_mode'] is [MYSQL]
2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:18.632 [job-0] INFO OriginalConfPretreatmentUtil - table:[job_group] all columns:[
2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] id,app_name,title,order,address_type,address_list
2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] ].
2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:18.632 [job-0] WARN OriginalConfPretreatmentUtil - 您的配置文件中的列配置信息存在风险. 因为您配置的写入数据库表的列为，当您的表字段个数、类型有变动时，可能影响任务正确性甚至会运行出错。请检查您的配置并作出修改.
2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:18.634 [job-0] INFO OriginalConfPretreatmentUtil - Write data [
2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] INSERT INTO %s (id,app_name,title,order,address_type,address_list) VALUES(?,?,?,?,?,?)
2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] ], which jdbcUrl like:[jdbc:oceanbase://10.250.37.236:2883/hdb?&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true]
2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:18.634 [job-0] INFO JobContainer - jobContainer starts to do prepare ...
2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:18.634 [job-0] INFO JobContainer - DataX Reader.Job [mysqlreader] do prepare work .
2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:18.635 [job-0] INFO JobContainer - DataX Writer.Job [oceanbasev10writer] do prepare work .
2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:18.716 [job-0] INFO CommonRdbmsWriter$Job - Begin to execute preSqls:[truncate table job_group]. context info:jdbc:oceanbase://10.250.37.236:2883/hdb?&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.037 [job-0] INFO DbUtils - value for query [show variables like 'version'] is [5.7.25-OceanBase_CE-v4.1.0.0]
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.038 [job-0] INFO JobContainer - jobContainer starts to do split ...
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.038 [job-0] INFO JobContainer - Job set Channel-Number to 4 channels.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.041 [job-0] INFO JobContainer - DataX Reader.Job [mysqlreader] splits to [1] tasks.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.041 [job-0] INFO JobContainer - DataX Writer.Job [oceanbasev10writer] splits to [1] tasks.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.055 [job-0] INFO JobContainer - jobContainer starts to do schedule ...
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.057 [job-0] INFO JobContainer - Scheduler starts [1] taskGroups.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.059 [job-0] INFO JobContainer - Running by standalone Mode.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.062 [taskGroup-0] INFO TaskGroupContainer - taskGroupId=[0] start [1] channels for [1] tasks.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.065 [taskGroup-0] INFO Channel - Channel set byte_speed_limit to -1, No bps activated.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.065 [taskGroup-0] INFO Channel - Channel set record_speed_limit to -1, No tps activated.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.072 [taskGroup-0] INFO TaskGroupContainer - taskGroup[0] taskId[0] attemptCount[1] is started
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.074 [0-0-0-writer] INFO OceanBaseV10Writer$Task - tableNumber:1,writerTask Class:com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.074 [0-0-0-reader] INFO CommonRdbmsReader$Task - Begin to read record by Sql: [select from job_group
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] ] jdbcUrl:[jdbc:mysql://127.0.0.1:3306/hdb?useUnicode=true&characterEncoding=utf8&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true].
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.074 [0-0-0-writer] INFO ConcurrentTableWriterTask - configure url is unavailable, use obclient for connections.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.103 [0-0-0-reader] INFO CommonRdbmsReader$Task - Finished read record by Sql: [select * from job_group
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] ] jdbcUrl:[jdbc:mysql://127.0.0.1:3306/hdb?useUnicode=true&characterEncoding=utf8&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true].
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.157 [0-0-0-writer] INFO ConcurrentTableWriterTask - Disable partition calculation feature.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.234 [0-0-0-writer] INFO CommonRdbmsWriter$Task - write mode: insert
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.235 [0-0-0-writer] INFO ConcurrentTableWriterTask - writeRecordSql :INSERT INTO job_group (id,app_name,title,order,address_type,address_list) VALUES(?,?,?,?,?,?)
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.311 [0-0-0-writer] ERROR ConcurrentTableWriterTask - partCalculator is null
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.312 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 1 insert task.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.390 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 2 insert task.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.469 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 3 insert task.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.546 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 4 insert task.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.626 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 5 insert task.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.713 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 6 insert task.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.802 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 7 insert task.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.879 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 8 insert task.
2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.957 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 9 insert task.
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:22.035 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 10 insert task.
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:22.213 [0-0-0-writer] ERROR WriterRunner - Writer Runner Received Exceptions:
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-01], Description:[获取表字段相关信息失败.]. - 获取表:job_group 的字段的元信息时失败. 请联系 DBA 核查该库、表信息. - com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ',address_type,address_list from job_group where 1=2' at line 1
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2903)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2855)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.StatementImpl.executeQuery(StatementImpl.java:1445)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:566)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ColumnMetaCache.init(ColumnMetaCache.java:29)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask.startWriteWithConnection(ConcurrentTableWriterTask.java:228)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Task.startWrite(OceanBaseV10Writer.java:239)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:750)
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:41) ~[datax-common-0.0.1-SNAPSHOT.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:579) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ColumnMetaCache.init(ColumnMetaCache.java:29) ~[oceanbasev10writer-0.0.1-SNAPSHOT.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask.startWriteWithConnection(ConcurrentTableWriterTask.java:228) ~[oceanbasev10writer-0.0.1-SNAPSHOT.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Task.startWrite(OceanBaseV10Writer.java:239) ~[oceanbasev10writer-0.0.1-SNAPSHOT.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) ~[datax-core-0.0.1-SNAPSHOT.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:750) [na:1.8.0_361]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ',address_type,address_list from job_group where 1=2' at line 1
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_361]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_361]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_361]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_361]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439) ~[oceanbase-client-1.1.10.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416) ~[oceanbase-client-1.1.10.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176) ~[oceanbase-client-1.1.10.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879) ~[oceanbase-client-1.1.10.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804) ~[oceanbase-client-1.1.10.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998) ~[oceanbase-client-1.1.10.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164) ~[oceanbase-client-1.1.10.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2903) ~[oceanbase-client-1.1.10.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2855) ~[oceanbase-client-1.1.10.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.StatementImpl.executeQuery(StatementImpl.java:1445) ~[oceanbase-client-1.1.10.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:566) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 common frames omitted
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:31.071 [job-0] INFO StandAloneJobContainerCommunicator - Total 1 records, 13 bytes | Speed 1B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00%
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:31.071 [job-0] ERROR JobContainer - 运行scheduler 模式[standalone]出错.
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:31.073 [job-0] ERROR JobContainer - Exception when job run
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-01], Description:[获取表字段相关信息失败.]. - 获取表:job_group 的字段的元信息时失败. 请联系 DBA 核查该库、表信息. - com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ',address_type,address_list from job_group where 1=2' at line 1
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2903)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2855)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.StatementImpl.executeQuery(StatementImpl.java:1445)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:566)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ColumnMetaCache.init(ColumnMetaCache.java:29)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask.startWriteWithConnection(ConcurrentTableWriterTask.java:228)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Task.startWrite(OceanBaseV10Writer.java:239)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:750)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:41) ~[datax-common-0.0.1-SNAPSHOT.jar:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:579) ~[na:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ColumnMetaCache.init(ColumnMetaCache.java:29) ~[na:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask.startWriteWithConnection(ConcurrentTableWriterTask.java:228) ~[na:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) ~[na:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Task.startWrite(OceanBaseV10Writer.java:239) ~[na:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) ~[datax-core-0.0.1-SNAPSHOT.jar:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:750) ~[na:1.8.0_361]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ',address_type,address_list from job_group where 1=2' at line 1
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_361]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_361]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_361]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_361]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439) ~[na:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416) ~[na:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176) ~[na:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879) ~[na:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804) ~[na:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998) ~[na:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164) ~[na:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2903) ~[na:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2855) ~[na:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.StatementImpl.executeQuery(StatementImpl.java:1445) ~[na:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:566) ~[na:na]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 common frames omitted
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:31.073 [job-0] INFO StandAloneJobContainerCommunicator - Total 1 records, 13 bytes | Speed 13B/s, 1 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00%
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:31.074 [job-0] ERROR Engine -
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 经DataX智能分析,该任务最可能的错误原因是:
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-01], Description:[获取表字段相关信息失败.]. - 获取表:job_group 的字段的元信息时失败. 请联系 DBA 核查该库、表信息. - com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ',address_type,address_list from job_group where 1=2' at line 1
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2903)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2855)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.StatementImpl.executeQuery(StatementImpl.java:1445)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:566)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ColumnMetaCache.init(ColumnMetaCache.java:29)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask.startWriteWithConnection(ConcurrentTableWriterTask.java:228)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Task.startWrite(OceanBaseV10Writer.java:239)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:750)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:41)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:579)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ColumnMetaCache.init(ColumnMetaCache.java:29)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask.startWriteWithConnection(ConcurrentTableWriterTask.java:228)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Task.startWrite(OceanBaseV10Writer.java:239)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:750)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ',address_type,address_list from job_group where 1=2' at line 1
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2903)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2855)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.StatementImpl.executeQuery(StatementImpl.java:1445)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:566)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 more
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] Sun Apr 30 09:52:17 GMT+08:00 2023 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] Sun Apr 30 09:52:21 GMT+08:00 2023 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] Exception in thread "taskGroup-0" com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-01], Description:[获取表字段相关信息失败.]. - 获取表:job_group 的字段的元信息时失败. 请联系 DBA 核查该库、表信息. - com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ',address_type,address_list from job_group where 1=2' at line 1
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2903)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2855)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.StatementImpl.executeQuery(StatementImpl.java:1445)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:566)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ColumnMetaCache.init(ColumnMetaCache.java:29)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask.startWriteWithConnection(ConcurrentTableWriterTask.java:228)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Task.startWrite(OceanBaseV10Writer.java:239)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:750)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53]
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:41)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:579)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ColumnMetaCache.init(ColumnMetaCache.java:29)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask.startWriteWithConnection(ConcurrentTableWriterTask.java:228)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Task.startWrite(OceanBaseV10Writer.java:239)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:750)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ',address_type,address_list from job_group where 1=2' at line 1
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2903)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2855)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.StatementImpl.executeQuery(StatementImpl.java:1445)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:566)
2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 more
2023-04-30 09:52:31 [JobThread.run-165] ----------- datax-web job execute end(finish) ----------- ----------- ReturnT:ReturnT [code=500, msg=command exit value(1) is failed, content=null]
2023-04-30 09:52:31 [TriggerCallbackThread.callbackLog-186] ----------- datax-web job callback finish.
jiangbei01
commented
1 year ago
场景还原： 1.在MySQL和oceanbase端，都建表job_group CREATE TABLE
job_group(idint NOT NULL AUTO_INCREMENT,app_namevarchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '执行器AppName',titlevarchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '执行器名称',orderint NOT NULL DEFAULT '0' COMMENT '排序',address_typetinyint NOT NULL DEFAULT '0' COMMENT '执行器地址类型：0=自动注册、1=手动录入',address_listvarchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行器地址列表，多地址逗号分隔', PRIMARY KEY (id) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC2.执行datax任务
{ "job": { "setting": { "speed": { "channel": 4 }, "errorLimit": { "record": 0, "percentage": 0.1 } }, "content": [ { "reader": { "name": "mysqlreader", "parameter": { "username": "dba", "password": "xxx", "column": [ "*" ], "connection": [ { "table": [ "job_group" ], "jdbcUrl": [ "jdbc:mysql://127.0.0.1:3306/hdb?useUnicode=true&characterEncoding=utf8" ] } ] } }, "writer": { "name": "oceanbasev10writer", "parameter": { "obWriteMode": "insert", "column": [ "*" ], "preSql": [ "truncate table job_group" ], "connection": [ { "jdbcUrl": "jdbc:oceanbase://10.250.37.236:2883/hdb?", "table": [ "job_group" ] } ], "username": "admin@test", "password": "xxx", "writerThreadCount": 10, "batchSize": 1000, "memstoreThreshold": "0.9" } } } ] } }3.错误如下 2023-04-30 09:52:17 [JobThread.run-130]----------- datax-web job execute start -----------
----------- Param: 2023-04-30 09:52:17 [BuildCommand.buildDataXParam-100] ------------------Command parameters: 2023-04-30 09:52:17 [ExecutorJobHandler.execute-57] ------------------DataX process id: 20270 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] DataX (DATAX-OPENSOURCE-3.0), From Alibaba ! 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] Copyright (C) 2010-2017, Alibaba Group. All Rights Reserved. 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.396 [main] INFO MessageSource - JVM TimeZone: GMT+08:00, Locale: zh_CN 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.398 [main] INFO MessageSource - use Locale: zh_CN timeZone: sun.util.calendar.ZoneInfo[id="GMT+08:00",offset=28800000,dstSavings=0,useDaylight=false,transitions=0,lastRule=null] 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.423 [main] INFO VMInfo - VMInfo# operatingSystem class => sun.management.OperatingSystemImpl 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.427 [main] INFO Engine - the machine info => 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] osInfo: Oracle Corporation 1.8 25.361-b09 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] jvmInfo: Linux amd64 3.10.0-1160.el7.x86_64 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] cpu num: 4 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] totalPhysicalMemory: -0.00G 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] freePhysicalMemory: -0.00G 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] maxFileDescriptorCount: -1 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] currentOpenFileDescriptorCount: -1 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] GC Names [PS MarkSweep, PS Scavenge] 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] MEMORY_NAME | allocation_size | init_size
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] PS Eden Space | 256.00MB | 256.00MB
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] Code Cache | 240.00MB | 2.44MB
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] Compressed Class Space | 1,024.00MB | 0.00MB
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] PS Survivor Space | 42.50MB | 42.50MB
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] PS Old Gen | 683.00MB | 683.00MB
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] Metaspace | -0.00MB | 0.00MB
2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.444 [main] INFO Engine - 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] { 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "content":[ 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] { 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "reader":{ 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "name":"mysqlreader", 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "parameter":{ 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "column":[ 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "*" 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ], 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "connection":[ 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] { 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "jdbcUrl":[ 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "jdbc:mysql://127.0.0.1:3306/hdb?useUnicode=true&characterEncoding=utf8" 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ], 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "table":[ 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "job_group" 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ] 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] } 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ], 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "password":"****", 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "username":"dba" 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] } 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] }, 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "writer":{ 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "name":"oceanbasev10writer", 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "parameter":{ 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "batchSize":1000, 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "column":[ 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "*" 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ], 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "connection":[ 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] { 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "jdbcUrl":"jdbc:oceanbase://10.250.37.236:2883/hdb?", 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "table":[ 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "job_group" 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ] 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] } 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ], 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "memstoreThreshold":"0.9", 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "obWriteMode":"insert", 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "password":"****", 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "preSql":[ 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "truncate table jobgroup" 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ], 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "username":"admin@test", 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "writerThreadCount":10 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] } 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] } 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] } 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] ], 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "setting":{ 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "errorLimit":{ 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "percentage":0.1, 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "record":0 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] }, 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "speed":{ 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] "channel":4 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] } 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] } 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] } 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.459 [main] WARN Engine - prioriy set to 0, because NumberFormatException, the value is: null 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.460 [main] INFO PerfTrace - PerfTrace traceId=job-1, isEnable=false, priority=0 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.460 [main] INFO JobContainer - DataX jobContainer starts job. 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.462 [main] INFO JobContainer - Set jobId = 0 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.960 [job-0] INFO OriginalConfPretreatmentUtil - Available jdbcUrl:jdbc:mysql://127.0.0.1:3306/hdb?useUnicode=true&characterEncoding=utf8&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true. 2023-04-30 09:52:17 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:17.961 [job-0] WARN OriginalConfPretreatmentUtil - 您的配置文件中的列配置存在一定的风险. 因为您未配置读取数据库表的列，当您的表字段个数、类型有变动时，可能影响任务正确性甚至会运行出错。请检查您的配置并作出修改. 2023-04-30 09:52:17 [ProcessCallbackThread.callbackLog-186]
----------- datax-web job callback finish. 2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:18.267 [job-0] INFO DbUtils - value for query [SHOW VARIABLES LIKE 'ob_compatibility_mode'] is [MYSQL] 2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:18.632 [job-0] INFO OriginalConfPretreatmentUtil - table:[job_group] all columns:[ 2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] id,app_name,title,order,address_type,address_list 2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] ]. 2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:18.632 [job-0] WARN OriginalConfPretreatmentUtil - 您的配置文件中的列配置信息存在风险. 因为您配置的写入数据库表的列为，当您的表字段个数、类型有变动时，可能影响任务正确性甚至会运行出错。请检查您的配置并作出修改. 2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:18.634 [job-0] INFO OriginalConfPretreatmentUtil - Write data [ 2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] INSERT INTO %s (id,app_name,title,order,address_type,address_list) VALUES(?,?,?,?,?,?) 2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] ], which jdbcUrl like:[jdbc:oceanbase://10.250.37.236:2883/hdb?&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true] 2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:18.634 [job-0] INFO JobContainer - jobContainer starts to do prepare ... 2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:18.634 [job-0] INFO JobContainer - DataX Reader.Job [mysqlreader] do prepare work . 2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:18.635 [job-0] INFO JobContainer - DataX Writer.Job [oceanbasev10writer] do prepare work . 2023-04-30 09:52:18 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:18.716 [job-0] INFO CommonRdbmsWriter$Job - Begin to execute preSqls:[truncate table job_group]. context info:jdbc:oceanbase://10.250.37.236:2883/hdb?&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.037 [job-0] INFO DbUtils - value for query [show variables like 'version'] is [5.7.25-OceanBase_CE-v4.1.0.0] 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.038 [job-0] INFO JobContainer - jobContainer starts to do split ... 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.038 [job-0] INFO JobContainer - Job set Channel-Number to 4 channels. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.041 [job-0] INFO JobContainer - DataX Reader.Job [mysqlreader] splits to [1] tasks. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.041 [job-0] INFO JobContainer - DataX Writer.Job [oceanbasev10writer] splits to [1] tasks. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.055 [job-0] INFO JobContainer - jobContainer starts to do schedule ... 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.057 [job-0] INFO JobContainer - Scheduler starts [1] taskGroups. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.059 [job-0] INFO JobContainer - Running by standalone Mode. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.062 [taskGroup-0] INFO TaskGroupContainer - taskGroupId=[0] start [1] channels for [1] tasks. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.065 [taskGroup-0] INFO Channel - Channel set byte_speed_limit to -1, No bps activated. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.065 [taskGroup-0] INFO Channel - Channel set record_speed_limit to -1, No tps activated. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.072 [taskGroup-0] INFO TaskGroupContainer - taskGroup[0] taskId[0] attemptCount[1] is started 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.074 [0-0-0-writer] INFO OceanBaseV10Writer$Task - tableNumber:1,writerTask Class:com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.074 [0-0-0-reader] INFO CommonRdbmsReader$Task - Begin to read record by Sql: [select from job_group 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] ] jdbcUrl:[jdbc:mysql://127.0.0.1:3306/hdb?useUnicode=true&characterEncoding=utf8&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true]. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.074 [0-0-0-writer] INFO ConcurrentTableWriterTask - configure url is unavailable, use obclient for connections. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.103 [0-0-0-reader] INFO CommonRdbmsReader$Task - Finished read record by Sql: [select * from job_group 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] ] jdbcUrl:[jdbc:mysql://127.0.0.1:3306/hdb?useUnicode=true&characterEncoding=utf8&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true]. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.157 [0-0-0-writer] INFO ConcurrentTableWriterTask - Disable partition calculation feature. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.234 [0-0-0-writer] INFO CommonRdbmsWriter$Task - write mode: insert 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.235 [0-0-0-writer] INFO ConcurrentTableWriterTask - writeRecordSql :INSERT INTO job_group (id,app_name,title,order,address_type,address_list) VALUES(?,?,?,?,?,?) 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.311 [0-0-0-writer] ERROR ConcurrentTableWriterTask - partCalculator is null 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.312 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 1 insert task. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.390 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 2 insert task. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.469 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 3 insert task. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.546 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 4 insert task. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.626 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 5 insert task. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.713 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 6 insert task. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.802 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 7 insert task. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.879 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 8 insert task. 2023-04-30 09:52:21 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:21.957 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 9 insert task. 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:22.035 [0-0-0-writer] INFO ConcurrentTableWriterTask - start 10 insert task. 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:22.213 [0-0-0-writer] ERROR WriterRunner - Writer Runner Received Exceptions: 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-01], Description:[获取表字段相关信息失败.]. - 获取表:job_group 的字段的元信息时失败. 请联系 DBA 核查该库、表信息. - com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ',address_type,address_list from job_group where 1=2' at line 1 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2903) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2855) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.StatementImpl.executeQuery(StatementImpl.java:1445) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:566) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ColumnMetaCache.init(ColumnMetaCache.java:29) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask.startWriteWithConnection(ConcurrentTableWriterTask.java:228) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Task.startWrite(OceanBaseV10Writer.java:239) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:750) 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:41) ~[datax-common-0.0.1-SNAPSHOT.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:579) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ColumnMetaCache.init(ColumnMetaCache.java:29) ~[oceanbasev10writer-0.0.1-SNAPSHOT.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask.startWriteWithConnection(ConcurrentTableWriterTask.java:228) ~[oceanbasev10writer-0.0.1-SNAPSHOT.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Task.startWrite(OceanBaseV10Writer.java:239) ~[oceanbasev10writer-0.0.1-SNAPSHOT.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) ~[datax-core-0.0.1-SNAPSHOT.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:750) [na:1.8.0_361] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ',address_type,address_list from job_group where 1=2' at line 1 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_361] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_361] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_361] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_361] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439) ~[oceanbase-client-1.1.10.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416) ~[oceanbase-client-1.1.10.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176) ~[oceanbase-client-1.1.10.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879) ~[oceanbase-client-1.1.10.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804) ~[oceanbase-client-1.1.10.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998) ~[oceanbase-client-1.1.10.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164) ~[oceanbase-client-1.1.10.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2903) ~[oceanbase-client-1.1.10.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2855) ~[oceanbase-client-1.1.10.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.StatementImpl.executeQuery(StatementImpl.java:1445) ~[oceanbase-client-1.1.10.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:566) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] 2023-04-30 09:52:22 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 common frames omitted 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:31.071 [job-0] INFO StandAloneJobContainerCommunicator - Total 1 records, 13 bytes | Speed 1B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00% 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:31.071 [job-0] ERROR JobContainer - 运行scheduler 模式[standalone]出错. 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:31.073 [job-0] ERROR JobContainer - Exception when job run 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-01], Description:[获取表字段相关信息失败.]. - 获取表:job_group 的字段的元信息时失败. 请联系 DBA 核查该库、表信息. - com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ',address_type,address_list from job_group where 1=2' at line 1 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2903) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2855) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.StatementImpl.executeQuery(StatementImpl.java:1445) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:566) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ColumnMetaCache.init(ColumnMetaCache.java:29) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask.startWriteWithConnection(ConcurrentTableWriterTask.java:228) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Task.startWrite(OceanBaseV10Writer.java:239) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:750) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:41) ~[datax-common-0.0.1-SNAPSHOT.jar:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:579) ~[na:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ColumnMetaCache.init(ColumnMetaCache.java:29) ~[na:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask.startWriteWithConnection(ConcurrentTableWriterTask.java:228) ~[na:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) ~[na:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Task.startWrite(OceanBaseV10Writer.java:239) ~[na:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) ~[datax-core-0.0.1-SNAPSHOT.jar:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:750) ~[na:1.8.0_361] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ',address_type,address_list from job_group where 1=2' at line 1 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_361] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_361] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_361] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_361] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439) ~[na:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416) ~[na:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176) ~[na:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879) ~[na:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804) ~[na:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998) ~[na:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164) ~[na:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2903) ~[na:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2855) ~[na:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.StatementImpl.executeQuery(StatementImpl.java:1445) ~[na:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:566) ~[na:na] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 common frames omitted 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:31.073 [job-0] INFO StandAloneJobContainerCommunicator - Total 1 records, 13 bytes | Speed 13B/s, 1 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00% 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:31.074 [job-0] ERROR Engine - 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 经DataX智能分析,该任务最可能的错误原因是: 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-01], Description:[获取表字段相关信息失败.]. - 获取表:job_group 的字段的元信息时失败. 请联系 DBA 核查该库、表信息. - com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ',address_type,address_list from job_group where 1=2' at line 1 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2903) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2855) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.StatementImpl.executeQuery(StatementImpl.java:1445) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:566) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ColumnMetaCache.init(ColumnMetaCache.java:29) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask.startWriteWithConnection(ConcurrentTableWriterTask.java:228) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Task.startWrite(OceanBaseV10Writer.java:239) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:750) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:41) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:579) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ColumnMetaCache.init(ColumnMetaCache.java:29) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask.startWriteWithConnection(ConcurrentTableWriterTask.java:228) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Task.startWrite(OceanBaseV10Writer.java:239) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:750) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ',address_type,address_list from job_group where 1=2' at line 1 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2903) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2855) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.StatementImpl.executeQuery(StatementImpl.java:1445) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:566) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 more 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] Sun Apr 30 09:52:17 GMT+08:00 2023 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] Sun Apr 30 09:52:21 GMT+08:00 2023 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] Exception in thread "taskGroup-0" com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-01], Description:[获取表字段相关信息失败.]. - 获取表:job_group 的字段的元信息时失败. 请联系 DBA 核查该库、表信息. - com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ',address_type,address_list from job_group where 1=2' at line 1 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2903) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2855) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.StatementImpl.executeQuery(StatementImpl.java:1445) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:566) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ColumnMetaCache.init(ColumnMetaCache.java:29) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask.startWriteWithConnection(ConcurrentTableWriterTask.java:228) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Task.startWrite(OceanBaseV10Writer.java:239) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:750) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:41) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:579) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ColumnMetaCache.init(ColumnMetaCache.java:29) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.ConcurrentTableWriterTask.startWriteWithConnection(ConcurrentTableWriterTask.java:228) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.oceanbasev10writer.OceanBaseV10Writer$Task.startWrite(OceanBaseV10Writer.java:239) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:750) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.alipay.oceanbase.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ',address_type,address_list from job_group where 1=2' at line 1 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.handleNewInstance(Util.java:439) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.Util.getInstance(Util.java:416) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1176) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4879) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4804) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2998) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3164) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2903) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2855) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alipay.oceanbase.jdbc.StatementImpl.executeQuery(StatementImpl.java:1445) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.util.DBUtil.getColumnMetaData(DBUtil.java:566) 2023-04-30 09:52:31 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 more 2023-04-30 09:52:31 [JobThread.run-165]
----------- datax-web job execute end(finish) -----------
----------- ReturnT:ReturnT [code=500, msg=command exit value(1) is failed, content=null] 2023-04-30 09:52:31 [TriggerCallbackThread.callbackLog-186]
----------- datax-web job callback finish.