My Oracle Support Banner

Upgrade to BDA V4.4 Fails on Step 6 Installing BDA Software on the Cluster with "Mysql::Refreshmysqlpasswords/Refreshpassword[oozie_db]" (Doc ID 2116447.1)

Last updated on DECEMBER 26, 2019

Applies to:

Big Data Appliance Integrated Software - Version 4.2.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.

  

When upgrading to BDA V4.4, Step 6 of the upgrade fails with:

INFO: Step 6: Installing BDC Packages
...
INFO: Installing BDA software on cluster. This will take some time ...
...
ERROR: Puppet script either timed out or ended with error on one or more nodes
ERROR: Nodes that failed are: , bdanode02, bdanode03
INFO: Pinging puppet agents ..
INFO: Puppet agent run on node bdanode01 completed successfully.
INFO: Check the log file in /opt/oracle/BDAMammoth/bdaconfig/tmp/pagent-bda1node01-<timestamp>.log

ERROR: Puppet agent run on node bdanode02 had errors. List of errors follows

************************************
Error [12421]: (//bdanode02.example.com//Stage[pre]/Mysql::Refreshmysqlpasswords/Refreshpassword[oozie_db]/Exec[refresh-oozie_db-ms-password]/returns) change from notrun to 0 failed:
/usr/bin/mysql -uroot -p'<MYSQL_ROOT_PASSWORD>' -e " SET SESSION old_passwords=0; SET PASSWORD FOR 'oozie'@'localhost' = PASSWORD('<OOZIE_PASSWORD>');
Error [12421]: (//bdanode02.example.com//Stage[pre]/Mysql::Refreshmysqlpasswords/Refreshpassword[oozie_db] /Exec[refresh-oozie_db-ms-password]/returns) change from notrun to 0 failed: /usr/bin/mysql -uroot -p'<MYSQL_ROOT_PASSWORD>' -e " SET SESSION old_passwords=0; SET PASSWORD FOR 'oozie'@'localhost' = PASSWORD('<OOZIE_PASSWORD>');
************************************

...

ERROR: Puppet agent run on node bdanode03 had errors. List of errors follows

************************************
Error [12421]: (//bdanode03.example.com//Stage[pre]/Mysql::Refreshmysqlpasswords/Refreshpassword[oozie_db]/Exec[refresh-oozie_db-ms-password]/returns) change from notrun to 0 failed:
/usr/bin/mysql -uroot -p'<MYSQL_ROOT_PASSWORD>' -e " SET SESSION old_passwords=0; SET PASSWORD FOR 'oozie'@'localhost' = PASSWORD('<OOZIE_PASSWORD>');
Error [12421]: (//bdanode03.example.com//Stage[pre]/Mysql::Refreshmysqlpasswords/Refreshpassword[oozie_db]/Exec[refresh-oozie_db-ms-password]/returns) change from notrun to 0 failed: /usr/bin/mysql -uroot -p'<MYSQL_ROOT_PASSWORD>' -e " SET SESSION old_passwords=0; SET PASSWORD FOR 'oozie'@'localhost' = PASSWORD('<OOZIE_PASSWORD>');
************************************

 

Other symptoms show:

1. It is possible to log into MySQL with: mysql -uroot -p'<MYSQL_ROOT_PASSWORD>' and all the oozie@hosts/localhost have the same password as expected i.e. 

  

 

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.