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

[Draft] Server crashes in Item_ident::get_depended_from

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3
    • None
    • None
    • None

    Description

      10.3 afc56a509cc7d

      #3  <signal handler called>
      #4  0x0000562b35730f64 in Item_ident::get_depended_from (this=0x7f77742b4190) at /data/src/10.3/sql/item.cc:10540
      #5  0x0000562b3571c2c5 in Item_field::used_tables (this=0x7f77742b4190) at /data/src/10.3/sql/item.cc:3536
      #6  0x0000562b35398e53 in setup_fields (thd=0x7f7774000b00, ref_pointer_array=..., fields=..., column_usage=MARK_COLUMNS_READ, sum_func_list=0x7f77742d0740, pre_fix=0x7f77742b28f0, allow_sum_func=true) at /data/src/10.3/sql/sql_base.cc:7308
      #7  0x0000562b354545b6 in JOIN::prepare (this=0x7f77742d0420, tables_init=0x7f77742b4cb8, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f77742b27b0, unit_arg=0x7f77742b2048) at /data/src/10.3/sql/sql_select.cc:1214
      #8  0x0000562b35502c6d in st_select_lex_unit::prepare_join (this=0x7f77742b2048, thd_arg=0x7f7774000b00, sl=0x7f77742b27b0, tmp_result=0x7f77742b92f8, additional_options=0, is_union_select=false) at /data/src/10.3/sql/sql_union.cc:675
      #9  0x0000562b35504024 in st_select_lex_unit::prepare (this=0x7f77742b2048, thd_arg=0x7f7774000b00, sel_result=0x7f77742b92f8, additional_options=0) at /data/src/10.3/sql/sql_union.cc:947
      #10 0x0000562b353d365e in mysql_derived_prepare (thd=0x7f7774000b00, lex=0x7f77e88bba80, derived=0x7f77742b1468) at /data/src/10.3/sql/sql_derived.cc:769
      #11 0x0000562b353d216d in mysql_handle_derived (lex=0x7f77e88bba80, phases=35) at /data/src/10.3/sql/sql_derived.cc:121
      #12 0x0000562b353931c8 in open_normal_and_derived_tables (thd=0x7f7774000b00, tables=0x7f77742b1468, flags=1090, dt_phases=35) at /data/src/10.3/sql/sql_base.cc:4943
      #13 0x0000562b35393388 in open_tables_only_view_structure (thd=0x7f7774000b00, table_list=0x7f77742b1468, can_deadlock=false) at /data/src/10.3/sql/sql_base.cc:4999
      #14 0x0000562b354b2c3f in fill_schema_table_by_open (thd=0x7f7774000b00, mem_root=0x7f77e88bd330, is_show_fields_or_keys=false, table=0x7f77742040d8, schema_table=0x562b36984d00 <schema_tables+2432>, orig_db_name=0x7f77742aeea0, orig_table_name=0x7f77742aef80, open_tables_state_backup=0x7f77e88bd380, can_deadlock=false) at /data/src/10.3/sql/sql_show.cc:4568
      #15 0x0000562b354b493e in get_all_tables (thd=0x7f7774000b00, tables=0x7f7774017450, cond=0x7f7774018ef0) at /data/src/10.3/sql/sql_show.cc:5268
      #16 0x0000562b354c489a in get_schema_tables_result (join=0x7f777411d408, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.3/sql/sql_show.cc:8664
      #17 0x0000562b3545eb72 in JOIN::exec_inner (this=0x7f777411d408) at /data/src/10.3/sql/sql_select.cc:4036
      #18 0x0000562b3545e216 in JOIN::exec (this=0x7f777411d408) at /data/src/10.3/sql/sql_select.cc:3867
      #19 0x0000562b35505d94 in st_select_lex_unit::exec (this=0x7f7774004898) at /data/src/10.3/sql/sql_union.cc:1427
      #20 0x0000562b35500ffa in mysql_union (thd=0x7f7774000b00, lex=0x7f77740047d0, result=0x7f77741b9cd8, unit=0x7f7774004898, setup_tables_done_option=0) at /data/src/10.3/sql/sql_union.cc:41
      #21 0x0000562b354510d1 in handle_select (thd=0x7f7774000b00, lex=0x7f77740047d0, result=0x7f77741b9cd8, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:360
      #22 0x0000562b3541be0b in execute_sqlcom_select (thd=0x7f7774000b00, all_tables=0x7f7774014710) at /data/src/10.3/sql/sql_parse.cc:6523
      #23 0x0000562b3541250f in mysql_execute_command (thd=0x7f7774000b00) at /data/src/10.3/sql/sql_parse.cc:3748
      #24 0x0000562b3541f804 in mysql_parse (thd=0x7f7774000b00, rawbuf=0x7f7774013958 "(  SELECT * FROM (INFORMATION_SCHEMA.`GEOMETRY_COLUMNS` AS table1 LEFT OUTER JOIN INFORMATION_SCHEMA.`PARAMETERS` AS table2 ON ( table2.`CHARACTER_MAXIMUM_LENGTH` = table1.`F_GEOMETRY_COLUMN` ) ) WHERE table1.`F_TABLE_CATALOG` >= 'tb' LIMIT 3 /* QNO 1227 CON_ID 17 */  ) UNION DISTINCT (  SELECT * FROM (INFORMATION_SCHEMA.`GEOMETRY_COLUMNS` AS table1 LEFT OUTER JOIN INFORMATION_SCHEMA.`PARAMETERS` AS table2 ON ( table2.`CHARACTER_MAXIMUM_LENGTH` = table1.`F_GEOMETRY_COLUMN` ) ) WHERE table1.`F_TABLE_CATALOG` >= 'tb' LIMIT 3 /* QNO 1227 CON_ID 17 */  ) /* TRANSFORM_OUTCOME_DISTINCT */ /* QNO 1257 CON_ID 17 */", length=614, parser_state=0x7f77e88bf630, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7980
      #25 0x0000562b3540cfb7 in dispatch_command (command=COM_QUERY, thd=0x7f7774000b00, packet=0x7f777400b191 "(  SELECT * FROM (INFORMATION_SCHEMA.`GEOMETRY_COLUMNS` AS table1 LEFT OUTER JOIN INFORMATION_SCHEMA.`PARAMETERS` AS table2 ON ( table2.`CHARACTER_MAXIMUM_LENGTH` = table1.`F_GEOMETRY_COLUMN` ) ) WHERE table1.`F_TABLE_CATALOG` >= 'tb' LIMIT 3 /* QNO 1227 CON_ID 17 */  ) UNION DISTINCT (  SELECT * FROM (INFORMATION_SCHEMA.`GEOMETRY_COLUMNS` AS table1 LEFT OUTER JOIN INFORMATION_SCHEMA.`PARAMETERS` AS table2 ON ( table2.`CHARACTER_MAXIMUM_LENGTH` = table1.`F_GEOMETRY_COLUMN` ) ) WHERE table1.`F_TABLE_CATALOG` >= 'tb' LIMIT 3 /* QNO 1227 CON_ID 17 */  ) /* TRANSFORM_OUTCOME_DISTINCT */ /* QNO 1257 CON_ID 17 */ ", packet_length=615, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1825
      #26 0x0000562b3540b9f6 in do_command (thd=0x7f7774000b00) at /data/src/10.3/sql/sql_parse.cc:1370
      #27 0x0000562b355745d7 in do_handle_one_connection (connect=0x562b38483630) at /data/src/10.3/sql/sql_connect.cc:1402
      #28 0x0000562b35574364 in handle_one_connection (arg=0x562b38483630) at /data/src/10.3/sql/sql_connect.cc:1308
      #29 0x00007f77edafb494 in start_thread (arg=0x7f77e88c0700) at pthread_create.c:333
      #30 0x00007f77ebee193f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      experimental 6b97ede2ef98c

      perl ./runall-new.pl --duration=350 --threads=2 --seed=1518986252 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/data/bld/10.3 --grammar=conf/runtime/information_schema.yy --engine=MyISAM --mysqld=--default-storage-engine=MyISAM --vardir=/dev/shm/vardir2
      

      Reproducible reasonably well with RQG, but not with MTR so far.

      Attachments

        1. threads
          41 kB
          Elena Stepanova
        2. mysql.log
          1.13 MB
          Elena Stepanova

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.