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

myisamchk gets Errcode: 175 "File too short; Expected more data in file" as number of rows in MyISAM table increases, unless buffer sizes are reduced

    XMLWordPrintable

Details

    Description

      myisamchk fails with the following error:

      /bin/myisamchk: Unexpected end-of-file found when reading file '/STMWKoK5' (Errcode: 175 "File too short; Expected more data in file").
      

      when rowcount exceeds 2.124 billion and key_buffer_size and sort_buffer_size under [myisamchk] tag is set to 4GB.

      When these values are adjusted to 2GB, the command works.

      As the table has grown to ~3 billion rows, buffer sizes must be lowered to 1GB for the command to work.

      Attachments

        Activity

          People

            Unassigned Unassigned
            juan.vera Juan
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.