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

Instant ALTER TABLE is not crash-safe

    XMLWordPrintable

Details

    Description

      I'm using the official MariaDB mariadb:10.4.6-bionic image and I have a problem: my tables corrupt themselves. This had happened at least four times this month:

      • on two different dev machines using docker-compose
      • on the staging machine using docker swarm

      Everytime the symptom is that a table exists in the information schema but it can't be read or altered at all. Any operation leads to a 'Table does not exists in engine' error.

      The container logs contain this error at startup:

      [ERROR] InnoDB: Table sfdb.specialist contains unrecognizable instant ALTER metadata

      I've checked the server system variables with

      SHOW VARIABLES;

      And alter_algorithm has the value DEFAULT which means (if I understand the documentation correctly) that it should not use the INSTANT algorithm, only INPLACE and COPY.
      https://mariadb.com/kb/en/library/server-system-variables/#alter_algorithm

      Trying to dig into the MariaDB codebase led me to this check:
      https://github.com/MariaDB/server/blob/cccfa9dcfe2c161779824c01a84edfa64fc4378a/storage/innobase/btr/btr0cur.cc#L465

      But I do not have enough knowledge of the inner workings of MariaDB to understand what is going on.

      What am I doing wrong? Should I set some flag or configuration to have a stable database in docker?

      PS: if this JIRA is not the correct place to ask this can you point me to a more suitable place to post my question ?

      Attachments

        1. MDEV-20198.yy
          0.7 kB
          Matthias Leich
        2. REPLAY_SIMP.sh
          11 kB
          Matthias Leich
        3. simp_MDEV-20198.cfg
          43 kB
          Matthias Leich

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              nreynisama Nicolas Reynis (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              10 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.