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

EITS: killing the server leaves statistical tables in "marked as crashed" state

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.9
    • 10.0.10
    • None

    Description

      If one does the following sequence of operations

      • make some action that updates statistical tables (e.g. ANALYZE TABLE ... PERSISTENT FOR ALL).
      • kill the server
      • start the server again

      then any action that attempts read from EITS tables will not be able to open the tables anymore. Opening the table will fail with "table marked as crashed" error.

      This task is about making EITS tables more resilient to the scenario.

      There are two things to be done:
      1. Flush statistical table to disk as soon as we've made any modification (similar to what is done to mysql.proc)
      2. Enable auto-repair for statistical tables, like it happens with regular myisam tables.

      Attachments

        Activity

          psergei Sergei Petrunia created issue -
          psergei Sergei Petrunia made changes -
          Field Original Value New Value
          Labels eits
          psergei Sergei Petrunia made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 36927 ] MariaDB v2 [ 43126 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 43126 ] MariaDB v3 [ 62182 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 62182 ] MariaDB v4 [ 147662 ]

          People

            psergei Sergei Petrunia
            psergei Sergei Petrunia
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.