flink 结果表为mysql null、浮点入表
硬件设备的软件版本，上报的信息不同。
flink 结果表为mysql null、浮点入表
com.alibaba.ververica.connectors.common.exception.ConnectorException:
************
ERR_ID:
CON-04000041
CAUSE:
RDS write to db error, sql INSERT INTO `device_status` (`data_version`,`did`,......, `Delta`, `proctime`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ACTION:
Check the cause, and contact system admin for help if necessary
DETAIL:
************
at com.alibaba.ververica.connectors.common.exception.ErrorUtils.getException(ErrorUtils.java:25) ~[?:?]
at com.alibaba.ververica.connectors.rds.sink.RdsOutputFormat.executeSql(RdsOutputFormat.java:525) ~[?:?]
at com.alibaba.ververica.connectors.rds.sink.RdsOutputFormat.eagerAdd(RdsOutputFormat.java:350) ~[?:?]
at com.alibaba.ververica.connectors.rds.sink.RdsOutputFormat.writeRecord(RdsOutputFormat.java:305) ~[?:?]
at com.alibaba.ververica.connectors.rds.sink.RdsOutputFormat.writeRecord(RdsOutputFormat.java:77) ~[?:?]
at com.alibaba.ververica.connectors.common.sink.OutputFormatSinkFunction.invoke(OutputFormatSinkFunction.java:71) ~[?:?]
at org.apache.flink.streaming.api.functions.sink.SinkFunction.invoke(SinkFunction.java:50) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.table.runtime.operators.sink.SinkOperator.processElement(SinkOperator.java:68) ~[flink-table-runtime-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.streaming.runtime.tasks.ChainingOutput.pushToOperator(ChainingOutput.java:94) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.streaming.runtime.tasks.ChainingOutput.collect(ChainingOutput.java:75) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.streaming.runtime.tasks.ChainingOutput.collect(ChainingOutput.java:39) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at StreamExecCalc$407708.processElement_split45809(Unknown Source) ~[?:?]
at StreamExecCalc$407708.processElement(Unknown Source) ~[?:?]
at org.apache.flink.streaming.runtime.tasks.ChainingOutput.pushToOperator(ChainingOutput.java:94) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.streaming.runtime.tasks.ChainingOutput.collect(ChainingOutput.java:75) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.streaming.runtime.tasks.ChainingOutput.collect(ChainingOutput.java:39) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.streaming.runtime.tasks.SourceOperatorStreamTask$AsyncDataOutputToOutput.emitRecord(SourceOperatorStreamTask.java:309) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.streaming.api.operators.source.SourceOutputWithWatermarks.collect(SourceOutputWithWatermarks.java:110) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at com.alibaba.ververica.connectors.metaq.source.reader.MetaQRecordEmitter$CollectorAdapter.collect(MetaQRecordEmitter.java:78) ~[?:?]
at com.alibaba.ververica.connectors.common.source.resolver.DefaultSourceCollector$MetadataCollector.collect(DefaultSourceCollector.java:1014) ~[?:?]
at com.alibaba.ververica.connectors.common.source.resolver.DefaultSourceCollector$MetadataCollector.collect(DefaultSourceCollector.java:982) ~[?:?]
at com.alibaba.ververica.connectors.common.source.resolver.parse.BufferedTextRowHighSpeedParser.parseBytesMessageByBinary(BufferedTextRowHighSpeedParser.java:144) ~[?:?]
at com.alibaba.ververica.connectors.common.source.deserializer.DefaultSourceDeserializer.parseRawMessage(DefaultSourceDeserializer.java:478) ~[?:?]
at com.alibaba.ververica.connectors.common.source.deserializer.DefaultSourceDeserializer.deserialize(DefaultSourceDeserializer.java:355) ~[?:?]
at com.alibaba.ververica.connectors.metaq.source.reader.deserializer.MetaQRowDeserializer.deserialize(MetaQRowDeserializer.java:86) ~[?:?]
at com.alibaba.ververica.connectors.metaq.source.reader.MetaQRecordEmitter.emitRecord(MetaQRecordEmitter.java:55) ~[?:?]
at com.alibaba.ververica.connectors.metaq.source.reader.MetaQRecordEmitter.emitRecord(MetaQRecordEmitter.java:35) ~[?:?]
at org.apache.flink.connector.base.source.reader.SourceReaderBase.pollNext(SourceReaderBase.java:160) ~[flink-connector-files-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.streaming.api.operators.SourceOperator.emitNext(SourceOperator.java:419) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.streaming.runtime.io.StreamTaskSourceInput.emitNext(StreamTaskSourceInput.java:70) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.streaming.runtime.io.StreamOneInputProcessor.processInput(StreamOneInputProcessor.java:68) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.streaming.runtime.tasks.StreamTask.processInput(StreamTask.java:613) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.streaming.runtime.tasks.mailbox.MailboxProcessor.runMailboxLoop(MailboxProcessor.java:231) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.streaming.runtime.tasks.StreamTask.runMailboxLoop(StreamTask.java:1059) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.streaming.runtime.tasks.StreamTask.invoke(StreamTask.java:1008) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.runtime.taskmanager.Task.runWithSystemExitMonitoring(Task.java:959) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.runtime.taskmanager.Task.restoreAndInvoke(Task.java:938) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.runtime.taskmanager.Task.doRun(Task.java:751) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at org.apache.flink.runtime.taskmanager.Task.run(Task.java:567) ~[flink-dist-1.17-vvr-8.0.1-SNAPSHOT.jar:1.17-vvr-8.0.1-SNAPSHOT]
at java.lang.Thread.run(Thread.java:834) ~[?:1.8.0_102]
Caused by: java.sql.BatchUpdateException: Incorrect decimal value: '' for column 'Delta' at row 1
at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source) ~[?:?]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_102]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_102]
at com.mysql.cj.util.Util.handleNewInstance(Util.java:192) ~[?:?]
at com.mysql.cj.util.Util.getInstance(Util.java:167) ~[?:?]
at com.mysql.cj.util.Util.getInstance(Util.java:174) ~[?:?]
at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224) ~[?:?]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:755) ~[?:?]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:426) ~[?:?]
at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:800) ~[?:?]
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:565) ~[?:?]
at com.alibaba.ververica.connectors.rds.sink.RdsOutputFormat.executeSql(RdsOutputFormat.java:488) ~[?:?]
... 38 more
Caused by: java.sql.SQLException: Incorrect decimal value: '' for column 'Delta' at row 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[?:?]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[?:?]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[?:?]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098) ~[?:?]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046) ~[?:?]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371) ~[?:?]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:716) ~[?:?]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:426) ~[?:?]
at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:800) ~[?:?]
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:565) ~[?:?]
at com.alibaba.ververica.connectors.rds.sink.RdsOutputFormat.executeSql(RdsOutputFormat.java:488) ~[?:?]
... 38 more
15:04:17,266 [flink-akka.actor.default-dispatcher-30] INFO org.apache.flink.runtime.resourcemanager.slotmanager.FineGrainedSlotManager [] - Clearing resource requirements of job 3abbe65245914e9f9d56065901ad3035
