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

Last updated on JULY 18, 2016

Applies to:

Big Data Appliance Integrated Software - Version 4.2.0 and later
Linux x86-64

Symptoms

Mammoth upgrade fails on step 6 with:

************************************
Error [11884]: (//node2.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]: (//node2.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 | % | 3654423944aa3c49 |
+-----------+------+------------------+
1 row in set (0.00 sec)

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms