2021-06-30  4:13:15 376165477 [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table  `schema`.`child_table`

2021_06_30_051001 [Note] Full-Backup Start

2021-06-30  5:12:03 0 [Note] WSREP: Member 0.0 (node1) desyncs itself from group

2021-06-30  5:12:03 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 738363159)

2021-06-30  5:12:03 376235117 [Note] WSREP: Provider paused at 991736fe-3886-11ea-9cdb-0bada3df9cd4:738363159 (362396096)

2021-06-30  5:12:04 376235117 [Note] WSREP: resuming provider at 362396096

2021-06-30  5:12:04 376235117 [Note] WSREP: Provider resumed.

2021-06-30  5:12:04 0 [Note] WSREP: Member 0.0 (node1) resyncs itself to group.

2021-06-30  5:12:04 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 738363159)

2021-06-30  5:12:04 0 [Note] WSREP: Member 0.0 (node1) synced with group.

2021-06-30  5:12:04 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 738363159)

2021-06-30  5:12:04 27 [Note] WSREP: Synchronized with group, ready for connections

CREATE TABLE `<table_name>` (

  `col1` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'ABC',

  `col2` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'XYZ',

  `col3` int(10) unsigned DEFAULT NULL COMMENT 'ABC_XYZ',

  PRIMARY KEY (`col1`,`col2`),

  KEY `col3` (`col3`),

  CONSTRAINT `key1` FOREIGN KEY (`col1`) REFERENCES `events` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `key2` FOREIGN KEY (`col3`) REFERENCES `events` (`id`) ON DELETE SET NULL ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC