Index BOA2VAI Not In Sync With ALF2VAI - Queueing Master Event To The Relay Log (Doc ID 2792703.1)

Last updated on OCTOBER 19, 2022

Applies to:

Symptoms

Index BOAXXX not in sync with ALFXXX".

Customer noticed that BOAXXX is with problems - the disk is becoming full with relay log files, since the database is not following the master correctly.
Customer have an error in the show slave printout.
They have tried to restart mysql service but they still seeing the error.

Can you please check and advise on the solution ASAP?

mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Queueing master event to the relay log
Master_Host: 10.X.XX.X
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: Primary1-mysql-bin.000XXX
Read_Master_Log_Pos: 772989464
Relay_Log_File: BOA2VAI-Index-relay-bin.000XXX
Relay_Log_Pos: 4043410
Relay_Master_Log_File: Primary1-mysql-bin.000XXX
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB: ipcr_db
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table: ipcr_db.log,ipcr_db.heartbeats
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1451
Last_Error: Could not execute Delete_rows event on table ipcr_db.recordings; Cannot delete or update a parent row: a foreign key constraint fails ('ipcr_db'.'sessions_recordings', CONSTRAINT 'fk_session_recording_recordings1' FOREIGN KEY ('recording_id') REFERENCES 'recordings' ('recording_id') ON DELETE NO ACTION ON UPDATE CASCADE), Error_code: 1451; handler error HA_ERR_ROW_IS_REFERENCED; the event's master log Primary1-mysql-bin.000246, end_log_pos 896551026
Skip_Counter: 0
Exec_Master_Log_Pos: 896550313
Relay_Log_Space: 37461496103
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0

Cause

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