Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
Description
A user running a custom MariaDB 10.2.11 build with build #17025 from the 10.2-compatibility branch killed an update query, and the query stuck around for over an hour. I suspect that it may have been hung because it was stuck in the "Init for update" state.
Attachments
Issue Links
- relates to
-
-
- Closed
-
-
-
- Closed
-
Activity
After-kill stack trace resembles recently fixed MDEV-14834:
#8 my_print_stacktrace (stack_bottom=<optimized out>, thread_stack=262144) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/mysys/stacktrace.c:271
|
addrs = {0x55b54706544e <my_print_stacktrace+46>, 0x55b546af46dd <handle_fatal_signal(int)+781>, 0x7f2b7b8d55e0 <__restore_rt>, 0x55b5469e6d7d
|
<TABLE::update_virtual_fields(handler*, enum_vcol_update_mode)+349>, 0x55b5468ef317 <fill_record_n_invoke_before_triggers(THD*, TABLE*, List<Item>&, List<Item>&, bool, trg_event_type)+199>,
|
0x55b5469d3a81 <mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, enum_duplicates, bool, unsigned long long*, unsigned long long*)+4769>, 0x55b54693c0db <mysql_execute_command(THD*)+16459>, 0x55b5468b1ca6 <sp_instr_stmt::exec_core(THD*, unsigned int*)+54>,
|
0x55b5468b98e9 <sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*)+153>, 0x55b5468b9ee5 <sp_instr_stmt::execute(THD*, unsigned int*)+517>,
|
0x55b5468b594e <sp_head::execute(THD*, bool)+2030>, 0x55b5468b6a77 <sp_head::execute_procedure(THD*, List<Item>*)+1847>, 0x55b54693148b <do_execute_sp(THD*, sp_head*)+123>,
|
0x55b546933286 <Sql_cmd_call::execute(THD*)+214>, 0x55b546933a80 <Sql_cmd_call::execute(THD*)+144>, 0x55b5469393dd <mysql_execute_command(THD*)+4941>, 0x55b5469533ae
|
<Prepared_statement::execute(String*, bool)+1246>, 0x55b54695353f <Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*)+191>,
|
0x55b546954287 <mysql_stmt_execute_common(THD*, ulong, uchar*, uchar*, ulong, bool, bool)+407>, 0x55b546954317 <mysqld_stmt_execute(THD*, char*, unsigned int)+39>,
|
0x55b546942d92 <dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool)+3378>, 0x55b546944c89 <do_command(THD*)+329>, 0x55b546a095aa <do_handle_one_connection(CONNECT*)+426>,
|
0x55b546a096cd <handle_one_connection(void*)+61>, 0x7f2b7b8cde25 <start_thread+197>, 0x7f2b79f2034d <clone+109>, 0x0, 0x55b549aa610c, 0x7f16dd242380, 0x7f16dd242390, 0x7f2b79fa6fa5,
|
0xbeef98ebd881b800, 0x55b6fbad8001, 0x7f16dd2421b0, 0x55b547948430 <dflt_key_cache>, 0x55b547064ffc <my_write_stderr+28>, 0x7f16dd2421b0, 0x7f2b7b8d46b9 <write+57>, 0x0,
|
0x55b5470650d3 <my_safe_printf_stderr+195>, 0x55b549aa610d, 0x3000000010, 0x7f16dd242490, 0x7f16dd2423c0, 0x6974706d65747441, 0x746b63616220676e, 0x6f59202e65636172, 0x7375206e61632075,
|
0x6f66206568742065, 0x20676e69776f6c6c, 0x74616d726f666e69, 0x66206f74206e6f69, 0xa74756f20646e69, 0x796d206572656877, 0x65696420646c7173, 0x6f79206649202e64, 0x6f6e206565732075,
|
0x6567617373656d20, 0x2072657466612073, 0x6f73202c73696874, 0x20676e696874656d, 0x7265740a746e6577, 0x727720796c626972, 0xa2e2e2e676e6f, 0x616d207369687420, 0xa2e6c6961662079, 0x61206e616320000a,
|
0x63206562206f736c, 0x7962206465737561, 0x636e75666c616d20, 0x20676e696e6f6974, 0x6572617764726168, 0x20202020000a0a2e, 0x4341202020202020, 0x7f16dd242370, 0x7f16dd2423a0, 0x7f16dd242380,
|
0x7f16dd2423a0, 0x7574617453746363, 0x755f2c2777654e73, 0x4320273227386674, 0x27204554414c4c4f, 0x6e65675f38667475, 0x2769635f6c617265, 0x202020200a0d2c29, 0x7f2b79ed7442 <parse_tzname+226>,
|
0x535f544343412020, 0x55544154, 0x4d414e20203d2044, 0x7f16dd242368, 0x7f16dd242460, 0x7f2b7a1e5000 <tzname>, 0x1, 0x7f16dd2424c0, 0x55b62d0d0408, 0x7f2b79ed7a15 <__tzset_parse_tz+485>,
|
0x7f16dd242390, 0x7f16dd2423a0, 0x7f16dd242370, 0x55b549aa610d, 0x55b6351f0008, 0x55b62cdc75e0, 0x55b64d080000, 0x55b62cdc7478, 0x7f16dd240000, 0x55b546b3150c
|
<Item_cond::copy_andor_arguments(THD*, Item_cond*)+76>, 0x55b600000001, 0x0, 0x7f16dd242420, 0xbeef98ebd881b800, 0x7f16dd2424c0, 0x55b5471d2658, 0x1f, 0x7f2b7b8d46ad <write+45>, 0x70, 0x0,
|
0x55b65f015f88, 0x7f16dd242450, 0x55b62cdc7638, 0x5a483a4b, 0x18, 0x7f16dd242470, 0x7f16dd242430, 0x7f16dd2424b8, 0x1, 0x1, 0x55b5470f6420, 0x55b5471db1ad}
|
strings = 0x0
|
n = <optimized out>
|
#9 0x000055b546af46dd in handle_fatal_signal (sig=11) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/signal_handler.cc:166
|
curr_time = 1514682955
|
tm = {tm_sec = 55, tm_min = 15, tm_hour = 9, tm_mday = 31, tm_mon = 11, tm_year = 117, tm_wday = 0, tm_yday = 364, tm_isdst = 0, tm_gmtoff = 28800, tm_zone = 0x55b549a4a130 "SGT"}
|
print_invalid_query_pointer = false
|
#10 <signal handler called>
|
No symbol table info available.
|
#11 0x000055b5469e6d7d in TABLE::update_virtual_fields (this=this@entry=0x55b62d0d0408, h=<optimized out>, update_mode=update_mode@entry=VCOL_UPDATE_FOR_WRITE)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/table.cc:7427
|
vcol_info = 0x55b642c6a680
|
update = <error reading variable update (Cannot access memory at address 0xb787a93d7575d8be)>
|
swap_values = false
|
vf = 0x55b62d0d11f0
|
backup_arena = {_vptr.Query_arena = 0x55b547824170 <vtable for Query_arena+16>, free_list = 0x55b65bfd5410, mem_root = 0x7f16dd2448d0, state = Query_arena::STMT_INITIALIZED_FOR_SP}
|
Suppress_errors = {<Internal_error_handler> = {_vptr.Internal_error_handler = 0x55b54782bef0 <vtable for Turn_errors_to_warnings_handler+16>, m_prev_internal_handler = 0x0}, <No data fields>}
|
handler_pushed = false
|
vfield_ptr = 0x55b62e0be750
|
#12 0x000055b5468ef317 in fill_record_n_invoke_before_triggers (thd=thd@entry=0x55b64d08c008, table=table@entry=0x55b62d0d0408, fields=..., values=..., ignore_errors=ignore_errors@entry=false,
|
event=event@entry=TRG_EVENT_UPDATE) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_base.cc:8176
|
fld = <optimized out>
|
item_field = <optimized out>
|
result = <optimized out>
|
triggers = 0x55b642c69c30
|
#13 0x000055b5469d3a81 in mysql_update (thd=thd@entry=0x55b64d08c008, table_list=0x55b6437e55e8, fields=..., values=..., conds=0x55b65bfd5410, order_num=<optimized out>, order=<optimized out>,
|
limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=found_return@entry=0x7f16dd243170, updated_return=updated_return@entry=0x7f16dd243220)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_update.cc:749
|
using_limit = false
|
transactional_table = true
|
loc_error = <optimized out>
|
dup_key_found = 31
|
select = 0x55b65bfd57b0
|
info = {table = 0x55b62d0d0408, forms = 0x7f16dd242d70, unlock_row = 0x55b54695e360 <rr_unlock_row(st_join_table*)>, read_record = 0x55b546c16d10 <rr_from_tempfile(READ_RECORD*)>,
|
thd = 0x55b64d08c008, select = 0x55b65bfd57b0, cache_records = 0, ref_length = 166, struct_length = 0, reclength = 0, rec_cache_size = 0, error_offset = 0, index = 0,
|
ref_pos = 0x55b642c69ab8 "\f", record = 0x55b633d45020 "\340\337\377/\376\f820200142298", rec_buf = 0x0, cache = 0x0, cache_pos = 0x0, cache_end = 0x0, read_positions = 0x0, addon_field = 0x0,
|
io_cache = 0x55b65bfd57d0, print_error = true, ignore_not_found_rows = false, unpack = 0x0, copy_field = 0x0, copy_field_end = 0x0}
|
will_batch = false
|
error = 0
|
want_privilege = <optimized out>
|
file_sort = 0x0
|
id = <optimized out>
|
killed_status = NOT_KILLED
|
can_compare_record = true
|
updated = 0
|
query_plan = {_vptr.Update_plan = 0x55b54782bb70 <vtable for Update_plan+16>, impossible_where = false, no_partitions = false, updating_a_view = false, mem_root = 0x7f16dd2448d0,
|
table = 0x55b62d0d0408, select = 0x55b65bfd57b0, index = 64, scanned_rows = 1, select_lex = 0x55b665754828, possible_keys = {map = 739}, using_filesort = false, using_io_buffer = true}
|
__FUNCTION__ = "mysql_update"
|
safe_update = <optimized out>
|
found = 0
|
old_covering_keys = <optimized out>
|
table = 0x55b62d0d0408
|
res = <optimized out>
|
table_count = 7
|
err2 = <optimized out>
|
used_key_is_modified = <optimized out>
|
need_sort = false
|
reverse = false
|
select_lex = 0x55b665754828
|
all_fields = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55b5479c6380 <end_of_list>, last = 0x7f16dd242cd0, elements = 0}, <No data fields>}
|
explain = 0x55b65bfd5d20
|
update_source_table = <optimized out>
|
#14 0x000055b54693c0db in mysql_execute_command (thd=0x55b64d08c008) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_parse.cc:4532
|
found = 0
|
updated = 0
|
res = 0
|
lex = 0x55b665754020
|
orig_binlog_format = <optimized out>
|
up_result = 0
|
rpl_filter = <optimized out>
|
orig_current_stmt_binlog_format = <optimized out>
|
__FUNCTION__ = "mysql_execute_command"
|
select_lex = 0x55b665754828
|
first_table = <optimized out>
|
all_tables = 0x55b6437e55e8
|
unit = 0x55b6657540e8
|
have_table_map_for_update = <optimized out>
|
#15 0x000055b5468b1ca6 in sp_instr_stmt::exec_core (this=0x55b66575a2f0, thd=<optimized out>, nextp=0x7f16dd244820)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sp_head.cc:3588
|
res = 1120315008
|
#16 0x000055b5468b98e9 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x55b66575a338, thd=thd@entry=0x55b64d08c008, nextp=nextp@entry=0x7f16dd244820, open_tables=open_tables@entry=false,
|
instr=instr@entry=0x55b66575a2f0) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sp_head.cc:3333
|
res = <optimized out>
|
parent_modified_non_trans_table = false
|
__FUNCTION__ = "reset_lex_and_exec_core"
|
#17 0x000055b5468b9ee5 in sp_instr_stmt::execute (this=0x55b66575a2f0, thd=0x55b64d08c008, nextp=0x7f16dd244820)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sp_head.cc:3504
|
log_slow = <optimized out>
|
res = 0
|
query_backup = {string = {str = 0x55b6580a8020 "call PKG_UPLOAD_ACCT_DTLS.PRC_UPLOAD_ACCT_SUMMARY('A','EODAS','201712310913512610','CBIN','20171230','IN',NULL)", length = 111},
|
cs = 0x55b5479b40c0 <my_charset_utf8_general_ci>}
|
#18 0x000055b5468b594e in sp_head::execute (this=this@entry=0x55b6289ce820, thd=thd@entry=0x55b64d08c008, merge_da_on_success=merge_da_on_success@entry=true)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sp_head.cc:1377
|
user_var_events_alloc_saved = 0x55b64d091060
|
parent_digest = 0x0
|
cur_db_changed = false
|
old_server_status = 0
|
err_status = false
|
save_sql_mode = 270590478
|
execute_arena = {_vptr.Query_arena = 0x55b547824170 <vtable for Query_arena+16>, free_list = 0x0, mem_root = 0x7f16dd2448d0, state = Query_arena::STMT_INITIALIZED_FOR_SP}
|
sp_wi = {m_warn_root = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 2009, total_alloc = 0, block_num = 4, first_block_usage = 0,
|
error_handler = 0x55b5469e9710 <sql_alloc_error_handler()>}, m_warn_list = {<I_P_List_counter> = {m_counter = 0}, <I_P_List_fast_push_back<Sql_condition>> = {m_last = 0x7f16dd244960},
|
m_first = 0x0}, m_warn_count = {0, 0, 0}, m_current_statement_warn_count = 0, m_current_row_for_warning = 1, m_warn_id = 3740550584, m_error_condition = 0x0, m_allow_unlimited_warnings = false,
|
initialized = true, m_read_only = false, m_next_in_da = 0x55b64d0912e0, m_prev_in_da = 0x55b64d0913a0, m_marked_sql_conditions = {<base_list> = {<Sql_alloc> = {<No data fields>},
|
first = 0x55b5479c6380 <end_of_list>, last = 0x7f16dd2449a8, elements = 0}, <No data fields>}}
|
saved_cur_db_name_buf = '\000' <repeats 168 times>, " \350\234(\266U\000\000@K$\335\026\177\000\000\b\300\bM\266U\000\000\330\352\234(\266U\000\000"...
|
old_lex = 0x55b66a346020
|
old_change_list = {<base_ilist> = {first = 0x55b64d08f468, last = {_vptr.ilink = 0x55b54781e4b0 <vtable for ilink+16>, prev = 0x55b64d08f460, next = 0x0}}, <No data fields>}
|
save_reprepare_observer = 0x7f16dd246ad0
|
saved_cur_db_name = {str = 0x7f16dd2449c0 "", length = 202}
|
ctx = 0x55b64555d680
|
save_abort_on_warning = false
|
old_arena = 0x55b64049a1e0
|
execute_mem_root = {free = 0x55b62828c008, used = 0x55b65bfd4008, pre_alloc = 0x0, min_malloc = 32, block_size = 8152, total_alloc = 16304, block_num = 6, first_block_usage = 0,
|
error_handler = 0x55b5469e9710 <sql_alloc_error_handler()>}
|
i = 0x55b66575a2f0
|
ip = 154
|
backup_arena = {_vptr.Query_arena = 0x55b547824170 <vtable for Query_arena+16>, free_list = 0x55b65eea76d0, mem_root = 0x55b64d091060, state = Query_arena::STMT_CONVENTIONAL_EXECUTION}
|
old_query_id = 3735567516
|
old_derived_tables = 0x0
|
old_packet = {Ptr = 0x55b6416ab008 "\003def", str_length = 23, Alloced_length = 16392, extra_alloc = 0, alloced = true, thread_specific = false, str_charset = 0x55b54794bea0 <my_charset_bin>}
|
saved_creation_ctx = 0x55b65eea7758
|
da = 0x55b64d0910a0
|
#19 0x000055b5468b6a77 in sp_head::execute_procedure (this=0x55b6289ce820, thd=thd@entry=0x55b64d08c008, args=0x55b66a346e10)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sp_head.cc:2299
|
params = <optimized out>
|
save_spcont = 0x0
|
nctx = 0x55b64555d680
|
octx = 0x55b6580c5ad0
|
save_log_general = true
|
__FUNCTION__ = "execute_procedure"
|
need_binlog_call = <optimized out>
|
err_status = false
|
utime_before_sp_exec = 3154992596569
|
save_enable_slow_log = true
|
pkg = 0x0
|
save_security_ctx = 0x55b64d08dac0
|
#20 0x000055b54693148b in do_execute_sp (thd=thd@entry=0x55b64d08c008, sp=sp@entry=0x55b6289ce820)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_parse.cc:2920
|
bits_to_be_cleared = <optimized out>
|
select_limit = 18446744073709551615
|
res = <optimized out>
|
#21 0x000055b546933286 in Sql_cmd_call::execute (this=this@entry=0x55b66a3486d0, thd=thd@entry=0x55b64d08c008)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_parse.cc:3160
|
sp = 0x55b6289ce820
|
#22 0x000055b546933a80 in Sql_cmd_call::execute (this=0x55b66a3486d0, thd=0x55b64d08c008) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_parse.cc:3114
|
No locals.
|
#23 0x000055b5469393dd in mysql_execute_command (thd=0x55b64d08c008) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_parse.cc:6236
|
res = 0
|
lex = 0x55b66a346020
|
orig_binlog_format = <optimized out>
|
up_result = 0
|
rpl_filter = <optimized out>
|
orig_current_stmt_binlog_format = <optimized out>
|
__FUNCTION__ = "mysql_execute_command"
|
select_lex = 0x55b66a346828
|
first_table = <optimized out>
|
all_tables = 0x0
|
unit = 0x55b66a3460e8
|
have_table_map_for_update = <optimized out>
|
#24 0x000055b5469533ae in Prepared_statement::execute (this=this@entry=0x55b64049a1c8, expanded_query=expanded_query@entry=0x7f16dd246f90, open_cursor=open_cursor@entry=false)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_prepare.cc:4777
|
parent_locker = <optimized out>
|
stmt_backup = {<ilink> = {_vptr.ilink = 0x55b5478241b0 <vtable for Statement+16>, prev = 0x0, next = 0x0}, <Query_arena> = {_vptr.Query_arena = 0x55b5478241e0 <vtable for Statement+64>,
|
free_list = 0x7f16dd246910, mem_root = 0x55b5470614e5 <my_malloc+101>, state = -584816336}, id = 0, mark_used_columns = MARK_COLUMNS_READ, name = {
|
str = 0x55b5479b40c0 <my_charset_utf8_general_ci> "!", length = 139736176159024}, lex = 0x55b64d08fa88, query_string = {string = {
|
str = 0x55b6580a8020 "call PKG_UPLOAD_ACCT_DTLS.PRC_UPLOAD_ACCT_SUMMARY('A','EODAS','201712310913512610','CBIN','20171230','IN',NULL)", length = 111},
|
cs = 0x55b5479b40c0 <my_charset_utf8_general_ci>}, base_query = {Ptr = 0x0, str_length = 0, Alloced_length = 0, extra_alloc = 0, alloced = false, thread_specific = false,
|
str_charset = 0x55b54794bea0 <my_charset_bin>}, db = 0x55b64d08c248 "\bN\302O\266U", db_length = 94241464828488, query_cache_is_applicable = 20 '\024'}
|
old_stmt_arena = 0x55b64d08c020
|
saved_cur_db_name_buf = "Po$\335\026\177\000\000\000z)0\000\000\000\000\065`jA\266U\000\000\255J\215{+\177\000\000m`jA\266U\000\000\b`jA\266U\000\000\313i$\335\026\177\000\000\000\000\000\000\000\000\000\000\300i$\335\026\177\000\000\bN\302O\266U\000\000tdsdbinuser\000\265U\000\000Pj$\335\026\177\000\000\360i$\335\026\177\000\000\347\000\000\000\000\000\000\000\b`jA\266U\000\000\241\320\017D\310f\343`\266IB\252(\360\226v*\334\030\321W\347\021\"\006\362{\203v\257\254N\264~T\274\023\210R\311pl![\210\b\370\323\340\372\227\006UQs\203ʢS\213\022\346!0\000j$\335\026\177\000\000P"...
|
saved_cur_db_name = {str = 0x7f16dd246970 "Po$\335\026\177", length = 202}
|
cur_db_changed = false
|
error = true
|
stmt_db_name = {str = 0x55b66a3475f8 "tdsdbinowner", length = 12}
|
#25 0x000055b54695353f in Prepared_statement::execute_loop (this=0x55b64049a1c8, expanded_query=0x7f16dd246f90, open_cursor=false, packet_end=<optimized out>, packet=<optimized out>)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_prepare.cc:4206
|
reprepare_observer = {m_invalidated = false}
|
error = <optimized out>
|
#26 0x000055b546954287 in mysql_stmt_execute_common (thd=thd@entry=0x55b64d08c008, stmt_id=3, packet=packet@entry=0x55b6416a6012 "@\001\017", packet_end=packet_end@entry=0x55b6416a604e "", cursor_flags=0,
|
bulk_op=bulk_op@entry=false, read_types=read_types@entry=false) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_prepare.cc:3224
|
expanded_query = {Ptr = 0x55b635410f48 "call PKG_UPLOAD_ACCT_DTLS.PRC_UPLOAD_ACCT_SUMMARY('A','EODAS','201712310913512610','CBIN','20171230','IN',NULL)", str_length = 111, Alloced_length = 184,
|
extra_alloc = 128, alloced = true, thread_specific = false, str_charset = 0x55b54794bea0 <my_charset_bin>}
|
stmt = 0x55b64049a1c8
|
save_protocol = 0x55b64d08c518
|
open_cursor = false
|
#27 0x000055b546954317 in mysqld_stmt_execute (thd=thd@entry=0x55b64d08c008, packet_arg=packet_arg@entry=0x55b6416a6009 "\003", packet_length=packet_length@entry=69)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_prepare.cc:3122
|
packet = 0x55b6416a6012 "@\001\017"
|
stmt_id = <optimized out>
|
flags = <optimized out>
|
packet_end = 0x55b6416a604e ""
|
#28 0x000055b546942d92 in dispatch_command (command=command@entry=COM_STMT_EXECUTE, thd=thd@entry=0x55b64d08c008, packet=packet@entry=0x55b6416a6009 "\003", packet_length=packet_length@entry=69,
|
is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_parse.cc:1776
|
net = 0x55b64d08c248
|
do_end_of_statement = true
|
__FUNCTION__ = "dispatch_command"
|
error = false
|
drop_more_results = false
|
#29 0x000055b546944c89 in do_command (thd=0x55b64d08c008) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_parse.cc:1383
|
return_value = <optimized out>
|
packet = 0x55b6416a6008 "\027\003"
|
packet_length = 70
|
net = 0x55b64d08c248
|
command = COM_STMT_EXECUTE
|
#30 0x000055b546a095aa in do_handle_one_connection (connect=connect@entry=0x55b63d71d6c8) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_connect.cc:1354
|
create_user = true
|
thr_create_utime = <optimized out>
|
thd = 0x55b64d08c008
|
#31 0x000055b546a096cd in handle_one_connection (arg=0x55b63d71d6c8) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_connect.cc:1260
|
connect = 0x55b63d71d6c8
|
#32 0x00007f2b7b8cde25 in start_thread () from /lib64/libpthread.so.0
|
No symbol table info available.
|
#33 0x00007f2b79f2034d in clone () from /lib64/libc.so.6
|
No symbol table info available.
|
Assigning to monty to confirm whether it can be the same problem.
My fix of MDEV-13935 was not applied nor merged to the bb-10.2-compatibility branch. I applied it to bb-10.2-compatibility today.
Is the above stack trace really from something that is stuck in "Init for update" ?
The stack trace shows that the code is called from mysql_update.cc::749.
Just before this line we have:
THD_STAGE_INFO(thd, stage_updating);
Which should change the state to "Updating"
I can't see how the function update_virtual_fields() could cause a hang and I have never experienced a hang in this code.
(Being able to examine a core for this kind of hang could help find out what really
happens)
MDEV-14834 was fixing a crash and is unrelated to any hung.
Did they have a hung in init before? Init for update is used instead of it now.