开发者社区 > 大数据与机器学习 > 大数据开发治理DataWorks > 正文

DataWorks 一直在等待 gateway 资源怎么办?

DataWorks 一直在等待 gateway 资源怎么办?image.png
oad driver class: com.mysql.cj.jdbc.Driver

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:172)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:862)
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:444)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:230)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:226)
at java.sql.DriverManager.getConnection(DriverManager.java:674)
at java.sql.DriverManager.getConnection(DriverManager.java:256)
at com.alibaba.dw.alisa.wrapper.util.ConnectionManager.getJDBCConnection(ConnectionManager.java:30)
at com.alibaba.dw.alisa.wrapper.JdbcWrapper.executeJdbcSql(JdbcWrapper.java:99)
at com.alibaba.dw.alisa.wrapper.JdbcWrapper.submitJob(JdbcWrapper.java:43)
at com.alibaba.dataworks.dwalisa.DwalisaWrapperMain.main(DwalisaWrapperMain.java:265)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
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.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:59)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:103)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:149)
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:165)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:92)
at com.mysql.cj.NativeSession.connect(NativeSession.java:152)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:982)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:852)
... 9 more
Caused by: java.net.SocketTimeoutException: connect timed out
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:639)
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:173)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:66)
... 12 more
sql execute failed! Communications link failure

展开
收起
夹心789 2024-06-11 22:24:12 30 0
2 条回答
写回答
取消 提交回答
  • 点「带参运行」选择的是独享调度资源组还是公共调度资源组 可以看下对应资源组水位是不是满了,点「带参运行」选择测通的独享调度资源组 ,此回答整理自钉群“DataWorks交流群(答疑@机器人)”

    2024-06-12 12:20:08
    赞同 展开评论 打赏
  • 为什么任务一直在等待gateway调度资源?
    问题现象
    任务日志中显示等待gateway调度资源。

    产生原因
    当前资源组里的任务并发数达到上限。

    解决措施
    需要等待运行中的任务执行完成释放资源,或者对独享调度资源组进行扩容。您可以通过以下方式查看资源信息。

    image.png

    参考文档https://help.aliyun.com/zh/dataworks/support/nodes-that-are-waiting-for-resources?spm=a2c4g.11186623.0.i48

    2024-06-12 09:17:49
    赞同 展开评论 打赏

DataWorks基于MaxCompute/Hologres/EMR/CDP等大数据引擎,为数据仓库/数据湖/湖仓一体等解决方案提供统一的全链路大数据开发治理平台。

相关产品

  • 大数据开发治理平台 DataWorks
  • 热门讨论

    热门文章

    相关电子书

    更多
    DataWorks高效数据分析最佳实践-2020飞天大数据平台实战应用第一季 立即下载
    DataWorks数据集成实时同步最佳实践(含内测邀请)-2020飞天大数据平台实战应用第一季 立即下载
    DataWorks调度任务迁移最佳实践-2020飞天大数据平台实战应用第一季 立即下载

    相关实验场景

    更多