/data/datax/bin/datax.py /data/datax/job/data-water.json
DataX (DATAX-OPENSOURCE-3.0), From Alibaba !
Copyright (C) 2010-2017, Alibaba Group. All Rights Reserved.
2025-11-11 17:12:32.796 [main] INFO MessageSource - JVM TimeZone: GMT+08:00, Locale: zh_CN
2025-11-11 17:12:32.800 [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]
2025-11-11 17:12:32.921 [main] INFO VMInfo - VMInfo# operatingSystem class => sun.management.OperatingSystemImpl
2025-11-11 17:12:32.934 [main] INFO Engine - the machine info =>
osInfo: Linux amd64 3.10.0-1127.19.1.el7.x86_64
jvmInfo: Oracle Corporation 1.8 25.291-b10
cpu num: 16
totalPhysicalMemory: -0.00G
freePhysicalMemory: -0.00G
maxFileDescriptorCount: -1
currentOpenFileDescriptorCount: -1
GC Names [PS MarkSweep, PS Scavenge]
MEMORY_NAME | allocation_size | init_size
PS Eden Space | 256.00MB | 256.00MB
Code Cache | 240.00MB | 2.44MB
Compressed Class Space | 1,024.00MB | 0.00MB
PS Survivor Space | 42.50MB | 42.50MB
PS Old Gen | 683.00MB | 683.00MB
Metaspace | -0.00MB | 0.00MB
2025-11-11 17:12:32.962 [main] INFO Engine -
{
"setting":{
"speed":{
"channel":1
},
"errorLimit":{
"record":0,
"percentage":0.02
}
},
"content":[
{
"reader":{
"name":"mysqlreader",
"parameter":{
"username":"root",
"password":"**********",
"connection":[
{
"jdbcUrl":[
"jdbc:mysql://192.168.12.59:3306/bmsapi?useSSL=false&serverTimezone=Asia/Shanghai"
],
"querySql":[
"SELECT battery_id AS tbname, upload_time AS ts, battery_voltage, battery_current, battery_soc, battery_hard_version, battery_soft_version, battery_work_mode, battery_protect_code, battery_error_code, battery_temperature_max, battery_temperature_min, battery_voltage_max, battery_voltage_min, mos_status, mos_temp, battery_cycle_times, steady_status, cell_voltage, model, manufacture, imei, imsi, iccid, tracker_hardware_version, tracker_software_version, csq, network_type, location_mode, longitude, longitude_direction, latitude, latitude_direction, gps_speed, gps_signal, satellite_num, accuracy, flag, client_id, topic as msg_topic, product_key as product_key_id, handled, todo_now, needack, businessmode, create_time, update_time, payload, project_id, sn, soh, battery_temperature_avg, charge_mode, low_battery_warn, charge_current_max, discharge_current_max, charge_current_avg, discharge_current_avg, gps_cog, total_charge_energy, charge_cycles_history, charge_capacity_history, discharge_capacity_history, ntc1, ntc2, ntc3, ntc4, tracker_communication_status, battery_kind, dsoc, correction_rate, tsoc, bsoc, fcc, actual_soh, charging_sop, discharging_sop, task_max_delay_1ms, task_max_delay_10ms, task_max_delay_100ms, task_max_delay_500ms, task_max_time_1ms, task_max_time_10ms, task_max_time_100ms, task_max_time_500ms, empty_count, cell_info, gps_max_signal, msg_delay_time, data_type, battery_vehicle_status, storage_status, ota_status, lock_status, battery_vehicle_alarm_status FROM my_battery_info WHERE upload_time IS NOT NULL LIMIT 10"
]
}
]
}
},
"writer":{
"name":"tdenginewriter",
"parameter":{
"username":"root",
"password":"**************",
"connection":[
{
"jdbcUrl":[
"jdbc:TAOS-RS://192.168.12.59:6041/bms"
],
"table":[
"my_battery_info"
]
}
],
"column":[
{
"name":"tbname",
"type":"VARCHAR"
},
{
"name":"ts",
"type":"TIMESTAMP"
},
{
"name":"battery_voltage",
"type":"INT"
},
{
"name":"battery_current",
"type":"INT"
},
{
"name":"battery_soc",
"type":"INT"
},
{
"name":"battery_hard_version",
"type":"VARCHAR"
},
{
"name":"battery_soft_version",
"type":"VARCHAR"
},
{
"name":"battery_work_mode",
"type":"VARCHAR"
},
{
"name":"battery_protect_code",
"type":"VARCHAR"
},
{
"name":"battery_error_code",
"type":"VARCHAR"
},
{
"name":"battery_temperature_max",
"type":"INT"
},
{
"name":"battery_temperature_min",
"type":"INT"
},
{
"name":"battery_voltage_max",
"type":"INT"
},
{
"name":"battery_voltage_min",
"type":"INT"
},
{
"name":"mos_status",
"type":"INT"
},
{
"name":"mos_temp",
"type":"INT"
},
{
"name":"battery_cycle_times",
"type":"INT"
},
{
"name":"steady_status",
"type":"INT"
},
{
"name":"cell_voltage",
"type":"VARCHAR"
},
{
"name":"model",
"type":"VARCHAR"
},
{
"name":"manufacture",
"type":"VARCHAR"
},
{
"name":"imei",
"type":"VARCHAR"
},
{
"name":"imsi",
"type":"VARCHAR"
},
{
"name":"iccid",
"type":"VARCHAR"
},
{
"name":"tracker_hardware_version",
"type":"VARCHAR"
},
{
"name":"tracker_software_version",
"type":"VARCHAR"
},
{
"name":"csq",
"type":"VARCHAR"
},
{
"name":"network_type",
"type":"VARCHAR"
},
{
"name":"location_mode",
"type":"VARCHAR"
},
{
"name":"longitude",
"type":"VARCHAR"
},
{
"name":"longitude_direction",
"type":"VARCHAR"
},
{
"name":"latitude",
"type":"VARCHAR"
},
{
"name":"latitude_direction",
"type":"VARCHAR"
},
{
"name":"gps_speed",
"type":"VARCHAR"
},
{
"name":"gps_signal",
"type":"VARCHAR"
},
{
"name":"satellite_num",
"type":"VARCHAR"
},
{
"name":"accuracy",
"type":"VARCHAR"
},
{
"name":"flag",
"type":"INT"
},
{
"name":"client_id",
"type":"VARCHAR"
},
{
"name":"msg_topic",
"type":"VARCHAR"
},
{
"name":"product_key_id",
"type":"VARCHAR"
},
{
"name":"handled",
"type":"INT"
},
{
"name":"todo_now",
"type":"INT"
},
{
"name":"needack",
"type":"TINYINT"
},
{
"name":"businessmode",
"type":"VARCHAR"
},
{
"name":"create_time",
"type":"TIMESTAMP"
},
{
"name":"update_time",
"type":"TIMESTAMP"
},
{
"name":"payload",
"type":"TEXT"
},
{
"name":"project_id",
"type":"INT"
},
{
"name":"sn",
"type":"VARCHAR"
},
{
"name":"soh",
"type":"INT"
},
{
"name":"battery_temperature_avg",
"type":"INT"
},
{
"name":"charge_mode",
"type":"INT"
},
{
"name":"low_battery_warn",
"type":"INT"
},
{
"name":"charge_current_max",
"type":"INT"
},
{
"name":"discharge_current_max",
"type":"INT"
},
{
"name":"charge_current_avg",
"type":"INT"
},
{
"name":"discharge_current_avg",
"type":"INT"
},
{
"name":"gps_cog",
"type":"VARCHAR"
},
{
"name":"total_charge_energy",
"type":"DOUBLE"
},
{
"name":"charge_cycles_history",
"type":"INT"
},
{
"name":"charge_capacity_history",
"type":"DOUBLE"
},
{
"name":"discharge_capacity_history",
"type":"DOUBLE"
},
{
"name":"ntc1",
"type":"INT"
},
{
"name":"ntc2",
"type":"INT"
},
{
"name":"ntc3",
"type":"INT"
},
{
"name":"ntc4",
"type":"INT"
},
{
"name":"tracker_communication_status",
"type":"VARCHAR"
},
{
"name":"battery_kind",
"type":"VARCHAR"
},
{
"name":"dsoc",
"type":"INT"
},
{
"name":"correction_rate",
"type":"INT"
},
{
"name":"tsoc",
"type":"INT"
},
{
"name":"bsoc",
"type":"INT"
},
{
"name":"fcc",
"type":"INT"
},
{
"name":"actual_soh",
"type":"INT"
},
{
"name":"charging_sop",
"type":"INT"
},
{
"name":"discharging_sop",
"type":"INT"
},
{
"name":"task_max_delay_1ms",
"type":"INT"
},
{
"name":"task_max_delay_10ms",
"type":"INT"
},
{
"name":"task_max_delay_100ms",
"type":"INT"
},
{
"name":"task_max_delay_500ms",
"type":"INT"
},
{
"name":"task_max_time_1ms",
"type":"INT"
},
{
"name":"task_max_time_10ms",
"type":"INT"
},
{
"name":"task_max_time_100ms",
"type":"INT"
},
{
"name":"task_max_time_500ms",
"type":"INT"
},
{
"name":"empty_count",
"type":"INT"
},
{
"name":"cell_info",
"type":"TEXT"
},
{
"name":"gps_max_signal",
"type":"INT"
},
{
"name":"msg_delay_time",
"type":"INT"
},
{
"name":"data_type",
"type":"INT"
},
{
"name":"battery_vehicle_status",
"type":"INT"
},
{
"name":"storage_status",
"type":"INT"
},
{
"name":"ota_status",
"type":"INT"
},
{
"name":"lock_status",
"type":"INT"
},
{
"name":"battery_vehicle_alarm_status",
"type":"INT"
}
],
"batchSize":1000,
"ignoreTagsUnmatched":true
}
}
}
]
}
2025-11-11 17:12:32.999 [main] INFO PerfTrace - PerfTrace traceId=job_-1, isEnable=false
2025-11-11 17:12:32.999 [main] INFO JobContainer - DataX jobContainer starts job.
2025-11-11 17:12:33.001 [main] INFO JobContainer - Set jobId = 0
2025-11-11 17:12:33.641 [job-0] INFO OriginalConfPretreatmentUtil - Available jdbcUrl:jdbc:mysql://192.168.12.59:3306/bmsapi?useSSL=false&serverTimezone=Asia/Shanghai&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true.
2025-11-11 17:12:33.654 [job-0] INFO JobContainer - jobContainer starts to do prepare ...
2025-11-11 17:12:33.655 [job-0] INFO JobContainer - DataX Reader.Job [mysqlreader] do prepare work .
2025-11-11 17:12:33.655 [job-0] INFO JobContainer - DataX Writer.Job [tdenginewriter] do prepare work .
2025-11-11 17:12:33.655 [job-0] INFO JobContainer - jobContainer starts to do split ...
2025-11-11 17:12:33.656 [job-0] INFO JobContainer - Job set Channel-Number to 1 channels.
2025-11-11 17:12:33.664 [job-0] INFO JobContainer - DataX Reader.Job [mysqlreader] splits to [1] tasks.
2025-11-11 17:12:33.666 [job-0] INFO JobContainer - DataX Writer.Job [tdenginewriter] splits to [1] tasks.
2025-11-11 17:12:33.711 [job-0] INFO JobContainer - jobContainer starts to do schedule ...
2025-11-11 17:12:33.717 [job-0] INFO JobContainer - Scheduler starts [1] taskGroups.
2025-11-11 17:12:33.720 [job-0] INFO JobContainer - Running by standalone Mode.
2025-11-11 17:12:33.729 [taskGroup-0] INFO TaskGroupContainer - taskGroupId=[0] start [1] channels for [1] tasks.
2025-11-11 17:12:33.737 [taskGroup-0] INFO Channel - Channel set byte_speed_limit to -1, No bps activated.
2025-11-11 17:12:33.737 [taskGroup-0] INFO Channel - Channel set record_speed_limit to -1, No tps activated.
2025-11-11 17:12:33.752 [taskGroup-0] INFO TaskGroupContainer - taskGroup[0] taskId[0] attemptCount[1] is started
2025-11-11 17:12:33.763 [0-0-0-reader] INFO CommonRdbmsReader$Task - Begin to read record by Sql: [SELECT battery_id AS tbname, upload_time AS ts, battery_voltage, battery_current, battery_soc, battery_hard_version, battery_soft_version, battery_work_mode, battery_protect_code, battery_error_code, battery_temperature_max, battery_temperature_min, battery_voltage_max, battery_voltage_min, mos_status, mos_temp, battery_cycle_times, steady_status, cell_voltage, model, manufacture, imei, imsi, iccid, tracker_hardware_version, tracker_software_version, csq, network_type, location_mode, longitude, longitude_direction, latitude, latitude_direction, gps_speed, gps_signal, satellite_num, accuracy, flag, client_id, topic as msg_topic, product_key as product_key_id, handled, todo_now, needack, businessmode, create_time, update_time, payload, project_id, sn, soh, battery_temperature_avg, charge_mode, low_battery_warn, charge_current_max, discharge_current_max, charge_current_avg, discharge_current_avg, gps_cog, total_charge_energy, charge_cycles_history, charge_capacity_history, discharge_capacity_history, ntc1, ntc2, ntc3, ntc4, tracker_communication_status, battery_kind, dsoc, correction_rate, tsoc, bsoc, fcc, actual_soh, charging_sop, discharging_sop, task_max_delay_1ms, task_max_delay_10ms, task_max_delay_100ms, task_max_delay_500ms, task_max_time_1ms, task_max_time_10ms, task_max_time_100ms, task_max_time_500ms, empty_count, cell_info, gps_max_signal, msg_delay_time, data_type, battery_vehicle_status, storage_status, ota_status, lock_status, battery_vehicle_alarm_status FROM my_battery_info WHERE upload_time IS NOT NULL LIMIT 10
] jdbcUrl:[jdbc:mysql://192.168.12.59:3306/bmsapi?useSSL=false&serverTimezone=Asia/Shanghai&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true].
2025-11-11 17:12:33.813 [0-0-0-reader] INFO CommonRdbmsReader$Task - Finished read record by Sql: [SELECT battery_id AS tbname, upload_time AS ts, battery_voltage, battery_current, battery_soc, battery_hard_version, battery_soft_version, battery_work_mode, battery_protect_code, battery_error_code, battery_temperature_max, battery_temperature_min, battery_voltage_max, battery_voltage_min, mos_status, mos_temp, battery_cycle_times, steady_status, cell_voltage, model, manufacture, imei, imsi, iccid, tracker_hardware_version, tracker_software_version, csq, network_type, location_mode, longitude, longitude_direction, latitude, latitude_direction, gps_speed, gps_signal, satellite_num, accuracy, flag, client_id, topic as msg_topic, product_key as product_key_id, handled, todo_now, needack, businessmode, create_time, update_time, payload, project_id, sn, soh, battery_temperature_avg, charge_mode, low_battery_warn, charge_current_max, discharge_current_max, charge_current_avg, discharge_current_avg, gps_cog, total_charge_energy, charge_cycles_history, charge_capacity_history, discharge_capacity_history, ntc1, ntc2, ntc3, ntc4, tracker_communication_status, battery_kind, dsoc, correction_rate, tsoc, bsoc, fcc, actual_soh, charging_sop, discharging_sop, task_max_delay_1ms, task_max_delay_10ms, task_max_delay_100ms, task_max_delay_500ms, task_max_time_1ms, task_max_time_10ms, task_max_time_100ms, task_max_time_500ms, empty_count, cell_info, gps_max_signal, msg_delay_time, data_type, battery_vehicle_status, storage_status, ota_status, lock_status, battery_vehicle_alarm_status FROM my_battery_info WHERE upload_time IS NOT NULL LIMIT 10
] jdbcUrl:[jdbc:mysql://192.168.12.59:3306/bmsapi?useSSL=false&serverTimezone=Asia/Shanghai&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true].
2025-11-11 17:12:33.930 [0-0-0-writer] ERROR WriterRunner - Writer Runner Received Exceptions:
com.alibaba.datax.common.exception.DataXException: Code:[TDengineWriter-02], Description:[运行时异常]. - No suitable driver found for ["jdbc:TAOS-RS://192.168.12.59:6041/bms"]
at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:30) ~[datax-common-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.writer.tdenginewriter.DefaultDataHandler.handle(DefaultDataHandler.java:113) ~[tdenginewriter-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.writer.tdenginewriter.TDengineWriter$Task.startWrite(TDengineWriter.java:109) ~[tdenginewriter-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) ~[datax-core-0.0.1-SNAPSHOT.jar:na]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_291]
Exception in thread "taskGroup-0" com.alibaba.datax.common.exception.DataXException: Code:[TDengineWriter-02], Description:[运行时异常]. - No suitable driver found for ["jdbc:TAOS-RS://192.168.12.59:6041/bms"]
at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:30)
at com.alibaba.datax.plugin.writer.tdenginewriter.DefaultDataHandler.handle(DefaultDataHandler.java:113)
at com.alibaba.datax.plugin.writer.tdenginewriter.TDengineWriter$Task.startWrite(TDengineWriter.java:109)
at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56)
at java.lang.Thread.run(Thread.java:748)
2025-11-11 17:12:43.751 [job-0] INFO StandAloneJobContainerCommunicator - Total 10 records, 3623 bytes | Speed 362B/s, 1 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00%
2025-11-11 17:12:43.751 [job-0] ERROR JobContainer - 运行scheduler 模式[standalone]出错.
2025-11-11 17:12:43.752 [job-0] ERROR JobContainer - Exception when job run
com.alibaba.datax.common.exception.DataXException: Code:[TDengineWriter-02], Description:[运行时异常]. - No suitable driver found for ["jdbc:TAOS-RS://192.168.12.59:6041/bms"]
at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:30) ~[datax-common-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.writer.tdenginewriter.DefaultDataHandler.handle(DefaultDataHandler.java:113) ~[na:na]
at com.alibaba.datax.plugin.writer.tdenginewriter.TDengineWriter$Task.startWrite(TDengineWriter.java:109) ~[na:na]
at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) ~[datax-core-0.0.1-SNAPSHOT.jar:na]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_291]
2025-11-11 17:12:43.753 [job-0] INFO StandAloneJobContainerCommunicator - Total 10 records, 3623 bytes | Speed 3.54KB/s, 10 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00%
2025-11-11 17:12:43.754 [job-0] ERROR Engine -
经DataX智能分析,该任务最可能的错误原因是:
com.alibaba.datax.common.exception.DataXException: Code:[TDengineWriter-02], Description:[运行时异常]. - No suitable driver found for ["jdbc:TAOS-RS://192.168.12.59:6041/bms"]
at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:30)
at com.alibaba.datax.plugin.writer.tdenginewriter.DefaultDataHandler.handle(DefaultDataHandler.java:113)
at com.alibaba.datax.plugin.writer.tdenginewriter.TDengineWriter$Task.startWrite(TDengineWriter.java:109)
at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56)
at java.lang.Thread.run(Thread.java:748)
最新发布