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

After upgrade 10.4 -> 10.5 some UPDATE queries getting stuck in "init for update" state

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 10.5.15, 10.5.16
    • Fix Version/s: 10.5
    • Component/s: Optimizer
    • Labels:
      None
    • Environment:
      RHEL 8.6

      Description

      After upgrade mariadb server from 10.4.25 to 10.5.16 similar UPDATE queries stuck in "init for update" state for 2-60 minutes, same queries was and are executed under 10.4.25 in milliseconds.

      SHOW FULL PROCESSLIST added to attachment, it was during replication but same happen when query is executed manually. And also SHOW CREATE TABLE\G added.

        Attachments

          Activity

            People

            Assignee:
            psergei Sergei Petrunia
            Reporter:
            lathander Jozef Kováč
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

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