Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.2(EOL), 10.4(EOL)
-
None
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
|