Assertion `err == DB_SUCCESS' failed. in btr_block_get_func during crash recovery

Workflow:

1. Start server and create a table

2. One session runs random

     ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) ;

     TRUNCATE TABLE t1;

3. Kill (SIGKILL) the process of the DB server 

4. The attempt to restart that server fails with

     2020-04-25 19:18:53 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2754798

    2020-04-25 19:18:53 0 [Note] InnoDB: Ignoring data file './test/t1.ibd' with space ID 83, since the redo log references ./test/t1.ibd with space ID 82.

    2020-04-25 19:18:53 0 [Note] InnoDB: Ignoring data file './test/t1.ibd' with space ID 82. Another data file called ./test/#sql-ib97.ibd exists with the same space ID.

    mysqld: storage/innobase/include/btr0btr.h:241: buf_block_t* btr_block_get_func(const dict_index_t&, ulint, ulint, bool, const char*, unsigned int, mtr_t*): Assertion `err == DB_SUCCESS' failed.

   200425 19:18:54 [rr 40350 5231][ERROR] mysqld got signal 6 ;

origin/10.5 2b2dcf34f7325872b03534ebca31c396f449330f with some local changes

which should not play a significant role because the bug was observed without

these changes too.

No replay (336 attempts) on origin/10.4 6dab094fbd31ef93a1d51b1b9c867188b2f958c3 2020-04-27T09:22:36+02:00

rqg.pl \

--duration=100 \

--queries=10000000 \

--threads=1 \

--no_mask \

--seed=random \

--engine=InnoDB \

--gendata=conf/mariadb/table_stress.zz \

--gendata_sql=conf/mariadb/table_stress.sql \

--sqltrace=MarkErrors \

--rpl_mode=none \

--mysqld=--lock-wait-timeout=86400 \

--mysqld=--loose-idle_transaction_timeout=0 \

--mysqld=--log-bin \

--mysqld=--loose-max-statement-time=30 \

--mysqld=--interactive_timeout=28800 \

--mysqld=--loose-debug_assert_on_not_freed_memory=0 \

--mysqld=--loose_innodb_lock_schedule_algorithm=fcfs \

--mysqld=--loose-idle_write_transaction_timeout=0 \

--mysqld=--net_write_timeout=60 \

--mysqld=--slave_net_timeout=60 \

--mysqld=--log_bin_trust_function_creators=1 \

--mysqld=--connect_timeout=60 \

--mysqld=--log-output=none \

--mysqld=--innodb_page_size=4K \

--mysqld=--net_read_timeout=30 \

--mysqld=--innodb-lock-wait-timeout=50 \

--mysqld=--innodb_stats_persistent=off \

--mysqld=--wait_timeout=28800 \

--mysqld=--loose-table_lock_wait_timeout=50 \

--mysqld=--loose-idle_readonly_transaction_timeout=0 \

--reporters=Backtrace,CrashRecovery1,Deadlock1,ErrorLog \

--validators=None \

--grammar=MDEV-22369.yy \

--workdir=<local settings> \

--vardir=<local settings> \

--mtr-build-thread=<local settings> \

--basedir1=<local settings> \

--script_debug=_nix_ \

--rr=Server