question Re: Ambari TimeoutException in Archives of Support Questions (Read Only)

Ambari TimeoutException

praveen_atmakur — Mon, 16 Apr 2018 15:31:02 GMT

Apache Ambari Version2.6.0.0

While executing the hive query with limit 5 also.

Giving the error shown below:

{"trace":"java.util.concurrent.TimeoutException: deadline passed\n\njava.util.concurrent.TimeoutException: deadline passed\n\tat akka.actor.dsl.Inbox$InboxActor$$anonfun$receive$1.applyOrElse(Inbox.scala:117)\n\tat scala.PartialFunction$AndThen.applyOrElse(PartialFunction.scala:189)\n\tat akka.actor.Actor$class.aroundReceive(Actor.scala:467)\n\tat akka.actor.dsl.Inbox$InboxActor.aroundReceive(Inbox.scala:62)\n\tat akka.actor.ActorCell.receiveMessage(ActorCell.scala:516)\n\tat akka.actor.ActorCell.invoke(ActorCell.scala:487)\n\tat akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238)\n\tat akka.dispatch.Mailbox.run(Mailbox.scala:220)\n\tat akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:397)\n\tat scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)\n\tat scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)\n\tat scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)\n\tat scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)\n","message":"Result fetch timed out","status":500}

For this I have increased the time in

following properties in "/etc/ambari-server/conf/ambari.properties"

views.request.read.timeout.millis=450000

Still facing the same error

Re: Ambari TimeoutException

jsensharma — Mon, 16 Apr 2018 15:35:00 GMT

@Praveen Atmakuri

Can you try setting the following properties in "/etc/ambari-server/conf/ambari.properties" as described in the following link to see if it works: https://community.hortonworks.com/articles/90768/how-to-fix-ambari-hive-view-15-result-fetch-timed.html

From Ambari 2.4 this new parameter is added that can be used to define the Hive Instance specific settings.

views.ambari.hive.<HIVE_VIEW_INSTANCE_NAME>.result.fetch.timeout=450000

Example:

views.ambari.hive.AUTO_HIVE_INSTANCE.result.fetch.timeout=450000

Here above is the most important ambari.properties for the Hive View 1.5/2.0. Here please replace the "<HIVE_VIEW_INSTANCE_NAME>" with your View Instance name.

Then restart the ambari server.

Re: Ambari TimeoutException

praveen_atmakur — Mon, 16 Apr 2018 18:24:22 GMT

Awesome!!! Its working...thanks @Jay Kumar SenSharma

Re: Ambari TimeoutException

jsensharma — Mon, 16 Apr 2018 18:32:18 GMT

@Praveen Atmakuri

If this resolved your query/issue then please mark this HCC thread as answered by clicking on "Accept" link on the correct answer, That way it will help other HCC users to quickly find the answers.