BDA Node 3 Migration Fails at Step 9 InstallHadoop With MySQL "<host> is blocked because of many connection errors; unblock with 'mysqladmin flush-host" Failure (Doc ID 1982329.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

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

Symptoms

 
1. BDA Node 3 Migration (e.g. bdacli admin_cluster migrate bdanode03) fails at Step 9 InstallHadoop with:

Feb 18 16:05:40 bdanode01 puppet-master[19353]: (//bdanode04.example.com/Puppet) /usr/bin/mysql -h  bdanode04.example.com -uroot -p'<pw>' -e "UPDATE mysql.user SET Password=PASSWORD('*****R') WHERE User='scm' ; flush privileges" &> /opt/oracle/BDAMammoth/bdaconfig/tmp/chg_mysql_pwd.out returned 1 instead of one of [0]


Feb 18 16:05:40 bdanode01 puppet-master[19353]: (//bdanode04.example.com//Stage[main]/Hadoop::Installpkg2/Exec[chg_mysql_pwd]/returns) change from notrun to 0 failed: /usr/bin/mysql -h bdanode04.example.com -uroot -p'<pw>' -e
"UPDATE mysql.user SET Password=PASSWORD('*****R') WHERE User='scm' ; flush privileges" &> /opt/oracle/BDAMammoth/bdaconfig/tmp/chg_mysql_pwd.out returned 1 instead of one of [0]

...
Feb 18 16:05:40 bdanode01 puppet-master[19353]: (//bdanode04.example.com//Stage[main]/Hadoop::Installpkg2/Exec[enabletls_script])
Dependency Exec[chg_mysql_pwd] has failures: true

 

Checking the log file /opt/oracle/BDAMammoth/bdaconfig/tmp/chg_mysql_pwd.out shows:

ERROR 1129 (HY000): Host 'bdanode04.example.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

 

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