My Oracle Support Banner

BDA Upgrade to 4.5.0 from 4.2.0 Fails At Step 6 - Mysql::Refreshmysqlpasswords (Doc ID 2143096.1)

Last updated on JANUARY 13, 2020

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. 

Mammoth upgrade fails on step 6 with:

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

************************************
...
ERROR: Step 6 failed
ERROR: Cannot continue with operation
INFO: Time spent in step 6 InstallBDASoftware is 6697 seconds.
INFO: Running bdadiagcluster...

Checking in the pagent-bdanode03-<timestamp>.log shows:

May 24 16:34:20 bdanode01 puppet-master[31354]: (//bdanode03.example.com//Stage[main]/Mysql::Refreshmysqlpasswords/Refreshpassword[nmeta_db]/Exec[refresh-nmeta_db-ms-password]/returns) SET PASSWORD FOR 'navigator'@'bdanode01.example.com' = PASSWORD('<PASSWORD>'); SET PASSWORD FOR 'navigator'@'bdanode02.example.com' = PASSWORD('<PASSWORD>'); SET PASSWORD FOR 'navigator'@'bdanode03.example.com' = PASSWORD('<PASSWORD>'); SET PASSWORD FOR
'navigator'@'bdanode04.example.com' = PASSWORD('<PASSWORD>'); SET PASSWORD FOR
'navigator'@'bdanode05.example.com' = PASSWORD('<PASSWORD>'); SET PASSWORD FOR
'navigator'@'bdanode06.example.com' = PASSWORD('<PASSWORD>');
May 24 16:34:20 bdanode01 puppet-master[31354]: (//bdanode03.example.com//Stage[main]/Mysql::Refreshmysqlpasswords/Refreshpassword[nmeta_db]/Exec[refresh-nmeta_db-ms-password]/returns) FLUSH PRIVILEGES ; "

May 24 16:34:20 bdanode01 puppet-master[31354]: (//bdanode03.example.com//Stage[main]/Mysql::Refreshmysqlpasswords/Refreshpassword[naud_db]/Exec[refresh-naud_db-ms-password]/returns) ERROR 1133 (42000) at line 1: Can't find any matching row in the user table
May 24 16:34:20 bdanode01 puppet-master[31354]: (//bdanode03.example.com/Puppet) /usr/bin/mysql -uroot -p'<PASSWORD>' -e " SET SESSION old_passwords=0; SET PASSWORD FOR 'navms'@'localhost' = PASSWORD('<PASSWORD>');
May 24 16:34:20 bdanode01 puppet-master[31354]: (//bdanode03.example.com/Puppet) SET PASSWORD FOR 'navms'@'bdanode01.example.com' = PASSWORD('<PASSWORD>'); SET PASSWORD FOR 'navms'@'bdanode02.example.com' = PASSWORD('<password>'); SET PASSWORD FOR 'navms'@'bdanode03.example.com' = PASSWORD('<password>'); SET PASSWORD FOR 'navms'@'bdanode04.example.com' = PASSWORD('<PASSWORD>'); SET PASSWORD FOR 'navms'@'bdanode05.example.com' = PASSWORD('<PASSWORD>'); SET PASSWORD FOR 'navms'@'bdanode06.example.com' = PASSWORD('<PASSWORD>');
May 24 16:34:20 bdanode01 puppet-master[31354]: (//bdanode03.example.com/Puppet) FLUSH PRIVILEGES ; "

 

Checking in mysql shows that the navigator and navms databases are present:

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| BDA_ODI_REPO |
| BDA_STB |
| activity_monitor |
| hive |
| host_monitor |
| hue |
| mysql |
| navigator |
| navms |
| oozie |
| performance_schema |
| reports_manager |
| resource_manager |
| scm |
| sentry |
| service_monitor |
| sqoop |
+--------------------+

Checking for users and password shows only a navigator user:

mysql> SELECT user, host, password FROM mysql.user WHERE user='navigator';
+-----------+------+------------------+
| user | host | password |
+-----------+------+------------------+
| navigator | % | <NAVIGATOR_PASSWORD> |
+-----------+------+------------------+
1 row in set (0.00 sec)

Note: With MySQL 5.7 and higher use "authentication_string" instead of Password as the Password column is removed. MySQL 5.7 came in BDA 4.8 so for any version higher use the following instead:

mysql> SELECT user, host, authentication_string FROM mysql.user WHERE user='navigator';

 

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.