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

Crash at change_item_tree

Details

    Description

      MariaDB server - 10.3.17, crashed with the following stack trace. We are not clear on execution of which particular query/SP/Function caused this problem.

      Here is the full backtrace for all threads captured from the core file generated.

      Attaching the full error log and full backtrace from all the threads for a core file.

      #0 0x00007f5c3f237207 in raise () from /lib64/libc.so.6
      		 
      #1 0x00007f5c3f238a38 in abort () from /lib64/libc.so.6
      		 
      #2 0x00007f5c3f279cc7 in __libc_message () from /lib64/libc.so.6
      		 
      #3 0x00007f5c3f319677 in __fortify_fail () from /lib64/libc.so.6
      		 
      #4 0x00007f5c3f3177f2 in __chk_fail () from /lib64/libc.so.6
      		 
      #5 0x00007f5c3f3195d7 in __fdelt_warn () from /lib64/libc.so.6
      		 
      #6 0x000055f1b28366da in my_addr_resolve (ptr=<optimized out>, loc=loc@entry=0x7f50931863b0)
      		 
      #7 0x000055f1b281fad2 in print_with_addr_resolve (n=<optimized out>, addrs=0x7f50931863d0)
      		 
      #8 my_print_stacktrace (stack_bottom=<optimized out>, thread_stack=262144, silent=<optimized out>)
      		 
      #9 0x000055f1b22bf2af in handle_fatal_signal (sig=11) at /usr/src/debug/mariadb-10.3.17-linux-x86_64/server/src_0/sql/signal_handler.cc:207
      		 
      #10 <signal handler called>
      		 
      #11 0x000055f1b22e30a7 in change_item_tree (new_value=0x7f4f45278518, place=0x0, this=0x7f50040611e8)
      		 
      #12 Item::split_sum_func2 (this=0x7f4f450e99e8, thd=0x7f50040611e8, ref_pointer_array=..., fields=..., ref=<optimized out>, split_flags=0)
      		 
      #13 0x000055f1b212cedd in JOIN::prepare (this=this@entry=0x7f4f45020bc8, tables_init=<optimized out>, wild_num=<optimized out>,
      		 
      #14 0x000055f1b217c51e in st_select_lex_unit::prepare_join (this=this@entry=0x7f4f450dd720, thd_arg=0x7f50040611e8, sl=sl@entry=0x7f4f450ddea0,
      		 
      #15 0x000055f1b2180164 in st_select_lex_unit::prepare (this=this@entry=0x7f4f450dd720, derived_arg=derived_arg@entry=0x7f4f450beea8,
      		 
      #16 0x000055f1b20ac983 in mysql_derived_prepare (thd=0x7f50040611e8, lex=0x7f4f45097b38, derived=0x7f4f450beea8)
      		 
      #17 0x000055f1b20ad6dc in mysql_handle_single_derived (lex=lex@entry=0x7f4f45097b38, derived=derived@entry=0x7f4f450beea8, phases=phases@entry=2)
      		 
      #18 0x000055f1b219aaae in TABLE_LIST::handle_derived (this=this@entry=0x7f4f450beea8, lex=lex@entry=0x7f4f45097b38, phases=phases@entry=2)
      		 
      #19 0x000055f1b20c4807 in handle_list_of_derived (phases=2, table_list=<optimized out>, this=0x7f4f45097b38)
      		 
      #20 st_select_lex::handle_derived (this=this@entry=0x7f4f450a3170, lex=lex@entry=0x7f4f45097b38, phases=phases@entry=2)
      		 
      #21 0x000055f1b219aa86 in TABLE_LIST::handle_derived (this=this@entry=0x7f4f4508ce20, lex=lex@entry=0x7f4f45097b38, phases=phases@entry=2)
      		 
      #22 0x000055f1b20b3c1a in handle_list_of_derived (phases=2, table_list=0x7f4f45089708, this=0x7f4f45097b38)
      		 
      #23 mysql_prepare_insert (thd=thd@entry=0x7f50040611e8, table_list=0x7f4f45089708, table=0x7f4f4508ff58, fields=..., values=values@entry=0x0,
      		 
      #24 0x000055f1b20b7e12 in mysql_insert_select_prepare (thd=thd@entry=0x7f50040611e8)
      		 
      #25 0x000055f1b20e8ce2 in mysql_execute_command (thd=0x7f50040611e8) at /usr/src/debug/mariadb-10.3.17-linux-x86_64/server/src_0/sql/sql_parse.cc:4550
      		 
      #26 0x000055f1b2050126 in sp_instr_stmt::exec_core (this=0x7f4f4508d470, thd=<optimized out>, nextp=0x7f5093189240)
      		 
      #27 0x000055f1b2057bc9 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7f4f4508d4b8, thd=thd@entry=0x7f50040611e8,
      		 
      #28 0x000055f1b205861c in sp_instr_stmt::execute (this=0x7f4f4508d470, thd=0x7f50040611e8, nextp=0x7f5093189240)
      		 
      #29 0x000055f1b2053b20 in sp_head::execute (this=this@entry=0x7f4f4507ffc0, thd=thd@entry=0x7f50040611e8,
      		 
      #30 0x000055f1b2054d4d in sp_head::execute_procedure (this=0x7f4f4507ffc0, thd=thd@entry=0x7f50040611e8, args=0x7f5004065ca8)
      		 
      #31 0x000055f1b20d98c2 in do_execute_sp (thd=0x7f50040611e8, sp=<optimized out>)
      		 
      #32 0x000055f1b20dad86 in Sql_cmd_call::execute (this=this@entry=0x7f5004432490, thd=thd@entry=0x7f50040611e8)
      		 
      #33 0x000055f1b20db5a0 in Sql_cmd_call::execute (this=0x7f5004432490, thd=0x7f50040611e8)
      		 
      #34 0x000055f1b20e4aa0 in mysql_execute_command (thd=thd@entry=0x7f50040611e8)
      		 
      #35 0x000055f1b20e9c2b in mysql_parse (thd=0x7f50040611e8, rawbuf=<optimized out>, length=16, parser_state=0x7f509318b4e0,
      		 
      #36 0x000055f1b20ec80f in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f50040611e8,
      		 
      #37 0x000055f1b20ed74e in do_command (thd=0x7f50040611e8) at /usr/src/debug/mariadb-10.3.17-linux-x86_64/server/src_0/sql/sql_parse.cc:1402
      		 
      #38 0x000055f1b21c0f61 in do_handle_one_connection (connect=connect@entry=0x55f1ef185788)
      		 
      #39 0x000055f1b21c102d in handle_one_connection (arg=0x55f1ef185788)
      		 
      #40 0x00007f5c40d28dd5 in start_thread () from /lib64/libpthread.so.0
      		 
      #41 0x00007f5c3f2ffb3d in clone () from /lib64/libc.so.6

      Thank You!

      Attachments

        1. error_mariadb_x01gegrcdb1a.log
          608 kB
        2. mysqld_6.0_dbg.err
          795 kB
        3. mysqld_6.0_opt.err
          710 kB
        4. mysqld_dbg.err
          1.09 MB
        5. mysqld_opt.err
          1.10 MB
        6. mysqld_tc2_dbg.err
          1.25 MB
        7. mysqld_tc2_opt.err
          1.09 MB
        8. stack_mariadb_core_20201217162837.txt
          208 kB

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25631 Crash executing query with VIEW, aggregate and subquery

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Oleksandr Byelkin made transition -
            Open In Progress
            		215d 5h 52m 1
            Oleksandr Byelkin made transition -
            In Progress In Review
            		56s 1
            Michael Widenius made transition -
            In Review Stalled
            		63d 57m 1
            Oleksandr Byelkin made transition -
            Stalled Closed
            		2d 20h 4m 1

            People

              sanja Oleksandr Byelkin
              suresh.ramagiri@mariadb.com suresh ramagiri
              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.