Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16344

[draft] Assertion `(templ->is_virtual && !field) || (field && field->prefix_len ? field->prefix_len == len : templ->mysql_col_len == len)' failed.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 10.3.8
    • Fix Version/s: N/A
    • Component/s: N/A
    • Labels:
      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

            Activity

              People

              Assignee:
              alice Alice Sherepa
              Reporter:
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: