error while installing 2nd instance of HiveMetastore using ambari

[#1]

"File "/usr/lib/ambari-agent/lib/resource_management/core/shell.py", line 303, in _call raise ExecutionFailed(err_msg, code, out, err) resource_management.core.exceptions.ExecutionFailed: Execution of 'export HIVE_CONF_DIR=/usr/hdp/current/hive-metastore/conf/conf.server ; /usr/hdp/current/hive-server2-hive2/bin/schematool -initSchema -dbType mysql -userName hive -passWord [PROTECTED] -verbose' returned 1. Your account has expired; please contact your system administrator"

[#2 · Accepted solution]

@Alampally Vinith

1. Can you please run the following command on the following host to see if by any chance the "hive" user account is locked?

# chage -l hive

Example Output:

# chage -l hive
Last password change                    : Jun 21, 2019
Password expires                        : never
Password inactive                       : never
Account expires                         : never
Minimum number of days between password change        : 0
Maximum number of days between password change        : 99999
Number of days of warning before password expires     : 7

2. Are you able to switch to that user?

# su - hive

Just in case of if you see the account is locked due to inactivity then Increase number of days of inactivity after a password has expired before the account is locked by setting INACTIVE option. Passing the number -1 as the INACTIVE option will remove the account’s inactivity so user can go through password change process anywhere in the future.

# chage -I 30  hive

Please read more about this INACTIVE=-1 will disable this feature meaning user can change the password anytime after password expires. And then according to your requirement you can set the user inactivity.

If you are running Hive Metastore with some other user then in the above commands use that user name instead of "hive"

Please check on that host what is the default INACTIVITY set to? Please share the output of the below command as well.

# cat /etc/default/useradd

Example:

# cat /etc/default/useradd 
# useradd defaults file
GROUP=100
HOME=/home
INACTIVE=-1
EXPIRE=
SHELL=/bin/bash
SKEL=/etc/skel
CREATE_MAIL_SPOOL=yes

.

[#3]

Permission Denied when I tried to run those commands

[#4]

The above question and the entire replky thread below was originally posted in the Community Help track. On Thu Jul 4 19:25 UTC 2019, a member of the HCC moderation staff moved it to the Data Processing track. The Community Help Track is intended for questions about using the HCC site itself, not technical questions about Hive or Ambari.