Assertion `0' failed in btr_search_hash_table_validate

origin/10.6, 10.6 68b2819342a00bf18ee98f1e8d5db4b6db78b146 2021-01-27T18:41:58+02:00

2021-01-28  5:09:50 33 [ERROR] InnoDB: Error in an adaptive hash index pointer to page [page id: space=5, page number=3], ptr mem address 0x56723beed201, index id 23, node fold 1270551399198, rec fold 1270308129438

InnoDB: Record [rr 1097029 2023276]PHYSICAL RECORD: n_fields 1; compact format; info bits 0

[rr 1097029 2023278] 0:[rr 1097029 2023280] len 4; hex [rr 1097029 2023282]00[rr 1097029 2023284]00[rr 1097029 2023286]00[rr 1097029 2023288]00[rr 1097029 2023290]; asc [rr 1097029 2023292] [rr 1097029 2023294] [rr 1097029 2023296] [rr 1097029 2023298] [rr 1097029 2023300];[rr 1097029 2023302];[rr 1097029 2023304]

[rr 1097029 2023306]

InnoDB: on that page. Page mem address 0x56723bee8000, is hashed 0x61600079f620, n fields 0

InnoDB: side 0

[rr 1097029 2023308]mysqld: /Server/10.6B/storage/innobase/btr/btr0sea.cc:2226: ulint btr_search_hash_table_validate(ulint): Assertion `0' failed.

Query (0x62b0001d5238): ALTER TABLE r CHECK PARTITION p2,p3

Status: KILL_TIMEOUT

(rr) bt

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

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

#2  0x00004c8c136cb729 in __assert_fail_base (fmt=0x4c8c13861588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55ce9389a160 "0", file=0x55ce9389a360 "/Server/10.6B/storage/innobase/btr/btr0sea.cc", line=2226, function=<optimized out>)

    at assert.c:92

#3  0x00004c8c136dcf36 in __GI___assert_fail (assertion=0x55ce9389a160 "0", file=0x55ce9389a360 "/Server/10.6B/storage/innobase/btr/btr0sea.cc", line=2226, function=0x55ce9389c980 "ulint btr_search_hash_table_validate(ulint)") at assert.c:101

#4  0x000055ce922776ac in btr_search_hash_table_validate (hash_table_id=5) at /Server/10.6B/storage/innobase/btr/btr0sea.cc:2226

#5  0x000055ce92277b28 in btr_search_validate () at /Server/10.6B/storage/innobase/btr/btr0sea.cc:2285

#6  0x000055ce91ce304c in ha_innobase::check (this=0x61d0001568b8, thd=0x62b0001ce218, check_opt=0x62b0001d3670) at /Server/10.6B/storage/innobase/handler/ha_innodb.cc:14654

#7  0x000055ce911a8f91 in handler::ha_check (this=0x61d0001568b8, thd=0x62b0001ce218, check_opt=0x62b0001d3670) at /Server/10.6B/sql/handler.cc:4586

#8  0x000055ce91a59271 in ha_partition::handle_opt_part (this=0x61d0001536b8, thd=0x62b0001ce218, check_opt=0x62b0001d3670, part_id=2, flag=3) at /Server/10.6B/sql/ha_partition.cc:1320

#9  0x000055ce91a5a410 in ha_partition::handle_opt_partitions (this=0x61d0001536b8, thd=0x62b0001ce218, check_opt=0x62b0001d3670, flag=3) at /Server/10.6B/sql/ha_partition.cc:1496

#10 0x000055ce91a58a30 in ha_partition::check (this=0x61d0001536b8, thd=0x62b0001ce218, check_opt=0x62b0001d3670) at /Server/10.6B/sql/ha_partition.cc:1228

#11 0x000055ce911a8f91 in handler::ha_check (this=0x61d0001536b8, thd=0x62b0001ce218, check_opt=0x62b0001d3670) at /Server/10.6B/sql/handler.cc:4586

#12 0x000055ce90df2184 in mysql_admin_table (thd=0x62b0001ce218, tables=0x62b0001d5398, check_opt=0x62b0001d3670, operator_name=0x55ce92d834e0 "check", lock_type=TL_READ_NO_INSERT, org_open_for_modify=false, repair_table_use_frm=false, 

    extra_open_options=32, prepare_func=0x0, operator_func=(int (handler::*)(class handler * const, class THD *, HA_CHECK_OPT *)) 0x55ce911a8b08 <handler::ha_check(THD*, st_ha_check_opt*)>, view_operator_func=

    0x55ce90caebac <view_check(THD*, TABLE_LIST*, st_ha_check_opt*)>) at /Server/10.6B/sql/sql_admin.cc:853

#13 0x000055ce90df6df4 in Sql_cmd_check_table::execute (this=0x62b0001d5ad0, thd=0x62b0001ce218) at /Server/10.6B/sql/sql_admin.cc:1423

#14 0x000055ce90dc042e in Sql_cmd_alter_table_check_partition::execute (this=0x62b0001d5ad0, thd=0x62b0001ce218) at /Server/10.6B/sql/sql_partition_admin.cc:741

#15 0x000055ce9099569f in mysql_execute_command (thd=0x62b0001ce218) at /Server/10.6B/sql/sql_parse.cc:5880

#16 0x000055ce909a309f in mysql_parse (thd=0x62b0001ce218, rawbuf=0x62b0001d5238 "ALTER TABLE r CHECK PARTITION p2,p3 /* E_R Thread18 QNO 27 CON_ID 33 */", length=71, parser_state=0x4eef806a97c0) at /Server/10.6B/sql/sql_parse.cc:7906

#17 0x000055ce90979c99 in dispatch_command (command=COM_QUERY, thd=0x62b0001ce218, packet=0x62d0000fa419 "", packet_length=72) at /Server/10.6B/sql/sql_parse.cc:1833

#18 0x000055ce90976b5f in do_command (thd=0x62b0001ce218) at /Server/10.6B/sql/sql_parse.cc:1365

#19 0x000055ce90db8665 in do_handle_one_connection (connect=0x608000003838, put_in_cache=true) at /Server/10.6B/sql/sql_connect.cc:1410

#20 0x000055ce90db7fce in handle_one_connection (arg=0x608000003838) at /Server/10.6B/sql/sql_connect.cc:1312

#21 0x000055ce91abb913 in pfs_spawn_thread (arg=0x61500000dc98) at /Server/10.6B/storage/perfschema/pfs.cc:2201

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

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

(rr) quit

sdp:/home/mleich/RQG_O/storage/1611834303/AHI/dev/shm/vardir/1611834303/22/1/rr

_RR_TRACE_DIR="." rr replay --mark-stdio

RQG

====

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

perl rqg.pl \

--views \

--grammar=conf/mariadb/partitions_innodb.yy \

--redefine=conf/mariadb/alter_table.yy \

--redefine=conf/mariadb/instant_add.yy \

--redefine=conf/mariadb/modules/alter_table_columns.yy \

--redefine=conf/mariadb/sp.yy \

--redefine=conf/mariadb/bulk_insert.yy \

--redefine=conf/mariadb/modules/userstat.yy \

--redefine=conf/mariadb/modules/foreign_keys.yy \

--redefine=conf/mariadb/modules/locks.yy \

--redefine=conf/mariadb/modules/sql_mode.yy \

--redefine=conf/mariadb/versioning.yy \

--redefine=conf/mariadb/sequences.yy \

--redefine=conf/mariadb/modules/locks-10.4-extra.yy \

--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=240 \

--mysqld=--plugin-load-add=file_key_management.so \

--mysqld=--loose-file-key-management-filename=$RQG_HOME/conf/mariadb/encryption_keys.txt \

--duration=300 \

--mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \

--mysqld=--innodb_stats_persistent=on \

--mysqld=--innodb_adaptive_hash_index=on \

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

--threads=33 \

--mysqld=--innodb_page_size=32K \

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

--duration=300 \

--no_mask \

--workdir=<local settings> \

--vardir=<local settings> \

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

--basedir1=<local settings> \

--script_debug=_nix_ \

--rr=Extended \

--rr_options=--chaos