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 laterLinux x86-64
Symptoms
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 |