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: Assigned Account 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".

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.