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

LP:636922 - Crash in __bzero_sse2 from JOIN_CACHE_BKA_UNIQUE::cleanup_hash_table with join_cache_level = 8

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • None
    • None
    • None

    Description

      When executing the following query

      SELECT table2 .`col_int`
      FROM I LEFT JOIN N table2 ON table2 .`col_varchar_10_latin1` LEFT JOIN F table3 LEFT JOIN L table4 JOIN P table6 ON table6 .`col_int` ON table3 .`col_int_key` = table4 .`col_int_key` ON table2 .`col_varchar_10_latin1` = table6 .`col_varchar_10_utf8_key`
      ;

      the server crashed as follows:

      #5 0x00b774f4 in __bzero_sse2 () from /lib/libc.so.6
      #6 0x082dae51 in JOIN_CACHE_BKA_UNIQUE::cleanup_hash_table (this=0xb6db6528) at sql_join_cache.cc:2916
      #7 0x082da95d in JOIN_CACHE_BKA_UNIQUE::reset (this=0xb6db6528, for_writing=true) at sql_join_cache.cc:2659
      #8 0x082d92d0 in JOIN_CACHE::join_records (this=0xb6db6528, skip_last=false) at sql_join_cache.cc:1709
      #9 0x082d9102 in JOIN_CACHE::join_records (this=0xb6d96450, skip_last=false) at sql_join_cache.cc:1650
      #10 0x0831ef60 in sub_select_cache (join=0xb6d8df88, join_tab=0xb6d94a20, end_of_records=true) at sql_select.cc:12822
      #11 0x0831f179 in sub_select (join=0xb6d8df88, join_tab=0xb6d94860, end_of_records=true) at sql_select.cc:12984
      #12 0x0831e733 in do_select (join=0xb6d8df88, fields=0x9fef714, table=0x0, procedure=0x0) at sql_select.cc:12580
      #13 0x08304ac1 in JOIN::exec (this=0xb6d8df88) at sql_select.cc:2300
      #14 0x083051f7 in mysql_select (thd=0x9fedd00, rref_pointer_array=0x9fef798, tables=0xb6d80808, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0,
      group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xb6d8df58, unit=0x9fef3dc, select_lex=0x9fef67c) at sql_select.cc:2501
      #15 0x082fd95b in handle_select (thd=0x9fedd00, lex=0x9fef380, result=0xb6d8df58, setup_tables_done_option=0) at sql_select.cc:276
      #16 0x0829bf3c in execute_sqlcom_select (thd=0x9fedd00, all_tables=0xb6d80808) at sql_parse.cc:5081
      #17 0x08292914 in mysql_execute_command (thd=0x9fedd00) at sql_parse.cc:2265
      #18 0x0829e0fd in mysql_parse (thd=0x9fedd00,
      inBuf=0xb6d4ecc8 "SELECT table2 .`col_int`\nFROM I LEFT JOIN N table2 ON table2 .`col_varchar_10_latin1` LEFT JOIN F table3 LEFT JOIN L table4 JOIN P table6 ON table6 .`col_int` ON table3 .`col_int_key` = tab"..., length=291, found_semicolon=0xa6eb7230) at sql_parse.cc:6027
      #19 0x082903ca in dispatch_command (command=COM_QUERY, thd=0x9fedd00, packet=0x9fefd21 "", packet_length=292) at sql_parse.cc:1184
      #20 0x0828f8b8 in do_command (thd=0x9fedd00) at sql_parse.cc:890
      #21 0x0828c8f0 in handle_one_connection (arg=0x9fedd00) at sql_connect.cc:1153
      #22 0x00bea919 in start_thread () from /lib/libpthread.so.0
      #23 0x00b2ccbe in clone () from /lib/libc.so.6

      Attachments

        Activity

          People

            igor Igor Babaev
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.