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

Update locks cannot be acquired during a READ UNCOMMITTED transaction with SELECT

    XMLWordPrintable

    Details

      Description

      After upgrading from 10.3.29 to 10.3.30 we started hitting "Update locks cannot be acquired during a READ UNCOMMITTED transaction" errors which did not occur in previous versions.

      Recreate test case DB with the attached test-case.sql and perform this query:

      SELECT * FROM polygonassets p WHERE ST_Contains(p.shape, (SELECT point FROM pointassets WHERE id = 0x000007158cce4a99950bb6589b31ab1b));
      

      This will result in:

      ERROR 1207 (25000): Update locks cannot be acquired during a READ UNCOMMITTED transaction
      

      Might be related to MDEV-26123?

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              richardh Richard H
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.