Bug #99975 Error_code: 1451; handler error HA_ERR_ROW_IS_REFERENCED, Error_code: MY-001451
Submitted: 24 Jun 2020 18:01 Modified: 26 Jul 2020 16:11
Reporter: Snehal Bhavsar Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Group Replication Severity:S3 (Non-critical)
Version: OS:CentOS
Assigned to: MySQL Verification Team CPU Architecture:Any

[24 Jun 2020 18:01] Snehal Bhavsar 
Description:
Hi I am facing this errror in Innodb Cluster on the daily basis. Slave nodes get missing from the cluster after facing this error

2020-06-24T12:40:29.786375Z 22 [ERROR] [MY-010584] [Repl] Slave SQL for channel 'group_replication_applier': Worker 8 failed executing transaction 'e295b724-53c8-11ea-80c8-fa163efa4b49:370937760'; Could not execute Delete_rows event on table XXXXXXXX.ZZZZZZZ; Cannot delete or update a parent row: a foreign key constraint fails (`XXXXXXXX`.`YYYYYYYYY`, CONSTRAINT `QRTZ_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `ZZZZZZZ` (`SCHED_NAME`, `TRIGGER_NAME`, `), Error_code: 1451; handler error HA_ERR_ROW_IS_REFERENCED, Error_code: MY-001451

How to repeat:
Run multiple DML operation in a sinlge trasaction.

Works fine on Master node but fails on slave in a cluster.
[26 Jun 2020 16:11] MySQL Verification Team 
Hi,

I cannot make a test case that is reproducing this behavior.

Please
 - provide config files for the nodes
 - provide set of steps to perform to reproduce problem (how to initialize data and what to execute afterwards)

kind regards
Bogdan
[27 Jul 2020 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".