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

[Draft] Server crashed in in setup_table_map

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.3
    • N/A
    • Server
    • None

    Description

      https://api.travis-ci.org/v3/job/378428409/log.txt

      10.3 15419a558370aeed9521b498c34d50f20a8d47a5

      #3  <signal handler called>
      #4  0x00005618daf153f3 in setup_table_map (table=0x7fdef8250ca0, table_list=0x7fdef42a1678, tablenr=0) at /home/travis/src/sql/sql_base.h:331
      #5  0x00005618daf0da6d in setup_tables (thd=0x7fdef4001320, context=0x7fdef429f7b8, from_clause=0x7fdef429f910, tables=0x7fdef42a1678, leaves=..., select_insert=false, full_table_list=false) at /home/travis/src/sql/sql_base.cc:7495
      #6  0x00005618daf0dfd5 in setup_tables_and_check_access (thd=0x7fdef4001320, context=0x7fdef429f7b8, from_clause=0x7fdef429f910, tables=0x7fdef42a1678, leaves=..., select_insert=false, want_access_first=1, want_access=1, full_table_list=false) at /home/travis/src/sql/sql_base.cc:7604
      #7  0x00005618dafd2b88 in JOIN::prepare (this=0x7fdef42a2320, tables_init=0x7fdef42a1678, 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=0x7fdef429f770, unit_arg=0x7fdef429eff8) at /home/travis/src/sql/sql_select.cc:1008
      #8  0x00005618db080c3f in st_select_lex_unit::prepare_join (this=0x7fdef429eff8, thd_arg=0x7fdef4001320, sl=0x7fdef429f770, tmp_result=0x7fdef42a2238, additional_options=0, is_union_select=false) at /home/travis/src/sql/sql_union.cc:667
      #9  0x00005618db081ff9 in st_select_lex_unit::prepare (this=0x7fdef429eff8, derived_arg=0x7fdef429e638, sel_result=0x7fdef42a2238, additional_options=0) at /home/travis/src/sql/sql_union.cc:939
      #10 0x00005618daf4818f in mysql_derived_prepare (thd=0x7fdef4001320, lex=0x7fdf580accb0, derived=0x7fdef429e638) at /home/travis/src/sql/sql_derived.cc:768
      #11 0x00005618daf46c91 in mysql_handle_derived (lex=0x7fdf580accb0, phases=35) at /home/travis/src/sql/sql_derived.cc:121
      #12 0x00005618daf076ba in open_normal_and_derived_tables (thd=0x7fdef4001320, tables=0x7fdef429e638, flags=1090, dt_phases=35) at /home/travis/src/sql/sql_base.cc:4985
      #13 0x00005618daf07879 in open_tables_only_view_structure (thd=0x7fdef4001320, table_list=0x7fdef429e638, can_deadlock=false) at /home/travis/src/sql/sql_base.cc:5041
      #14 0x00005618db031513 in fill_schema_table_by_open (thd=0x7fdef4001320, mem_root=0x7fdf580ae550, is_show_fields_or_keys=false, table=0x7fdef4198dc8, schema_table=0x5618dc4c6880 <schema_tables+2368>, orig_db_name=0x7fdef429b1b0, orig_table_name=0x7fdef429b510, open_tables_state_backup=0x7fdf580ae5a0, can_deadlock=false) at /home/travis/src/sql/sql_show.cc:4563
      #15 0x00005618db032e27 in get_all_tables (thd=0x7fdef4001320, tables=0x7fdef4015248, cond=0x7fdef4015ba0) at /home/travis/src/sql/sql_show.cc:5203
      #16 0x00005618db0438a2 in get_schema_tables_result (join=0x7fdef4019928, executed_place=PROCESSED_BY_JOIN_EXEC) at /home/travis/src/sql/sql_show.cc:8768
      #17 0x00005618dafdd6e3 in JOIN::exec_inner (this=0x7fdef4019928) at /home/travis/src/sql/sql_select.cc:3935
      #18 0x00005618dafdcd66 in JOIN::exec (this=0x7fdef4019928) at /home/travis/src/sql/sql_select.cc:3766
      #19 0x00005618dafde00f in mysql_select (thd=0x7fdef4001320, tables=0x7fdef4014b78, wild_num=1, fields=..., conds=0x7fdef40165e8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=552440433408, result=0x7fdef4019908, unit=0x7fdef40051a0, select_lex=0x7fdef4005918) at /home/travis/src/sql/sql_select.cc:4171
      #20 0x00005618dafd02f2 in handle_select (thd=0x7fdef4001320, lex=0x7fdef40050d8, result=0x7fdef4019908, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:382
      #21 0x00005618daf9aca9 in execute_sqlcom_select (thd=0x7fdef4001320, all_tables=0x7fdef4014b78) at /home/travis/src/sql/sql_parse.cc:6545
      #22 0x00005618daf91332 in mysql_execute_command (thd=0x7fdef4001320) at /home/travis/src/sql/sql_parse.cc:3768
      #23 0x00005618daf9e958 in mysql_parse (thd=0x7fdef4001320, rawbuf=0x7fdef40140d8 "SELECT * FROM (INFORMATION_SCHEMA.`ROUTINES` AS table1 INNER JOIN INFORMATION_SCHEMA.`VIEWS` AS table2 ON ( table2.`ALGORITHM` = table1.`LAST_ALTERED` ) ) WHERE table1.`ROUTINE_BODY` >= 'q' LIMIT 2 /*"..., length=221, parser_state=0x7fdf580b05f0, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8019
      #24 0x00005618daf8bddc in dispatch_command (command=COM_QUERY, thd=0x7fdef4001320, packet=0x7fdef400b911 " SELECT * FROM (INFORMATION_SCHEMA.`ROUTINES` AS table1 INNER JOIN INFORMATION_SCHEMA.`VIEWS` AS table2 ON ( table2.`ALGORITHM` = table1.`LAST_ALTERED` ) ) WHERE table1.`ROUTINE_BODY` >= 'q' LIMIT 2 /"..., packet_length=223, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1846
      #25 0x00005618daf8a80d in do_command (thd=0x7fdef4001320) at /home/travis/src/sql/sql_parse.cc:1391
      #26 0x00005618db0f0609 in do_handle_one_connection (connect=0x5618debbbd80) at /home/travis/src/sql/sql_connect.cc:1402
      #27 0x00005618db0f038d in handle_one_connection (arg=0x5618debbbd80) at /home/travis/src/sql/sql_connect.cc:1308
      #28 0x00007fdf5c533184 in start_thread (arg=0x7fdf580b1700) at pthread_create.c:312
      #29 0x00007fdf5ba4003d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
       
      Query (0x7fdef40140d8): SELECT * FROM (INFORMATION_SCHEMA.`ROUTINES` AS table1 INNER JOIN INFORMATION_SCHEMA.`VIEWS` AS table2 ON ( table2.`ALGORITHM` = table1.`LAST_ALTERED` ) ) WHERE table1.`ROUTINE_BODY` >= 'q' LIMIT 2 /* QNO 822 CON_ID 16 */
      Connection ID (thread ID): 16
      Status: NOT_KILLED
      

      experimental 6c40fc679d99de2a34ba7e3b6ac807b84be5942a

      perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --redefine=conf/mariadb/alter_table.yy --reporters=Backtrace,ErrorLog,Deadlock --engine=InnoDB --seed=1526242550 --basedir=/home/travis/server --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/runtime/information_schema.yy --engine=MyISAM --mysqld=--default-storage-engine=MyISAM --vardir=/home/travis/logs/vardir1_2
      

      Can't reproduce, hitting other known bugs instead.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.