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

InnoDB: Defragmentation of BASE_IDX in SYS_VIRTUAL failed: Data structure corruption

    XMLWordPrintable

Details

    • Related to performance
    • Q3/2026 Server Maintenance

    Description

      We have been running MariaDB 11.4.10 for some time against a several years old database. I noticed that even after enabling autoshrink, the `ibdata1` file which should be empty always remains at 12GB.

      After updating to 11.4.12, I see in the error log:
      ```
      InnoDB: Moving the data from extents 34304 through 786432
      InnoDB: Destination extent range: 320 through 640
      [ERROR] InnoDB: Defragmentation of BASE_IDX in SYS_VIRTUAL failed: Data structure corruption
      ```

      ```
      root@localhost [(none)]> SELECT * FROM information_schema.innodb_sys_virtual;
      Empty set (0.000 sec)
      ```

      Attachments

        1. mariadb.err
          3 kB
          Alex Strange
        2. my.cnf
          19 kB
          Alex Strange

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              astrange Alex Strange
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 1.95h Original Estimate - 1.95h
                  1.95h
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 7h 25m
                  7h 25m

                  Git Integration

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