DataWorks数据同步错误,在开发空间跑正常,上生产报错,这是日志 MYSQL --》 ODPS ,Communications link failure The last packet successfully received from the server was 30,024 milliseconds ago. The last packet sent successfully to the server was 30,023 milliseconds ago. - com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 30,024 milliseconds ago. The last packet sent successfully to the server was 30,023 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3562) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3462) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3903) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2482) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2440) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381) at com.alibaba.datax.plugin.rdbms.util.DBUtil.query(DBUtil.java:1023) at com.alibaba.datax.plugin.rdbms.util.DBUtil.query(DBUtil.java:1009) at com.alibaba.datax.plugin.rdbms.util.DBUtil.query(DBUtil.java:961) at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.doReadOneSplitSlice(CommonRdbmsReader.java:605) at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.doStartRead(CommonRdbmsReader.java:486) at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:684) at com.alibaba.datax.plugin.reader.mysqlreader.MysqlReader$Task.startRead(MysqlReader.java:122) at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:116) at java.lang.Thread.run(Thread.java:853) Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:101) at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:144) at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:174) at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3011) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3472) ... 16 more 2023-06-13 10:40:30.711 [836941214-0-0-reader] WARN CommonRdbmsReader$Task - enableSelfAdaptionSplit: false selfAdaptionSplitWriterPlugin: null selfAdaptionSplitErrorMessage: null !!! needReSplit: false?联通性没问题,
现在mysql数据源 开发/生产 数据集成资源组测试联通性是通过的吗,此回答整理自钉群“DataWorks交流群(答疑@机器人)”
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
DataWorks基于MaxCompute/Hologres/EMR/CDP等大数据引擎,为数据仓库/数据湖/湖仓一体等解决方案提供统一的全链路大数据开发治理平台。