My Oracle Support Banner

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

Last updated on NOVEMBER 08, 2022

Applies to:

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


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

ERROR: Error code 1 when executing on host <HOSTNAMEx> #Step -1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'sentry'@'<HOSTNAMEx>.<DOMAIN>' (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: <HOSTNAME_MYSQL_SLAVE>-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 shows that they are no longer available.

[<HOSTNAME_MYSQL_MASTER>].root:/var/lib/mysql > cat mysql-bin.index

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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.