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

Infinite loop after LOCK+REPAIR

    XMLWordPrintable

Details

    • Bug
    • Status: In Testing (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • N/A
    • None
    • None
    • Q4/2025 Server Development

    Description

      An infinite loop happens in open_tables after REPAIR TABLE t under LOCK TABLES.

      CREATE TABLE t1(x int);
      CREATE GLOBAL TEMPORARY TABLE t (x INT);
      LOCK TABLES t WRITE, t1 WRITE;
      REPAIR TABLE t, t1;
      ANALYZE TABLE t;
      

      A table is marked flushed after repair, LOCK prevents eviction. Then, a table is denied to open flush, and backoff is issued – the retries happen in the infinite loop.

      Attachments

        Issue Links

          Activity

            People

              nikitamalyavin Nikita Malyavin
              nikitamalyavin Nikita Malyavin
              Nikita Malyavin Nikita Malyavin
              Michael Widenius Michael Widenius
              Roel Van de Paar Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.