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

Server crash in in JOIN_CACHE_HASHED::put_record or Assertion `0' failed in Field_blob_compressed::new_key_field, with join_cache_level>2

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.3, 10.4
    • Fix Version/s: 10.3, 10.4
    • Component/s: Server
    • Labels:
      None

      Description

      --source include/have_innodb.inc
      set join_cache_level=3;
       
      CREATE TABLE t1 (col_blob text)engine=innodb;
      CREATE TABLE t2 (col_blob text COMPRESSED)engine=innodb;
       
      SELECT * FROM t1 JOIN t2 USING ( col_blob );
      

       
      mysqld: /git/10.3/sql/field.h:3831: virtual Field* Field_blob_compressed::new_key_field(MEM_ROOT*, TABLE*, uchar*, uint32, uchar*, uint): Assertion `0' failed.
      180724 12:21:59 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.3.9-MariaDB-debug-log
       
      stack_bottom = 0x7f573900bc70 thread_stack 0x49000
      /usr/lib/x86_64-linux-gnu/libasan.so.2(+0x4a077)[0x7f5753ab8077]
      mysys/stacktrace.c:269(my_print_stacktrace)[0x5617a87a81dc]
      sql/signal_handler.cc:168(handle_fatal_signal)[0x5617a74c5331]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f5752350390]
      linux/raise.c:54(__GI_raise)[0x7f5751709428]
      stdlib/abort.c:91(__GI_abort)[0x7f575170b02a]
      assert/assert.c:92(__assert_fail_base)[0x7f5751701bd7]
      /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f5751701c82]
      /git/10.3/sql/mysqld(+0x16a88d5)[0x5617a74a68d5]
      sql/sql_select.h:1839(store_key::store_key(THD*, Field*, unsigned char*, unsigned char*, unsigned int))[0x5617a6f60663]
      sql/sql_select.h:1896(store_key_field::store_key_field(THD*, Field*, unsigned char*, unsigned char*, unsigned int, Field*, char const*))[0x5617a6f60bdd]
      sql/sql_select.cc:9972(get_store_key(THD*, keyuse_t*, unsigned long long, st_key_part_info*, unsigned char*, unsigned int))[0x5617a6ee1099]
      sql/sql_select.cc:9890(create_ref_for_key(JOIN*, st_join_table*, keyuse_t*, bool, unsigned long long))[0x5617a6ee016b]
      sql/sql_select.cc:9565(JOIN::get_best_combination())[0x5617a6edd455]
      sql/sql_select.cc:1928(JOIN::optimize_stage2())[0x5617a6ea460a]
      sql/sql_select.cc:1907(JOIN::optimize_inner())[0x5617a6ea43ae]
      sql/sql_select.cc:1448(JOIN::optimize())[0x5617a6ea02ae]
      sql/sql_select.cc:4206(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*))[0x5617a6eb9f3d]
      sql/sql_select.cc:382(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5617a6e95973]
      sql/sql_parse.cc:6542(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5617a6e1b4c4]
      sql/sql_parse.cc:3765(mysql_execute_command(THD*))[0x5617a6e09cd7]
      sql/sql_parse.cc:8073(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5617a6e23dd2]
      sql/sql_parse.cc:1849(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5617a6dfeab9]
      sql/sql_parse.cc:1392(do_command(THD*))[0x5617a6dfbc51]
      sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x5617a714b0b6]
      sql/sql_connect.cc:1309(handle_one_connection)[0x5617a714aa93]
      perfschema/pfs.cc:1864(pfs_spawn_thread)[0x5617a86892e3]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f57523466ba]
      x86_64/clone.S:111(clone)[0x7f57517db41d]
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x62b000000288): SELECT * FROM t1 JOIN t2 USING ( col_blob )
      Connection ID (thread ID): 9
      Status: NOT_KILLED
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated: