Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-360

LP #1179974: INFORMATION_SCHEMA.INNODB_CHANGED_PAGES query fails server with an I/O error if a bitmap file in the middle of requested range is missing

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Laurynas Biveinis last update 19-09-2013 10:46:47

      If a INNODB_CHANGED_PAGES query needs a bitmap file range with one of the files missing in the middle of the range, then the server will stop with an I/O error on a debug build, probably on a release build as well.

      To reproduce, add the following to the end of innodb_changed_pages.test, before the final DROP TABLE t1:

      let $MYSQLD_DATADIR= `select @@datadir`;

      1. --replace_regex /_[[:digit:]]+\.xdb$//
        list_files $MYSQLD_DATADIR ib_modified_log*;

      remove_files_wildcard $MYSQLD_DATADIR ib_modified_log_4_*.xdb;

      1. --replace_regex /_[[:digit:]]+\.xdb$//
        list_files $MYSQLD_DATADIR ib_modified_log*;

      SELECT COUNT FROM INFORMATION_SCHEMA.INNODB_CHANGED_PAGES
      WHERE START_LSN > 10000;

      Discovered while working on XtraBackup, as the bitmap file reader is shared between XtraDB and XtraBackup. The fix will be to take the XtraBackup reader robustness improvements.

      Triaging as Medium instead of High, because impossible to reproduce without write access to the server data dir.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: