Uploaded image for project: 'Percona XtraBackup'
  1. Percona XtraBackup
  2. PXB-450

LP #1527081: xtrabackup 2.3 does not respect innodb_log_file_size stored in backup-my.cnf

    XMLWordPrintable

    Details

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

      Description

      **Reported in Launchpad by Sergei Glushchenko last update 10-03-2016 19:03:41

      Test case:

      ###

      MYSQLD_EXTRA_MY_CNF_OPTS="
      innodb-log-files-in-group=4
      innodb-log-file-size=2M
      "

      start_server

      xtrabackup --backup --target-dir=$topdir/backup

      cat $topdir/backup/backup-my.cnf

      ${XB_BIN} --prepare --target-dir=$topdir/backup

      stop_server

      rm -rf ${mysql_datadir}

      xtrabackup --move-back --target-dir=$topdir/backup

      start_server

      cat ${MYSQLD_ERRFILE}

      ###

      backup-my.cnf:

      ###

      [mysqld]
      innodb_checksum_algorithm=innodb
      innodb_log_checksum_algorithm=innodb
      innodb_data_file_path=ibdata1:12M:autoextend
      innodb_log_files_in_group=4
      innodb_log_file_size=2097152
      innodb_fast_checksum=false
      innodb_page_size=16384
      innodb_log_block_size=512
      innodb_undo_directory=.
      innodb_undo_tablespaces=0

      ###

      From prepare log:

      xtrabackup: using the following InnoDB configuration for recovery:
      xtrabackup: innodb_data_home_dir = ./
      xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
      xtrabackup: innodb_log_group_home_dir = ./
      xtrabackup: innodb_log_files_in_group = 2
      xtrabackup: innodb_log_file_size = 50331648

      ...

      InnoDB: Setting log file ./ib_logfile101 size to 48 MB
      InnoDB: Setting log file ./ib_logfile1 size to 48 MB
      InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
      InnoDB: New log files created, LSN=1626007

      ###

      From server startup log:

      ###

      2015-12-17 13:43:57 52535 [Warning] InnoDB: Resizing redo log from 2*3072 to 4*128 pages, LSN=1626134
      2015-12-17 13:43:57 52535 [Warning] InnoDB: Starting to delete and rewrite log files.
      2015-12-17 13:43:57 52535 [Note] InnoDB: Setting log file ./ib_logfile101 size to 2 MB
      2015-12-17 13:43:57 52535 [Note] InnoDB: Setting log file ./ib_logfile1 size to 2 MB
      2015-12-17 13:43:57 52535 [Note] InnoDB: Setting log file ./ib_logfile2 size to 2 MB
      2015-12-17 13:43:57 52535 [Note] InnoDB: Setting log file ./ib_logfile3 size to 2 MB
      2015-12-17 13:43:57 52535 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
      2015-12-17 13:43:57 52535 [Warning] InnoDB: New log files created, LSN=1626134

      ###

        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: