My Oracle Support Banner

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 NOVEMBER 20, 2019

Applies to:

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

 
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'<MYSQL_ROOT_PASSSWORD>' -e "UPDATE mysql.user SET Password=PASSWORD('<PASSWORD>') 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'<MYSQL_ROOT_PASSWORD>' -e
"UPDATE mysql.user SET Password=PASSWORD('<PASSWORD>') 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

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.