My Oracle Support Banner

Hive Metastore and Webhcat Test Failures During BDA Cluster Verifications (./mammoth -c) After Upgrade to V4.5. (Doc ID 2265111.1)

Last updated on FEBRUARY 14, 2020

Applies to:

Big Data Appliance Integrated Software - Version 4.5.0 and later
Linux x86-64

Symptoms

NOTE: In the examples that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner. 

On Oracle Big Data Appliance after upgrade to BDA V4.5 the Hive Metastore and Webhcat tests fail when running the cluster verifications with "./mammoth -c". 

The following errors are seen:

...

ERROR: Errors in Metastore test run
ERROR: Errors in Webhcat test run
INFO: Executing oracleUserDestroy.sh on nodes /opt/oracle/BDAMammoth/bdaconfig/tmp/all_nodes #Step -1#
SUCCESS: Executed oracleUserDestroy.sh on nodes /opt/oracle/BDAMammoth/bdaconfig/tmp/all_nodes #Step -1#
INFO: Executing remTestUsers.sh on nodes bdanode01 #Step -1#
SUCCESS: Executed remTestUsers.sh on nodes bdanode01 #Step -1#
SUCCESS: Successfully removed Kerberos test users.
SUCCESS: Ran /bin/cp -pr /opt/oracle/BDAMammoth/bdaconfig/tmp/* /opt/oracle/bda/install/log/clusterchk/summary-<timestamp> and it returned: RC=0
SUCCESS: Ran /bin/rm -rf /opt/oracle/BDAMammoth/bdaconfig/tmp/* and it returned: RC=0
SUCCESS: Ran /bin/cp -prf /tmp/bdacheckcluster* /opt/oracle/bda/install/log/clusterchk/summary-<timestamp> and it returned: RC=0
INFO: Install summary copied to /opt/oracle/bda/install/log/clusterchk/summary-<timestamp>
ERROR: Errors found in cluster validation checks
ERROR: Resolve the errors and then re-run mammoth with the -c option
INFO: Time spent in post-cleanup operations is 757 seconds.
==================================================================================
ERROR: Cluster checks failed!
ERROR: Resolve the errors and then re-run mammoth with the -c option

 

Additional failure output may look like below failing with "User oracle does not have privileges for CREATEDATABASE".

Webhcat Test output
------------------------------------------------------------------------------
TEST: create a hcatlog database directory
TEST: create a hcatlog database
{"error":"FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:User oracle does not have privileges for CREATEDATABASE)","errorDetail":"org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:User oracle does not have privileges for CREATEDATABASE) org.apache.hadoop.hive.ql.metadata.Hive.createDatabase(Hive.java:347)  ... com.sun.proxy.$Proxy5.createDatabase(Unknown Source)\norg.apache.hadoop.hive.ql.metadata.Hive.createDatabase(Hive.java:341) ... 19 more\n","errorCode":40000,"sqlState":"08S01","database":"webhcat_test_db_<EPOCH_TIMESTAMP>"}ERROR: Timed out running creating a hcatlog database. HTTP/1.1 500 Server Error
Please check details in webhcat_test.out

{"error":"FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:User oracle does not have privileges for CREATEDATABASE)","errorDetail":"org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:User oracle does not have privileges for CREATEDATABASE) ... ,"errorCode":40000,"sqlState":"08S01","database":"webhcat_test_db_<EPOCH_TIMESTAMP>"}ERROR: Timed out running creating a hcatlog database. HTTP/1.1 500 Server Error
Webhcat test failed

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
 Cluster with Network Encryption Disabled
 Cluster with Network Encryption Enabled

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.