Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-26062

InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `schema`.`child_table`

    XMLWordPrintable

    Details

      Description

      Occasionally receiving error:

       
      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
      
      

      Table Definition :-

       
      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
      
      

      Configuration wise , all looks normal except added transaction_isolation is REPEATABLE-READ

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              pramod.mahto@mariadb.com Pramod Mahto
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration