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

Server crashes in Item::fix_fields_if_needed / table_value_constr::prepare upon 2nd execution of PS

    XMLWordPrintable

Details

    Description

      The failure is scalable and is not limited to low levels of the threshold. The crash happens whenever the number of elements in the IN list equals or exceeds the threshold value.

      SET NAMES latin1;
       
      CREATE TABLE t1 (f VARCHAR(8) CHARACTER SET utf8, i INT);
      INSERT INTO t1 VALUES ('foo',1),('bar',2);
       
      SET in_predicate_conversion_threshold= 3;
      PREPARE stmt FROM "SELECT * FROM t1 WHERE (f IN ('a','b','c') AND i = 10)";
      EXECUTE stmt;
      EXECUTE stmt;
      

      10.3 f3f23b5c

      #3  <signal handler called>
      #4  0x0000000000000000 in ?? ()
      #5  0x0000558dec49e0dd in Item::check_is_evaluable_expression_or_error (this=0x7fe0800130e8) at /data/src/10.3/sql/item.h:1367
      #6  0x0000558dec49b193 in fix_fields_for_tvc (thd=0x7fe080000af0, li=...) at /data/src/10.3/sql/sql_tvc.cc:63
      #7  0x0000558dec49b81f in table_value_constr::prepare (this=0x7fe0800828a0, thd=0x7fe080000af0, sl=0x7fe080081c40, tmp_result=0x7fe0800131d0, unit_arg=0x7fe080082058) at /data/src/10.3/sql/sql_tvc.cc:238
      #8  0x0000558dec37aac0 in st_select_lex_unit::prepare (this=0x7fe080082058, derived_arg=0x7fe080082918, sel_result=0x7fe0800130e8, additional_options=0) at /data/src/10.3/sql/sql_union.cc:1018
      #9  0x0000558dec22e072 in mysql_derived_prepare (thd=0x7fe080000af0, lex=0x7fe08007e050, derived=0x7fe080082918) at /data/src/10.3/sql/sql_derived.cc:770
      #10 0x0000558dec22cbfe in mysql_handle_single_derived (lex=0x7fe08007e050, derived=0x7fe080082918, phases=2) at /data/src/10.3/sql/sql_derived.cc:199
      #11 0x0000558dec3ab028 in TABLE_LIST::handle_derived (this=0x7fe080082918, lex=0x7fe08007e050, phases=2) at /data/src/10.3/sql/table.cc:8356
      #12 0x0000558dec246c44 in LEX::handle_list_of_derived (this=0x7fe08007e050, table_list=0x7fe08007f9d0, phases=2) at /data/src/10.3/sql/sql_lex.h:3997
      #13 0x0000558dec252c72 in st_select_lex::handle_derived (this=0x7fe08007e898, lex=0x7fe08007e050, phases=2) at /data/src/10.3/sql/sql_lex.cc:4143
      #14 0x0000558dec2c0db3 in JOIN::prepare (this=0x7fe080012b80, tables_init=0x7fe08007f9d0, wild_num=0, conds_init=0x7fe080012948, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7fe08007e898, unit_arg=0x7fe08007e110) at /data/src/10.3/sql/sql_select.cc:1045
      #15 0x0000558dec2ccbb8 in mysql_select (thd=0x7fe080000af0, tables=0x7fe08007f9d0, wild_num=0, fields=..., conds=0x7fe080012948, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7fe080080958, unit=0x7fe08007e110, select_lex=0x7fe08007e898) at /data/src/10.3/sql/sql_select.cc:4293
      #16 0x0000558dec2be24a in handle_select (thd=0x7fe080000af0, lex=0x7fe08007e050, result=0x7fe080080958, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:370
      #17 0x0000558dec285b98 in execute_sqlcom_select (thd=0x7fe080000af0, all_tables=0x7fe08007f9d0) at /data/src/10.3/sql/sql_parse.cc:6286
      #18 0x0000558dec27c2eb in mysql_execute_command (thd=0x7fe080000af0) at /data/src/10.3/sql/sql_parse.cc:3812
      #19 0x0000558dec2a9444 in Prepared_statement::execute (this=0x7fe080073e90, expanded_query=0x7fe092bd5c70, open_cursor=false) at /data/src/10.3/sql/sql_prepare.cc:4812
      #20 0x0000558dec2a76ae in Prepared_statement::execute_loop (this=0x7fe080073e90, expanded_query=0x7fe092bd5c70, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/10.3/sql/sql_prepare.cc:4240
      #21 0x0000558dec2a518e in mysql_sql_stmt_execute (thd=0x7fe080000af0) at /data/src/10.3/sql/sql_prepare.cc:3348
      #22 0x0000558dec27c330 in mysql_execute_command (thd=0x7fe080000af0) at /data/src/10.3/sql/sql_parse.cc:3828
      #23 0x0000558dec289ea3 in mysql_parse (thd=0x7fe080000af0, rawbuf=0x7fe080012818 "EXECUTE stmt", length=12, parser_state=0x7fe092bd65e0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7810
      #24 0x0000558dec2766ea in dispatch_command (command=COM_QUERY, thd=0x7fe080000af0, packet=0x7fe0801234f1 "EXECUTE stmt", packet_length=12, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1848
      #25 0x0000558dec275002 in do_command (thd=0x7fe080000af0) at /data/src/10.3/sql/sql_parse.cc:1393
      #26 0x0000558dec3ee4d7 in do_handle_one_connection (connect=0x558def4832e0) at /data/src/10.3/sql/sql_connect.cc:1403
      #27 0x0000558dec3ee239 in handle_one_connection (arg=0x558def4832e0) at /data/src/10.3/sql/sql_connect.cc:1308
      #28 0x0000558decda50e8 in pfs_spawn_thread (arg=0x558def49e390) at /data/src/10.3/storage/perfschema/pfs.cc:1869
      #29 0x00007fe09a9604a4 in start_thread (arg=0x7fe092bd7700) at pthread_create.c:456
      #30 0x00007fe098a94d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      A much stranger stack trace on 10.5:

      10.5 30e7a0a8

      #3  <signal handler called>
      #4  0x000055cefa45632c in base_list_iterator::next_fast (this=0x7f85b027e570) at /data/src/10.5/sql/sql_list.h:441
      #5  0x000055cefa4677f3 in List_iterator_fast<Item>::operator++ (this=0x7f85b027e570) at /data/src/10.5/sql/sql_list.h:620
      #6  0x000055cefa6b9e91 in get_table_map (items=0xa5a5a5a5a5a5a5a5) at /data/src/10.5/sql/sql_update.cc:1459
      #7  0x000055cefa6bb6c3 in multi_update::prepare (this=0x7f85940141b8, not_used_values=..., lex_unit=0x7f85940141b8) at /data/src/10.5/sql/sql_update.cc:1988
      #8  0x000055cefa80d76f in Item::check_is_evaluable_expression_or_error (this=0x7f85940141b8) at /data/src/10.5/sql/item.h:1625
      #9  0x000055cefa80a767 in fix_fields_for_tvc (thd=0x7f8594000b18, li=...) at /data/src/10.5/sql/sql_tvc.cc:93
      #10 0x000055cefa80addd in table_value_constr::prepare (this=0x7f859406baf8, thd=0x7f8594000b18, sl=0x7f859406add8, tmp_result=0x7f8594014298, unit_arg=0x7f859406b238) at /data/src/10.5/sql/sql_tvc.cc:268
      #11 0x000055cefa6af8b9 in st_select_lex_unit::prepare (this=0x7f859406b238, derived_arg=0x7f859406c110, sel_result=0x7f85940141b8, additional_options=0) at /data/src/10.5/sql/sql_union.cc:1543
      #12 0x000055cefa537d63 in mysql_derived_prepare (thd=0x7f8594000b18, lex=0x7f8594065da8, derived=0x7f859406c110) at /data/src/10.5/sql/sql_derived.cc:816
      #13 0x000055cefa5363d6 in mysql_handle_single_derived (lex=0x7f8594065da8, derived=0x7f859406c110, phases=2) at /data/src/10.5/sql/sql_derived.cc:206
      #14 0x000055cefa6e3dee in TABLE_LIST::handle_derived (this=0x7f859406c110, lex=0x7f8594065da8, phases=2) at /data/src/10.5/sql/table.cc:9087
      #15 0x000055cefa5521ea in LEX::handle_list_of_derived (this=0x7f8594065da8, table_list=0x7f8594067ff0, phases=2) at /data/src/10.5/sql/sql_lex.h:4416
      #16 0x000055cefa560066 in st_select_lex::handle_derived (this=0x7f85940679f8, lex=0x7f8594065da8, phases=2) at /data/src/10.5/sql/sql_lex.cc:4850
      #17 0x000055cefa5dacc3 in JOIN::prepare (this=0x7f8594013c40, tables_init=0x7f8594067ff0, conds_init=0x7f85940139f0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f85940679f8, unit_arg=0x7f8594065e70) at /data/src/10.5/sql/sql_select.cc:1149
      #18 0x000055cefa5e7de6 in mysql_select (thd=0x7f8594000b18, tables=0x7f8594067ff0, fields=..., conds=0x7f85940139f0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2201171004160, result=0x7f8594069990, unit=0x7f8594065e70, select_lex=0x7f85940679f8) at /data/src/10.5/sql/sql_select.cc:4619
      #19 0x000055cefa5d7c30 in handle_select (thd=0x7f8594000b18, lex=0x7f8594065da8, result=0x7f8594069990, setup_tables_done_option=0) at /data/src/10.5/sql/sql_select.cc:429
      #20 0x000055cefa59d276 in execute_sqlcom_select (thd=0x7f8594000b18, all_tables=0x7f8594067ff0) at /data/src/10.5/sql/sql_parse.cc:6209
      #21 0x000055cefa59451d in mysql_execute_command (thd=0x7f8594000b18) at /data/src/10.5/sql/sql_parse.cc:3931
      #22 0x000055cefa5c1ff5 in Prepared_statement::execute (this=0x7f8594065938, expanded_query=0x7f85b0280cc0, open_cursor=false) at /data/src/10.5/sql/sql_prepare.cc:4791
      #23 0x000055cefa5c04aa in Prepared_statement::execute_loop (this=0x7f8594065938, expanded_query=0x7f85b0280cc0, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/10.5/sql/sql_prepare.cc:4280
      #24 0x000055cefa5bdf17 in mysql_sql_stmt_execute (thd=0x7f8594000b18) at /data/src/10.5/sql/sql_prepare.cc:3392
      #25 0x000055cefa594562 in mysql_execute_command (thd=0x7f8594000b18) at /data/src/10.5/sql/sql_parse.cc:3947
      #26 0x000055cefa5a20c3 in mysql_parse (thd=0x7f8594000b18, rawbuf=0x7f85940138d0 "EXECUTE stmt", length=12, parser_state=0x7f85b0281520, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:7993
      #27 0x000055cefa58e3bc in dispatch_command (command=COM_QUERY, thd=0x7f8594000b18, packet=0x7f85941af209 "EXECUTE stmt", packet_length=12, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1867
      #28 0x000055cefa58caf4 in do_command (thd=0x7f8594000b18) at /data/src/10.5/sql/sql_parse.cc:1348
      #29 0x000055cefa7321d9 in do_handle_one_connection (connect=0x55cefdc672f8, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1411
      #30 0x000055cefa731f41 in handle_one_connection (arg=0x55cefdc672f8) at /data/src/10.5/sql/sql_connect.cc:1313
      #31 0x000055cefac6fdd0 in pfs_spawn_thread (arg=0x55cefdc66f28) at /data/src/10.5/storage/perfschema/pfs.cc:2201
      #32 0x00007f85b66cf4a4 in start_thread (arg=0x7f85b0282700) at pthread_create.c:456
      #33 0x00007f85b4803d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      A more sensible stack trace on 10.5 non-debug:

      10.5 30e7a0a8 non-debug

      #3  <signal handler called>
      #4  0x0000562b48d9c994 in Item::fix_fields_if_needed (ref=0x0, thd=0x7f45f00009b8, this=0x7f45f0010c28) at /data/src/10.5/sql/item.h:978
      #5  fix_fields_for_tvc (thd=thd@entry=0x7f45f00009b8, li=...) at /data/src/10.5/sql/sql_tvc.cc:92
      #6  0x0000562b48d9cd76 in table_value_constr::prepare (this=0x7f45f0046228, thd=0x7f45f00009b8, sl=sl@entry=0x7f45f0045508, tmp_result=tmp_result@entry=0x7f45f0010c48, unit_arg=unit_arg@entry=0x7f45f0045968) at /data/src/10.5/sql/sql_tvc.cc:268
      #7  0x0000562b48ccfd03 in st_select_lex_unit::prepare (this=this@entry=0x7f45f0045968, derived_arg=derived_arg@entry=0x7f45f018fb80, sel_result=<optimized out>, additional_options=additional_options@entry=0) at /data/src/10.5/sql/sql_union.cc:1543
      #8  0x0000562b48be8fbe in mysql_derived_prepare (thd=0x7f45f00009b8, lex=0x7f45f00404d8, derived=0x7f45f018fb80) at /data/src/10.5/sql/sql_derived.cc:816
      #9  0x0000562b48be7f6f in mysql_handle_single_derived (lex=lex@entry=0x7f45f00404d8, derived=derived@entry=0x7f45f018fb80, phases=phases@entry=2) at /data/src/10.5/sql/sql_derived.cc:206
      #10 0x0000562b48cecbde in TABLE_LIST::handle_derived (this=this@entry=0x7f45f018fb80, lex=lex@entry=0x7f45f00404d8, phases=phases@entry=2) at /data/src/10.5/sql/table.cc:9087
      #11 0x0000562b48c06077 in LEX::handle_list_of_derived (phases=2, table_list=<optimized out>, this=0x7f45f00404d8) at /data/src/10.5/sql/sql_lex.h:4416
      #12 st_select_lex::handle_derived (this=<optimized out>, lex=0x7f45f00404d8, phases=phases@entry=2) at /data/src/10.5/sql/sql_lex.cc:4850
      #13 0x0000562b48c745e3 in JOIN::prepare (this=this@entry=0x7f45f00105f0, tables_init=tables_init@entry=0x7f45f0042720, conds_init=conds_init@entry=0x7f45f00103a0, og_num=og_num@entry=0, order_init=order_init@entry=0x0, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f45f0042128, unit_arg=0x7f45f00405a0) at /data/src/10.5/sql/sql_select.cc:1149
      #14 0x0000562b48c847e7 in mysql_select (thd=thd@entry=0x7f45f00009b8, tables=0x7f45f0042720, fields=..., conds=0x7f45f00103a0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2201171004160, result=0x7f45f00440c0, unit=0x7f45f00405a0, select_lex=0x7f45f0042128) at /data/src/10.5/sql/sql_select.cc:4619
      #15 0x0000562b48c84954 in handle_select (thd=thd@entry=0x7f45f00009b8, lex=lex@entry=0x7f45f00404d8, result=result@entry=0x7f45f00440c0, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.5/sql/sql_select.cc:429
      #16 0x0000562b48b0b179 in execute_sqlcom_select (thd=thd@entry=0x7f45f00009b8, all_tables=0x7f45f0042720) at /data/src/10.5/sql/sql_parse.cc:6209
      #17 0x0000562b48c25d38 in mysql_execute_command (thd=0x7f45f00009b8) at /data/src/10.5/sql/sql_parse.cc:3931
      #18 0x0000562b48c434ac in Prepared_statement::execute (this=this@entry=0x7f45f00400e8, expanded_query=expanded_query@entry=0x7f4602bcaf10, open_cursor=open_cursor@entry=false) at /data/src/10.5/sql/sql_prepare.cc:4791
      #19 0x0000562b48c435a2 in Prepared_statement::execute_loop (this=0x7f45f00400e8, expanded_query=0x7f4602bcaf10, open_cursor=<optimized out>, packet=<optimized out>, packet_end=<optimized out>) at /data/src/10.5/sql/sql_prepare.cc:4280
      #20 0x0000562b48c43887 in mysql_sql_stmt_execute (thd=thd@entry=0x7f45f00009b8) at /data/src/10.5/sql/sql_prepare.cc:3392
      #21 0x0000562b48c26bf4 in mysql_execute_command (thd=thd@entry=0x7f45f00009b8) at /data/src/10.5/sql/sql_parse.cc:3947
      #22 0x0000562b48c2cb3c in mysql_parse (thd=thd@entry=0x7f45f00009b8, rawbuf=<optimized out>, length=12, parser_state=parser_state@entry=0x7f4602bcb500, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.5/sql/sql_parse.cc:7993
      #23 0x0000562b48c22928 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f45f00009b8, packet=packet@entry=0x7f45f0007be9 "EXECUTE stmt", packet_length=packet_length@entry=12, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.5/sql/sql_parse.cc:1867
      #24 0x0000562b48c20cbe in do_command (thd=0x7f45f00009b8) at /data/src/10.5/sql/sql_parse.cc:1348
      #25 0x0000562b48d18e80 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x562b4ac446c8, put_in_cache=put_in_cache@entry=true) at /data/src/10.5/sql/sql_connect.cc:1411
      #26 0x0000562b48d194e4 in handle_one_connection (arg=arg@entry=0x562b4ac446c8) at /data/src/10.5/sql/sql_connect.cc:1313
      #27 0x0000562b4908a6d1 in pfs_spawn_thread (arg=0x562b4ac44738) at /data/src/10.5/storage/perfschema/pfs.cc:2201
      #28 0x00007f46092854a4 in start_thread (arg=0x7f4602bcc700) at pthread_create.c:456
      #29 0x00007f4608303d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      Reproducible with at least MyISAM and InnoDB.
      For running through the client, SET NAMES latin1 is needed (added it to the test case, even though it's not needed for MTR).

      A slightly more complicated variation of essentially the same test case can also cause "pure virtual method called" exceptions on non-debug builds (while on debug build failures look the same as above).

      10.5 7a60bc22

      pure virtual method called
      terminate called without an active exception
      201227  1:35:42 [ERROR] mysqld got signal 6 ;
       
      #5  0x00007effdee24859 in __GI_abort () at abort.c:79
      #6  0x00007effdf1e0951 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
      #7  0x00007effdf1ec47c in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
      #8  0x00007effdf1ec4e7 in std::terminate() () from /lib/x86_64-linux-gnu/libstdc++.so.6
      #9  0x00007effdf1ed245 in __cxa_pure_virtual () from /lib/x86_64-linux-gnu/libstdc++.so.6
      #10 0x00005564e58a4759 in join_type_handlers_for_tvc (thd=thd@entry=0x7effc8000c58, li=..., holders=holders@entry=0x7effc81a5a08, first_list_el_count=first_list_el_count@entry=1) at /data/src/10.5/sql/sql_tvc.cc:151
      #11 0x00005564e58a4bb7 in table_value_constr::prepare (this=0x7effc8191a10, thd=0x7effc8000c58, sl=sl@entry=0x7effc8190d30, tmp_result=tmp_result@entry=0x7effc8011ef0, unit_arg=unit_arg@entry=0x7effc8191188) at /data/src/10.5/sql/sql_tvc.cc:266
      #12 0x00005564e57cf937 in st_select_lex_unit::prepare (this=this@entry=0x7effc8191188, derived_arg=derived_arg@entry=0x7effc8191a88, sel_result=<optimized out>, additional_options=additional_options@entry=0) at /data/src/10.5/sql/sql_union.cc:1567
      #13 0x00005564e56d13a9 in mysql_derived_prepare (thd=0x7effc8000c58, lex=0x7effc80f14a0, derived=0x7effc8191a88) at /data/src/10.5/sql/sql_derived.cc:816
      #14 0x00005564e56d0324 in mysql_handle_single_derived (lex=lex@entry=0x7effc80f14a0, derived=derived@entry=0x7effc8191a88, phases=phases@entry=2) at /data/src/10.5/sql/sql_derived.cc:206
      #15 0x00005564e57eed5e in TABLE_LIST::handle_derived (this=this@entry=0x7effc8191a88, lex=lex@entry=0x7effc80f14a0, phases=phases@entry=2) at /data/src/10.5/sql/table.cc:9120
      #16 0x00005564e56ed217 in LEX::handle_list_of_derived (phases=2, table_list=<optimized out>, this=0x7effc80f14a0) at /data/src/10.5/sql/table.h:2704
      #17 st_select_lex::handle_derived (this=<optimized out>, lex=0x7effc80f14a0, phases=phases@entry=2) at /data/src/10.5/sql/sql_lex.cc:4911
      #18 0x00005564e576bc9d in JOIN::prepare (this=0x7effc8011898, tables_init=<optimized out>, conds_init=<optimized out>, og_num=0, order_init=<optimized out>, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7effc818ff88, unit_arg=0x7effc81903e0) at /data/src/10.5/sql/sql_select.cc:1158
      #19 0x00005564e59ed82a in subselect_single_select_engine::prepare (thd=0x7effc8000c58, this=0x7effc81923b0) at /data/src/10.5/sql/sql_lex.h:1350
      #20 subselect_single_select_engine::prepare (this=0x7effc81923b0, thd=0x7effc8000c58) at /data/src/10.5/sql/item_subselect.cc:3760
      #21 0x00005564e59ecc7d in Item_subselect::fix_fields (this=this@entry=0x7effc8192168, thd_param=thd_param@entry=0x7effc8000c58, ref=ref@entry=0x7effc81a5640) at /data/src/10.5/sql/item_subselect.cc:285
      #22 0x00005564e59ecfce in Item_in_subselect::fix_fields (this=0x7effc8192168, thd_arg=0x7effc8000c58, ref=0x7effc81a5640) at /data/src/10.5/sql/item_subselect.cc:3438
      #23 0x00005564e5964cdd in Item::fix_fields_if_needed (ref=0x7effc81a5640, thd=0x7effc8000c58, this=0x7effc8192168) at /data/src/10.5/sql/item.h:986
      #24 Item::fix_fields_if_needed (ref=0x7effc81a5640, thd=0x7effc8000c58, this=0x7effc8192168) at /data/src/10.5/sql/item.h:986
      #25 Item_in_optimizer::fix_fields (this=0x7effc81a55a0, thd=0x7effc8000c58, ref=<optimized out>) at /data/src/10.5/sql/item_cmpfunc.cc:1381
      #26 0x00005564e598bb1d in Item::fix_fields_if_needed (ref=0x7effc8192488, thd=0x7effc8000c58, this=0x7effc81a55a0) at /data/src/10.5/sql/item.h:986
      #27 Item::fix_fields_if_needed (ref=0x7effc8192488, thd=0x7effc8000c58, this=0x7effc81a55a0) at /data/src/10.5/sql/item.h:986
      #28 Item_func::fix_fields (ref=0x7effc8192490, thd=0x7effc8000c58, this=0x7effc81923f0) at /data/src/10.5/sql/item_func.cc:352
      #29 Item_func::fix_fields (this=this@entry=0x7effc81923f0, thd=thd@entry=0x7effc8000c58, ref=ref@entry=0x7effc80107d0) at /data/src/10.5/sql/item_func.cc:319
      #30 0x00005564e5961b2e in Item_func_not::fix_fields (this=0x7effc81923f0, thd=0x7effc8000c58, ref=0x7effc80107d0) at /data/src/10.5/sql/item_cmpfunc.cc:6445
      #31 0x00005564e5962431 in Item::fix_fields_if_needed (ref=0x7effc80107d0, thd=0x7effc8000c58, this=0x7effc81923f0) at /data/src/10.5/sql/item.h:986
      #32 Item::fix_fields_if_needed (ref=0x7effc80107d0, thd=0x7effc8000c58, this=0x7effc81923f0) at /data/src/10.5/sql/item.h:986
      #33 Item::fix_fields_if_needed_for_scalar (ref=0x7effc80107d0, thd=0x7effc8000c58, this=0x7effc81923f0) at /data/src/10.5/sql/item.h:992
      #34 Item::fix_fields_if_needed_for_bool (ref=0x7effc80107d0, thd=0x7effc8000c58, this=0x7effc81923f0) at /data/src/10.5/sql/item.h:996
      #35 Item_cond::fix_fields (this=0x7effc8010698, thd=0x7effc8000c58, ref=<optimized out>) at /data/src/10.5/sql/item_cmpfunc.cc:4901
      #36 0x00005564e56b192b in Item::fix_fields_if_needed (ref=0x7effc8010d08, thd=0x7effc8000c58, this=0x7effc8010698) at /data/src/10.5/sql/item.h:986
      #37 Item::fix_fields_if_needed (ref=0x7effc8010d08, thd=0x7effc8000c58, this=0x7effc8010698) at /data/src/10.5/sql/item.h:986
      #38 Item::fix_fields_if_needed_for_scalar (ref=0x7effc8010d08, thd=0x7effc8000c58, this=0x7effc8010698) at /data/src/10.5/sql/item.h:992
      #39 Item::fix_fields_if_needed_for_bool (ref=0x7effc8010d08, thd=0x7effc8000c58, this=0x7effc8010698) at /data/src/10.5/sql/item.h:996
      #40 setup_conds (thd=thd@entry=0x7effc8000c58, tables=tables@entry=0x7effc80f39e8, leaves=..., conds=conds@entry=0x7effc8010d08) at /data/src/10.5/sql/sql_base.cc:8360
      #41 0x00005564e576c1c4 in setup_without_group (reserved=0x7effc80f355c, hidden_group_fields=0x7effc8010bdf, win_funcs=..., win_specs=..., group=0x0, order=0x0, conds=0x7effc8010d08, all_fields=..., fields=..., leaves=..., tables=0x7effc80f39e8, ref_pointer_array=..., thd=0x7effc8000c58) at /data/src/10.5/sql/sql_select.cc:696
      #42 JOIN::prepare (this=0x7effc80108f8, tables_init=<optimized out>, conds_init=<optimized out>, og_num=<optimized out>, order_init=<optimized out>, skip_order_by=<optimized out>, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7effc80f3250, unit_arg=0x7effc80f1568) at /data/src/10.5/sql/sql_select.cc:1264
      #43 0x00005564e577f28f in mysql_select (thd=0x7effc8000c58, tables=0x7effc80f39e8, fields=..., conds=0x7effc8010698, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2201171004160, result=0x7effc80f69c8, unit=0x7effc80f1568, select_lex=0x7effc80f3250) at /data/src/10.5/sql/sql_select.cc:4634
      #44 0x00005564e577f567 in handle_select (thd=thd@entry=0x7effc8000c58, lex=lex@entry=0x7effc80f14a0, result=result@entry=0x7effc80f69c8, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.5/sql/sql_select.cc:417
      #45 0x00005564e570e0b1 in execute_sqlcom_select (thd=0x7effc8000c58, all_tables=0x7effc80f39e8) at /data/src/10.5/sql/sql_parse.cc:6264
      #46 0x00005564e571c24e in mysql_execute_command (thd=0x7effc8000c58) at /data/src/10.5/sql/sql_parse.cc:3968
      #47 0x00005564e572db45 in Prepared_statement::execute (this=0x7effc811a558, expanded_query=<optimized out>, open_cursor=false) at /data/src/10.5/sql/sql_prepare.cc:4997
      #48 0x00005564e572dd19 in Prepared_statement::execute_loop (packet=<optimized out>, packet_end=<optimized out>, open_cursor=<optimized out>, expanded_query=0x7effd97d6e50, this=0x7effc811a558) at /data/src/10.5/sql/sql_prepare.cc:4460
      #49 Prepared_statement::execute_loop (this=0x7effc811a558, expanded_query=0x7effd97d6e50, open_cursor=<optimized out>, packet=<optimized out>, packet_end=<optimized out>) at /data/src/10.5/sql/sql_prepare.cc:4415
      #50 0x00005564e572e023 in mysql_sql_stmt_execute (thd=thd@entry=0x7effc8000c58) at /data/src/10.5/sql/sql_prepare.cc:3558
      #51 0x00005564e571ab23 in mysql_execute_command (thd=0x7effc8000c58) at /data/src/10.5/sql/sql_parse.cc:3984
      #52 0x00005564e5708a5f in mysql_parse (thd=0x7effc8000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.5/sql/sql_parse.cc:8042
      #53 0x00005564e57147bf in dispatch_command (command=COM_QUERY, thd=0x7effc8000c58, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.5/sql/sql_class.h:1255
      #54 0x00005564e5716b76 in do_command (thd=0x7effc8000c58) at /data/src/10.5/sql/sql_parse.cc:1353
      #55 0x00005564e581b8c1 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5564e9180088, put_in_cache=put_in_cache@entry=true) at /data/src/10.5/sql/sql_connect.cc:1410
      #56 0x00005564e581bd3d in handle_one_connection (arg=arg@entry=0x5564e9180088) at /data/src/10.5/sql/sql_connect.cc:1312
      #57 0x00005564e5ba32e6 in pfs_spawn_thread (arg=0x5564e9117aa8) at /data/src/10.5/storage/perfschema/pfs.cc:2201
      #58 0x00007effdf332609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #59 0x00007effdef21293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Attachments

        Issue Links

          Activity

            People

              shulga Dmitry Shulga
              elenst Elena Stepanova
              Votes:
              1 Vote for this issue
              Watchers:
              8 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.