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

              Assignee:
              jacob-mathew Jacob Mathew (Inactive)
              Reporter:
              mattiasjonsson Mattias Jonsson
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: