[MDEV-11739] [Draft] InnoDB: Failing assertion: templ->mysql_null_bit_mask Created: 2017-01-07  Updated: 2019-02-24

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2, 10.4
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Unresolved Votes: 0
Labels: None

Attachments: File mysql.err     File mysql.log.gz     HTML File threads    

 Description   

Encountered during tests on bb-10.2-monty. Information in the report is related to that test run, but I couldn't reproduce it so far neither on the same tree, nor on 10.2.

bb-10.2-monty 4ec3e60ae3734 of Jan 6

 
2017-01-07 02:51:02 0x7f0e9bea4300  InnoDB: Assertion failure in file /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0sel.cc line 3137
 
InnoDB: Failing assertion: templ->mysql_null_bit_mask
 
 
 
# 2017-01-07T02:51:44 [46169] #5  0x00007f0e9bfbcb8b in abort () from /lib/x86_64-linux-gnu/libc.so.6
 
# 2017-01-07T02:51:44 [46169] #6  0x00007f0e9eec5df5 in ut_dbg_assertion_failed (expr=0x7f0e9f44ca93 "templ->mysql_null_bit_mask", file=0x7f0e9f44bd10 "/home/elenst/git/bb-10.2-monty/storage/innobase
 
/row/row0sel.cc", line=3137) at /home/elenst/git/bb-10.2-monty/storage/innobase/ut/ut0dbg.cc:59
 
# 2017-01-07T02:51:44 [46169] #7  0x00007f0e9ee21ff7 in row_sel_store_mysql_field_func (mysql_rec=0x7f0e5a824d88 "", prebuilt=0x7f0e5a9b5088, rec=0x7f0e69e4841d "\200", index=0x7f0e8851b388, offsets=
 
0x7f0e9bea0da0, field_no=8, templ=0x7f0e5a901fc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0sel.cc:3137
 
# 2017-01-07T02:51:44 [46169] #8  0x00007f0e9ee2263f in row_sel_store_mysql_rec (mysql_rec=0x7f0e5a824d88 "", prebuilt=0x7f0e5a9b5088, rec=0x7f0e69e4841d "\200", vrow=0x0, rec_clust=1, index=0x7f0e88
 
51b388, offsets=0x7f0e9bea0da0) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0sel.cc:3307
 
# 2017-01-07T02:51:44 [46169] #9  0x00007f0e9ee277ea in row_search_mvcc (buf=0x7f0e5a824d88 "", mode=PAGE_CUR_G, prebuilt=0x7f0e5a9b5088, match_mode=0, direction=1) at /home/elenst/git/bb-10.2-monty/
 
storage/innobase/row/row0sel.cc:5540
 
# 2017-01-07T02:51:44 [46169] #10 0x00007f0e9eca27ef in ha_innobase::general_fetch (this=0x7f0e5a93b888, buf=0x7f0e5a824d88 "", direction=1, match_mode=0) at /home/elenst/git/bb-10.2-monty/storage/in
 
nobase/handler/ha_innodb.cc:10646
 
# 2017-01-07T02:51:44 [46169] #11 0x00007f0e9eca2a70 in ha_innobase::index_next (this=0x7f0e5a93b888, buf=0x7f0e5a824d88 "") at /home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc:10
 
713
 
# 2017-01-07T02:51:44 [46169] #12 0x00007f0e9ea9547d in handler::ha_index_next (this=0x7f0e5a93b888, buf=0x7f0e5a824d88 "") at /home/elenst/git/bb-10.2-monty/sql/handler.cc:2677
 
# 2017-01-07T02:51:44 [46169] #13 0x00007f0e9ea9b9da in handler::read_range_next (this=0x7f0e5a93b888) at /home/elenst/git/bb-10.2-monty/sql/handler.cc:5365
 
# 2017-01-07T02:51:44 [46169] #14 0x00007f0e9e9b33d4 in handler::multi_range_read_next (this=0x7f0e5a93b888, range_info=0x7f0e9bea18a0) at /home/elenst/git/bb-10.2-monty/sql/multi_range_read.cc:257
 
# 2017-01-07T02:51:44 [46169] #15 0x00007f0e9e9b3674 in Mrr_simple_index_reader::get_next (this=0x7f0e5a93bdf0, range_info=0x7f0e9bea18a0) at /home/elenst/git/bb-10.2-monty/sql/multi_range_read.cc:32
 
2
 
# 2017-01-07T02:51:44 [46169] #16 0x00007f0e9e9b61ec in DsMrr_impl::dsmrr_next (this=0x7f0e5a93bcb0, range_info=0x7f0e9bea18a0) at /home/elenst/git/bb-10.2-monty/sql/multi_range_read.cc:1408
 
# 2017-01-07T02:51:44 [46169] #17 0x00007f0e9ecb6cbe in ha_innobase::multi_range_read_next (this=0x7f0e5a93b888, range_info=0x7f0e9bea18a0) at /home/elenst/git/bb-10.2-monty/storage/innobase/handler/
 
ha_innodb.cc:23473
 
# 2017-01-07T02:51:44 [46169] #18 0x00007f0e9ebeaa2c in QUICK_RANGE_SELECT::get_next (this=0x7f0e5a9e6140) at /home/elenst/git/bb-10.2-monty/sql/opt_range.cc:11190
 
# 2017-01-07T02:51:44 [46169] #19 0x00007f0e9ebfb9c1 in rr_quick (info=0x7f0e5a9acd48) at /home/elenst/git/bb-10.2-monty/sql/records.cc:353
 
# 2017-01-07T02:51:44 [46169] #20 0x00007f0e9e88b891 in sub_select (join=0x7f0e5a9b05c0, join_tab=0x7f0e5a9acc80, end_of_records=false) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:18362
 
# 2017-01-07T02:51:44 [46169] #21 0x00007f0e9e88ad99 in do_select (join=0x7f0e5a9b05c0, procedure=0x0) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:17887
 
# 2017-01-07T02:51:44 [46169] #22 0x00007f0e9e865b7a in JOIN::exec_inner (this=0x7f0e5a9b05c0) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:3388
 
# 2017-01-07T02:51:44 [46169] #23 0x00007f0e9e8650cc in JOIN::exec (this=0x7f0e5a9b05c0) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:3199
 
# 2017-01-07T02:51:44 [46169] #24 0x00007f0e9e866267 in mysql_select (thd=0x7f0e5a89e070, tables=0x7f0e5a8dfaa8, wild_num=1, fields=..., conds=0x7f0e5a8e1468, og_num=0, order=0x0, group=0x0, having=0
 
x0, proc_param=0x0, select_options=551903562496, result=0x7f0e5a8e4e48, unit=0x7f0e5a8a1b48, select_lex=0x7f0e5a8a2278) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:3584
 
# 2017-01-07T02:51:44 [46169] #25 0x00007f0e9e85b2cd in handle_select (thd=0x7f0e5a89e070, lex=0x7f0e5a8a1a80, result=0x7f0e5a8e4e48, setup_tables_done_option=0) at /home/elenst/git/bb-10.2-monty/sql
 
/sql_select.cc:373
 
# 2017-01-07T02:51:44 [46169] #26 0x00007f0e9e82734f in execute_sqlcom_select (thd=0x7f0e5a89e070, all_tables=0x7f0e5a8dfaa8) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:6396
 
# 2017-01-07T02:51:44 [46169] #27 0x00007f0e9e81cd7b in mysql_execute_command (thd=0x7f0e5a89e070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:3426
 
# 2017-01-07T02:51:44 [46169] #28 0x00007f0e9e82ad45 in mysql_parse (thd=0x7f0e5a89e070, rawbuf=0x7f0e5a8df088 "SELECT * FROM (test.`view_D` AS table1 INNER JOIN test.`D` AS table2 ON ( table2.`col_time_key` = table1.`col_time_key` ) ) WHERE table2.`col_datetime_key` < '1988-12-27 19:50:42.048505' LIMIT 7 /* QNO 1468 CON_ID 19 */", length=219, parser_state=0x7f0e9bea2db0, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:7839
 
# 2017-01-07T02:51:44 [46169] #29 0x00007f0e9e8187e6 in dispatch_command (command=COM_QUERY, thd=0x7f0e5a89e070, packet=0x7f0e5a8d5071 "", packet_length=221, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1799
 
# 2017-01-07T02:51:44 [46169] #30 0x00007f0e9e8171a6 in do_command (thd=0x7f0e5a89e070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1359
 
# 2017-01-07T02:51:44 [46169] #31 0x00007f0e9e961894 in do_handle_one_connection (connect=0x7f0e82bfe2b0) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1354
 
# 2017-01-07T02:51:44 [46169] #32 0x00007f0e9e961621 in handle_one_connection (arg=0x7f0e82bfe2b0) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1260
 
# 2017-01-07T02:51:44 [46169] #33 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
 
# 2017-01-07T02:51:44 [46169] #34 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
 
# 2017-01-07T02:51:44 [46169] #35 0x0000000000000000 in ?? ()


Trying to get some variables.
 
Some pointers may be invalid and cause the dump to abort.
 
Query (0x7f0e5a8df088): SELECT * FROM (test.`view_D` AS table1 INNER JOIN test.`D` AS table2 ON ( table2.`col_time_key` = table1.`col_time_key` ) ) WHERE table2.`col_datetime_key` < '1988-12-27 19:50:42.048505' LIMIT 7 /* QNO 1468 CON_ID 19 */
 
Connection ID (thread ID): 15
 
Status: NOT_KILLED

RQG experimental 67b190f486

 
perl /home/elenst/git/rqg/runall-new.pl --no-mask --seed=1483750045 --threads=8 --duration=600 --queries=100M --validators=TransformerNoComparator --transformers=ExecuteAsPreparedTwice,DisableOptimizations,EnableOptimizations,InlineVirtualColumns,ExecuteAsTrigger --redefine=conf/mariadb/general-workarounds.yy --redefine=conf/mariadb/10.0-features-redefine.yy --mysqld=--log_output=FILE --views --grammar=conf/runtime/information_schema.yy --vcols=VIRTUAL --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock,CrashRestart --restart-timeout=20 --mtr-build-thread=72 --basedir1=/home/elenst/git/bb-10.2-monty --vardir1=/home/elenst/test_results/monty-4/current1_1



 Comments   
Comment by Elena Stepanova [ 2019-02-24 ]

Same assertion failure, but with a very different cause, appeared in 10.4: MDEV-18722.

Generated at Thu Feb 08 07:52:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.