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

MariaDB 10.1 fails to start datadir created with MariaDB 10.0/MySQL 5.6 using innodb-page-size!=16K

Details

    • 10.2.4-5, 10.1.21

    Description

      Error log will contain:

      InnoDB: Error: Current page size 8192 !=  page size on page 16384
      		 
      Error: JAN: pageno 8191 offset 3772
      		 
      2016-12-21 14:08:08 140182760941440 [ERROR] InnoDB: innodb-page-size mismatch in data file ./ibdata1

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15333 MariaDB (still) slow start

          • Major - Major loss of function.
          • Closed
          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9581 [PATCH] Innodb in Mariadb-10.1.x is unable to start up with data files generated by older version

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11202 InnoDB 10.1 -> 10.2 migration does not work

          • 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-11799 InnoDB can abort if the doublewrite buffer contains a bad and a good copy

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11816 Disallow CREATE TEMPORARY TABLE…ROW_FORMAT=COMPRESSED

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14169 MariaDB 10.0/10.1 fail to start with datadir created by MariaDB 5.5 using innodb-page-size != 16K

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18097 Indicate which InnoDB data files are zero-initialized

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-11596 Testing for live upgrade with compressed/encrypted InnoDB data and non-default innodb_page_size

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12530 MariaDB 10.1.22 has slower speed of starting then MariaDB 10.1.18 with innodb_flush_method=O_DIRECT

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13105 InnoDB fails to load a table with PAGE_COMPRESSION_LEVEL after upgrade from 10.1.20

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14076 InnoDB: Failing assertion when accessing INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES upon upgrade from 10.1.0 to 10.1.20

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            View 11 older comments
            marko Marko Mäkelä added a comment -

            In response to the failure https://gist.github.com/elenst/c0a11433d6146f21675f68f19021eb71
            I fixed two bugs in the doublewrite buffer code. Please review the latest commit in the bb-10.1-mdev-11623 branch.

            marko Marko Mäkelä added a comment - In response to the failure https://gist.github.com/elenst/c0a11433d6146f21675f68f19021eb71 I fixed two bugs in the doublewrite buffer code. Please review the latest commit in the bb-10.1-mdev-11623 branch.
            jplindst Jan Lindström (Inactive) added a comment -

            Ok to push.

            jplindst Jan Lindström (Inactive) added a comment - Ok to push.
            marko Marko Mäkelä added a comment -

            I filed MDEV-11799 for the non-flags-related fix of buf_dblwr_process().
            I think that we should fix that one separately already in 10.0, to make the InnoDB doublewrite buffer a more useful.

            marko Marko Mäkelä added a comment - I filed MDEV-11799 for the non-flags-related fix of buf_dblwr_process(). I think that we should fix that one separately already in 10.0, to make the InnoDB doublewrite buffer a more useful.
            marko Marko Mäkelä added a comment -

            The fix has been pushed to 10.1.21. I will keep this open until the fix is in 10.2 as well.

            marko Marko Mäkelä added a comment - The fix has been pushed to 10.1.21. I will keep this open until the fix is in 10.2 as well.
            marko Marko Mäkelä added a comment -

            The merge to 10.2 was challenging due to the refactoring of tablespace code and changes to tablespace discovery in crash recovery.

            marko Marko Mäkelä added a comment - The merge to 10.2 was challenging due to the refactoring of tablespace code and changes to tablespace discovery in crash recovery.

            People

              marko Marko Mäkelä
              jplindst Jan Lindström (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.