JaySenSharma created AMBARI-25362: ------------------------------------- Summary: Hive View throws TimeoutException deadline passed for few queries randomly. Key: AMBARI-25362 URL: https://issues.apache.org/jira/browse/AMBARI-25362 Project: Ambari Issue Type: Bug Components: ambari-views Affects Versions: 2.6.2 Reporter: JaySenSharma
Running some hive queries throws "deadline passed" error as following inside amber logs. {code} 25 Jul 2019 13:07:53,134 ERROR [ambari-client-thread-591197] [HIVE 2.0.0 AUTO_HIVE20_INSTANCE] ServiceFormattedException:97 - deadline passed 25 Jul 2019 13:07:53,135 ERROR [ambari-client-thread-591197] [HIVE 2.0.0 AUTO_HIVE20_INSTANCE] ServiceFormattedException:98 - java.util.concurrent.TimeoutException: deadline passed java.util.concurrent.TimeoutException: deadline passed at akka.actor.dsl.Inbox$InboxActor$$anonfun$receive$1.applyOrElse(Inbox.scala:117) at scala.PartialFunction$AndThen.applyOrElse(PartialFunction.scala:189) at akka.actor.Actor$class.aroundReceive(Actor.scala:467) at akka.actor.dsl.Inbox$InboxActor.aroundReceive(Inbox.scala:62) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516) at akka.actor.ActorCell.invoke(ActorCell.scala:487) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238) at akka.dispatch.Mailbox.run(Mailbox.scala:220) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:397) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) {code} Increasing the following timeouts inside "/etc/ambari-server/conf/ambari.properties" followed by ambari server restart does not help either. {code} views.ambari.hive.AUTO_HIVE20_INSTANCE.connection.inactivity.timeout=7200000 views.ambari.hive.AUTO_HIVE20_INSTANCE.result.fetch.timeout=7200000 views.ambari.request.connect.timeout.millis=7200000 views.ambari.request.read.timeout.millis=7200000 views.request.connect.timeout.millis=7200000 views.request.read.timeout.millis=7200000 {code} Additionally setting the following property in HiveView20 and the executing the query still causes the same failure. {code} set hive.fetch.task.conversion=none {code} "TimeoutException: deadline passed" still occurs much prior to the timeout defined. -- This message was sent by Atlassian JIRA (v7.6.14#76016)