Hi Knime team,
While executing the two hive loader parallely, we are getting the following error,
ERROR Hive Loader 2:45 Execute failed: org.apache.thrift.TApplicationException: ExecuteStatement failed: out of sequence response
We are configured the Database timeout for operations is 900s.
some time getting the following error as well for the same scenario.
ERROR Hive Loader 3:166 Execute failed: GetTables failed: out of sequence response
ERROR Hive Loader 3:57 Execute failed: org.apache.thrift.TApplicationException: ExecuteStatement failed: out of sequence response
ERROR Hive Loader 3:162 Execute failed: Read a negative frame size (-2147418110)!
how to avoid or fix the above error, while executing two or more hive loaders parallely in the workflow?
or Are we missed any configuration for running more than one hive loader scenario?
Is KNIME supports multiple hive loader execution?
Kindly provide the suggestion for this and let me know if you need more information regarding this.
Thanks in advance.
please, find the below knime.log for the Execute failed: org.apache.thrift.TApplicationException: ExecuteStatement failed: out of sequence response.
2015-11-17 12:58:47,537 : DEBUG : KNIME-Worker-99 : Hive Loader : Hive Loader : 2:45 : reset
2015-11-17 12:58:47,537 : ERROR : KNIME-Worker-99 : Hive Loader : Hive Loader : 2:45 : Execute failed: org.apache.thrift.TApplicationException: ExecuteStatement failed: out of sequence response
2015-11-17 12:58:47,538 : DEBUG : KNIME-Worker-99 : Hive Loader : Hive Loader : 2:45 : Execute failed: org.apache.thrift.TApplicationException: ExecuteStatement failed: out of sequence response
java.sql.SQLException: org.apache.thrift.TApplicationException: ExecuteStatement failed: out of sequence response
at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:215)
at org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:333)
at org.knime.core.node.port.database.DatabaseReaderConnection.getDataTableSpec(DatabaseReaderConnection.java:225)
at com.knime.bigdata.hive.node.loader.HiveLoaderNodeModel.execute(HiveLoaderNodeModel.java:199)
at org.knime.core.node.NodeModel.executeModel(NodeModel.java:563)
at org.knime.core.node.Node.invokeFullyNodeModelExecute(Node.java:1136)
at org.knime.core.node.Node.execute(Node.java:932)
at org.knime.core.node.workflow.NativeNodeContainer.performExecuteNode(NativeNodeContainer.java:554)
at org.knime.core.node.exec.LocalNodeExecutionJob.mainExecute(LocalNodeExecutionJob.java:95)
at org.knime.core.node.workflow.NodeExecutionJob.internalRun(NodeExecutionJob.java:179)
at org.knime.core.node.workflow.NodeExecutionJob.run(NodeExecutionJob.java:110)
at org.knime.core.util.ThreadUtils$RunnableWithContextImpl.runWithContext(ThreadUtils.java:328)
at org.knime.core.util.ThreadUtils$RunnableWithContext.run(ThreadUtils.java:204)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at org.knime.core.util.ThreadPool$MyFuture.run(ThreadPool.java:123)
at org.knime.core.util.ThreadPool$Worker.run(ThreadPool.java:246)
Caused by: org.apache.thrift.TApplicationException: ExecuteStatement failed: out of sequence response
at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:76)
at org.apache.hive.service.cli.thrift.TCLIService$Client.recv_ExecuteStatement(TCLIService.java:229)
at org.apache.hive.service.cli.thrift.TCLIService$Client.ExecuteStatement(TCLIService.java:216)
at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:209)
... 16 more
2015-11-17 12:58:47,538 : DEBUG : KNIME-Worker-99 : WorkflowManager : Hive Loader : 2:45 : Hive Loader 2:45 doBeforePostExecution
2015-11-17 12:58:47,538 : DEBUG : KNIME-Worker-99 : NodeContainer : Hive Loader : 2:45 : Hive Loader 2:45 has new state: POSTEXECUTE
2015-11-17 12:58:47,539 : DEBUG : KNIME-Worker-99 : WorkflowManager : Hive Loader : 2:45 : Hive Loader 2:45 doAfterExecute - failure
2015-11-17 12:58:47,539 : DEBUG : KNIME-Worker-99 : Hive Loader : Hive Loader : 2:45 : reset
2015-11-17 12:58:47,539 : DEBUG : KNIME-Worker-99 : Hive Loader : Hive Loader : 2:45 : clean output ports.
Thanks & Regards,
velu