Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-3958

handle_fatal_signal (sig=11) in subselect_hash_sj_engine::cleanup

    Details

      Description

      # mysqld options required for replay:  --innodb_temp_tablespace_encrypt=ON
      # can't reproduce when server started without this -^
      CREATE DATABASE test;
      USE test;
      SET optimizer_switch='materialization=on,subquery_materialization_cost_based=off';
      SET big_tables=1;
      create TABLE t1(a int,b char,filler char,primary key(a,b))ENGINE=InnoDB;
      SELECT a FROM t1 WHERE NOT a IN(SELECT a FROM t1 WHERE b=0);
      
      (gdb) bt
      +bt
      #0  0x00007f90a79b99b1 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
      #1  0x0000000001872a64 in my_write_core (sig=11) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/mysys/stacktrace.c:249
      #2  0x0000000000e90acf in handle_fatal_signal (sig=11) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/signal_handler.cc:223
      #3  <signal handler called>
      #4  0x00000000013df3c1 in subselect_hash_sj_engine::cleanup (this=0x7f9067906678) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/item_subselect.cc:4016
      #5  0x00000000013d4b2b in Item_in_subselect::finalize_materialization_transform (this=0x7f906782d358, join=0x7f9067905580) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/item_subselect.cc:340
      #6  0x0000000001528950 in JOIN::decide_subquery_strategy (this=0x7f9067905580) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_optimizer.cc:10983
      #7  0x0000000001519de1 in JOIN::make_join_plan (this=0x7f9067905580) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_optimizer.cc:5121
      #8  0x000000000150e3fa in JOIN::optimize (this=0x7f9067905580) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_optimizer.cc:387
      #9  0x000000000158968f in st_select_lex::optimize (this=0x7f90678b1030, thd=0x7f9067819000) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_select.cc:1011
      #10 0x00000000015ed773 in st_select_lex_unit::optimize (this=0x7f90678b1310, thd=0x7f9067819000) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_union.cc:704
      #11 0x00000000015896eb in st_select_lex::optimize (this=0x7f906782c0b0, thd=0x7f9067819000) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_select.cc:1017
      #12 0x0000000001587db7 in handle_query (thd=0x7f9067819000, lex=0x7f906781b620, result=0x7f90678b2310, added_options=0, removed_options=0) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_select.cc:165
      #13 0x000000000153b34d in execute_sqlcom_select (thd=0x7f9067819000, all_tables=0x7f906782d7c8) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_parse.cc:5445
      #14 0x000000000153446b in mysql_execute_command (thd=0x7f9067819000, first_level=true) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_parse.cc:2939
      #15 0x000000000153c3bf in mysql_parse (thd=0x7f9067819000, parser_state=0x7f90a7fb1470) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_parse.cc:5901
      #16 0x0000000001530f0f in dispatch_command (thd=0x7f9067819000, com_data=0x7f90a7fb1c50, command=COM_QUERY) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_parse.cc:1490
      #17 0x000000000152fd97 in do_command (thd=0x7f9067819000) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_parse.cc:1021
      #18 0x0000000001670586 in handle_connection (arg=0x7f909fbffd30) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/conn_handler/connection_handler_per_thread.cc:312
      #19 0x000000000189635d in pfs_spawn_thread (arg=0x7f90a3c18f20) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/storage/perfschema/pfs.cc:2190
      #20 0x00007f90a79b4e25 in start_thread (arg=0x7f90a7fb2700) at pthread_create.c:308
      #21 0x00007f90a5b8834d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
      

      another trial:

      # mysqld options required for replay:  --innodb_temp_tablespace_encrypt=ON
      CREATE DATABASE test;
      USE test;
      CREATE TABLE t1(a int key)engine=MEMORY;
      INSERT INTO t1 VALUES(11061);
      insert INTO t1 values(3);
      set big_tables=1;
      SELECT * FROM t1 WHERE a IN(SELECT MAX(a)FROM t1);
      
      (gdb) bt
      +bt
      #0  0x00007fcbf7df39b1 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
      #1  0x0000000001872a64 in my_write_core (sig=11) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/mysys/stacktrace.c:249
      #2  0x0000000000e90acf in handle_fatal_signal (sig=11) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/signal_handler.cc:223
      #3  <signal handler called>
      #4  0x00000000013df3c1 in subselect_hash_sj_engine::cleanup (this=0x7fcbb75158e8) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/item_subselect.cc:4016
      #5  0x00000000013d4b2b in Item_in_subselect::finalize_materialization_transform (this=0x7fcbb742d200, join=0x7fcbb7515240) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/item_subselect.cc:340
      #6  0x0000000001528950 in JOIN::decide_subquery_strategy (this=0x7fcbb7515240) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_optimizer.cc:10983
      #7  0x0000000001519de1 in JOIN::make_join_plan (this=0x7fcbb7515240) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_optimizer.cc:5121
      #8  0x000000000150e3fa in JOIN::optimize (this=0x7fcbb7515240) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_optimizer.cc:387
      #9  0x000000000158968f in st_select_lex::optimize (this=0x7fcbb742db70, thd=0x7fcbb7419000) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_select.cc:1011
      #10 0x00000000015ed773 in st_select_lex_unit::optimize (this=0x7fcbb7513030, thd=0x7fcbb7419000) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_union.cc:704
      #11 0x00000000015896eb in st_select_lex::optimize (this=0x7fcbb742c0a0, thd=0x7fcbb7419000) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_select.cc:1017
      #12 0x0000000001587db7 in handle_query (thd=0x7fcbb7419000, lex=0x7fcbb741b620, result=0x7fcbb7513c98, added_options=0, removed_options=0) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_select.cc:165
      #13 0x000000000153b34d in execute_sqlcom_select (thd=0x7fcbb7419000, all_tables=0x7fcbb742d4b0) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_parse.cc:5445
      #14 0x000000000153446b in mysql_execute_command (thd=0x7fcbb7419000, first_level=true) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_parse.cc:2939
      #15 0x000000000153c3bf in mysql_parse (thd=0x7fcbb7419000, parser_state=0x7fcbf83eb470) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_parse.cc:5901
      #16 0x0000000001530f0f in dispatch_command (thd=0x7fcbb7419000, com_data=0x7fcbf83ebc50, command=COM_QUERY) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_parse.cc:1490
      #17 0x000000000152fd97 in do_command (thd=0x7fcbb7419000) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_parse.cc:1021
      #18 0x0000000001670586 in handle_connection (arg=0x7fcbeffffd30) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/conn_handler/connection_handler_per_thread.cc:312
      #19 0x000000000189635d in pfs_spawn_thread (arg=0x7fcbf4018e20) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/storage/perfschema/pfs.cc:2190
      #20 0x00007fcbf7deee25 in start_thread (arg=0x7fcbf83ec700) at pthread_create.c:308
      #21 0x00007fcbf5fc234d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
      

      Reproduced on 5.7 trunk (d666728a14ff7349fbb923336bc9977565cbe479)

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                sergei.glushchenko Sergei Glushchenko
                Reporter:
                hrvoje.matijakovic Hrvoje Matijakovic
              • Votes:
                1 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 5 hours, 44 minutes
                  5h 44m