Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
N/A
-
bb-10.2-compatibility build 18009
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
- relates to
-
MDEV-15070 Crash when doing a CREATE VIEW inside a package routine
-
- Closed
-
-
MDEV-15080 ASAN heap-use-after-free in Query_tables_list::set_query_tables_list / Sp_handler::sp_cache_package_routine or crash in MDL_key::mdl_namespace
-
- Closed
-
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 fromMDEV-15080, so the recommendation is to upgrade to the build #18318 or higher.