Assert hit during RQG testing

2020-10-20 05:57:31 0x71105010a300  InnoDB: Assertion failure in file /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/btr/btr0sea.cc line 668

InnoDB: Failing assertion: (block)->index || my_atomic_loadlint(&(block)->n_pointers) == 0

...

# 2020-10-20T06:07:10 [2145719] | Query (0x62b00017a228): SELECT `col_char_255_utf8_key` FROM `table100_innodb_int_autoinc` /* E_R Thread6 QNO 770 CON_ID 25 */

Connection ID (thread ID): 25

Status: KILL_TIMEOUT

(rr) bt

#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

#1  0x000055ecc294b859 in __GI_abort () at abort.c:79

#2  0x000055ecc5039feb in ut_dbg_assertion_failed (expr=expr@entry=0x55ecc60be200 "(block)->index || my_atomic_loadlint(&(block)->n_pointers) == 0", 

    file=file@entry=0x55ecc60bc3c0 "/home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/btr/btr0sea.cc", line=line@entry=668) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/ut/ut0dbg.cc:60

#3  0x000055ecc5107e0a in btr_search_update_hash_ref (info=info@entry=0x61a0000441b0, block=block@entry=0x55354aa45300, cursor=cursor@entry=0x6230002b0068) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/btr/btr0sea.cc:668

#4  0x000055ecc51171ce in btr_search_info_update_slow (info=info@entry=0x61a0000441b0, cursor=cursor@entry=0x6230002b0068) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/btr/btr0sea.cc:1548

#5  0x000055ecc50d1f94 in btr_search_info_update (cursor=<optimized out>, index=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/include/btr0sea.ic:84

#6  btr_cur_search_to_nth_level_func (index=index@entry=0x616000067308, level=level@entry=0, tuple=<optimized out>, mode=mode@entry=PAGE_CUR_LE, latch_mode=<optimized out>, latch_mode@entry=1, cursor=cursor@entry=0x6230002b0068, 

    ahi_latch=<optimized out>, file=<optimized out>, line=<optimized out>, mtr=<optimized out>, autoinc=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/btr/btr0cur.cc:2364

#7  0x000055ecc4e57017 in btr_pcur_open_with_no_init_func (mtr=0x7110501049e0, line=3308, file=0x55ecc6005ca0 "/home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/row/row0sel.cc", ahi_latch=0x0, cursor=0x6230002b0068, latch_mode=1, 

    mode=PAGE_CUR_LE, tuple=<optimized out>, index=0x616000067308) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/include/btr0pcur.ic:504

#8  Row_sel_get_clust_rec_for_mysql::operator() (this=<optimized out>, prebuilt=prebuilt@entry=0x6230002afd88, sec_index=sec_index@entry=0x61600006fa08, rec=<optimized out>, thr=thr@entry=0x6230002b0840, out_rec=<optimized out>, 

    offsets=<optimized out>, offset_heap=<optimized out>, vrow=<optimized out>, mtr=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/row/row0sel.cc:3308

#9  0x000055ecc4e682c2 in row_search_mvcc (buf=buf@entry=0x6260000ed128 "\221$\b", mode=<optimized out>, mode@entry=PAGE_CUR_UNSUPP, prebuilt=0x6230002afd88, match_mode=match_mode@entry=0, direction=direction@entry=1)

    at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/row/row0sel.cc:5335

#10 0x000055ecc49ebd25 in ha_innobase::general_fetch (this=0x61c0000d00a8, buf=<optimized out>, direction=direction@entry=1, match_mode=match_mode@entry=0) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/handler/ha_innodb.cc:9499

#11 0x000055ecc49ec789 in ha_innobase::index_next (this=<optimized out>, buf=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/handler/ha_innodb.cc:9567

#12 0x000055ecc42d7c07 in handler::ha_index_next (this=0x61c0000d00a8, buf=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/handler.cc:2954

#13 0x000055ecc3c24f74 in join_read_next (info=0x62b00017bff0) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/records.h:71

#14 0x000055ecc3bed6b7 in READ_RECORD::read_record (this=0x62b00017bff0) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/records.h:70

#15 sub_select (join=0x62b00017ad88, join_tab=0x62b00017bf28, end_of_records=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_select.cc:19733

#16 0x000055ecc3c757f6 in do_select (join=join@entry=0x62b00017ad88, procedure=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_select.cc:19254

#17 0x000055ecc3c96597 in JOIN::exec_inner (this=this@entry=0x62b00017ad88) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_select.cc:4116

#18 0x000055ecc3c96807 in JOIN::exec (this=this@entry=0x62b00017ad88) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_select.cc:3910

#19 0x000055ecc3c91ed1 in mysql_select (thd=thd@entry=0x62a00023a208, tables=<optimized out>, wild_num=<optimized out>, fields=..., conds=<optimized out>, og_num=<optimized out>, order=<optimized out>, group=<optimized out>, having=<optimized out>, 

    proc_param=<optimized out>, select_options=<optimized out>, result=<optimized out>, unit=<optimized out>, select_lex=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_select.cc:4315

#20 0x000055ecc3c9290e in handle_select (thd=thd@entry=0x62a00023a208, lex=lex@entry=0x62a00023e010, result=result@entry=0x62b00017ad58, setup_tables_done_option=setup_tables_done_option@entry=0)

    at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_select.cc:370

#21 0x000055ecc3ae1a62 in execute_sqlcom_select (thd=thd@entry=0x62a00023a208, all_tables=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_parse.cc:6286

#22 0x000055ecc3b0b90e in mysql_execute_command (thd=thd@entry=0x62a00023a208) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_parse.cc:3812

#23 0x000055ecc3b1f17f in mysql_parse (thd=thd@entry=0x62a00023a208, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x711050107f40, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false)

    at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_parse.cc:7810

#24 0x000055ecc3b268bf in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62a00023a208, packet=packet@entry=0x6290008de209 "", packet_length=packet_length@entry=102, is_com_multi=is_com_multi@entry=false, 

    is_next_command=is_next_command@entry=false) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_class.h:1134

#25 0x000055ecc3b301d6 in do_command (thd=0x62a00023a208) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_parse.cc:1393

#26 0x000055ecc3ef99d0 in do_handle_one_connection (connect=connect@entry=0x6080000011a8) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_connect.cc:1403

#27 0x000055ecc3efa0de in handle_one_connection (arg=0x6080000011a8) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_connect.cc:1308

#28 0x000055ecc820f609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#29 0x000055ecc2a48103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

(rr)

The assert looks like the one in https://jira.mariadb.org/browse/MDEV-20824.

But here its in btr0sea.cc line 668 + SQL is a SELECT ...

and there its in buf0buf.cc line 3275 + SQL is a ALTER TABLE t4 DROP COLUMN ...

origin/bb-10.3-MDEV-23072 36f5ea8b1092099e7ad96251bdefd43142bbe6c3 2020-10-19T22:18:29+05:30 compiled with debug+ASAN+Og

RQG

====

git clone https://github.com/mleich1/rqg --branch experimental RQG

perl rqg.pl \

--grammar=conf/engines/many_indexes.yy \

--gendata=conf/engines/many_indexes.zz \

--mysqld=--innodb_use_native_aio=1 \

--mysqld=--innodb_lock_schedule_algorithm=fcfs \

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

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

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

--mysqld=--connect_timeout=60 \

--mysqld=--interactive_timeout=28800 \

--mysqld=--slave_net_timeout=60 \

--mysqld=--net_read_timeout=30 \

--mysqld=--net_write_timeout=60 \

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

--mysqld=--wait_timeout=28800 \

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

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

--no-mask \

--queries=10000000 \

--seed=random \

--reporters=Backtrace \

--reporters=ErrorLog \

--reporters=Deadlock1 \

--validators=None \

--mysqld=--log_output=none \

--mysqld=--log-bin \

--mysqld=--log_bin_trust_function_creators=1 \

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

--engine=InnoDB \

--restart_timeout=120 \

--duration=400 \

--mysqld=--loose-innodb_fatal_semaphore_wait_threshold=400 \

--mysqld=--innodb_stats_persistent=off \

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

--threads=9 \

--mysqld=--innodb_page_size=8K \

--mysqld=--innodb-buffer-pool-size=256M \

--duration=400 \

--no_mask \

--workdir=<local settings> \

--vardir=<local settings> \

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

--basedir1=<local settings> \

--script_debug=_nix_ \

--rr=Server \

--rr_options=--chaos