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

InnoDB defragmentation periodically hangs when replicated

    XMLWordPrintable

Details

    Description

      Periodically, InnoDB defragmentation (innodb-defragment = 1) hangs on the slave in a replicated setup.

      It seems to happen only when parallel replication is enabled (specifically slave_parallel_threads = 4 and slave_parallel_mode = 'optimistic').

      When the hang occurs, one of the slave workers executing the OPTIMIZE TABLE) statement remains in state "Waiting for table metadata lock" seemingly forever.

      Stopping the slave does not appear to work, although manually killing the other slave workers does result in the STOP SLAVE statement to eventually succeed.

      Attachments

        1. my_a.cnf
          2 kB
        2. my_b.cnf
          2 kB

        Activity

          People

            mleich Matthias Leich
            crishoj Christian Rishøj
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.