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

innochecksum mistakes a file for an encrypted one (page 0 invalid)

    XMLWordPrintable

Details

    • 10.1.22, 10.2.6-2, 10.2.6-3

    Description

      innochecksum returns an error message when ran on ibdata1 on a server that is working fine (a check on all tables has been done without finding anything) :

      # innochecksum -d /var/lib/mysql/ibdata1 
      InnoDB offline file checksum utility.
       
      Variables (--variable-name=value)
      and boolean options {FALSE|TRUE}  Value (after reading options)
      --------------------------------- ----------------------------------------
      verbose                           TRUE
      debug                             TRUE
      skip-corrupt                      FALSE
      count                             FALSE
      start-page                        0
      end-page                          0
      page                              0
      per-page-details                  FALSE
      leaf                              FALSE
      merge                             0
      Table is uncompressed
      Page size is 16384
      file /var/lib/mysql/ibdata1 = 3844079616 bytes (234624 pages)...
      InnoChecksum; checking pages in range 0 to 234623
      Page 0 encrypted key_version 5 checksum 1135705172
      page 0: log sequence number: first = 1136557346; second = 1136557346
      page 0: old style: calculated = 2609070081; recorded = 2609070081
      page 0: new style: calculated = 3631443077; crc32 = 286255075; recorded = 1135705172
      Fail; page 0 invalid (fails innodb and crc32 checksum)
      

      This server was previously running on 10.0 and was just upgraded to 10.1 and it is not using tablespace encryption.

      Attachments

        Issue Links

          Activity

            People

              jplindst Jan Lindström (Inactive)
              jb-boin Jean Weisbuch
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.