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

InnoDB redo log apply fails to adjust data file sizes

    XMLWordPrintable

Details

    • 10.2.4-5

    Description

      Prepare of partial backup (with --tables option) sporadically fails with following error :

      InnoDB: Error: tablespace size stored in header is 4864 pages, but
      InnoDB: the sum of data file sizes is only 768 pages
      InnoDB: Cannot start InnoDB. The tail of the system tablespace is
      InnoDB: missing.

      Attached are:
      test_partial_uncommitted.sh - test which reliably demonstrates the problem in my environment
      test_partial_uncommitted.log - corresponding log
      my.cnf - config used
      partial_uncommitted.test 'identical' mtr test, which DOES NOT demonstrate the problem (for unknown reasons (generated xtrabackup_info and backup-my.cnf are identical to .sh test).

      Interesting observation is that all tables are backed up - this should be another bug eventually if not fixed as part of this.

      Attachments

        1. test_partial_uncommitted.sh
          0.7 kB
        2. test_partial_uncommitted.log
          25 kB
        3. problem.tar.gz
          8.89 MB
        4. partial_uncommitted.test
          0.5 kB
        5. my.cnf
          0.3 kB

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12027 posix_fallocate returned OS error 201.

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12075 innodb_use_fallocate does not work in MariaDB Server 10.1.21

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22501 Various issues when using --innodb-data-file-size-debug=-1 | SIGABRT in fil_mutex_enter_and_prepare_for_io

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-11690 Remove UNIV_HOTBACKUP

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11915 Detect InnoDB system tablespace size mismatch early

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12022 InnoDB wrongly ignores the end of an .ibd file

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13822 Mariabackup --prepare --incremental sets file size incorrectly

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14082 Enforcing innodb_open_files leads to fil_system->mutex problem

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18194 Incremental prepare tries to access page which is out of tablespace bounds.

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30069 InnoDB: Trying to write ... bytes at ... outside the bounds of the file ...

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11968 With innodb_page_size=8K crash with 'Error 17' after "Tried to read 65536 bytes at offset 0. Was only able to read 49152."

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12893 innodb.log_data_file_size failed in buildbot with InnoDB: Database page corruption

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14447 mariabackup --incremental --prepare fails to extend last file when applying ibdata1.delta

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23190 Assertion `id.page_no() < space.size' during recovery

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26068 Server crashes when innodb-data-file-size-debug set to 1

          • Major - Major loss of function.
          • Closed

          Activity

            People

              marko Marko Mäkelä
              anikitin Andrii Nikitin (Inactive)
              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.