Another one of the same category. Since they all are clearly related and none gets fixed, I don't see much point in getting a test case and filing another report, I'll just leave it here for future reference.
#8 0x0000559beae7162f in row_sel_store_mysql_field (mysql_rec=0x7f8a482374e0 "\217\217\200", prebuilt=0x7f8a48044f08, rec=0x7f8a6e84407e "\216\346\265\a", index=0x7f8a480faec8, offsets=0x7f8a6c5567f0, field_no=1, templ=0x7f8a48ba2b28) at /data/src/10.8/storage/innobase/row/row0sel.cc:3016
#9 0x0000559beae73fe2 in row_search_idx_cond_check (mysql_rec=0x7f8a482374e0 "\217\217\200", prebuilt=0x7f8a48044f08, rec=0x7f8a6e84407e "\216\346\265\a", offsets=0x7f8a6c5567f0) at /data/src/10.8/storage/innobase/row/row0sel.cc:4030
#10 0x0000559beae782b6 in row_search_mvcc (buf=0x7f8a482374e0 "\217\217\200", mode=PAGE_CUR_GE, prebuilt=0x7f8a48044f08, match_mode=1, direction=0) at /data/src/10.8/storage/innobase/row/row0sel.cc:5414
#11 0x0000559beac7ccf8 in ha_innobase::index_read (this=0x7f8a48114c00, buf=0x7f8a482374e0 "\217\217\200", key_ptr=0x7f8a48019098 "\001", key_len=67, find_flag=HA_READ_KEY_EXACT) at /data/src/10.8/storage/innobase/handler/ha_innodb.cc:8990
#12 0x0000559bea7c0108 in handler::index_read_map (this=0x7f8a48114c00, buf=0x7f8a482374e0 "\217\217\200", key=0x7f8a48019098 "\001", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /data/src/10.8/sql/handler.h:3855
#13 0x0000559bea899acd in handler::ha_index_read_map (this=0x7f8a48114c00, buf=0x7f8a482374e0 "\217\217\200", key=0x7f8a48019098 "\001", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /data/src/10.8/sql/handler.cc:3471
#14 0x0000559bea57b5a5 in join_read_always_key (tab=0x7f8a48230778) at /data/src/10.8/sql/sql_select.cc:21943
#15 0x0000559bea57984d in sub_select (join=0x7f8a48017108, join_tab=0x7f8a48230778, end_of_records=false) at /data/src/10.8/sql/sql_select.cc:21160
#16 0x0000559bea578d5f in do_select (join=0x7f8a48017108, procedure=0x0) at /data/src/10.8/sql/sql_select.cc:20708
#17 0x0000559bea54c24e in JOIN::exec_inner (this=0x7f8a48017108) at /data/src/10.8/sql/sql_select.cc:4759
#18 0x0000559bea54b2c3 in JOIN::exec (this=0x7f8a48017108) at /data/src/10.8/sql/sql_select.cc:4537
#19 0x0000559bea54cbf4 in mysql_select (thd=0x7f8a48000db8, tables=0x7f8a48015ad0, fields=..., conds=0x7f8a48016708, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f8a480170e0, unit=0x7f8a480051c8, select_lex=0x7f8a480154f8) at /data/src/10.8/sql/sql_select.cc:5017
#20 0x0000559bea53befd in handle_select (thd=0x7f8a48000db8, lex=0x7f8a480050f0, result=0x7f8a480170e0, setup_tables_done_option=0) at /data/src/10.8/sql/sql_select.cc:551
#21 0x0000559bea4e4d9b in execute_sqlcom_select (thd=0x7f8a48000db8, all_tables=0x7f8a48015ad0) at /data/src/10.8/sql/sql_parse.cc:6252
#22 0x0000559bea4dc0c0 in mysql_execute_command (thd=0x7f8a48000db8, is_called_from_prepared_stmt=false) at /data/src/10.8/sql/sql_parse.cc:3943
#23 0x0000559bea4e9b0d in mysql_parse (thd=0x7f8a48000db8, rawbuf=0x7f8a48015410 "SELECT * FROM t5 WHERE id BETWEEN 8 AND 366 AND vcol_varchar IS NULL", length=68, parser_state=0x7f8a6c558500) at /data/src/10.8/sql/sql_parse.cc:8027
#24 0x0000559bea4d6196 in dispatch_command (command=COM_QUERY, thd=0x7f8a48000db8, packet=0x7f8a48b137a9 "", packet_length=68, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1894
#25 0x0000559bea4d4b91 in do_command (thd=0x7f8a48000db8, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1407
#26 0x0000559bea6a821a in do_handle_one_connection (connect=0x559beed1a148, put_in_cache=true) at /data/src/10.8/sql/sql_connect.cc:1418
#27 0x0000559bea6a7eb9 in handle_one_connection (arg=0x559beed2fa18) at /data/src/10.8/sql/sql_connect.cc:1312
#28 0x0000559beab9eb26 in pfs_spawn_thread (arg=0x559beed19cb8) at /data/src/10.8/storage/perfschema/pfs.cc:2201
#29 0x00007f8a79485ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
#30 0x00007f8a79084def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
Elena Stepanova
added a comment - Another one of the same category. Since they all are clearly related and none gets fixed, I don't see much point in getting a test case and filing another report, I'll just leave it here for future reference.
10.8 0e0a3580
mariadbd: /data/src/10.8/storage/innobase/row/row0sel.cc:3016: ulint row_sel_store_mysql_field(byte*, row_prebuilt_t*, const rec_t*, const dict_index_t*, const rec_offs*, ulint, const mysql_row_templ_t*): Assertion `templ->mysql_null_bit_mask' failed.
220529 1:19:17 [ERROR] mysqld got signal 6 ;
#7 0x00007f8a78fbb662 in __GI___assert_fail (assertion=0x559beb5cdc6b "templ->mysql_null_bit_mask", file=0x559beb5cc788 "/data/src/10.8/storage/innobase/row/row0sel.cc", line=3016, function=0x559beb5cdaa0 "ulint row_sel_store_mysql_field(byte*, row_prebuilt_t*, const rec_t*, const dict_index_t*, const rec_offs*, ulint, const mysql_row_templ_t*)") at assert.c:101
#8 0x0000559beae7162f in row_sel_store_mysql_field (mysql_rec=0x7f8a482374e0 "\217\217\200", prebuilt=0x7f8a48044f08, rec=0x7f8a6e84407e "\216\346\265\a", index=0x7f8a480faec8, offsets=0x7f8a6c5567f0, field_no=1, templ=0x7f8a48ba2b28) at /data/src/10.8/storage/innobase/row/row0sel.cc:3016
#9 0x0000559beae73fe2 in row_search_idx_cond_check (mysql_rec=0x7f8a482374e0 "\217\217\200", prebuilt=0x7f8a48044f08, rec=0x7f8a6e84407e "\216\346\265\a", offsets=0x7f8a6c5567f0) at /data/src/10.8/storage/innobase/row/row0sel.cc:4030
#10 0x0000559beae782b6 in row_search_mvcc (buf=0x7f8a482374e0 "\217\217\200", mode=PAGE_CUR_GE, prebuilt=0x7f8a48044f08, match_mode=1, direction=0) at /data/src/10.8/storage/innobase/row/row0sel.cc:5414
#11 0x0000559beac7ccf8 in ha_innobase::index_read (this=0x7f8a48114c00, buf=0x7f8a482374e0 "\217\217\200", key_ptr=0x7f8a48019098 "\001", key_len=67, find_flag=HA_READ_KEY_EXACT) at /data/src/10.8/storage/innobase/handler/ha_innodb.cc:8990
#12 0x0000559bea7c0108 in handler::index_read_map (this=0x7f8a48114c00, buf=0x7f8a482374e0 "\217\217\200", key=0x7f8a48019098 "\001", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /data/src/10.8/sql/handler.h:3855
#13 0x0000559bea899acd in handler::ha_index_read_map (this=0x7f8a48114c00, buf=0x7f8a482374e0 "\217\217\200", key=0x7f8a48019098 "\001", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /data/src/10.8/sql/handler.cc:3471
#14 0x0000559bea57b5a5 in join_read_always_key (tab=0x7f8a48230778) at /data/src/10.8/sql/sql_select.cc:21943
#15 0x0000559bea57984d in sub_select (join=0x7f8a48017108, join_tab=0x7f8a48230778, end_of_records=false) at /data/src/10.8/sql/sql_select.cc:21160
#16 0x0000559bea578d5f in do_select (join=0x7f8a48017108, procedure=0x0) at /data/src/10.8/sql/sql_select.cc:20708
#17 0x0000559bea54c24e in JOIN::exec_inner (this=0x7f8a48017108) at /data/src/10.8/sql/sql_select.cc:4759
#18 0x0000559bea54b2c3 in JOIN::exec (this=0x7f8a48017108) at /data/src/10.8/sql/sql_select.cc:4537
#19 0x0000559bea54cbf4 in mysql_select (thd=0x7f8a48000db8, tables=0x7f8a48015ad0, fields=..., conds=0x7f8a48016708, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f8a480170e0, unit=0x7f8a480051c8, select_lex=0x7f8a480154f8) at /data/src/10.8/sql/sql_select.cc:5017
#20 0x0000559bea53befd in handle_select (thd=0x7f8a48000db8, lex=0x7f8a480050f0, result=0x7f8a480170e0, setup_tables_done_option=0) at /data/src/10.8/sql/sql_select.cc:551
#21 0x0000559bea4e4d9b in execute_sqlcom_select (thd=0x7f8a48000db8, all_tables=0x7f8a48015ad0) at /data/src/10.8/sql/sql_parse.cc:6252
#22 0x0000559bea4dc0c0 in mysql_execute_command (thd=0x7f8a48000db8, is_called_from_prepared_stmt=false) at /data/src/10.8/sql/sql_parse.cc:3943
#23 0x0000559bea4e9b0d in mysql_parse (thd=0x7f8a48000db8, rawbuf=0x7f8a48015410 "SELECT * FROM t5 WHERE id BETWEEN 8 AND 366 AND vcol_varchar IS NULL", length=68, parser_state=0x7f8a6c558500) at /data/src/10.8/sql/sql_parse.cc:8027
#24 0x0000559bea4d6196 in dispatch_command (command=COM_QUERY, thd=0x7f8a48000db8, packet=0x7f8a48b137a9 "", packet_length=68, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1894
#25 0x0000559bea4d4b91 in do_command (thd=0x7f8a48000db8, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1407
#26 0x0000559bea6a821a in do_handle_one_connection (connect=0x559beed1a148, put_in_cache=true) at /data/src/10.8/sql/sql_connect.cc:1418
#27 0x0000559bea6a7eb9 in handle_one_connection (arg=0x559beed2fa18) at /data/src/10.8/sql/sql_connect.cc:1312
#28 0x0000559beab9eb26 in pfs_spawn_thread (arg=0x559beed19cb8) at /data/src/10.8/storage/perfschema/pfs.cc:2201
#29 0x00007f8a79485ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
#30 0x00007f8a79084def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
Another one of the same category. Since they all are clearly related and none gets fixed, I don't see much point in getting a test case and filing another report, I'll just leave it here for future reference.
10.8 0e0a3580
mariadbd: /data/src/10.8/storage/innobase/row/row0sel.cc:3016: ulint row_sel_store_mysql_field(byte*, row_prebuilt_t*, const rec_t*, const dict_index_t*, const rec_offs*, ulint, const mysql_row_templ_t*): Assertion `templ->mysql_null_bit_mask' failed.
220529 1:19:17 [ERROR] mysqld got signal 6 ;
#7 0x00007f8a78fbb662 in __GI___assert_fail (assertion=0x559beb5cdc6b "templ->mysql_null_bit_mask", file=0x559beb5cc788 "/data/src/10.8/storage/innobase/row/row0sel.cc", line=3016, function=0x559beb5cdaa0 "ulint row_sel_store_mysql_field(byte*, row_prebuilt_t*, const rec_t*, const dict_index_t*, const rec_offs*, ulint, const mysql_row_templ_t*)") at assert.c:101
#8 0x0000559beae7162f in row_sel_store_mysql_field (mysql_rec=0x7f8a482374e0 "\217\217\200", prebuilt=0x7f8a48044f08, rec=0x7f8a6e84407e "\216\346\265\a", index=0x7f8a480faec8, offsets=0x7f8a6c5567f0, field_no=1, templ=0x7f8a48ba2b28) at /data/src/10.8/storage/innobase/row/row0sel.cc:3016
#9 0x0000559beae73fe2 in row_search_idx_cond_check (mysql_rec=0x7f8a482374e0 "\217\217\200", prebuilt=0x7f8a48044f08, rec=0x7f8a6e84407e "\216\346\265\a", offsets=0x7f8a6c5567f0) at /data/src/10.8/storage/innobase/row/row0sel.cc:4030
#10 0x0000559beae782b6 in row_search_mvcc (buf=0x7f8a482374e0 "\217\217\200", mode=PAGE_CUR_GE, prebuilt=0x7f8a48044f08, match_mode=1, direction=0) at /data/src/10.8/storage/innobase/row/row0sel.cc:5414
#11 0x0000559beac7ccf8 in ha_innobase::index_read (this=0x7f8a48114c00, buf=0x7f8a482374e0 "\217\217\200", key_ptr=0x7f8a48019098 "\001", key_len=67, find_flag=HA_READ_KEY_EXACT) at /data/src/10.8/storage/innobase/handler/ha_innodb.cc:8990
#12 0x0000559bea7c0108 in handler::index_read_map (this=0x7f8a48114c00, buf=0x7f8a482374e0 "\217\217\200", key=0x7f8a48019098 "\001", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /data/src/10.8/sql/handler.h:3855
#13 0x0000559bea899acd in handler::ha_index_read_map (this=0x7f8a48114c00, buf=0x7f8a482374e0 "\217\217\200", key=0x7f8a48019098 "\001", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /data/src/10.8/sql/handler.cc:3471
#14 0x0000559bea57b5a5 in join_read_always_key (tab=0x7f8a48230778) at /data/src/10.8/sql/sql_select.cc:21943
#15 0x0000559bea57984d in sub_select (join=0x7f8a48017108, join_tab=0x7f8a48230778, end_of_records=false) at /data/src/10.8/sql/sql_select.cc:21160
#16 0x0000559bea578d5f in do_select (join=0x7f8a48017108, procedure=0x0) at /data/src/10.8/sql/sql_select.cc:20708
#17 0x0000559bea54c24e in JOIN::exec_inner (this=0x7f8a48017108) at /data/src/10.8/sql/sql_select.cc:4759
#18 0x0000559bea54b2c3 in JOIN::exec (this=0x7f8a48017108) at /data/src/10.8/sql/sql_select.cc:4537
#19 0x0000559bea54cbf4 in mysql_select (thd=0x7f8a48000db8, tables=0x7f8a48015ad0, fields=..., conds=0x7f8a48016708, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f8a480170e0, unit=0x7f8a480051c8, select_lex=0x7f8a480154f8) at /data/src/10.8/sql/sql_select.cc:5017
#20 0x0000559bea53befd in handle_select (thd=0x7f8a48000db8, lex=0x7f8a480050f0, result=0x7f8a480170e0, setup_tables_done_option=0) at /data/src/10.8/sql/sql_select.cc:551
#21 0x0000559bea4e4d9b in execute_sqlcom_select (thd=0x7f8a48000db8, all_tables=0x7f8a48015ad0) at /data/src/10.8/sql/sql_parse.cc:6252
#22 0x0000559bea4dc0c0 in mysql_execute_command (thd=0x7f8a48000db8, is_called_from_prepared_stmt=false) at /data/src/10.8/sql/sql_parse.cc:3943
#23 0x0000559bea4e9b0d in mysql_parse (thd=0x7f8a48000db8, rawbuf=0x7f8a48015410 "SELECT * FROM t5 WHERE id BETWEEN 8 AND 366 AND vcol_varchar IS NULL", length=68, parser_state=0x7f8a6c558500) at /data/src/10.8/sql/sql_parse.cc:8027
#24 0x0000559bea4d6196 in dispatch_command (command=COM_QUERY, thd=0x7f8a48000db8, packet=0x7f8a48b137a9 "", packet_length=68, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1894
#25 0x0000559bea4d4b91 in do_command (thd=0x7f8a48000db8, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1407
#26 0x0000559bea6a821a in do_handle_one_connection (connect=0x559beed1a148, put_in_cache=true) at /data/src/10.8/sql/sql_connect.cc:1418
#27 0x0000559bea6a7eb9 in handle_one_connection (arg=0x559beed2fa18) at /data/src/10.8/sql/sql_connect.cc:1312
#28 0x0000559beab9eb26 in pfs_spawn_thread (arg=0x559beed19cb8) at /data/src/10.8/storage/perfschema/pfs.cc:2201
#29 0x00007f8a79485ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
#30 0x00007f8a79084def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95