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

stale .TMM file causes Aria engine to stop serving the table

Details

    Description

      I'm not sure on which operation the file was created (assuming mysqloptimize), but assume you have this temp file.
      You restart the server.
      You can repair this table by hand, everything looks fine. If you have a cron job that does a mysqloptimize -A at nighty, this operation fails, the table is marked as crashed. You get the message "... is marked as crashed and last (automatic?) repair failed" inside the log.

      No automatic repair will work. Doing a repair by hand, will work, but will not remove the temp file, as it is not removed by a full server restart.

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Elena Stepanova made transition -
            Open Confirmed
            4h 57m 1
            Michael Widenius made transition -
            Confirmed In Progress
            15h 58m 1
            Michael Widenius made transition -
            In Progress Closed
            9d 11h 3m 1
            Michael Widenius made transition -
            Closed Stalled
            14s 1
            Michael Widenius made transition -
            Stalled Closed
            3m 5s 1

            People

              monty Michael Widenius
              mokraemer Marc
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.