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 laterInformation in this document applies to any platform.
Symptoms
On Oracle Big Data Appliance , enabling hdfs_encrypted_data_transport fails with below error
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
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.
./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
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 |
| References |