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

MyISAM index corruption on 400M rows

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.5.11, 10.5.12
    • N/A
    • N/A
    • debian unstable

    Description

      Hi

      I have table corruption caught by check table.

      I narrowed my ~400M rows table to a single integer column. The error happens after index creation if you run check table.

      I managed to recreate it with a random set of 70K values distributed in 400M rows.

      See the attached script. It completes in 32' in my system (oldish xeon with NVM) and it fails
      with

      --------------
      CHECK TABLE bugtable
      --------------
       
      +---------------+-------+-------+------------------------------------------+
      | budb.bugtable | check | error | Key in wrong position at page 1023494144 |
      | budb.bugtable | check | error | Corrupt                                  |
      +---------------+-------+-------+------------------------------------------+
      2 rows in set (38.701 sec)
      
      

      The script is easily run with:

      time ./mysql-index-corruption-bug.sh bugdb bugtable;
      

      Attachments

        1. mariadb-groupby-fails-bug.sh
          2 kB
          Vassilis Virvilis
        2. mysql-index-corruption-bug.sh
          0.7 kB
          Vassilis Virvilis

        Issue Links

          Activity

            People

              Unassigned Unassigned
              vasvir Vassilis Virvilis
              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.