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

LP:884715 - Aria spontaneous corruption

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • None
    • None
    • None

    Description

      We've duplicate an Aria table to some servers by copying the files directly. A mysqlcheck confirms that the table is good, aria_chk also sees no issues. After a restart of MariaDB all is fine with the table as well. Now we checked again the next day, and suddenly a check indicates the table is corrupted. This happened twice now (on the same server).

      :~/$ mysqlcheck -v database table
      database.table
      warning  : Table is marked as crashed
      error    : Wrong base information on indexpage at page: 34022
      error    : Corrupt
      :~/$ 

      The actual count of rows using {{select count(*)} did not change. However, after executing a repair table many rows disappeared. Nothing is writing to this table (only reads in very low volume), so it's really strange that this spontaneously corrupts without any restarts/writing to the table.

      I'll upload the original non-crashed version, and the crashed-version to FTP.

      Attachments

        Activity

          People

            Unassigned Unassigned
            dreasvandonselaar Dreas van Donselaar (Inactive)
            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.