11:57:50 - 执行datax任务 - (stdout) com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'active_date' cannot be null
11:57:50 - 执行datax任务 - (stdout) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_151]
11:57:50 - 执行datax任务 - (stdout) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_151]
11:57:50 - 执行datax任务 - (stdout) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_151]
11:57:50 - 执行datax任务 - (stdout) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_151]
11:57:50 - 执行datax任务 - (stdout) at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.34.jar:5.1.34]
11:57:50 - 执行datax任务 - (stdout) at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.34.jar:5.1.34]
11:57:50 - 执行datax任务 - (stdout) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.34.jar:5.1.34]
11:57:50 - 执行datax任务 - (stdout) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.34.jar:5.1.34]
11:57:50 - 执行datax任务 - (stdout) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.34.jar:5.1.34]
11:57:50 - 执行datax任务 - (stdout) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.34.jar:5.1.34]
11:57:50 - 执行datax任务 - (stdout) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.34.jar:5.1.34]
11:57:50 - 执行datax任务 - (stdout) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.34.jar:5.1.34]
11:57:50 - 执行datax任务 - (stdout) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.34.jar:5.1.34]
11:57:50 - 执行datax任务 - (stdout) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.34.jar:5.1.34]
11:57:50 - 执行datax任务 - (stdout) at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doOneInsert(CommonRdbmsWriter.java:382) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
11:57:50 - 执行datax任务 - (stdout) at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:362) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
11:57:50 - 执行datax任务 - (stdout) at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:297) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
11:57:50 - 执行datax任务 - (stdout) at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
11:57:50 - 执行datax任务 - (stdout) at com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter$Task.startWrite(MysqlWriter.java:78) [mysqlwriter-0.0.1-SNAPSHOT.jar:na]
11:57:50 - 执行datax任务 - (stdout) at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) [datax-core-0.0.1-SNAPSHOT.jar:na]
11:57:50 - 执行datax任务 - (stdout) at java.lang.Thread.run(Thread.java:748) [na:1.8.0_151]
11:57:50 - 执行datax任务 - (stdout) 2021-01-07 11:57:50.430 [0-0-0-writer] ERROR StdoutPluginCollector - 脏数据:
2条答案
按热度按时间ffdz8vbo1#
vzgqcmou2#
这种场景下面研发写的代码中 插入是不包含此字段的 直接默认0000 这样通过查询语句此时包含此字段zeroDateTimeBehavior默认转为null 但是通过replace到该表会直接报错 非空约束