My Oracle Support Banner

Enable Sentry In BDA 4.5 or Higher Failed With Error "Failed to create Sentry database tables" (Doc ID 2211418.1)

Last updated on NOVEMBER 08, 2022

Applies to:

Big Data Appliance Integrated Software - Version 4.5.0 and later
Information in this document applies to any platform.

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. 

Try to enable sentry on BDA 4.5 using doc "How to Add or Remove Sentry on Oracle Big Data Appliance v4.2 or Higher with bdacli (Doc ID 2052733.1)” it failed with the following error:

ERROR: Puppet agent run on node bdanode01 had errors. List of errors follows
INFO: Also check the log file in /opt/oracle/BDAMammoth/bdaconfig/tmp/pagent-bdanode01-<TIMESTAMP>.log

From pagent-bdanode01-<TIMESTAMP>.log:

Nov 29 09:24:42 bdanode01 puppet-master[14095]: Compiled catalog for bdanode01.example.com in environment production in 0.67 seconds
Nov 29 09:26:36 bdanode01 puppet-master[14095]: (//bdanode01.example.com//Stage[main]/Hadoop::Enablesentry/File[enable_sentry]/ensure) created
Nov 29 09:26:36 bdanode01 puppet-master[14095]: (//bdanode01.example.com//Stage[main]/Hadoop::Enablesentry/File_with_backup[sentry_sql_53]/File[sentry_sql_53]/content) content changed '{md5}<MD51>' to '{md5}<MD52>'
Nov 29 09:26:36 bdanode01 puppet-master[14095]: (//bdanode01.example.com//Stage[main]/Hadoop::Enablesentry/File_with_backup[sentry_sql_53]/Exec[sentry_sql_53]/returns) executed successfully
Nov 29 09:26:36 bdanode01 puppet-master[14095]: (//bdanode01.example.com//Stage[main]/Hadoop::Enablesentry/File_with_backup[sentry_sql_52]/File[sentry_sql_52]/content) content changed '{md5}<MD51>' to '{md5}<MD52>'
Nov 29 09:26:36 bdanode01 puppet-master[14095]: (//bdanode01.example.com//Stage[main]/Hadoop::Enablesentry/File_with_backup[sentry_sql_52]/Exec[sentry_sql_52]/returns) executed successfully
Nov 29 09:26:36 bdanode01 puppet-master[14095]: (//bdanode01.example.com//Stage[main]/Hadoop::Enablesentry/Mysqldb[sentry]/Exec[create-sentry-db]/returns) executed successfully
Nov 29 09:26:36 bdanode01 puppet-master[14095]: (//bdanode01.example.com//Stage[main]/Hadoop::Enablesentry/Mysqldb[sentry]/Exec[create-sentry-db-user]/returns) executed successfully
Nov 29 09:26:36 bdanode01 puppet-master[14095]: (//bdanode01.example.com//Stage[main]/Hadoop::Enablesentry/File_with_backup[sentry_sql]/File[sentry_sql]/content) content changed '{md5}<MD51>' to '{md5}<MD52>'
Nov 29 09:26:36 bdanode01 puppet-master[14095]: (//bdanode01.example.com//Stage[main]/Hadoop::Enablesentry/File_with_backup[sentry_sql]/Exec[sentry_sql]/returns) executed successfully
Nov 29 09:26:36 bdanode01 puppet-master[14095]: (//bdanode01.example.com/Puppet) /opt/oracle/BDAMammoth/bdaconfig/tmp/enablesentry.sh &> /opt/oracle/BDAMammoth/bdaconfig/tmp/enablesentry_1480432306.out returned 1 instead of one of [0]
Nov 29 09:26:36 bdanode01 puppet-master[14095]: (//bdanode01.example.com//Stage[main]/Hadoop::Enablesentry/Exec[enable_sentry]/returns) change from notrun to 0 failed: /opt/oracle/BDAMammoth/bdaconfig/tmp/enablesentry.sh &> /opt/oracle/BDAMammoth/bdaconfig/tmp/enablesentry_1480432306.out returned 1 instead of one of [0]
Nov 29 09:26:36 bdanode01 puppet-master[14095]: (//bdanode01.example.com/Puppet) Finished catalog run in 114.25 seconds

From enablesentry_<EPOCH_TIMESTAMP>.out:

Succeeded. Output in : /opt/oracle/BDAMammoth/bdaconfig/tmp/cm_commands.out
API Version used is v12
Succeeded. Output in : /opt/oracle/BDAMammoth/bdaconfig/tmp/clusters_<CLUSTER_NAME>_services_<EPOCH_TIMESTAMP>.out
API Version used is v12
Succeeded. Output in : /opt/oracle/BDAMammoth/bdaconfig/tmp/clusters_<CLUSTER_NAME>_services_sentry_roles_<EPOCH_TIMESTAMP>.out
API Version used is v12
Succeeded. Output in : /opt/oracle/BDAMammoth/bdaconfig/tmp/clusters_<CLUSTER_NAME>_services_sentry_config_<EPOCH_TIMESTAMP>.out
API Version used is v12
Succeeded. Output in : /opt/oracle/BDAMammoth/bdaconfig/tmp/cm_commands_generateCredentials.out
Command ID is 7707

Command 7707 finished after 5 seconds
Operation completed successfully
API Version used is v12
Succeeded. Output in : /opt/oracle/BDAMammoth/bdaconfig/tmp/clusters_<CLUSTER_NAME>_services_sentry_commands_sentryCreateDatabaseTables.out
Command ID is 7709
..
Command 7709 finished after 15 seconds
Operation failed
Result Message is: "Failed to create Sentry database tables.",
API Version used is v12
Succeeded. Output in : /opt/oracle/BDAMammoth/bdaconfig/tmp/clusters_<CLUSTER_NAME>_services_sentry_commands_restart.out
Command ID is 7712
.....
Command 7712 finished after 30 seconds
Operation failed
Result Message is: "Failed to restart service.",



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


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