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

Crash in open_tables() while calling stored procedure from the package

Details

    Description

      The following crash happens while calling stored procedure form the package (from full gdb backtrace, showrtened a lot to hide potentially sensitive data):

      #0  0x00007f52dcf0a9b1 in pthread_kill () from /lib64/libpthread.so.0
      No symbol table info available.
      #1  0x000055e3071a107a in handle_fatal_signal (sig=11) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.13/sql/signal_handler.cc:305
              buff = "/mariadb/data/\000\000\360\256\322&=\177\000\000P\036\b\300R\177\000\000@\036\b\300R\177\000\000b\311\362\006\343U\000\000\360\256\322&=\177\000\000\000b{\344\256++C(ݏ\310<\177\000\000 ۆ&=\177\000"
              curr_time = 1516604732
              tm = {tm_sec = 32, tm_min = 5, tm_hour = 15, tm_mday = 22, tm_mon = 0, tm_year = 118, tm_wday = 1, tm_yday = 21, tm_isdst = 0, tm_gmtoff = 28800, tm_zone = 0x55e30a2a9f50 "SGT"}
              print_invalid_query_pointer = false
      #2  <signal handler called>
      No symbol table info available.
      #3  open_tables (thd=thd@entry=0x7f3d26c12cd8, options=..., start=start@entry=0x7f52c0082538, counter=counter@entry=0x7f52c0082540, flags=flags@entry=0, 
          prelocking_strategy=prelocking_strategy@entry=0x7f52c0082590) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.13/sql/sql_base.cc:3121
      No locals.
      #4  0x000055e306f90b84 in open_and_lock_tables (thd=thd@entry=0x7f3d26c12cd8, options=..., tables=tables@entry=0x0, derived=derived@entry=true, flags=flags@entry=0, 
          prelocking_strategy=prelocking_strategy@entry=0x7f52c0082590) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.13/sql/sql_base.cc:4745
              counter = 0
              mdl_savepoint = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0}
      #5  0x000055e306fd8d81 in open_and_lock_tables (flags=0, derived=true, tables=0x0, thd=0x7f3d26c12cd8)
          at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.13/sql/sql_base.h:496
              prelocking_strategy = {<Prelocking_strategy> = {_vptr.Prelocking_strategy = 0x55e307ed18b0 <vtable for DML_prelocking_strategy+16>}, <No data fields>}
      #6  Sql_cmd_call::execute (this=0x7f3d26b60b88, thd=0x7f3d26c12cd8) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.13/sql/sql_parse.cc:3117
              all_tables = 0x0
      #7  0x000055e306fde79e in mysql_execute_command (thd=0x7f3d26c12cd8) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.13/sql/sql_parse.cc:6247
      ...
      #8  0x000055e306f56cf6 in sp_instr_stmt::exec_core (this=0x7f3d26b612f0, thd=<optimized out>, nextp=0x7f52c0083d70)
          at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.13/sql/sp_head.cc:3591
              res = 1414349151
      #9  0x000055e306f5e959 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7f3d26b61338, thd=thd@entry=0x7f3d26c12cd8, nextp=nextp@entry=0x7f52c0083d70, open_tables=open_tables@entry=false, 
          instr=instr@entry=0x7f3d26b612f0) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.13/sql/sp_head.cc:3336
              res = <optimized out>
              parent_modified_non_trans_table = false
              __FUNCTION__ = "reset_lex_and_exec_core"
      #10 0x000055e306f5ef55 in sp_instr_stmt::execute (this=0x7f3d26b612f0, thd=0x7f3d26c12cd8, nextp=0x7f52c0083d70)
          at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.13/sql/sp_head.cc:3507
      ...
      #12 0x000055e306f5baed in sp_head::execute_procedure (this=0x7f3d24c670b0, thd=thd@entry=0x7f3d26c12cd8, args=0x7f3d26ca5a20)
          at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.13/sql/sp_head.cc:2313
      ...
      

      Attachments

        Issue Links

          Activity

            I got the same stack trace during concurrent tests on bb-10.2-compatibility build 18296, it's one of variations reported in MDEV-15080:

            #2  <signal handler called>
            #3  0x0000559dfa56a9aa in open_tables (thd=thd@entry=0x7f5bcc0009a8, options=..., start=start@entry=0x7f5c3414a9a8, counter=counter@entry=0x7f5c3414a9bc, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f5c3414a9f0) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:4053
            #4  0x0000559dfa56b58d in open_and_lock_tables (thd=thd@entry=0x7f5bcc0009a8, options=..., tables=tables@entry=0x0, derived=derived@entry=true, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f5c3414a9f0) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:4745
            #5  0x0000559dfa5b01d8 in open_and_lock_tables (flags=0, derived=true, tables=0x0, thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_base.h:496
            #6  Sql_cmd_call::execute (this=0x7f5bcca24580, thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3124
            #7  0x0000559dfa5b5722 in mysql_execute_command (thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
            #8  0x0000559dfa535c04 in sp_instr_stmt::exec_core (this=0x7f5bcca24a28, thd=<optimized out>, nextp=0x7f5c3414c134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591
            #9  0x0000559dfa53d1a3 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7f5bcca24a70, thd=thd@entry=0x7f5bcc0009a8, nextp=nextp@entry=0x7f5c3414c134, open_tables=open_tables@entry=false, instr=instr@entry=0x7f5bcca24a28) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336
            #10 0x0000559dfa53d7ec in sp_instr_stmt::execute (this=0x7f5bcca24a28, thd=0x7f5bcc0009a8, nextp=0x7f5c3414c134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507
            #11 0x0000559dfa5394cd in sp_head::execute (this=0x7f5bcc828600, thd=0x7f5bcc0009a8, merge_da_on_success=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390
            #12 0x0000559dfa53a53e in sp_head::execute_procedure (this=0x7f5bcc828600, thd=0x7f5bcc0009a8, args=0x0) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313
            #13 0x0000559dfa5ae31d in do_execute_sp (thd=0x7f5bcc0009a8, sp=sp@entry=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929
            #14 0x0000559dfa5af976 in Sql_cmd_call::execute (this=this@entry=0x7f5bcc00fba8, thd=thd@entry=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169
            #15 0x0000559dfa5b01e7 in Sql_cmd_call::execute (this=0x7f5bcc00fba8, thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123
            #16 0x0000559dfa5b5722 in mysql_execute_command (thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254
            #17 0x0000559dfa5bc04d in mysql_parse (thd=0x7f5bcc0009a8, rawbuf=<optimized out>, length=65, parser_state=0x7f5c3414e260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974
            #18 0x0000559dfa5bf555 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f5bcc0009a8, packet=packet@entry=0x7f5bcc006fa9 " CALL pkg.pr5(NOW())  /* QNO 969 CON_ID 17 */ ", packet_length=packet_length@entry=67, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835
            #19 0x0000559dfa5bfe23 in do_command (thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383
            #20 0x0000559dfa688594 in do_handle_one_connection (connect=connect@entry=0x559e033b9a18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335
            #21 0x0000559dfa688734 in handle_one_connection (arg=0x559e033b9a18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241
            #22 0x00007f5d724e7494 in start_thread (arg=0x7f5c3414f700) at pthread_create.c:333
            #23 0x00007f5d708cd93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
            

            it appears to be gone after the fix for MDEV-15070, along with other failures from MDEV-15080, so the recommendation is to upgrade to the build #18318 or higher.

            elenst Elena Stepanova added a comment - I got the same stack trace during concurrent tests on bb-10.2-compatibility build 18296, it's one of variations reported in MDEV-15080 : #2 <signal handler called> #3 0x0000559dfa56a9aa in open_tables (thd=thd@entry=0x7f5bcc0009a8, options=..., start=start@entry=0x7f5c3414a9a8, counter=counter@entry=0x7f5c3414a9bc, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f5c3414a9f0) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:4053 #4 0x0000559dfa56b58d in open_and_lock_tables (thd=thd@entry=0x7f5bcc0009a8, options=..., tables=tables@entry=0x0, derived=derived@entry=true, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f5c3414a9f0) at /data/src/bb-10.2-compatibility/sql/sql_base.cc:4745 #5 0x0000559dfa5b01d8 in open_and_lock_tables (flags=0, derived=true, tables=0x0, thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_base.h:496 #6 Sql_cmd_call::execute (this=0x7f5bcca24580, thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3124 #7 0x0000559dfa5b5722 in mysql_execute_command (thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254 #8 0x0000559dfa535c04 in sp_instr_stmt::exec_core (this=0x7f5bcca24a28, thd=<optimized out>, nextp=0x7f5c3414c134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3591 #9 0x0000559dfa53d1a3 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7f5bcca24a70, thd=thd@entry=0x7f5bcc0009a8, nextp=nextp@entry=0x7f5c3414c134, open_tables=open_tables@entry=false, instr=instr@entry=0x7f5bcca24a28) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3336 #10 0x0000559dfa53d7ec in sp_instr_stmt::execute (this=0x7f5bcca24a28, thd=0x7f5bcc0009a8, nextp=0x7f5c3414c134) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:3507 #11 0x0000559dfa5394cd in sp_head::execute (this=0x7f5bcc828600, thd=0x7f5bcc0009a8, merge_da_on_success=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:1390 #12 0x0000559dfa53a53e in sp_head::execute_procedure (this=0x7f5bcc828600, thd=0x7f5bcc0009a8, args=0x0) at /data/src/bb-10.2-compatibility/sql/sp_head.cc:2313 #13 0x0000559dfa5ae31d in do_execute_sp (thd=0x7f5bcc0009a8, sp=sp@entry=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:2929 #14 0x0000559dfa5af976 in Sql_cmd_call::execute (this=this@entry=0x7f5bcc00fba8, thd=thd@entry=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3169 #15 0x0000559dfa5b01e7 in Sql_cmd_call::execute (this=0x7f5bcc00fba8, thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:3123 #16 0x0000559dfa5b5722 in mysql_execute_command (thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:6254 #17 0x0000559dfa5bc04d in mysql_parse (thd=0x7f5bcc0009a8, rawbuf=<optimized out>, length=65, parser_state=0x7f5c3414e260, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:7974 #18 0x0000559dfa5bf555 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f5bcc0009a8, packet=packet@entry=0x7f5bcc006fa9 " CALL pkg.pr5(NOW()) /* QNO 969 CON_ID 17 */ ", packet_length=packet_length@entry=67, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1835 #19 0x0000559dfa5bfe23 in do_command (thd=0x7f5bcc0009a8) at /data/src/bb-10.2-compatibility/sql/sql_parse.cc:1383 #20 0x0000559dfa688594 in do_handle_one_connection (connect=connect@entry=0x559e033b9a18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1335 #21 0x0000559dfa688734 in handle_one_connection (arg=0x559e033b9a18) at /data/src/bb-10.2-compatibility/sql/sql_connect.cc:1241 #22 0x00007f5d724e7494 in start_thread (arg=0x7f5c3414f700) at pthread_create.c:333 #23 0x00007f5d708cd93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 it appears to be gone after the fix for MDEV-15070 , along with other failures from MDEV-15080 , so the recommendation is to upgrade to the build #18318 or higher.

            Elena, Valerii, can we close this bug report?

            bar Alexander Barkov added a comment - Elena, Valerii, can we close this bug report?

            People

              bar Alexander Barkov
              valerii Valerii Kravchuk
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.