alibaba / DataX

DataX是阿里云DataWorks数据集成的开源版本。
Other
15.98k stars 5.45k forks source link

使用datax进行同步一个千万级别的表数据时候 数据同步失败 报这个错, #940

Open liwenhaode opened 3 years ago

liwenhaode commented 3 years ago

我用datax同步mysql数据库(mysql8.0.22)的表,中途中断,报这个错,是数据库连接超时,需要如何修改呢###

021-01-10 13:06:28.381 [job-0] INFO StandAloneJobContainerCommunicator - Total 10772992 records, 1957602363 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 1,425.826s | All Task WaitReaderTime 43.637s | Percentage 0.00% 2021-01-10 13:06:42 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:06:42.572 [job-0] INFO StandAloneJobContainerCommunicator - Total 10772992 records, 1957602363 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 1,425.826s | All Task WaitReaderTime 43.637s | Percentage 0.00% 2021-01-10 13:06:59 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:06:59.567 [job-0] INFO StandAloneJobContainerCommunicator - Total 10772992 records, 1957602363 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 1,425.826s | All Task WaitReaderTime 43.637s | Percentage 0.00% 2021-01-10 13:07:24 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:07:19.274 [job-0] INFO StandAloneJobContainerCommunicator - Total 10772992 records, 1957602363 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 1,425.826s | All Task WaitReaderTime 43.637s | Percentage 0.00% 2021-01-10 13:08:15 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:14.961 [job-0] INFO StandAloneJobContainerCommunicator - Total 10772992 records, 1957602363 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 1,425.826s | All Task WaitReaderTime 43.637s | Percentage 0.00% 2021-01-10 13:08:15 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:15.974 [0-0-0-writer] WARN CommonRdbmsWriter$Task - 回滚此次写入, 采用每次写入一行方式提交. 因为:No operations allowed after statement closed. 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:16.001 [0-0-0-writer] ERROR WriterRunner - Writer Runner Received Exceptions: 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-05], Description:[往您配置的写入表中写入数据时失败.]. - java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed. 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:73) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1875) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:361) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:291) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter$Task.startWrite(MysqlWriter.java:78) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.ConnectionIsClosedException: No operations allowed after connection closed. 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.checkClosed(NativeSession.java:1274) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:575) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1829) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 more 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] The last packet successfully received from the server was 382,695 milliseconds ago. The last packet sent successfully to the server was 382,789 milliseconds ago. 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1168) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:932) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1094) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1042) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1345) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:718) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:428) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:357) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 more 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] ... 17 more 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] - java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed. 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:73) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1875) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:361) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:291) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter$Task.startWrite(MysqlWriter.java:78) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.ConnectionIsClosedException: No operations allowed after connection closed. 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.checkClosed(NativeSession.java:1274) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:575) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1829) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 more 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] The last packet successfully received from the server was 382,695 milliseconds ago. The last packet sent successfully to the server was 382,789 milliseconds ago. 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1168) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:932) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1094) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1042) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1345) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:718) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:428) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:357) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 more 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556) 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] ... 17 more 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:40) ~[datax-common-0.0.1-SNAPSHOT.jar:na] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:302) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] 2021-01-10 13:08:16 [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] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter$Task.startWrite(MysqlWriter.java:78) ~[mysqlwriter-0.0.1-SNAPSHOT.jar:na] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) ~[datax-core-0.0.1-SNAPSHOT.jar:na] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_242] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed. 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:73) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1875) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:361) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:291) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] ... 4 common frames omitted 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.ConnectionIsClosedException: No operations allowed after connection closed. 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_242] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_242] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_242] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_242] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.checkClosed(NativeSession.java:1274) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:575) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1829) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 common frames omitted 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] The last packet successfully received from the server was 382,695 milliseconds ago. The last packet sent successfully to the server was 382,789 milliseconds ago. 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_242] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_242] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_242] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_242] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1168) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:932) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1094) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1042) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1345) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:718) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:428) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:357) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 common frames omitted 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556) ~[mysql-connector-java-8.0.16.jar:8.0.16] 2021-01-10 13:08:16 [AnalysisStatistics.analysisStatisticsLog-53] ... 17 common frames omitted 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25.166 [job-0] INFO StandAloneJobContainerCommunicator - Total 10772992 records, 1957602363 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 1,425.826s | All Task WaitReaderTime 43.637s | Percentage 0.00% 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25.166 [job-0] ERROR JobContainer - 运行scheduler 模式[standalone]出错. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25.169 [job-0] ERROR JobContainer - Exception when job run 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-05], Description:[往您配置的写入表中写入数据时失败.]. - java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:73) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1875) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:361) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:291) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter$Task.startWrite(MysqlWriter.java:78) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.ConnectionIsClosedException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.checkClosed(NativeSession.java:1274) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:575) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1829) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] The last packet successfully received from the server was 382,695 milliseconds ago. The last packet sent successfully to the server was 382,789 milliseconds ago. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1168) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:932) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1094) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1042) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1345) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:718) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:428) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:357) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 17 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] - java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:73) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1875) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:361) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:291) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter$Task.startWrite(MysqlWriter.java:78) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.ConnectionIsClosedException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.checkClosed(NativeSession.java:1274) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:575) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1829) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] The last packet successfully received from the server was 382,695 milliseconds ago. The last packet sent successfully to the server was 382,789 milliseconds ago. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1168) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:932) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1094) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1042) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1345) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:718) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:428) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:357) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 17 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:40) ~[datax-common-0.0.1-SNAPSHOT.jar:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:302) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter$Task.startWrite(MysqlWriter.java:78) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) ~[datax-core-0.0.1-SNAPSHOT.jar:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_242] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:73) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1875) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:361) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:291) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 4 common frames omitted 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.ConnectionIsClosedException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_242] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_242] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_242] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_242] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.checkClosed(NativeSession.java:1274) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:575) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1829) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 common frames omitted 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] The last packet successfully received from the server was 382,695 milliseconds ago. The last packet sent successfully to the server was 382,789 milliseconds ago. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_242] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_242] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_242] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_242] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1168) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:932) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1094) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1042) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1345) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:718) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:428) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:357) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 common frames omitted 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556) ~[na:na] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 17 common frames omitted 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25.170 [job-0] INFO StandAloneJobContainerCommunicator - Total 10772992 records, 1957602363 bytes | Speed 1.82GB/s, 10772992 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 1,425.826s | All Task WaitReaderTime 43.637s | Percentage 0.00% 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25.173 [job-0] ERROR Engine - 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 经DataX智能分析,该任务最可能的错误原因是: 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-05], Description:[往您配置的写入表中写入数据时失败.]. - java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:73) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1875) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:361) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:291) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter$Task.startWrite(MysqlWriter.java:78) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.ConnectionIsClosedException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.checkClosed(NativeSession.java:1274) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:575) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1829) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] The last packet successfully received from the server was 382,695 milliseconds ago. The last packet sent successfully to the server was 382,789 milliseconds ago. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1168) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:932) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1094) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1042) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1345) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:718) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:428) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:357) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 17 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] - java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:73) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1875) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:361) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:291) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter$Task.startWrite(MysqlWriter.java:78) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.ConnectionIsClosedException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.checkClosed(NativeSession.java:1274) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:575) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1829) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] The last packet successfully received from the server was 382,695 milliseconds ago. The last packet sent successfully to the server was 382,789 milliseconds ago. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1168) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:932) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1094) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1042) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1345) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:718) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:428) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:357) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 17 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:40) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:302) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter$Task.startWrite(MysqlWriter.java:78) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:73) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1875) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:361) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:291) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 4 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.ConnectionIsClosedException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.checkClosed(NativeSession.java:1274) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:575) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1829) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] The last packet successfully received from the server was 382,695 milliseconds ago. The last packet sent successfully to the server was 382,789 milliseconds ago. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1168) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:932) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1094) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1042) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1345) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:718) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:428) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:357) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 17 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Exception in thread "taskGroup-0" com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-05], Description:[往您配置的写入表中写入数据时失败.]. - java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:73) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1875) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:361) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:291) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter$Task.startWrite(MysqlWriter.java:78) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.ConnectionIsClosedException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.checkClosed(NativeSession.java:1274) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:575) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1829) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] The last packet successfully received from the server was 382,695 milliseconds ago. The last packet sent successfully to the server was 382,789 milliseconds ago. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1168) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:932) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1094) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1042) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1345) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:718) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:428) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:357) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 17 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] - java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:73) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1875) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:361) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:291) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter$Task.startWrite(MysqlWriter.java:78) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.ConnectionIsClosedException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.checkClosed(NativeSession.java:1274) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:575) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1829) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] The last packet successfully received from the server was 382,695 milliseconds ago. The last packet sent successfully to the server was 382,789 milliseconds ago. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1168) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:932) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1094) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1042) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1345) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:718) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:428) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:357) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 17 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:40) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:302) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWrite(CommonRdbmsWriter.java:319) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.writer.mysqlwriter.MysqlWriter$Task.startWrite(MysqlWriter.java:78) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:56) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.Thread.run(Thread.java:748) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:73) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1875) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:361) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:291) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 4 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.ConnectionIsClosedException: No operations allowed after connection closed. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.checkClosed(NativeSession.java:1274) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:575) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1829) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 6 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] The last packet successfully received from the server was 382,695 milliseconds ago. The last packet sent successfully to the server was 382,789 milliseconds ago. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1168) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:932) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1094) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1042) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1345) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:718) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:428) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:357) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 5 more 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556) 2021-01-10 13:08:25 [AnalysisStatistics.analysisStatisticsLog-53] ... 17 more 2021-01-10 13:08:25 [JobThread.run-165]
----------- datax-web job execute end(finish) -----------
----------- ReturnT:ReturnT [code=500, msg=command exit value(1) is failed, content=null] 2021-01-10 13:08:28 [TriggerCallbackThread.callbackLog-186]
----------- datax-web job callback fail, callbackResult:ReturnT [code=500, msg=xxl-rpc remoting error(Read timed out), for url : http://127.0.0.1:9527/api/callback, content=null] 2021-01-10 13:08:49 [TriggerCallbackThread.callbackLog-186]
----------- datax-web job callback fail, callbackResult:ReturnT [code=500, msg=xxl-rpc remoting error(Read timed out), for url : http://127.0.0.1:9527/api/callback, content=null] 2021-01-10 13:09:22 [TriggerCallbackThread.callbackLog-186]
----------- datax-web job callback fail, callbackResult:ReturnT [code=500, msg=xxl-rpc remoting error(Read timed out), for url : http://127.0.0.1:9527/api/callback, content=null] 2021-01-10 13:09:55 [TriggerCallbackThread.callbackLog-186]
----------- datax-web job callback fail, callbackResult:ReturnT [code=500, msg=xxl-rpc remoting error(Read timed out), for url : http://127.0.0.1:9527/api/callback, content=null]

jiangleifree commented 3 years ago

我也遇到了 从oracle导出1.3亿数据,Task一直等待,jvm分了1g内存,是因为内存不够了吗

yueru commented 3 years ago

可以在JSON里面设置会话级别参数,调大maxStatementTime和wait_timeout来保证任务执行。 具体可以参考plugin-rdbms-util中CommonRdbmsReader的代码,里面有关于任务session方面的设置。

dzygoon commented 2 years ago

月如 评论 on 5 Feb 2021

能麻烦提供个配置示例吗?十分感谢。或者发送我邮箱dzygoon@163.com