On Oracle Big Data Appliance CDH Cluster Enabling/Disabling a Service Fails (Doc ID 2108507.1)

Last updated on APRIL 01, 2017

Applies to:

Big Data Appliance Integrated Software - Version 4.1.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Big Data Appliance , enabling hdfs_encrypted_data_transport fails with below error

ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bda01node13 #Step -1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'sentry'@'bda01node13.example.com' (using password: YES) #Step -1#

And further investigation shows the error occurs since sentry DB is missing from Slave MySQL DB on node02 of the Cluster.

On Slave MySQL DB on node02 MySQL, 'SHOW SLAVE STATUS\G' reveals below error

Master_Log_File: mysql-bin.000006
  Read_Master_Log_Pos: 94792635
  Relay_Log_File: bda01node14-relay-bin.000014
  Relay_Log_Pos: 4
  Relay_Master_Log_File: mysql-bin.000006
.........
Last_IO_Errno: 1236
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file' 


Also checking if the binary log file in question and the next still exists on the MySQL Master state that they are no longer available

[BDANode03].root:/var/lib/mysql > cat mysql-bin.index
./mysql-bin.000010
./mysql-bin.000011
./mysql-bin.000012
./mysql-bin.000013
./mysql-bin.000014
./mysql-bin.000015
./mysql-bin.000016

MySQL Slave is trying to read mysql-bin.000006 and on master can only find mysql-bin.000010 and onwards. So 4 mysql-bin files are no longer available on Master that need to be replicated to the Slave.

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