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

main.backup_stages occasionally fails with lock wait timeout

Details

    Description

      With MDEV-16678, InnoDB background tasks (most notably, the purge of committed transaction history) can acquire metadata locks. This seems to explain recent failures of the test main.backup_stages in 10.5:

      10.5 ce41a9075ad63e5388045943b80f69b7

      		 
      CURRENT_TEST: main.backup_stages
      		 
      mysqltest: At line 177: query 'ALTER TABLE t_permanent_innodb ADD COLUMN col3 INT' failed: 1205: Lock wait timeout exceeded; try restarting transaction

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-x86/builds/7887

      10.5 44be8652c567ccaa0067830fa327cbff

      		 
      CURRENT_TEST: main.backup_stages
      		 
      mysqltest: At line 145: query 'ALTER TABLE t_permanent_innodb ADD COLUMN col2 INT' failed: 1205: Lock wait timeout exceeded; try restarting transaction

      http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/3179

      I encountered the first failure (test line 177) locally.

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-16678 Use MDL for innodb background threads instead of dict_operation_lock

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-5336 Implement BACKUP STAGE for safe external backups

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-5336 Implement BACKUP STAGE for safe external backups

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            marko Marko Mäkelä created issue -
            marko Marko Mäkelä made changes -
            Field Original Value New Value
            marko Marko Mäkelä made changes -
            julien.fritsch Julien Fritsch made changes -
            Assignee Sergey Vojtovich [ svoj ] Marko Mäkelä [ marko ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Michael Widenius [ monty ]
            marko Marko Mäkelä made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2020-06-02 11:48:36.0 2020-06-02 11:48:36.527
            marko Marko Mäkelä made changes -
            Fix Version/s 10.5.4 [ 24264 ]
            Fix Version/s 10.5 [ 23123 ]
            Assignee Michael Widenius [ monty ] Marko Mäkelä [ marko ]
            Resolution Fixed [ 1 ]
            Status Confirmed [ 10101 ] Closed [ 6 ]
            monty Michael Widenius made changes -
            Assignee Marko Mäkelä [ marko ] Michael Widenius [ monty ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 103222 ] MariaDB v4 [ 157230 ]

            People

              monty Michael Widenius
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.