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

Mariabackup copied too old page or too new checkpoint

    XMLWordPrintable

Details

    Description

      extra/mariabackup/mariabackup --host=127.0.0.1 --user=root --password=''  --innodb-use-native-aio=0  --port=24704 --prepare --target-dir=/dev/shm/vardir/1585648469/6/1_clone/data
      fails with
      ...
      2020-03-31  9:56:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7111846
      2020-03-31  9:56:36 0 [Note] InnoDB: Starting final batch to recover 363 pages from redo log.
      2020-03-31  9:56:36 0 [ERROR] InnoDB: Not applying INSERT_REUSE_DYNAMIC due to corruption on [page id: space=6, page number=677]
      2020-03-31  9:56:36 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
      2020-03-31  9:56:36 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1574] with error Data structure corruption
       
      Workflow
      1. Create DB server and start it
      2. One session starts to run some SQL stream (DML and DDL) against this server
      3. Concurrent to the ongoing 2. 
           extra/mariabackup/mariabackup --host=127.0.0.1 --user=root --password=''  --innodb-use-native-aio=0  --port=24700 --backup --datadir=/dev/shm/vardir/1585648469/6/1/data --target-dir=/dev/shm/vardir/1585648469/6/1_clone/data
            gets executed.
      4. Also concurrent to 2. but not touching the server started in 1. some
           extra/mariabackup/mariabackup --host=127.0.0.1 --user=root --password=''  --innodb-use-native-aio=0  --port=24700 --prepare  --target-dir=/dev/shm/vardir/1585648469/6/1_clone/data
           gets executed
       
      The uploaded RQG protocol 000022.log shows exact that RQG run.
       
      RQG
      git clone https://github.com/mleich1/rqg --branch experimental RQG_mleich1
      origin/experimental d417497b476e263428422b4640cf63b8e9d16afe 2020-03-30T17:17:54+02:00
       
      MariaDB
      origin/10.5 718f18599a9bcf1e7c2d3f18416fca4f7124d00d 2020-03-26T16:05:25+02:00
      build with debug
       
      cd <top directory of tree with RQG>
      perl rqg.pl \
      --duration=300 \
      --queries=10000000 \
      --threads=1 \
      --no_mask \
      --seed=random \
      --gendata=conf/mariadb/table_stress.zz \
      --gendata_sql=conf/mariadb/table_stress.sql \
      --rpl_mode=none \
      --engine=InnoDB \
      --mysqld=--log_bin_trust_function_creators=1 \
      --mysqld=--lock-wait-timeout=86400 \
      --mysqld=--loose-idle_write_transaction_timeout=0 \
      --mysqld=--interactive_timeout=28800 \
      --mysqld=--innodb-lock-wait-timeout=50 \
      --mysqld=--loose-debug_assert_on_not_freed_memory=0 \
      --mysqld=--slave_net_timeout=60 \
      --mysqld=--wait_timeout=28800 \ 
      --mysqld=--loose_innodb_use_native_aio=1 \
      --mysqld=--loose-table_lock_wait_timeout=50 \
      --mysqld=--net_write_timeout=60 \
      --mysqld=--log-bin \
      --mysqld=--innodb_stats_persistent=off \
      --mysqld=--log-output=none \
      --mysqld=--loose-idle_readonly_transaction_timeout=0 \
      --mysqld=--innodb_page_size=4K \
      --mysqld=--connect_timeout=60 \ 
      --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs \
      --mysqld=--net_read_timeout=30 \
      --mysqld=--loose-idle_transaction_timeout=0 \
      --reporters=Deadlock1,ErrorLog,Mariabackup,None,ServerDead \
      --validators=None \
      --grammar=c00000.yy \
      --workdir=/home/mleich/RQG_mleich/storage/1585648469/6 \
      --vardir=/dev/shm/vardir/1585648469/6 \
      --mtr-build-thread=735 \
      --basedir1=<path tp the 10.5 binaries> \
      --script_debug=_nix_ \
      --rr
      

      Attachments

        1. c00000.yy
          3 kB
        2. 000022.log
          330 kB

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              mleich Matthias Leich
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.