Hortonworks.com
  • Explore
    • All Tags
    • All Questions
    • All Articles
    • All Ideas
    • All Repos
    • All SKB
    • All Users
    • All Badges
    • Leaderboard
  • Create
    • Ask a question
    • Create Article
    • Post Idea
    • Add Repo
  • Tracks
    • All Tracks
    • Community Help
    • Cloud & Operations
    • CyberSecurity
    • Data Ingestion & Streaming
    • Data Processing
    • Data Science & Advanced Analytics
    • Design & Architecture
    • Governance & Lifecycle
    • Hadoop Core
    • Sandbox & Learning
    • Security
    • Solutions
  • Login
HCC Hortonworks Community Connection
  • Home /
  • Solutions /
  • Home /
  • Solutions /
avatar image

"ERROR exec.Task (TezTask.java:execute(226)) - Failed to execute tez graph" when executing Hive jobs with Tez

Nuruddin Ahmed created · Feb 01 at 04:31 PM
avatar image
0

SupportKB

Problem Description:
Hive job with Tez execution engine fails with the following error:
2018-08-14 15:55:27,581 ERROR exec.Task (TezTask.java:execute(226)) - Failed to execute tez graph. 
java.lang.InterruptedException 
at java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireInterruptibly(AbstractQueuedSynchronizer.java:1220) 
at java.util.concurrent.locks.ReentrantLock.lockInterruptibly(ReentrantLock.java:335) 
at java.util.concurrent.ArrayBlockingQueue.put(ArrayBlockingQueue.java:350) 
at org.apache.hadoop.hive.ql.exec.tez.TezSessionPoolManager.returnSession(TezSessionPoolManager.java:176)

Cause:
This issue occurs when a query is killed or cancelled. This interrupts with the background thread, which fails to put the session back to the pool. It is known issue related to  HIVE-15731 and HIVE-20415.
Solution:


Workaround Change the settings to:
hive.server2.tez.initialize.default.sessions=false

along with below:

hive.server2.idle.session.timeout=12h
hive.server2.idle.operation.timeout=8h
hive.server2.session.check.interval=4h
tez.session.am.dag.submit.timeout.secs=1200
Hold Containers to Reduce Latency=true
Number of Containers Held=


About:
This article created by Hortonworks Support (Article: 000007885) on 2019-02-01 08:09
OS: Linux
Type: Executing-Jobs
Version: 2-6-3
Support ID: 000007885
thub.nodes.view.add-new-comment
solutionhwsupportHive
Add comment
10 |6000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 5 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image

Related posts

ERROR:"SemanticException [Error 10072]: Database does not exist: XX Connection String: DSN=HIVE;UID=ABC" while connecting to Hive from Microstrategy through ODBC

ERROR: "Unable to determine if hdfs://x.x.x.x:8020/test/t_carpo is encrypted" when creating an Hive external table

ORC not returning correct results using the where clause with between or not between operators in Hive

Error: "java.lang.NullPointerException" when running a Hive query during Vector/MapJoin processing in LLAP

Unable to pass Tez queue name when connecting to HiveServer 2 from Have ODBC driver

"java.io.IOException: wrong key class: org.apache.hadoop.io.LongWritable is not class org.apache.hadoop.hive.ql.io.HiveKey" when generating HFiles using TotalOrderPartitioner

"ERROR client.ServiceClient: Error on destroy 'llap0': not found. WARN client.ServiceClient: Property yarn.service.framework.path has a value /bch/apps/3.0.0/yarn/service-dep.tar.gz, but is not a valid file" when starting LLAP with Yarn

LLAP queries are not working in a SSL enabled environment

ERROR:"SemanticException Error while configuring input job properties"when accessing HBase table from Hive after upgrading to Ambari 2.2.2.

How to add Java command line argument to specific Hive components through Ambari?

This website uses cookies for analytics, personalisation and advertising. To learn more or change your cookie settings, please read our Cookie Policy. By continuing to browse, you agree to our use of cookies.

HCC Guidelines | HCC FAQs | HCC Privacy Policy | Privacy Policy | Terms of Service

© 2011-2019 Hortonworks Inc. All Rights Reserved.

Hadoop, Falcon, Atlas, Sqoop, Flume, Kafka, Pig, Hive, HBase, Accumulo, Storm, Solr, Spark, Ranger, Knox, Ambari, ZooKeeper, Oozie and the Hadoop elephant logo are trademarks of the Apache Software Foundation.

  • Anonymous
  • Login
  • Create
  • Ask a question
  • Create Article
  • Post Idea
  • Add Repo
  • Create SupportKB
  • Tracks
  • Community Help
  • Cloud & Operations
  • CyberSecurity
  • Data Ingestion & Streaming
  • Data Processing
  • Data Science & Advanced Analytics
  • Design & Architecture
  • Governance & Lifecycle
  • Hadoop Core
  • Sandbox & Learning
  • Security
  • Solutions
  • Explore
  • All Tags
  • All Questions
  • All Articles
  • All Ideas
  • All Repos
  • All SKB
  • All Users
  • Leaderboard
  • All Badges