首页 > 解决方案 > Oozie + YARN:获取连接失败异常

问题描述

在我们的应用程序中,我们希望一次只运行一个 oozie 工作流。我们面临与第一个工作流中断连接的问题,并且由于第二个工作流开始。在 YARN 上,第一个工作流程仍在运行。

我们收到以下错误消息:

E0603 : E0603: SQL error in operation, The last packet successfully received from the server was 94,669,212 milliseconds ago.  The last packet sent successfully to the server was 94,669,212 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
        at org.apache.oozie.client.OozieClient.handleError(OozieClient.java:628)
        at org.apache.oozie.client.OozieClient$JobInfo.call(OozieClient.java:980)
        at org.apache.oozie.client.OozieClient$JobInfo.call(OozieClient.java:964)
        at org.apache.oozie.client.OozieClient$ClientCallable.call(OozieClient.java:576)
        at org.apache.oozie.client.OozieClient.getJobInfo(OozieClient.java:1055)
        at org.apache.oozie.client.OozieClient.getJobInfo(OozieClient.java:1033

)

不确定在哪里设置“wait_timeout”/“autoReconnect”属性。它是在 oozie 工作流 xml 中的每个操作级别设置的吗?

问候 Anuj Mehra

标签: hadoophadoop-yarnooziemapr

解决方案


根据 MapR 技术支持工程师 Prakhar Verma 的说法,您可以忽略代码中这些无害的异常。请重新编写您的java代码。


推荐阅读