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. mysql.log
          1.13 MB
        2. threads
          41 kB

        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.