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

[ERROR] InnoDB: Unlock row could not find a 2 mode lock on the record

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
    • 10.5.12, 10.6.4
    • Optimizer
    • None

    Description

      This is MariaDB's variant of https://bugs.mysql.com/bug.php?id=76803 .

      If there is an outer join with a constant inner table, a locking-read statement (UPDATE or SELECT... FOR UPDATE) will produce these kind of warnings in the error log:

      [ERROR] InnoDB: Unlock row could not find a 3 mode lock on the record. Current
      		 
      statement: SELECT * FROM t1 LEFT JOIN t2 ON t1.c2=t2.c2 AND t2.c1=1 FOR UPDATE

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            psergei Sergei Petrunia
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.