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

Spider system tables are MyISAM and needs repair after a crash

    XMLWordPrintable

Details

    Description

      If a crash occurs during the use of a spider table, the system tables for spiders needs to be repaired.

      Maybe the system tables for spider should be crash safe?

      show warnings;
      +-------+-------+------------------------------------------------------------------------------+
      | Level | Code  | Message                                                                      |
      +-------+-------+------------------------------------------------------------------------------+
      | Error |   145 | Table './mysql/spider_tables' is marked as crashed and should be repaired    |
      | Error |  1034 | 1 client is using or hasn't closed the table properly                        |
      | Error |   145 | Table './mysql/spider_table_sts' is marked as crashed and should be repaired |
      | Error |  1034 | 1 client is using or hasn't closed the table properly                        |
      | Error |   145 | Table './mysql/spider_table_crd' is marked as crashed and should be repaired |
      

      Attachments

        Issue Links

          Activity

            People

              jacob-mathew Jacob Mathew (Inactive)
              mattiasjonsson Mattias Jonsson
              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.