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

DEADLOCK when running ALTER TABLE truncate partition + SELECT when using galera

    XMLWordPrintable

Details

    Description

      When running concurrent SELECT and ALTER TABLE .. truncate partition with galera enabled one randomly gets a deadlock error. This does not happen when on runs the same test without galera.
      To verify this, install the attached test case in galera/t and run it in a loop.
      It will eventually die with

      mysqltest: At line 401: query 'reap' failed: ER_LOCK_DEADLOCK (1213): Deadlock found
      when trying to get lock; try restarting transaction.

      Attachments

        Activity

          People

            seppo Seppo Jaakola
            monty Michael Widenius
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.