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

Server crashes in next_breadth_first_tab or Assertion `0' failed in Field_varstring_compressed::new_key_field

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • N/A
    • N/A
    • OTHER
    • None

    Description

      Note: it might be a duplicate of MDEV-13540. The same assertion fails on a debug build, but stack traces are essentially different, test cases too, and non-debug build crashes in different ways, so I'm filing it separately just in case.

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (c VARCHAR(500) COMPRESSED) ENGINE=InnoDB;
      INSERT INTO t1 VALUES ('foo'),('bar');
       
      SELECT DISTINCT c FROM t1;
       
      # Cleanup
      DROP TABLE t1;
      

      bb-10.3-svoj debug f1a3cd40

      mysqld: /data/src/bb-10.3-svoj/sql/field.h:3222: virtual Field* Field_varstring_compressed::new_key_field(MEM_ROOT*, TABLE*, uchar*, uint32, uchar*, uint): Assertion `0' failed.
      170816  1:26:42 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fe2031ecee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055c0dc0aaed3 in Field_varstring_compressed::new_key_field (this=0x7fe1ac155a68, root=0x7fe1ac154f50, new_table=0x7fe1ac154498, new_ptr=0x7fe1ac1557b9 '\245' <repeats 200 times>..., length=501, new_null_ptr=0x7fe1ac1789a8 "\377", new_null_bit=2) at /data/src/bb-10.3-svoj/sql/field.h:3222
      #9  0x000055c0dbe7cd74 in create_tmp_table (thd=0x7fe1ac000b00, param=0x7fe1ac016d40, fields=..., group=0x7fe1ac016ce8, distinct=false, save_sum_fields=false, select_options=2147748609, rows_limit=18446744073709551615, table_alias=0x55c0dc8c2915 "", do_not_open=true, keep_row_order=false) at /data/src/bb-10.3-svoj/sql/sql_select.cc:16886
      #10 0x000055c0dbe5867d in JOIN::create_postjoin_aggr_table (this=0x7fe1ac0151c0, tab=0x7fe1ac016558, table_fields=0x7fe1ac0154d8, table_group=0x7fe1ac016ce8, save_sum_fields=false, distinct=false, keep_row_order=false) at /data/src/bb-10.3-svoj/sql/sql_select.cc:2831
      #11 0x000055c0dbe56a4a in JOIN::make_aggr_tables_info (this=0x7fe1ac0151c0) at /data/src/bb-10.3-svoj/sql/sql_select.cc:2405
      #12 0x000055c0dbe55c2f in JOIN::optimize_inner (this=0x7fe1ac0151c0) at /data/src/bb-10.3-svoj/sql/sql_select.cc:2160
      #13 0x000055c0dbe52154 in JOIN::optimize (this=0x7fe1ac0151c0) at /data/src/bb-10.3-svoj/sql/sql_select.cc:1084
      #14 0x000055c0dbe5af26 in mysql_select (thd=0x7fe1ac000b00, tables=0x7fe1ac014ac8, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748609, result=0x7fe1ac0151a0, unit=0x7fe1ac0046b8, select_lex=0x7fe1ac004df0) at /data/src/bb-10.3-svoj/sql/sql_select.cc:3651
      #15 0x000055c0dbe4fa6e in handle_select (thd=0x7fe1ac000b00, lex=0x7fe1ac0045f0, result=0x7fe1ac0151a0, setup_tables_done_option=0) at /data/src/bb-10.3-svoj/sql/sql_select.cc:373
      #16 0x000055c0dbe1bf1b in execute_sqlcom_select (thd=0x7fe1ac000b00, all_tables=0x7fe1ac014ac8) at /data/src/bb-10.3-svoj/sql/sql_parse.cc:6450
      #17 0x000055c0dbe122cf in mysql_execute_command (thd=0x7fe1ac000b00) at /data/src/bb-10.3-svoj/sql/sql_parse.cc:3574
      #18 0x000055c0dbe1f90d in mysql_parse (thd=0x7fe1ac000b00, rawbuf=0x7fe1ac0148d8 "SELECT DISTINCT c FROM t1", length=25, parser_state=0x7fe1f45f2210, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-svoj/sql/sql_parse.cc:7897
      #19 0x000055c0dbe0d687 in dispatch_command (command=COM_QUERY, thd=0x7fe1ac000b00, packet=0x7fe1ac173951 "SELECT DISTINCT c FROM t1", packet_length=25, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-svoj/sql/sql_parse.cc:1814
      #20 0x000055c0dbe0c02b in do_command (thd=0x7fe1ac000b00) at /data/src/bb-10.3-svoj/sql/sql_parse.cc:1377
      #21 0x000055c0dbf57f31 in do_handle_one_connection (connect=0x55c0dfcc4dd0) at /data/src/bb-10.3-svoj/sql/sql_connect.cc:1354
      #22 0x000055c0dbf57cbe in handle_one_connection (arg=0x55c0dfcc4dd0) at /data/src/bb-10.3-svoj/sql/sql_connect.cc:1260
      #23 0x000055c0dc3b0e29 in pfs_spawn_thread (arg=0x55c0dfc0c490) at /data/src/bb-10.3-svoj/storage/perfschema/pfs.cc:1862
      #24 0x00007fe204f26494 in start_thread (arg=0x7fe1f45f3700) at pthread_create.c:333
      #25 0x00007fe2032a993f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      bb-10.3-svoj non-debug f1a3cd40

      #2  <signal handler called>
      #3  0x000055bceba5be57 in next_breadth_first_tab (first_top_tab=first_top_tab@entry=0x7fd000012b50, n_top_tabs_count=n_top_tabs_count@entry=1, tab=tab@entry=0x7fd000012f00) at /data/src/bb-10.3-svoj-rel/sql/sql_select.cc:8476
      #4  0x000055bceba7348d in JOIN::cleanup (this=this@entry=0x7fd000011b68, full=full@entry=true) at /data/src/bb-10.3-svoj-rel/sql/sql_select.cc:12015
      #5  0x000055bceba73abd in JOIN::destroy (this=0x7fd000011b68) at /data/src/bb-10.3-svoj-rel/sql/sql_select.cc:3496
      #6  0x000055bcebacd460 in st_select_lex::cleanup (this=this@entry=0x7fd000004b58) at /data/src/bb-10.3-svoj-rel/sql/sql_union.cc:1708
      #7  0x000055bceba8bfce in mysql_select (thd=thd@entry=0x7fd0000009a8, tables=0x7fd000011470, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748609, result=0x7fd000011b48, unit=0x7fd000004420, select_lex=0x7fd000004b58) at /data/src/bb-10.3-svoj-rel/sql/sql_select.cc:3677
      #8  0x000055bceba8c8d0 in handle_select (thd=thd@entry=0x7fd0000009a8, lex=lex@entry=0x7fd000004358, result=result@entry=0x7fd000011b48, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/bb-10.3-svoj-rel/sql/sql_select.cc:373
      #9  0x000055bceba30906 in execute_sqlcom_select (thd=0x7fd0000009a8, all_tables=0x7fd000011470) at /data/src/bb-10.3-svoj-rel/sql/sql_parse.cc:6450
      #10 0x000055bceba3cbed in mysql_execute_command (thd=0x7fd0000009a8) at /data/src/bb-10.3-svoj-rel/sql/sql_parse.cc:3574
      #11 0x000055bceba401cf in mysql_parse (thd=0x7fd0000009a8, rawbuf=<optimized out>, length=<optimized out>, parser_state=0x7fd04c390250, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.3-svoj-rel/sql/sql_parse.cc:7897
      #12 0x000055bceba42d6b in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fd0000009a8, packet=packet@entry=0x7fd000008f19 "SELECT DISTINCT c FROM t1", packet_length=packet_length@entry=25, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.3-svoj-rel/sql/sql_parse.cc:1814
      #13 0x000055bceba435c7 in do_command (thd=0x7fd0000009a8) at /data/src/bb-10.3-svoj-rel/sql/sql_parse.cc:1377
      #14 0x000055bcebb072f4 in do_handle_one_connection (connect=connect@entry=0x55bcee2f4e78) at /data/src/bb-10.3-svoj-rel/sql/sql_connect.cc:1354
      #15 0x000055bcebb07494 in handle_one_connection (arg=arg@entry=0x55bcee2f4e78) at /data/src/bb-10.3-svoj-rel/sql/sql_connect.cc:1260
      #16 0x000055bcebdfd794 in pfs_spawn_thread (arg=0x55bcee2f50d8) at /data/src/bb-10.3-svoj-rel/storage/perfschema/pfs.cc:1862
      #17 0x00007fd054c42494 in start_thread (arg=0x7fd04c391700) at pthread_create.c:333
      #18 0x00007fd052fc593f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Attachments

        Issue Links

          Activity

            People

              svoj Sergey Vojtovich
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.