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

Crash when select where not in select distinct subquery

Details

    Description

      170712 16:02:48 [ERROR] mysqld got signal 11 ;
      This could be because you hit a bug. It is also possible that this binary
      or one of the libraries it was linked against is corrupt, improperly built,
      or misconfigured. This error can also be caused by malfunctioning hardware.
      To report this bug, see https://mariadb.com/kb/en/reporting-bugs
      We will try our best to scrape up some info that will hopefully help
      diagnose the problem, but since we have already crashed, 
      something is definitely wrong and this may fail.
      Server version: 10.2.6-MariaDB
      key_buffer_size=134217728
      read_buffer_size=131072
      max_used_connections=19
      max_threads=153
      thread_count=25
      It is possible that mysqld could use up to 
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467201 K  bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.
      Thread pointer: 0x7f71080009a8
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0x7f71b0476d70 thread_stack 0x49000
      /usr/sbin/mysqld(my_print_stacktrace+0x2b)[0x7f71ca7f0a6b]
      /usr/sbin/mysqld(handle_fatal_signal+0x4d5)[0x7f71ca2880e5]
      /lib64/libpthread.so.0(+0x3921c0f7e0)[0x7f71c97b47e0]
      /usr/sbin/mysqld(_ZN4JOIN4execEv+0x1a)[0x7f71ca15d81a]
      /usr/sbin/mysqld(_ZN24subselect_hash_sj_engine4execEv+0x4a)[0x7f71ca31efca]
      /usr/sbin/mysqld(_ZN14Item_subselect4execEv+0x5a)[0x7f71ca315faa]
      /usr/sbin/mysqld(_ZN17Item_in_subselect8val_boolEv+0x3c)[0x7f71ca31581c]
      /usr/sbin/mysqld(_ZN17Item_in_optimizer7val_intEv+0x16d)[0x7f71ca2bab8d]
      mysys/stacktrace.c:268(my_print_stacktrace)[0x7f71ca29623a]
      /usr/sbin/mysqld(_ZN18Item_cache_wrapper5cacheEv+0x33)[0x7f71ca2afcf3]
      /usr/sbin/mysqld(_ZN18Item_cache_wrapper8val_boolEv+0x58)[0x7f71ca2a5af8]
      /usr/sbin/mysqld(_ZN13Item_func_not7val_intEv+0x1f)[0x7f71ca2b21af]
      sql/sql_analyze_stmt.h:97(Time_and_counter_tracker::incr_loops())[0x7f71ca13730d]
      sql/item_subselect.cc:5396(subselect_hash_sj_engine::exec())[0x7f71ca13f70e]
      /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0x993)[0x7f71ca15d613]
      sql/item_cmpfunc.cc:1622(Item_in_optimizer::val_int())[0x7f71ca15d83c]
      /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x12a)[0x7f71ca15c7ba]
      /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1d4)[0x7f71ca15da54]
      sql/item.cc:9460(Item_cache_int::cache_value())[0x7f71ca105066]
      sql/sql_select.cc:373(sult*, unsigned long))[0x7f71ca10f501]
      sql/sql_parse.cc:3448(mysql_execute_command(THD*))[0x7f71ca386a6e]
      sql/sp_head.cc:2997(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x7f71ca38c739]
      sql/sp_head.cc:3151(sp_instr_stmt::execute(THD*, unsigned int*))[0x7f71ca38cc55]
      sql/sp_head.cc:1325(sp_head::execute(THD*, bool))[0x7f71ca389b30]
      sql/sp_head.cc:2112(sp_head::execute_procedure(THD*, List<Item>*))[0x7f71ca38af3e]
      sql/sql_parse.cc:2883(do_execute_sp)[0x7f71ca104b7d]
      sql/sql_parse.cc:5797(mysql_execute_command(THD*))[0x7f71ca10b46e]
      sql/sql_parse.cc:7874(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x7f71ca11258a]
      sql/sql_parse.cc:1812(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x7f71ca11480d]
      sql/sql_parse.cc:1364(do_command(THD*))[0x7f71ca114dd1]
      sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x7f71ca1d099f]
      sql/sql_connect.cc:1262(handle_one_connection)[0x7f71ca1d0ac4]
      /lib64/libpthread.so.0(+0x3921c07aa1)[0x7f71c97acaa1]
      /lib64/libc.so.6(clone+0x6d)[0x7f71c7ec5aad]
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7f7108021b90): select * from risk_sod 
      where cport_legal_entity_id not in(select distinct(rca.cport_legal_entity_id) from risk_client_accounts rca)
      Connection ID (thread ID): 98
      Status: NOT_KILLED
      Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on
      The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
      information that should help you find out what is causing the crash.
      170712 16:02:48 mysqld_safe Number of processes running now: 0
      170712 16:02:48 mysqld_safe mysqld restarted
      2017-07-12 16:02:49 140496719788000 [Note] /usr/sbin/mysqld (mysqld 10.2.6-MariaDB) starting as process 17534 ...
      

      Attachments

        Issue Links

          Activity

            elenst Elena Stepanova added a comment - - edited

            --source include/have_innodb.inc
             
            CREATE TABLE t1 (a varchar(8)) ENGINE=InnoDB;
            INSERT INTO t1 VALUES ('foo'),('bar');
             
            CREATE TABLE t2 (b varchar(8)) ENGINE=InnoDB;
            INSERT INTO t2 VALUES ('foo'),('bar');
             
            CREATE VIEW v1 AS select distinct a from t1;
             
            CREATE PROCEDURE pr()
              select * from t2 where b not in (select distinct(a) from v1);
             
            show create procedure pr;
            call pr();
             
            # Cleanup
            drop procedure pr;
            drop view v1;
            drop table t1, t2;
            

            Note: Most likely it has the same root cause as MDEV-13174, but the stack trace is somewhat different here, so it makes sense to recheck both when one is fixed.

            10.2 488f46f3de51070fa91e5eadcc215b6a4e343f7b

            #3  <signal handler called>
            #4  0x000055c87d7aa4b4 in Time_and_counter_tracker::incr_loops (this=0x80) at /data/src/10.2/sql/sql_analyze_stmt.h:97
            #5  0x000055c87d76e70b in JOIN::exec (this=0x7fddd0041188) at /data/src/10.2/sql/sql_select.cc:3277
            #6  0x000055c87da64fa7 in subselect_hash_sj_engine::exec (this=0x7fddd004d798) at /data/src/10.2/sql/item_subselect.cc:5419
            #7  0x000055c87da56f87 in Item_subselect::exec (this=0x7fddd0035f20) at /data/src/10.2/sql/item_subselect.cc:715
            #8  0x000055c87da5759c in Item_in_subselect::exec (this=0x7fddd0035f20) at /data/src/10.2/sql/item_subselect.cc:895
            #9  0x000055c87da5a0d3 in Item_in_subselect::val_bool (this=0x7fddd0035f20) at /data/src/10.2/sql/item_subselect.cc:1743
            #10 0x000055c87d662c7b in Item::val_bool_result (this=0x7fddd0035f20) at /data/src/10.2/sql/item.h:1182
            #11 0x000055c87d9d3b80 in Item_in_optimizer::val_int (this=0x7fddd0043ec0) at /data/src/10.2/sql/item_cmpfunc.cc:1621
            #12 0x000055c87d662bef in Item::val_int_result (this=0x7fddd0043ec0) at /data/src/10.2/sql/item.h:1178
            #13 0x000055c87d9c1a15 in Item_cache_int::cache_value (this=0x7fddd0051f60) at /data/src/10.2/sql/item.cc:9550
            #14 0x000055c87d9cb81e in Item_cache_wrapper::cache (this=0x7fddd0051ea8) at /data/src/10.2/sql/item.cc:8273
            #15 0x000055c87d9be290 in Item_cache_wrapper::val_bool (this=0x7fddd0051ea8) at /data/src/10.2/sql/item.cc:8437
            #16 0x000055c87d9cfbd0 in Item_func_not::val_int (this=0x7fddd0036160) at /data/src/10.2/sql/item_cmpfunc.cc:284
            #17 0x000055c87d795818 in evaluate_join_record (join=0x7fddd0040c20, join_tab=0x7fddd0047708, error=0) at /data/src/10.2/sql/sql_select.cc:18649
            #18 0x000055c87d795452 in sub_select (join=0x7fddd0040c20, join_tab=0x7fddd0047708, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18554
            #19 0x000055c87d7949eb in do_select (join=0x7fddd0040c20, procedure=0x0) at /data/src/10.2/sql/sql_select.cc:18098
            #20 0x000055c87d76f299 in JOIN::exec_inner (this=0x7fddd0040c20) at /data/src/10.2/sql/sql_select.cc:3483
            #21 0x000055c87d76e748 in JOIN::exec (this=0x7fddd0040c20) at /data/src/10.2/sql/sql_select.cc:3278
            #22 0x000055c87d76f911 in mysql_select (thd=0x7fddd0000b00, tables=0x7fddd00352b8, wild_num=1, fields=..., conds=0x7fddd0036160, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147749632, result=0x7fddd0040c00, unit=0x7fddd0036ac0, select_lex=0x7fddd00371f8) at /data/src/10.2/sql/sql_select.cc:3678
            #23 0x000055c87d76423c in handle_select (thd=0x7fddd0000b00, lex=0x7fddd00369f8, result=0x7fddd0040c00, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:373
            #24 0x000055c87d73011a in execute_sqlcom_select (thd=0x7fddd0000b00, all_tables=0x7fddd00352b8) at /data/src/10.2/sql/sql_parse.cc:6443
            #25 0x000055c87d726159 in mysql_execute_command (thd=0x7fddd0000b00) at /data/src/10.2/sql/sql_parse.cc:3458
            #26 0x000055c87db120bc in sp_instr_stmt::exec_core (this=0x7fddd0036228, thd=0x7fddd0000b00, nextp=0x7fde1c3551c4) at /data/src/10.2/sql/sp_head.cc:3235
            #27 0x000055c87db1172d in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fddd0036268, thd=0x7fddd0000b00, nextp=0x7fde1c3551c4, open_tables=false, instr=0x7fddd0036228) at /data/src/10.2/sql/sp_head.cc:2998
            #28 0x000055c87db11d67 in sp_instr_stmt::execute (this=0x7fddd0036228, thd=0x7fddd0000b00, nextp=0x7fde1c3551c4) at /data/src/10.2/sql/sp_head.cc:3151
            #29 0x000055c87db0cfac in sp_head::execute (this=0x7fddd00344d8, thd=0x7fddd0000b00, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1324
            #30 0x000055c87db0f037 in sp_head::execute_procedure (this=0x7fddd00344d8, thd=0x7fddd0000b00, args=0x7fddd00052f8) at /data/src/10.2/sql/sp_head.cc:2113
            #31 0x000055c87d72483e in do_execute_sp (thd=0x7fddd0000b00, sp=0x7fddd00344d8) at /data/src/10.2/sql/sql_parse.cc:2889
            #32 0x000055c87d72d8f4 in mysql_execute_command (thd=0x7fddd0000b00) at /data/src/10.2/sql/sql_parse.cc:5799
            #33 0x000055c87d733ada in mysql_parse (thd=0x7fddd0000b00, rawbuf=0x7fddd0012378 "call pr()", length=9, parser_state=0x7fde1c356200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7879
            #34 0x000055c87d721b86 in dispatch_command (command=COM_QUERY, thd=0x7fddd0000b00, packet=0x7fddd013e9e1 "", packet_length=9, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1817
            #35 0x000055c87d7204c7 in do_command (thd=0x7fddd0000b00) at /data/src/10.2/sql/sql_parse.cc:1362
            #36 0x000055c87d86c259 in do_handle_one_connection (connect=0x55c880efeee0) at /data/src/10.2/sql/sql_connect.cc:1354
            #37 0x000055c87d86bfe6 in handle_one_connection (arg=0x55c880efeee0) at /data/src/10.2/sql/sql_connect.cc:1260
            #38 0x000055c87dc86300 in pfs_spawn_thread (arg=0x55c880e49f20) at /data/src/10.2/storage/perfschema/pfs.cc:1862
            #39 0x00007fde26630494 in start_thread (arg=0x7fde1c357700) at pthread_create.c:333
            #40 0x00007fde247a893f in clone () from /lib/x86_64-linux-gnu/libc.so.6
            

            10.1 56959e7b2ce621980bad1445a0a659c2b0fb4c83

            #3  <signal handler called>
            #4  0x0000561b551f50fa in Time_and_counter_tracker::incr_loops (this=0x78) at /data/src/10.1/sql/sql_analyze_stmt.h:97
            #5  0x0000561b551b813b in JOIN::exec (this=0x7f3d3b22a7c0) at /data/src/10.1/sql/sql_select.cc:2510
            #6  0x0000561b55461c51 in subselect_hash_sj_engine::exec (this=0x7f3d3b234bd0) at /data/src/10.1/sql/item_subselect.cc:5399
            #7  0x0000561b55454d25 in Item_subselect::exec (this=0x7f3d3b12fbd0) at /data/src/10.1/sql/item_subselect.cc:710
            #8  0x0000561b554552c6 in Item_in_subselect::exec (this=0x7f3d3b12fbd0) at /data/src/10.1/sql/item_subselect.cc:888
            #9  0x0000561b55457a73 in Item_in_subselect::val_bool (this=0x7f3d3b12fbd0) at /data/src/10.1/sql/item_subselect.cc:1734
            #10 0x0000561b550c2c25 in Item::val_bool_result (this=0x7f3d3b12fbd0) at /data/src/10.1/sql/item.h:1038
            #11 0x0000561b553e91d8 in Item_in_optimizer::val_int (this=0x7f3d3b22d7a0) at /data/src/10.1/sql/item_cmpfunc.cc:1634
            #12 0x0000561b550c2b99 in Item::val_int_result (this=0x7f3d3b22d7a0) at /data/src/10.1/sql/item.h:1034
            #13 0x0000561b553db205 in Item_cache_int::cache_value (this=0x7f3d3b28b520) at /data/src/10.1/sql/item.cc:8891
            #14 0x0000561b553e2d60 in Item_cache_wrapper::cache (this=0x7f3d3b28b470) at /data/src/10.1/sql/item.cc:7738
            #15 0x0000561b553d83f8 in Item_cache_wrapper::val_bool (this=0x7f3d3b28b470) at /data/src/10.1/sql/item.cc:7902
            #16 0x0000561b553e5322 in Item_func_not::val_int (this=0x7f3d3b12fdc8) at /data/src/10.1/sql/item_cmpfunc.cc:284
            #17 0x0000561b551e1005 in evaluate_join_record (join=0x7f3d3b22a228, join_tab=0x7f3d3b2306c8, error=0) at /data/src/10.1/sql/sql_select.cc:18497
            #18 0x0000561b551e0c2f in sub_select (join=0x7f3d3b22a228, join_tab=0x7f3d3b2306c8, end_of_records=false) at /data/src/10.1/sql/sql_select.cc:18398
            #19 0x0000561b551e0492 in do_select (join=0x7f3d3b22a228, fields=0x7f3d3b12e968, table=0x0, procedure=0x0) at /data/src/10.1/sql/sql_select.cc:18053
            #20 0x0000561b551baf00 in JOIN::exec_inner (this=0x7f3d3b22a228) at /data/src/10.1/sql/sql_select.cc:3225
            #21 0x0000561b551b8191 in JOIN::exec (this=0x7f3d3b22a228) at /data/src/10.1/sql/sql_select.cc:2512
            #22 0x0000561b551bb727 in mysql_select (thd=0x7f3d473c7070, rref_pointer_array=0x7f3d3b12eae0, tables=0x7f3d3b131e90, wild_num=1, fields=..., conds=0x7f3d3b12fdc8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147749632, result=0x7f3d3b22a208, unit=0x7f3d3b12e150, select_lex=0x7f3d3b12e850) at /data/src/10.1/sql/sql_select.cc:3449
            #23 0x0000561b551b114c in handle_select (thd=0x7f3d473c7070, lex=0x7f3d3b12e088, result=0x7f3d3b22a208, setup_tables_done_option=0) at /data/src/10.1/sql/sql_select.cc:384
            #24 0x0000561b55180ff6 in execute_sqlcom_select (thd=0x7f3d473c7070, all_tables=0x7f3d3b131e90) at /data/src/10.1/sql/sql_parse.cc:5923
            #25 0x0000561b551774f2 in mysql_execute_command (thd=0x7f3d473c7070) at /data/src/10.1/sql/sql_parse.cc:2980
            #26 0x0000561b55503e9a in sp_instr_stmt::exec_core (this=0x7f3d3b12fe88, thd=0x7f3d473c7070, nextp=0x7f3d52df9624) at /data/src/10.1/sql/sp_head.cc:3212
            #27 0x0000561b5550358c in sp_lex_keeper::reset_lex_and_exec_core (this=0x7f3d3b12fec8, thd=0x7f3d473c7070, nextp=0x7f3d52df9624, open_tables=false, instr=0x7f3d3b12fe88) at /data/src/10.1/sql/sp_head.cc:2978
            #28 0x0000561b55503b60 in sp_instr_stmt::execute (this=0x7f3d3b12fe88, thd=0x7f3d473c7070, nextp=0x7f3d52df9624) at /data/src/10.1/sql/sp_head.cc:3128
            #29 0x0000561b554ff426 in sp_head::execute (this=0x7f3d3b131088, thd=0x7f3d473c7070, merge_da_on_success=true) at /data/src/10.1/sql/sp_head.cc:1316
            #30 0x0000561b555012c0 in sp_head::execute_procedure (this=0x7f3d3b131088, thd=0x7f3d473c7070, args=0x7f3d473cb728) at /data/src/10.1/sql/sp_head.cc:2103
            #31 0x0000561b55175bed in do_execute_sp (thd=0x7f3d473c7070, sp=0x7f3d3b131088) at /data/src/10.1/sql/sql_parse.cc:2412
            #32 0x0000561b5517eb00 in mysql_execute_command (thd=0x7f3d473c7070) at /data/src/10.1/sql/sql_parse.cc:5285
            #33 0x0000561b55184701 in mysql_parse (thd=0x7f3d473c7070, rawbuf=0x7f3d3b0fa088 "call pr()", length=9, parser_state=0x7f3d52dfa5e0) at /data/src/10.1/sql/sql_parse.cc:7339
            #34 0x0000561b551736ec in dispatch_command (command=COM_QUERY, thd=0x7f3d473c7070, packet=0x7f3d49321071 "", packet_length=9) at /data/src/10.1/sql/sql_parse.cc:1490
            #35 0x0000561b5517244b in do_command (thd=0x7f3d473c7070) at /data/src/10.1/sql/sql_parse.cc:1109
            #36 0x0000561b552a9fb5 in do_handle_one_connection (thd_arg=0x7f3d473c7070) at /data/src/10.1/sql/sql_connect.cc:1349
            #37 0x0000561b552a9d19 in handle_one_connection (arg=0x7f3d473c7070) at /data/src/10.1/sql/sql_connect.cc:1261
            #38 0x0000561b55660bda in pfs_spawn_thread (arg=0x7f3d492ea970) at /data/src/10.1/storage/perfschema/pfs.cc:1860
            #39 0x00007f3d52a8a494 in start_thread (arg=0x7f3d52dfbb00) at pthread_create.c:333
            #40 0x00007f3d50bd593f in clone () from /lib/x86_64-linux-gnu/libc.so.6
            

            elenst Elena Stepanova added a comment - - edited --source include/have_innodb.inc   CREATE TABLE t1 (a varchar (8)) ENGINE=InnoDB; INSERT INTO t1 VALUES ( 'foo' ),( 'bar' );   CREATE TABLE t2 (b varchar (8)) ENGINE=InnoDB; INSERT INTO t2 VALUES ( 'foo' ),( 'bar' );   CREATE VIEW v1 AS select distinct a from t1;   CREATE PROCEDURE pr() select * from t2 where b not in ( select distinct (a) from v1);   show create procedure pr; call pr();   # Cleanup drop procedure pr; drop view v1; drop table t1, t2; Note: Most likely it has the same root cause as MDEV-13174 , but the stack trace is somewhat different here, so it makes sense to recheck both when one is fixed. 10.2 488f46f3de51070fa91e5eadcc215b6a4e343f7b #3 <signal handler called> #4 0x000055c87d7aa4b4 in Time_and_counter_tracker::incr_loops (this=0x80) at /data/src/10.2/sql/sql_analyze_stmt.h:97 #5 0x000055c87d76e70b in JOIN::exec (this=0x7fddd0041188) at /data/src/10.2/sql/sql_select.cc:3277 #6 0x000055c87da64fa7 in subselect_hash_sj_engine::exec (this=0x7fddd004d798) at /data/src/10.2/sql/item_subselect.cc:5419 #7 0x000055c87da56f87 in Item_subselect::exec (this=0x7fddd0035f20) at /data/src/10.2/sql/item_subselect.cc:715 #8 0x000055c87da5759c in Item_in_subselect::exec (this=0x7fddd0035f20) at /data/src/10.2/sql/item_subselect.cc:895 #9 0x000055c87da5a0d3 in Item_in_subselect::val_bool (this=0x7fddd0035f20) at /data/src/10.2/sql/item_subselect.cc:1743 #10 0x000055c87d662c7b in Item::val_bool_result (this=0x7fddd0035f20) at /data/src/10.2/sql/item.h:1182 #11 0x000055c87d9d3b80 in Item_in_optimizer::val_int (this=0x7fddd0043ec0) at /data/src/10.2/sql/item_cmpfunc.cc:1621 #12 0x000055c87d662bef in Item::val_int_result (this=0x7fddd0043ec0) at /data/src/10.2/sql/item.h:1178 #13 0x000055c87d9c1a15 in Item_cache_int::cache_value (this=0x7fddd0051f60) at /data/src/10.2/sql/item.cc:9550 #14 0x000055c87d9cb81e in Item_cache_wrapper::cache (this=0x7fddd0051ea8) at /data/src/10.2/sql/item.cc:8273 #15 0x000055c87d9be290 in Item_cache_wrapper::val_bool (this=0x7fddd0051ea8) at /data/src/10.2/sql/item.cc:8437 #16 0x000055c87d9cfbd0 in Item_func_not::val_int (this=0x7fddd0036160) at /data/src/10.2/sql/item_cmpfunc.cc:284 #17 0x000055c87d795818 in evaluate_join_record (join=0x7fddd0040c20, join_tab=0x7fddd0047708, error=0) at /data/src/10.2/sql/sql_select.cc:18649 #18 0x000055c87d795452 in sub_select (join=0x7fddd0040c20, join_tab=0x7fddd0047708, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18554 #19 0x000055c87d7949eb in do_select (join=0x7fddd0040c20, procedure=0x0) at /data/src/10.2/sql/sql_select.cc:18098 #20 0x000055c87d76f299 in JOIN::exec_inner (this=0x7fddd0040c20) at /data/src/10.2/sql/sql_select.cc:3483 #21 0x000055c87d76e748 in JOIN::exec (this=0x7fddd0040c20) at /data/src/10.2/sql/sql_select.cc:3278 #22 0x000055c87d76f911 in mysql_select (thd=0x7fddd0000b00, tables=0x7fddd00352b8, wild_num=1, fields=..., conds=0x7fddd0036160, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147749632, result=0x7fddd0040c00, unit=0x7fddd0036ac0, select_lex=0x7fddd00371f8) at /data/src/10.2/sql/sql_select.cc:3678 #23 0x000055c87d76423c in handle_select (thd=0x7fddd0000b00, lex=0x7fddd00369f8, result=0x7fddd0040c00, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:373 #24 0x000055c87d73011a in execute_sqlcom_select (thd=0x7fddd0000b00, all_tables=0x7fddd00352b8) at /data/src/10.2/sql/sql_parse.cc:6443 #25 0x000055c87d726159 in mysql_execute_command (thd=0x7fddd0000b00) at /data/src/10.2/sql/sql_parse.cc:3458 #26 0x000055c87db120bc in sp_instr_stmt::exec_core (this=0x7fddd0036228, thd=0x7fddd0000b00, nextp=0x7fde1c3551c4) at /data/src/10.2/sql/sp_head.cc:3235 #27 0x000055c87db1172d in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fddd0036268, thd=0x7fddd0000b00, nextp=0x7fde1c3551c4, open_tables=false, instr=0x7fddd0036228) at /data/src/10.2/sql/sp_head.cc:2998 #28 0x000055c87db11d67 in sp_instr_stmt::execute (this=0x7fddd0036228, thd=0x7fddd0000b00, nextp=0x7fde1c3551c4) at /data/src/10.2/sql/sp_head.cc:3151 #29 0x000055c87db0cfac in sp_head::execute (this=0x7fddd00344d8, thd=0x7fddd0000b00, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1324 #30 0x000055c87db0f037 in sp_head::execute_procedure (this=0x7fddd00344d8, thd=0x7fddd0000b00, args=0x7fddd00052f8) at /data/src/10.2/sql/sp_head.cc:2113 #31 0x000055c87d72483e in do_execute_sp (thd=0x7fddd0000b00, sp=0x7fddd00344d8) at /data/src/10.2/sql/sql_parse.cc:2889 #32 0x000055c87d72d8f4 in mysql_execute_command (thd=0x7fddd0000b00) at /data/src/10.2/sql/sql_parse.cc:5799 #33 0x000055c87d733ada in mysql_parse (thd=0x7fddd0000b00, rawbuf=0x7fddd0012378 "call pr()", length=9, parser_state=0x7fde1c356200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7879 #34 0x000055c87d721b86 in dispatch_command (command=COM_QUERY, thd=0x7fddd0000b00, packet=0x7fddd013e9e1 "", packet_length=9, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1817 #35 0x000055c87d7204c7 in do_command (thd=0x7fddd0000b00) at /data/src/10.2/sql/sql_parse.cc:1362 #36 0x000055c87d86c259 in do_handle_one_connection (connect=0x55c880efeee0) at /data/src/10.2/sql/sql_connect.cc:1354 #37 0x000055c87d86bfe6 in handle_one_connection (arg=0x55c880efeee0) at /data/src/10.2/sql/sql_connect.cc:1260 #38 0x000055c87dc86300 in pfs_spawn_thread (arg=0x55c880e49f20) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #39 0x00007fde26630494 in start_thread (arg=0x7fde1c357700) at pthread_create.c:333 #40 0x00007fde247a893f in clone () from /lib/x86_64-linux-gnu/libc.so.6 10.1 56959e7b2ce621980bad1445a0a659c2b0fb4c83 #3 <signal handler called> #4 0x0000561b551f50fa in Time_and_counter_tracker::incr_loops (this=0x78) at /data/src/10.1/sql/sql_analyze_stmt.h:97 #5 0x0000561b551b813b in JOIN::exec (this=0x7f3d3b22a7c0) at /data/src/10.1/sql/sql_select.cc:2510 #6 0x0000561b55461c51 in subselect_hash_sj_engine::exec (this=0x7f3d3b234bd0) at /data/src/10.1/sql/item_subselect.cc:5399 #7 0x0000561b55454d25 in Item_subselect::exec (this=0x7f3d3b12fbd0) at /data/src/10.1/sql/item_subselect.cc:710 #8 0x0000561b554552c6 in Item_in_subselect::exec (this=0x7f3d3b12fbd0) at /data/src/10.1/sql/item_subselect.cc:888 #9 0x0000561b55457a73 in Item_in_subselect::val_bool (this=0x7f3d3b12fbd0) at /data/src/10.1/sql/item_subselect.cc:1734 #10 0x0000561b550c2c25 in Item::val_bool_result (this=0x7f3d3b12fbd0) at /data/src/10.1/sql/item.h:1038 #11 0x0000561b553e91d8 in Item_in_optimizer::val_int (this=0x7f3d3b22d7a0) at /data/src/10.1/sql/item_cmpfunc.cc:1634 #12 0x0000561b550c2b99 in Item::val_int_result (this=0x7f3d3b22d7a0) at /data/src/10.1/sql/item.h:1034 #13 0x0000561b553db205 in Item_cache_int::cache_value (this=0x7f3d3b28b520) at /data/src/10.1/sql/item.cc:8891 #14 0x0000561b553e2d60 in Item_cache_wrapper::cache (this=0x7f3d3b28b470) at /data/src/10.1/sql/item.cc:7738 #15 0x0000561b553d83f8 in Item_cache_wrapper::val_bool (this=0x7f3d3b28b470) at /data/src/10.1/sql/item.cc:7902 #16 0x0000561b553e5322 in Item_func_not::val_int (this=0x7f3d3b12fdc8) at /data/src/10.1/sql/item_cmpfunc.cc:284 #17 0x0000561b551e1005 in evaluate_join_record (join=0x7f3d3b22a228, join_tab=0x7f3d3b2306c8, error=0) at /data/src/10.1/sql/sql_select.cc:18497 #18 0x0000561b551e0c2f in sub_select (join=0x7f3d3b22a228, join_tab=0x7f3d3b2306c8, end_of_records=false) at /data/src/10.1/sql/sql_select.cc:18398 #19 0x0000561b551e0492 in do_select (join=0x7f3d3b22a228, fields=0x7f3d3b12e968, table=0x0, procedure=0x0) at /data/src/10.1/sql/sql_select.cc:18053 #20 0x0000561b551baf00 in JOIN::exec_inner (this=0x7f3d3b22a228) at /data/src/10.1/sql/sql_select.cc:3225 #21 0x0000561b551b8191 in JOIN::exec (this=0x7f3d3b22a228) at /data/src/10.1/sql/sql_select.cc:2512 #22 0x0000561b551bb727 in mysql_select (thd=0x7f3d473c7070, rref_pointer_array=0x7f3d3b12eae0, tables=0x7f3d3b131e90, wild_num=1, fields=..., conds=0x7f3d3b12fdc8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147749632, result=0x7f3d3b22a208, unit=0x7f3d3b12e150, select_lex=0x7f3d3b12e850) at /data/src/10.1/sql/sql_select.cc:3449 #23 0x0000561b551b114c in handle_select (thd=0x7f3d473c7070, lex=0x7f3d3b12e088, result=0x7f3d3b22a208, setup_tables_done_option=0) at /data/src/10.1/sql/sql_select.cc:384 #24 0x0000561b55180ff6 in execute_sqlcom_select (thd=0x7f3d473c7070, all_tables=0x7f3d3b131e90) at /data/src/10.1/sql/sql_parse.cc:5923 #25 0x0000561b551774f2 in mysql_execute_command (thd=0x7f3d473c7070) at /data/src/10.1/sql/sql_parse.cc:2980 #26 0x0000561b55503e9a in sp_instr_stmt::exec_core (this=0x7f3d3b12fe88, thd=0x7f3d473c7070, nextp=0x7f3d52df9624) at /data/src/10.1/sql/sp_head.cc:3212 #27 0x0000561b5550358c in sp_lex_keeper::reset_lex_and_exec_core (this=0x7f3d3b12fec8, thd=0x7f3d473c7070, nextp=0x7f3d52df9624, open_tables=false, instr=0x7f3d3b12fe88) at /data/src/10.1/sql/sp_head.cc:2978 #28 0x0000561b55503b60 in sp_instr_stmt::execute (this=0x7f3d3b12fe88, thd=0x7f3d473c7070, nextp=0x7f3d52df9624) at /data/src/10.1/sql/sp_head.cc:3128 #29 0x0000561b554ff426 in sp_head::execute (this=0x7f3d3b131088, thd=0x7f3d473c7070, merge_da_on_success=true) at /data/src/10.1/sql/sp_head.cc:1316 #30 0x0000561b555012c0 in sp_head::execute_procedure (this=0x7f3d3b131088, thd=0x7f3d473c7070, args=0x7f3d473cb728) at /data/src/10.1/sql/sp_head.cc:2103 #31 0x0000561b55175bed in do_execute_sp (thd=0x7f3d473c7070, sp=0x7f3d3b131088) at /data/src/10.1/sql/sql_parse.cc:2412 #32 0x0000561b5517eb00 in mysql_execute_command (thd=0x7f3d473c7070) at /data/src/10.1/sql/sql_parse.cc:5285 #33 0x0000561b55184701 in mysql_parse (thd=0x7f3d473c7070, rawbuf=0x7f3d3b0fa088 "call pr()", length=9, parser_state=0x7f3d52dfa5e0) at /data/src/10.1/sql/sql_parse.cc:7339 #34 0x0000561b551736ec in dispatch_command (command=COM_QUERY, thd=0x7f3d473c7070, packet=0x7f3d49321071 "", packet_length=9) at /data/src/10.1/sql/sql_parse.cc:1490 #35 0x0000561b5517244b in do_command (thd=0x7f3d473c7070) at /data/src/10.1/sql/sql_parse.cc:1109 #36 0x0000561b552a9fb5 in do_handle_one_connection (thd_arg=0x7f3d473c7070) at /data/src/10.1/sql/sql_connect.cc:1349 #37 0x0000561b552a9d19 in handle_one_connection (arg=0x7f3d473c7070) at /data/src/10.1/sql/sql_connect.cc:1261 #38 0x0000561b55660bda in pfs_spawn_thread (arg=0x7f3d492ea970) at /data/src/10.1/storage/perfschema/pfs.cc:1860 #39 0x00007f3d52a8a494 in start_thread (arg=0x7f3d52dfbb00) at pthread_create.c:333 #40 0x00007f3d50bd593f in clone () from /lib/x86_64-linux-gnu/libc.so.6
            sanja Oleksandr Byelkin added a comment - It is duplicate of https://jira.mariadb.org/browse/MDEV-10972

            People

              sanja Oleksandr Byelkin
              ben Ben Stillman
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.