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

Spider system tables are MyISAM and needs repair after a crash

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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17068 mysql system table is marked as crashed and should be repaired after the server crashes or is killed

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16421 Make system tables crash safe

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            mattiasjonsson Mattias Jonsson created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Fix Version/s 10.3 [ 22126 ]
            Assignee Jacob Mathew [ jacob-mathew ]
            serg Sergei Golubchik made changes -
            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 |             		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?
            {noformat}
            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 |
            {noformat}
            jacob-mathew Jacob Mathew (Inactive) made changes -
            jacob-mathew Jacob Mathew (Inactive) made changes -
            Component/s Authentication and Privilege System [ 13101 ]
            jacob-mathew Jacob Mathew (Inactive) made changes -
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.3 [ 22126 ]
            jacob-mathew Jacob Mathew (Inactive) made changes -
            jacob-mathew Jacob Mathew (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            jacob-mathew Jacob Mathew (Inactive) made changes -
            Assignee Jacob Mathew [ jacob-mathew ] Kentoku [ kentoku ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            Kentoku Kentoku Shiba (Inactive) made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            Kentoku Kentoku Shiba (Inactive) made changes -
            Assignee Kentoku [ kentoku ] Jacob Mathew [ jacob-mathew ]
            jacob-mathew Jacob Mathew (Inactive) made changes -
            Fix Version/s 10.4.0 [ 23115 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 87391 ] MariaDB v4 [ 154406 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 177946

            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.