Mariabackup copied too old page or too new checkpoint

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