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

Preparation of incremental backup displays database corrupted

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Pending Release
    • 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.

        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