Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.3.8
-
None
Description
mysqld:m3-10.3/src/storage/innobase/row/row0sel.cc:2890: void row_sel_field_store_in_mysql_format_func(byte*, const mysql_row_templ_t*, const dict_index_t*, ulint, const byte*, ulint): Assertion `(templ->is_virtual && !field) || (field && field->prefix_len ? field->prefix_len == len : templ->mysql_col_len == len)' failed.
|
|
180530 22:46:07 [ERROR] mysqld got signal 6 ;
|
|
stack_bottom = 0x7f27e5207ec0 thread_stack 0x49000
|
/home/alice/BR/m3-10.3/bld/sql//mysqld(my_print_stacktrace+0x40)[0x5643aa7f8247]
|
mysys/stacktrace.c:269(my_print_stacktrace)[0x5643aa03d3a6]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f27e8d5b390]
|
linux/raise.c:54(__GI_raise)[0x7f27e8114428]
|
stdlib/abort.c:91(__GI_abort)[0x7f27e811602a]
|
assert/assert.c:92(__assert_fail_base)[0x7f27e810cbd7]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f27e810cc82]
|
row/row0sel.cc:2894(row_sel_field_store_in_mysql_format_func(unsigned char*, mysql_row_templ_t const*, dict_index_t const*, unsigned long, unsigned char const*, unsigned long))[0x5643aa42bda5]
|
row/row0sel.cc:3058(row_sel_store_mysql_field_func(unsigned char*, row_prebuilt_t*, unsigned char const*, dict_index_t const*, unsigned long const*, unsigned long, mysql_row_templ_t const*))[0x5643aa42c5a2]
|
row/row0sel.cc:3185(row_sel_store_mysql_rec(unsigned char*, row_prebuilt_t*, unsigned char const*, dtuple_t const*, bool, dict_index_t const*, unsigned long const*))[0x5643aa42cb1b]
|
row/row0sel.cc:5458(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x5643aa432854]
|
handler/ha_innodb.cc:9317(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x5643aa29e07b]
|
handler/ha_innodb.cc:9734(ha_innobase::index_first(unsigned char*))[0x5643aa29f36e]
|
handler/ha_innodb.cc:9827(ha_innobase::rnd_next(unsigned char*))[0x5643aa29f579]
|
sql/handler.cc:2764(handler::ha_rnd_next(unsigned char*))[0x5643aa044b81]
|
sql/records.cc:481(rr_sequential(READ_RECORD*))[0x5643aa1c5c42]
|
sql/records.h:73(READ_RECORD::read_record())[0x5643a9cb90a3]
|
sql/sql_select.cc:20189(join_init_read_record(st_join_table*))[0x5643a9dc83cf]
|
sql/sql_select.cc:19253(sub_select(JOIN*, st_join_table*, bool))[0x5643a9dc607b]
|
sql/sql_select.cc:18796(do_select(JOIN*, Procedure*))[0x5643a9dc5619]
|
sql/sql_select.cc:4012(JOIN::exec_inner())[0x5643a9d9ea5f]
|
sql/sql_select.cc:3807(JOIN::exec())[0x5643a9d9ded2]
|
sql/sql_select.cc:4213(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5643a9d9f139]
|
sql/sql_derived.cc:1165(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x5643a9d094bc]
|
sql/sql_derived.cc:197(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x5643a9d070ee]
|
sql/sql_select.cc:12437(st_join_table::preread_init())[0x5643a9db4f65]
|
sql/sql_select.cc:19224(sub_select(JOIN*, st_join_table*, bool))[0x5643a9dc5f3f]
|
sql/sql_select.cc:18796(do_select(JOIN*, Procedure*))[0x5643a9dc5619]
|
sql/sql_select.cc:4012(JOIN::exec_inner())[0x5643a9d9ea5f]
|
sql/sql_select.cc:3807(JOIN::exec())[0x5643a9d9ded2]
|
sql/sql_select.cc:4213(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5643a9d9f139]
|
sql/sql_select.cc:382(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5643a9d911ba]
|
sql/sql_parse.cc:6543(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5643a9d5ba5f]
|
sql/sql_parse.cc:3765(mysql_execute_command(THD*))[0x5643a9d51e0c]
|
sql/sql_parse.cc:8078(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5643a9d5f9a4]
|
sql/sql_parse.cc:1849(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5643a9d4c868]
|
sql/sql_parse.cc:1392(do_command(THD*))[0x5643a9d4b285]
|
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x5643a9eb0bd1]
|
sql/sql_connect.cc:1309(handle_one_connection)[0x5643a9eb0922]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f27e8d516ba]
|
x86_64/clone.S:111(clone)[0x7f27e81e641d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f2778013778): SELECT DISTINCT alias1.`c45` AS cfield1 FROM `view_table10_innodb_utf8_1` AS alias1 WHERE alias1.`c7` IN ( SELECT SQ1_alias1.`c4` AS SQ1_ifield1 FROM ( view_table1_aria_utf8_0 AS SQ1_alias1 INNER JOIN view_table1000_myisam_latin1_1 AS SQ1_alias2 ON (SQ1_alias2.`c35` = SQ1_alias1.`c37` ) ) HAVING ((SQ1_ifield1 = 'l' OR SQ1_ifield1 <= 'n') AND SQ1_ifield1 <= 98) )
|
Connection ID (thread ID): 9
|
Status: NOT_KILLED
|
https://github.com/mysql/mysql-server/commit/b2368702d401f6cd1a4104fe590a6e6dbd14cd6c
Attachments
Issue Links
- relates to
-
MDEV-13481 Merge new release of InnoDB MySQL 5.7.19 to 10.2
- Closed