InnoDB: Failing assertion: field->col->mtype == type

--source include/have_innodb.inc

CREATE TABLE t1 (a INT, KEY (a)) ENGINE=InnoDB;

INSERT INTO t1 VALUES (1);

BEGIN;

SELECT * FROM t1;

--connect (con1,localhost,root)

--send ALTER TABLE t1 MODIFY a BIGINT, ALGORITHM=COPY, LOCK=SHARED

--connection default

--let $wait_condition= SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE = 'Waiting for table metadata lock' AND INFO LIKE 'ALTER TABLE%'

--source include/wait_condition.inc

--source include/kill_mysqld.inc

--disconnect con1

--let $restart_parameters= --innodb-force-recovery=5

--source include/start_mysqld.inc

SELECT * FROM t1 FORCE INDEX (a) WHERE a > 0;

--let $restart_parameters=

--source include/restart_mysqld.inc

DROP TABLE t1;

InnoDB: Failing assertion: field->col->mtype == type

Core was generated by `/test/EMD261026-mariadb-10.6.29-25-linux-x86_64-dbg/bin/mariadbd --defaults-gro'.

Program terminated with signal SIGABRT, Aborted.

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

[Current thread is 1 (LWP 2055662)]

(gdb) bt

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

#1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78

#2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89

#3  0x000070fb6de4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26

#4  0x000070fb6de288ff in __GI_abort () at ./stdlib/abort.c:79

#5  0x000061fe2b47918d in ut_dbg_assertion_failed (expr=0x61fe2b8c2bc6 "field->col->mtype == type", file=0x61fe2b8c2a8a "/test/10.6-es_dbg/storage/innobase/row/row0sel.cc", line=2642) at /test/10.6-es_dbg/storage/innobase/ut/ut0dbg.cc:60

#6  0x000061fe2b3e6e01 in row_sel_convert_mysql_key_to_innobase (tuple=0x68fa7c070770, buf=0x68fa7c0300cc "\217\217\217\217", buf_len=4, index=0x68fa7c02f700, key_ptr=0x68fa7c06f74d "", key_len=9)at /test/10.6-es_dbg/storage/innobase/row/row0sel.cc:2642

#7  0x000061fe2b1f8148 in ha_innobase::records_in_range (this=0x68fa7c023fc8, keynr=0, min_key=0x70fb6c73adb8, max_key=0x0, pages=0x70fb6c73ad10)at /test/10.6-es_dbg/storage/innobase/handler/ha_innodb.cc:14264

#8  0x000061fe2ac9ec92 in handler::multi_range_read_info_const (this=0x68fa7c023fc8, keyno=0, seq=0x70fb6c73af50, seq_init_param=0x70fb6c73af78, n_ranges_arg=0, bufsz=0x70fb6c73ae58, flags=0x70fb6c73ae5c, cost=0x70fb6c73b5f8)at /test/10.6-es_dbg/sql/multi_range_read.cc:177

#9  0x000061fe2aca20de in DsMrr_impl::dsmrr_info_const (this=0x68fa7c0244e0, keyno=0, seq=0x70fb6c73af50, seq_init_param=0x70fb6c73af78, n_ranges=0, bufsz=0x70fb6c73b5e8, flags=0x70fb6c73b5ec, cost=0x70fb6c73b5f8)at /test/10.6-es_dbg/sql/multi_range_read.cc:1714

#10 0x000061fe2b1ffab5 in ha_innobase::multi_range_read_info_const (this=0x68fa7c023fc8, keyno=0, seq=0x70fb6c73af50, seq_init_param=0x70fb6c73af78, n_ranges=0, bufsz=0x70fb6c73b5e8, flags=0x70fb6c73b5ec, cost=0x70fb6c73b5f8)at /test/10.6-es_dbg/storage/innobase/handler/ha_innodb.cc:20044

#11 0x000061fe2afff8f9 in check_quick_select (param=0x70fb6c73bbd0, idx=0, index_only=true, tree=0x68fa7c06f7f8, update_tbl_stats=true, mrr_flags=0x70fb6c73b5ec, bufsize=0x70fb6c73b5e8, cost=0x70fb6c73b5f8, is_ror_scan=0x70fb6c73b5e7) at /test/10.6-es_dbg/sql/opt_range.cc:11778

#12 0x000061fe2afe4d2a in get_key_scans_params (param=0x70fb6c73bbd0, tree=0x68fa7c06f768, index_read_must_be_used=false, for_range_access=true, read_time=1.2001830942935612) at /test/10.6-es_dbg/sql/opt_range.cc:7620

#13 0x000061fe2afe3b27 in SQL_SELECT::test_quick_select (this=0x68fa7c01a1d0, thd=0x68fa7c000d58, keys_to_use={static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {1}}, prev_tables=0, limit=18446744073709551615, force_quick_range=false, ordered_output=false, remove_false_parts_of_where=true, only_single_index_range_scan=false, note_unusable_keys=Item_func::BITMAP_EXCEPT_ANY_EQUALITY)at /test/10.6-es_dbg/sql/opt_range.cc:2964

#14 0x000061fe2ab4e997 in get_quick_record_count (thd=0x68fa7c000d58, select=0x68fa7c01a1d0, table=0x68fa7c023b58, keys=0x68fa7c019160, limit=18446744073709551615, quick_count=0x70fb6c73c710)at /test/10.6-es_dbg/sql/sql_select.cc:5345

#15 0x000061fe2ab115ee in make_join_statistics (join=0x68fa7c018688, tables_list=@0x68fa7c016da0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x68fa7c018dc0, last = 0x68fa7c018dc0, elements = 1}, <No data fields>}, keyuse_array=0x68fa7c0189b8) at /test/10.6-es_dbg/sql/sql_select.cc:6087

#16 0x000061fe2ab0cc3b in JOIN::optimize_inner (this=0x68fa7c018688)at /test/10.6-es_dbg/sql/sql_select.cc:2643

#17 0x000061fe2ab08897 in JOIN::optimize (this=0x68fa7c018688)at /test/10.6-es_dbg/sql/sql_select.cc:1951

#18 0x000061fe2ab0132b in mysql_select (thd=0x68fa7c000d58, tables=0x68fa7c017200, fields=@0x68fa7c016e40: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x68fa7c017168, last = 0x68fa7c017168, elements = 1}, <No data fields>}, conds=0x68fa7c017ac0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x68fa7c018660, unit=0x68fa7c004f40, select_lex=0x68fa7c016b68)at /test/10.6-es_dbg/sql/sql_select.cc:5269

#19 0x000061fe2ab00edd in handle_select (thd=0x68fa7c000d58, lex=0x68fa7c004e78, result=0x68fa7c018660, setup_tables_done_option=0)at /test/10.6-es_dbg/sql/sql_select.cc:575

#20 0x000061fe2aab1c31 in execute_sqlcom_select (thd=0x68fa7c000d58, all_tables=0x68fa7c017200) at /test/10.6-es_dbg/sql/sql_parse.cc:6449

#21 0x000061fe2aaa6eba in mysql_execute_command (thd=0x68fa7c000d58, is_called_from_prepared_stmt=false)at /test/10.6-es_dbg/sql/sql_parse.cc:4029

#22 0x000061fe2aa9f6f8 in mysql_parse (thd=0x68fa7c000d58, rawbuf=0x68fa7c016ab0 "SELECT * FROM t1 FORCE INDEX (a) WHERE a > 0", length=44, parser_state=0x70fb6c73ea28)at /test/10.6-es_dbg/sql/sql_parse.cc:8228

#23 0x000061fe2aa9cef1 in dispatch_command (command=COM_QUERY, thd=0x68fa7c000d58, packet=0x68fa7c00aed9 "SELECT * FROM t1 FORCE INDEX (a) WHERE a > 0", packet_length=44, blocking=true) at /test/10.6-es_dbg/sql/sql_parse.cc:1918

#24 0x000061fe2aaa019f in do_command (thd=0x68fa7c000d58, blocking=true)at /test/10.6-es_dbg/sql/sql_parse.cc:1428

#25 0x000061fe2ac4f7be in do_handle_one_connection (connect=0x61fe38053da8, put_in_cache=true) at /test/10.6-es_dbg/sql/sql_connect.cc:1394

#26 0x000061fe2ac4f5a5 in handle_one_connection (arg=0x61fe38053da8)at /test/10.6-es_dbg/sql/sql_connect.cc:1306

#27 0x000070fb6de9cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447

#28 0x000070fb6df29ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

    Rel    o/d  Build   Commit                                    UniqueID observed

CS  10.11  dbg  261026  6a063120d4d3d451bff3ea84b3ffbee288b33be8  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

CS  10.11  opt  261026  6a063120d4d3d451bff3ea84b3ffbee288b33be8  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

CS  11.4   dbg  261026  b6406d42c8e26be3d86a4a743180f6b415a4559b  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

CS  11.4   opt  261026  b6406d42c8e26be3d86a4a743180f6b415a4559b  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

CS  11.8   dbg  261026  274dd0d8d90bc773090d13303b8d5e36d2390241  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

CS  11.8   opt  261026  274dd0d8d90bc773090d13303b8d5e36d2390241  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

CS  12.3   dbg  261026  788a07c52132d9f42b6991e599510c62d1625c0f  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

CS  12.3   opt  261026  788a07c52132d9f42b6991e599510c62d1625c0f  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

CS  13.0   dbg  261026  620a4b5624222048fece7fe1789978ae0675cae2  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

CS  13.0   opt  261026  620a4b5624222048fece7fe1789978ae0675cae2  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

CS  13.2   dbg  261026  c894d97781b54fbf074677c9d67f81cd60a162ac  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

CS  13.2   opt  261026  c894d97781b54fbf074677c9d67f81cd60a162ac  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

ES  10.6   dbg  261026  45fbb1583d8cdcc7da5a123a844b3bf512f31c9d  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

ES  10.6   opt  261026  45fbb1583d8cdcc7da5a123a844b3bf512f31c9d  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

ES  11.4   dbg  261026  6b2ae48e6e2488060adfdd02a7114bb60d4d150c  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

ES  11.4   opt  261026  6b2ae48e6e2488060adfdd02a7114bb60d4d150c  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

ES  11.8   dbg  261026  6e6ba60bdc2b3f478513c5afa3faa062d8e73736  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

ES  11.8   opt  261026  6e6ba60bdc2b3f478513c5afa3faa062d8e73736  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

ES  12.3   dbg  261026  781803ca9943d806ecb4b3b3fb39264dfafe1cf0  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const

ES  12.3   opt  261026  781803ca9943d806ecb4b3b3fb39264dfafe1cf0  field->col->mtype == type|SIGABRT|ut_dbg_assertion_failed|row_sel_convert_mysql_key_to_innobase|ha_innobase::records_in_range|handler::multi_range_read_info_const