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

Preparation of incremental backup displays database corrupted

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 8.0-2-alpha2
    • Fix Version/s: 8.0-2-alpha2
    • Component/s: None
    • Labels:
      None
    • Environment:

      CentOS7.5

      Description

      1. Start PS8.0.12 server

      /home/mchawla/PS240918-percona-server-8.0.12-1-linux-x86_64-debug/bin/mysqld --no-defaults --core-file --basedir=/home/mchawla/PS240918-percona-server-8.0.12-1-linux-x86_64-debug --tmpdir=/home/mchawla/PS240918-percona-server-8.0.12-1-linux-x86_64-debug/data --datadir=/home/mchawla/PS240918-percona-server-8.0.12-1-linux-x86_64-debug/data --plugin-load-add=tokudb=ha_tokudb.so --tokudb-check-jemalloc=0 --plugin-load-add=rocksdb=ha_rocksdb.so --socket=/home/mchawla/PS240918-percona-server-8.0.12-1-linux-x86_64-debug/socket.sock --port=15267 --log-error=/home/mchawla/PS240918-percona-server-8.0.12-1-linux-x86_64-debug/log/master.err --server-id=100 --innodb_buffer_pool_size=2G --innodb_log_file_size=2G --innodb_page_size=16K --log-bin=mysql-bin --log-slave-updates --server-id=1 --gtid-mode=ON --enforce-gtid-consistency --binlog-format=row
      

       

      2. Create database and add data in it

      create database sysbench_test_db;
      
      sysbench /usr/share/sysbench/oltp_insert.lua --table-size=1000 --tables=35 --mysql-db=sysbench_test_db --mysql-user=root  --threads=100 --db-driver=mysql --mysql-socket=/home/mchawla/PS240918-percona-server-8.0.12-1-linux-x86_64-debug/socket.sock prepare
      
      create table sysbench_test_db.t1(c varchar(255)) data directory='/home/mchawla/test_mode/PS240918-percona-server-8.0.12-1-linux-x86_64-debug';
      
      insert into sysbench_test_db.t1 select c from sysbench_test_db.sbtest1;
      
      flush tables;
      

       

      3. Take full backup

      /home/mchawla/test_mode/target/percona-xtrabackup-8.0.1-debug/bin/xtrabackup --defaults-file= --user=root --password='' --target-dir=/home/mchawla/dbbackup_PS8/full --backup --socket=/home/mchawla/PS240918-percona-server-8.0.12-1-linux-x86_64-debug/socket.sock --slave-info --no-version-check --core-file --ftwrl-wait-timeout=0 --ftwrl-wait-query-type=all --ftwrl-wait-threshold=1 --kill-long-queries-timeout=1 --kill-wait-query-type=all --kill-long-query-type=all --no-backup-locks --parallel=10 --throttle=40 --check-privileges

       

      4. Take incremental backup

      /home/mchawla/test_mode/target/percona-xtrabackup-8.0.1-debug/bin/xtrabackup --defaults-file= --user=root --password='' --target-dir=/home/mchawla/dbbackup_PS8/inc --incremental-basedir=/home/mchawla/dbbackup_PS8/full --backup --socket=/home/mchawla/PS240918-percona-server-8.0.12-1-linux-x86_64-debug/socket.sock --slave-info --no-version-check --core-file --ftwrl-wait-timeout=0 --ftwrl-wait-query-type=all --ftwrl-wait-threshold=1 --kill-long-queries-timeout=1 --kill-wait-query-type=all --kill-long-query-type=all --no-backup-locks --parallel=10 --throttle=40 --check-privileges

       

      5. Prepare full backup

      /home/mchawla/test_mode/target/percona-xtrabackup-8.0.1-debug/bin/xtrabackup --prepare --apply-log-only --target-dir=/home/mchawla/dbbackup_PS8/full --slave-info --no-version-check --core-file --ftwrl-wait-timeout=0 --ftwrl-wait-query-type=all --ftwrl-wait-threshold=1 --kill-long-queries-timeout=1 --kill-wait-query-type=all --kill-long-query-type=all --no-backup-locks --parallel=10 --throttle=40 --check-privileges

       

      6. Prepare incremental backup

      /home/mchawla/test_mode/target/percona-xtrabackup-8.0.1-debug/bin/xtrabackup --prepare --target-dir=/home/mchawla/dbbackup_PS8/full --incremental-dir=/home/mchawla/dbbackup_PS8/inc --slave-info --no-version-check --core-file --ftwrl-wait-timeout=0 --ftwrl-wait-query-type=all --ftwrl-wait-threshold=1 --kill-long-queries-timeout=1 --kill-wait-query-type=all --kill-long-query-type=all --no-backup-locks --parallel=10 --throttle=40 --check-privileges

       

      Issue: The following message is displayed in logs:

      InnoDB: We scanned the log up to 30885969. A checkpoint was at 30886412 and the maximum LSN on a database page was 140088501836912. It is possible that the database is now corrupt!
      

       

      Contents of xtrabackup_checkpoints file in increment dir:

      backup_type = incremental
      from_lsn = 30885969
      to_lsn = 30885969
      last_lsn = 30885969

       

      Attached prepare log for incremental backup.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                sergei.glushchenko Sergei Glushchenko
                Reporter:
                manish.chawla Manish Chawla
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day, 3 hours
                  1d 3h