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
|
Bug
Major
