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

[ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index

    XMLWordPrintable

Details

    Description

      Hello.

      we are occasionally receiving error:

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

      What could be the cause for such error?
      Is there any way to trace this issue?

      Thanks for answer.

      Regards,
      Marko

      Attachments

        1. error.log
          7 kB
          Mark Ruys
        2. mysql.tar.gz
          4 kB
          Mark Ruys
        3. st_monitor_20190925_2208CEST.sql
          0.7 kB
          Mark Ruys

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26062 InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `schema`.`child_table`

          • Major - Major loss of function.
          • Closed

          Activity

            People

              jplindst Jan Lindström (Inactive)
              Sutic Marko Sutic
              Votes:
              2 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.