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

j9per5c4  于 2022-10-26  发布在  其他
关注(0)|答案(3)|浏览(244)

我用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 is com.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 is com.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]

DataX

3条答案

按热度按时间
4si2a6ki

4si2a6ki1#

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

赞(0）分享  回复(0）举报  2022-10-26
gt0wga4j

gt0wga4j2#

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

赞(0）分享  回复(0）举报  2022-10-26
ubof19bj

ubof19bj3#

**月如**评论 on 5 Feb 2021

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

赞(0）分享  回复(0）举报  2022-10-26
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备2022004421号-2 NULL123 https://www.null123.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com