#################### /home/vsts/logs/vardir/data/core #################### /home/vsts/server/bin/mysqld [New LWP 8668] [New LWP 8601] [New LWP 8609] [New LWP 8606] [New LWP 8614] [New LWP 8608] [New LWP 8618] [New LWP 8610] [New LWP 8621] [New LWP 8611] [New LWP 8612] [New LWP 8613] [New LWP 8623] [New LWP 8615] [New LWP 8625] [New LWP 8616] [New LWP 8626] [New LWP 8617] [New LWP 8627] [New LWP 8622] [New LWP 8624] [New LWP 8628] [New LWP 8629] [New LWP 8631] [New LWP 8632] [New LWP 8630] [New LWP 8664] [New LWP 8634] [New LWP 8666] [New LWP 8600] [New LWP 8670] [New LWP 8673] [New LWP 8675] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". Core was generated by `/home/vsts/server/bin/mysqld --no-defaults --basedir=/home/vsts/server --lc-mes'. Program terminated with signal SIGSEGV, Segmentation fault. #0 __pthread_kill (threadid=, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 [Current thread is 1 (Thread 0x7ff8cc152b00 (LWP 8668))] Thread 33 (Thread 0x7ff8cc074b00 (LWP 8675)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 No locals. #1 0x00005644c607790a in safe_cond_timedwait (cond=0x5644c86ff168, mp=0x5644c86ff0b8, abstime=0x7ff8cc071ec0, file=0x5644c61a00c0 "/home/vsts/src/include/mysql/psi/mysql_thread.h", line=1202) at /home/vsts/src/mysys/thr_mutex.c:547 error = 32760 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 8675, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\343!\000\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 8675, __nusers = 1, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\343!\000\000\001", '\000' , __align = 1}, file = 0x5644c61a03fa "/home/vsts/src/sql/mdl.cc", name = 0x5644c61a05b4 "m_LOCK_wait_status", line = 1063, count = 0, create_flags = 0, active_flags = 0, id = 856, thread = 140706551646976, locked_mutex = 0x7ff87c00c640, used_mutex = 0x7ff87c00c6a8, prev = 0x0, next = 0x0} #2 0x00005644c590b8f0 in inline_mysql_cond_timedwait (that=0x5644c86ff168, mutex=0x5644c86ff0b8, abstime=0x7ff8cc071ec0, src_file=0x5644c61a03fa "/home/vsts/src/sql/mdl.cc", src_line=1088) at /home/vsts/src/include/mysql/psi/mysql_thread.h:1202 result = 32760 #3 0x00005644c590cc43 in MDL_wait::timed_wait (this=0x5644c86ff0b8, owner=0x5644c86ff070, abs_timeout=0x7ff8cc071ec0, set_status_on_timeout=false, wait_state_name=0x5644c6935d70 ) at /home/vsts/src/sql/mdl.cc:1088 old_stage = {m_key = 0, m_name = 0x5644c6151716 "Opening tables", m_flags = -871948816} result = MDL_wait::EMPTY wait_result = 0 _db_stack_frame_ = {func = 0x5644c61a0940 "MDL_context::acquire_lock", file = 0x5644c61a03fa "/home/vsts/src/sql/mdl.cc", level = 2147483658, line = -1, prev = 0x7ff8cc071ed0} __FUNCTION__ = "timed_wait" __PRETTY_FUNCTION__ = "MDL_wait::enum_wait_status MDL_wait::timed_wait(MDL_context_owner*, timespec*, bool, const PSI_stage_info*)" #4 0x00005644c590e780 in MDL_context::acquire_lock (this=0x5644c86ff0b8, mdl_request=0x7ff87c0096e8, lock_wait_timeout=10) at /home/vsts/src/sql/mdl.cc:2125 lock = 0x7ff86c56d030 ticket = 0x7ff87c00c580 wait_status = MDL_wait::EMPTY _db_stack_frame_ = {func = 0x5644c6160ebe "open_table", file = 0x5644c61606a8 "/home/vsts/src/sql/sql_base.cc", level = 2147483657, line = -1, prev = 0x7ff8cc0721d0} __PRETTY_FUNCTION__ = "bool MDL_context::acquire_lock(MDL_request*, double)" abs_timeout = {tv_sec = 1548994447, tv_nsec = 151304000} abs_shortwait = {tv_sec = 1548994438, tv_nsec = 151304000} #5 0x00005644c5762092 in open_table_get_mdl_lock (thd=0x5644c86fefc0, ot_ctx=0x7ff8cc072580, mdl_request=0x7ff87c0096e8, flags=0, mdl_ticket=0x7ff8cc0721b0) at /home/vsts/src/sql/sql_base.cc:2115 mdl_deadlock_handler = { = {_vptr.Internal_error_handler = 0x5644c6870b40 , m_prev_internal_handler = 0x0}, m_ot_ctx = 0x7ff8cc072580, m_is_active = false} result = false mdl_request_shared = {type = 3423019120, duration = 32760, next_in_list = 0x5644c6093d20 <_db_doprnt_+519>, prev_in_list = 0x7ff86c3e7b00, ticket = 0x5644c63563c8, key = {m_length = 0, m_db_name_length = 0, m_hash_value = 0, m_ptr = "\000\000\000\000\000\000\000\000\240\f\000|\370\177\000\000\b\000\000\000\060\000\000\000\200 \a\314\370\177\000\000\300\037\a\314\370\177\000\000x{>l\370\177\000\000T\023\034\306DV\000\000`\r\263\306DV\000\000\300R\036\320\370\177", '\000' , "\240\f\000|\370\177\000\000x\f\000|\002\000\001\000\000!\a\314\370\177\000\000\371\376\006\306DV\000\000p\020\034\306DV\000\000\060\v\000|\370\177\000\000@ \a\314\370\177\000\000k\023\t\306DV\000\000\240\f\000|\370\177\000\000Q\377\006\306DV\000\000p \a\314\370\177\000\000\060\v\000|\370\177\000\000p \a\314\370\177\000\000\205i\a\306DV\000\000"..., static m_namespace_to_wait_state_name = {{m_key = 0, m_name = 0x5644c61a02cb "Waiting for global read lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a02e8 "Waiting for schema metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0310 "Waiting for table metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0330 "Waiting for stored function metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0360 "Waiting for stored procedure metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0390 "Waiting for trigger metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a03b8 "Waiting for event metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a03d8 "Waiting for commit lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a03f0 "User lock", m_flags = 0}}}} __PRETTY_FUNCTION__ = "bool open_table_get_mdl_lock(THD*, Open_table_context*, MDL_request*, uint, MDL_ticket**)" #6 0x00005644c576298d in open_table (thd=0x5644c86fefc0, table_list=0x7ff87c0092c0, ot_ctx=0x7ff8cc072580) at /home/vsts/src/sql/sql_base.cc:2406 table = 0x7ff87c000ca0 key = 0x7ff87c009711 "test" key_length = 44 alias = 0x7ff87c009298 "table0_aria_key_pk_parts_2_int_autoinc" flags = 0 mdl_ticket = 0x7ff87c00dbf0 share = 0x70000000b gts_flags = 3423019424 _db_stack_frame_ = {func = 0x5644c61612d3 "open_and_process_table", file = 0x5644c61606a8 "/home/vsts/src/sql/sql_base.cc", level = 2147483656, line = -1, prev = 0x7ff8cc072490} __PRETTY_FUNCTION__ = "bool open_table(THD*, TABLE_LIST*, Open_table_context*)" #7 0x00005644c5765947 in open_and_process_table (thd=0x5644c86fefc0, lex=0x5644c8702a30, tables=0x7ff87c0092c0, counter=0x7ff8cc072690, flags=0, prelocking_strategy=0x7ff8cc072600, has_prelocking_list=false, ot_ctx=0x7ff8cc072580) at /home/vsts/src/sql/sql_base.cc:4124 error = false safe_to_ignore_table = false _db_stack_frame_ = {func = 0x5644c6161415 "open_tables", file = 0x5644c61606a8 "/home/vsts/src/sql/sql_base.cc", level = 2147483655, line = -1, prev = 0x7ff8cc072560} __PRETTY_FUNCTION__ = "bool open_and_process_table(THD*, LEX*, TABLE_LIST*, uint*, uint, Prelocking_strategy*, bool, Open_table_context*)" #8 0x00005644c5766a40 in open_tables (thd=0x5644c86fefc0, options=..., start=0x7ff8cc072670, counter=0x7ff8cc072690, flags=0, prelocking_strategy=0x7ff8cc072600) at /home/vsts/src/sql/sql_base.cc:4639 table_to_open = 0x7ff87c0057e8 sroutine_to_open = 0x5644c8702ac8 tables = 0x7ff87c0092c0 ot_ctx = {m_thd = 0x5644c86fefc0, m_failed_table = 0x0, m_start_of_statement_svp = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0}, m_timeout = 10, m_flags = 0, m_action = Open_table_context::OT_NO_ACTION, m_has_locks = false, m_has_protection_against_grl = true} error = false some_routine_modifies_data = false has_prelocking_list = false _db_stack_frame_ = {func = 0x5644c618ba39 "mysql_update", file = 0x5644c618b9d8 "/home/vsts/src/sql/sql_update.cc", level = 2147483654, line = -1, prev = 0x7ff8cc072760} xa_state = XA_NOTR __FUNCTION__ = "open_tables" __PRETTY_FUNCTION__ = "bool open_tables(THD*, const DDL_options_st&, TABLE_LIST**, uint*, uint, Prelocking_strategy*)" #9 0x00005644c57a7b12 in open_tables (thd=0x5644c86fefc0, tables=0x7ff8cc072670, counter=0x7ff8cc072690, flags=0) at /home/vsts/src/sql/sql_base.h:513 prelocking_strategy = { = {_vptr.Prelocking_strategy = 0x5644c6870ae0 }, } #10 0x00005644c58a91c4 in mysql_update (thd=0x5644c86fefc0, table_list=0x7ff87c0057e0, fields=..., values=..., conds=0x7ff87c006160, order_num=5, order=0x7ff87c0063f0, limit=5, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7ff8cc072d50, updated_return=0x7ff8cc072de0) at /home/vsts/src/sql/sql_update.cc:285 using_limit = true safe_update = false used_key_is_modified = false transactional_table = 7 will_batch = false can_compare_record = 204 res = 2080378016 error = 32760 loc_error = 2080378016 dup_key_found = 0 need_sort = true reverse = false want_privilege = 22084 table_count = 1 updated = 281477057088304 found = 140706551637760 old_covering_keys = {map = 140705208994976} table = 0x7ff8cc072940 select = 0x0 info = {table = 0x5644c6356b29, forms = 0x7c000b30, unlock_row = 0x5644c61485ad, read_record = 0x7ff87c000ca0, thd = 0x7ff87c000ca0, select = 0x7c000c78, cache_records = 3323407248, ref_length = 22084, struct_length = 0, reclength = 0, rec_cache_size = 3423021648, error_offset = 32760, index = 2080377648, ref_pos = 0x7ff8cc072840 "\200*\a\314\370\177", record = 0x5644c60946a8 "\203\370\003t.\203\370\003\177\023\203\370\001t2\203\370\001\177&\205\300t", , rec_buf = 0x7ff87c000ca0 "\271\301Fo\374\177", cache = 0x7ff87c000ca0 "\271\301Fo\374\177", cache_pos = 0x7ff8cc072a80 "\320*\a\314\370\177", cache_end = 0x5644c6093ab8 <_db_return_+527> "H\211\302\213\205\340\375\377\377\211\002\353\004\220\353\001\220H\213E\370dH3\004%(", read_positions = 0x7ff87c000ca0 "\271\301Fo\374\177", io_cache = 0x7ff8cc072aa0, print_error = 11, ignore_not_found_rows = false, copy_field = 0x7ff87c000ca0, copy_field_end = 0x7ff8cc0728b0} select_lex = 0x5644c87031f8 id = 281477057088304 all_fields = { = { = {}, first = 0x5644c6b0f7e0 , last = 0x7ff8cc072740, elements = 0}, } killed_status = NOT_KILLED query_plan = {_vptr.Update_plan = 0x5644c6875be0 , impossible_where = false, no_partitions = false, updating_a_view = false, mem_root = 0x5644c8703f18, table = 0x0, select = 0x7ff87c000ca0, index = 64, scanned_rows = 140706551637968, select_lex = 0x5644c60946a8 , possible_keys = {map = 140705208994976}, using_filesort = false, using_io_buffer = false} explain = 0x5644c6093ab8 <_db_return_+527> _db_stack_frame_ = {func = 0x5644c6171a3f "mysql_execute_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7ff8cc072d10} __PRETTY_FUNCTION__ = "int mysql_update(THD*, TABLE_LIST*, List&, List&, COND*, uint, ORDER*, ha_rows, enum_duplicates, bool, ha_rows*, ha_rows*)" __FUNCTION__ = "mysql_update" err2 = 32760 #11 0x00005644c57ce748 in mysql_execute_command (thd=0x5644c86fefc0) at /home/vsts/src/sql/sql_parse.cc:3790 found = 0 updated = 0 res = 0 up_result = 0 lex = 0x5644c8702a30 select_lex = 0x5644c87031f8 first_table = 0x7ff87c0057e0 all_tables = 0x7ff87c0057e0 unit = 0x5644c8702af8 have_table_map_for_update = false rpl_filter = 0x7ff87c000b30 _db_stack_frame_ = {func = 0x5644c61728f8 "mysql_parse", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7ff8cc0734f0} __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" orig_binlog_format = BINLOG_FORMAT_STMT orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT __FUNCTION__ = "mysql_execute_command" #12 0x00005644c57d9f13 in mysql_parse (thd=0x5644c86fefc0, rawbuf=0x7ff87c0054c8 "UPDATE LOW_PRIORITY `view_table0_aria_key_pk_parts_2_int_autoinc` AS X SET `col_int` = 59 WHERE X.`pk` < 't' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 5 /* QNO 276 CO"..., length=210, parser_state=0x7ff8cc073670) at /home/vsts/src/sql/sql_parse.cc:7468 found_semicolon = 0x0 lex = 0x5644c8702a30 err = false error = 32760 _db_stack_frame_ = {func = 0x5644c61715d9 "dispatch_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7ff8cc073650} __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*)" __FUNCTION__ = "mysql_parse" #13 0x00005644c57c8437 in dispatch_command (command=COM_QUERY, thd=0x5644c86fefc0, packet=0x5644c87064f1 "UPDATE LOW_PRIORITY `view_table0_aria_key_pk_parts_2_int_autoinc` AS X SET `col_int` = 59 WHERE X.`pk` < 't' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 5 /* QNO 276 CO"..., packet_length=211) at /home/vsts/src/sql/sql_parse.cc:1496 packet_end = 0x7ff87c00559a "" parser_state = {m_input = {m_compute_digest = false}, m_lip = {m_thd = 0x5644c86fefc0, yylineno = 1, yylval = 0x7ff8cc072740, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7ff87c00559b "\004", m_tok_start = 0x7ff87c00559b "\004", m_tok_end = 0x7ff87c00559b "\004", m_end_of_query = 0x7ff87c00559a "", m_tok_start_prev = 0x7ff87c00559a "", m_buf = 0x7ff87c0054c8 "UPDATE LOW_PRIORITY `view_table0_aria_key_pk_parts_2_int_autoinc` AS X SET `col_int` = 59 WHERE X.`pk` < 't' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 5 /* QNO 276 CO"..., m_buf_length = 210, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7ff87c005600 "UPDATE LOW_PRIORITY `view_table0_aria_key_pk_parts_2_int_autoinc` AS X SET `col_int` = 59 WHERE X.`pk` < 't' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 5 /* QNO 276 CO"..., m_cpp_ptr = 0x7ff87c0056d2 "", m_cpp_tok_start = 0x7ff87c0056d2 "", m_cpp_tok_start_prev = 0x7ff87c0056d2 "", m_cpp_tok_end = 0x7ff87c0056d2 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x5644c8703f50 "", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 119 'w', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = NO_COMMENT, m_cpp_text_start = 0x7ff87c0056b9 "5 /* QNO 276 CON_ID 14 */", m_cpp_text_end = 0x7ff87c0056ba " /* QNO 276 CON_ID 14 */", m_underscore_cs = 0x0, m_digest = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 }}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x0} net = 0x5644c86ff280 error = false do_end_of_statement = true _db_stack_frame_ = {func = 0x5644c61713cb "do_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7ff8cc073e50} __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" __FUNCTION__ = "dispatch_command" #14 0x00005644c57c71a9 in do_command (thd=0x5644c86fefc0) at /home/vsts/src/sql/sql_parse.cc:1124 return_value = false packet = 0x5644c87064f0 "\003UPDATE LOW_PRIORITY `view_table0_aria_key_pk_parts_2_int_autoinc` AS X SET `col_int` = 59 WHERE X.`pk` < 't' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 5 /* QNO 276 C"... packet_length = 212 net = 0x5644c86ff280 command = COM_QUERY _db_stack_frame_ = {func = 0x5644c6358ebd "?func", file = 0x5644c6358ec3 "?file", level = 2147483649, line = -1, prev = 0x0} __PRETTY_FUNCTION__ = "bool do_command(THD*)" #15 0x00005644c59028f2 in do_handle_one_connection (thd_arg=0x5644c86fefc0) at /home/vsts/src/sql/sql_connect.cc:1330 create_user = true thd = 0x5644c86fefc0 #16 0x00005644c5902641 in handle_one_connection (arg=0x5644c86fefc0) at /home/vsts/src/sql/sql_connect.cc:1242 thd = 0x5644c86fefc0 #17 0x00007ff8cffd46ba in start_thread (arg=0x7ff8cc074b00) at pthread_create.c:333 __res = pd = 0x7ff8cc074b00 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140706551646976, 7669664285794399464, 0, 140722175383455, 140706551647680, 0, -7673703826951080728, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #18 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 32 (Thread 0x7ff8cc0beb00 (LWP 8673)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 No locals. #1 0x00005644c607790a in safe_cond_timedwait (cond=0x5644c86f3af8, mp=0x5644c86f3a48, abstime=0x7ff8cc0bbec0, file=0x5644c61a00c0 "/home/vsts/src/include/mysql/psi/mysql_thread.h", line=1202) at /home/vsts/src/mysys/thr_mutex.c:547 error = 32760 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 8673, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\341!\000\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 8673, __nusers = 1, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\341!\000\000\001", '\000' , __align = 1}, file = 0x5644c61a03fa "/home/vsts/src/sql/mdl.cc", name = 0x5644c61a05b4 "m_LOCK_wait_status", line = 1063, count = 0, create_flags = 0, active_flags = 0, id = 835, thread = 140706551950080, locked_mutex = 0x7ff870016f00, used_mutex = 0x7ff870016f68, prev = 0x0, next = 0x0} #2 0x00005644c590b8f0 in inline_mysql_cond_timedwait (that=0x5644c86f3af8, mutex=0x5644c86f3a48, abstime=0x7ff8cc0bbec0, src_file=0x5644c61a03fa "/home/vsts/src/sql/mdl.cc", src_line=1088) at /home/vsts/src/include/mysql/psi/mysql_thread.h:1202 result = 32760 #3 0x00005644c590cc43 in MDL_wait::timed_wait (this=0x5644c86f3a48, owner=0x5644c86f3a00, abs_timeout=0x7ff8cc0bbec0, set_status_on_timeout=false, wait_state_name=0x5644c6935d70 ) at /home/vsts/src/sql/mdl.cc:1088 old_stage = {m_key = 0, m_name = 0x5644c6151716 "Opening tables", m_flags = -871645712} result = MDL_wait::EMPTY wait_result = 0 _db_stack_frame_ = {func = 0x5644c61a0940 "MDL_context::acquire_lock", file = 0x5644c61a03fa "/home/vsts/src/sql/mdl.cc", level = 2147483658, line = -1, prev = 0x7ff8cc0bbed0} __FUNCTION__ = "timed_wait" __PRETTY_FUNCTION__ = "MDL_wait::enum_wait_status MDL_wait::timed_wait(MDL_context_owner*, timespec*, bool, const PSI_stage_info*)" #4 0x00005644c590e780 in MDL_context::acquire_lock (this=0x5644c86f3a48, mdl_request=0x7ff870006250, lock_wait_timeout=10) at /home/vsts/src/sql/mdl.cc:2125 lock = 0x7ff86c56d030 ticket = 0x7ff87000de00 wait_status = MDL_wait::EMPTY _db_stack_frame_ = {func = 0x5644c6160ebe "open_table", file = 0x5644c61606a8 "/home/vsts/src/sql/sql_base.cc", level = 2147483657, line = -1, prev = 0x7ff8cc0bc1d0} __PRETTY_FUNCTION__ = "bool MDL_context::acquire_lock(MDL_request*, double)" abs_timeout = {tv_sec = 1548994446, tv_nsec = 890892000} abs_shortwait = {tv_sec = 1548994437, tv_nsec = 890892000} #5 0x00005644c5762092 in open_table_get_mdl_lock (thd=0x5644c86f3950, ot_ctx=0x7ff8cc0bc580, mdl_request=0x7ff870006250, flags=0, mdl_ticket=0x7ff8cc0bc1b0) at /home/vsts/src/sql/sql_base.cc:2115 mdl_deadlock_handler = { = {_vptr.Internal_error_handler = 0x5644c6870b40 , m_prev_internal_handler = 0x0}, m_ot_ctx = 0x7ff8cc0bc580, m_is_active = false} result = false mdl_request_shared = {type = 3323594739, duration = 22084, next_in_list = 0x7ff870001250, prev_in_list = 0x7ff870001250, ticket = 0x1000270001228, key = {m_length = 49296, m_db_name_length = 52235, m_hash_value = 32760, m_ptr = " =\t\306DV\000\000\372\003\032\306DV\000\000n\t\032\306DV\000\000\323O\030\306\000\000\000\000 \000\000p\370\177\000\000P\022\000p\370\177\000\000\b\000\000\000\060\000\000\000\240\300\v\314\370\177\000\000\340\277\v\314\370\177\000\000\020\300\v\314\370\177\000\000\001\000\000\000\000\000\000\000\363\a\032\306DV\000\000\300R\036\320\370\177", '\000' , "@\300\v\314\370\177\000\000p\023\221\305DV\000\000\320\315\rp\370\177\000\000\371\376\006\306DV\000\000\n\000\000\000\000\000\000\000\340\020\000p\370\177\000\000`\300\v\314\370\177\000\000k\023\t\306\000\000\000\000Tw\026\306DV\000\000\000\000\000\000\000\000\000\000"..., static m_namespace_to_wait_state_name = {{m_key = 0, m_name = 0x5644c61a02cb "Waiting for global read lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a02e8 "Waiting for schema metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0310 "Waiting for table metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0330 "Waiting for stored function metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0360 "Waiting for stored procedure metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0390 "Waiting for trigger metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a03b8 "Waiting for event metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a03d8 "Waiting for commit lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a03f0 "User lock", m_flags = 0}}}} __PRETTY_FUNCTION__ = "bool open_table_get_mdl_lock(THD*, Open_table_context*, MDL_request*, uint, MDL_ticket**)" #6 0x00005644c576298d in open_table (thd=0x5644c86f3950, table_list=0x7ff870005e28, ot_ctx=0x7ff8cc0bc580) at /home/vsts/src/sql/sql_base.cc:2406 table = 0x666f2065756c6176 key = 0x7ff870006279 "test" key_length = 44 alias = 0x7ff870005e10 "X" flags = 0 mdl_ticket = 0x274c414e4f495443 share = 0x7ff8cc0bc1b8 gts_flags = 539452772 _db_stack_frame_ = {func = 0x5644c61612d3 "open_and_process_table", file = 0x5644c61606a8 "/home/vsts/src/sql/sql_base.cc", level = 2147483656, line = -1, prev = 0x7ff8cc0bc490} __PRETTY_FUNCTION__ = "bool open_table(THD*, TABLE_LIST*, Open_table_context*)" #7 0x00005644c5765947 in open_and_process_table (thd=0x5644c86f3950, lex=0x5644c86f73c0, tables=0x7ff870005e28, counter=0x7ff8cc0bc690, flags=0, prelocking_strategy=0x7ff8cc0bc600, has_prelocking_list=false, ot_ctx=0x7ff8cc0bc580) at /home/vsts/src/sql/sql_base.cc:4124 error = false safe_to_ignore_table = false _db_stack_frame_ = {func = 0x5644c6161415 "open_tables", file = 0x5644c61606a8 "/home/vsts/src/sql/sql_base.cc", level = 2147483655, line = -1, prev = 0x7ff8cc0bc560} __PRETTY_FUNCTION__ = "bool open_and_process_table(THD*, LEX*, TABLE_LIST*, uint*, uint, Prelocking_strategy*, bool, Open_table_context*)" #8 0x00005644c5766a40 in open_tables (thd=0x5644c86f3950, options=..., start=0x7ff8cc0bc670, counter=0x7ff8cc0bc690, flags=0, prelocking_strategy=0x7ff8cc0bc600) at /home/vsts/src/sql/sql_base.cc:4639 table_to_open = 0x7ff8cc0bc670 sroutine_to_open = 0x5644c86f7458 tables = 0x7ff870005e28 ot_ctx = {m_thd = 0x5644c86f3950, m_failed_table = 0x0, m_start_of_statement_svp = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0}, m_timeout = 10, m_flags = 0, m_action = Open_table_context::OT_NO_ACTION, m_has_locks = false, m_has_protection_against_grl = true} error = false some_routine_modifies_data = false has_prelocking_list = false _db_stack_frame_ = {func = 0x5644c618ba39 "mysql_update", file = 0x5644c618b9d8 "/home/vsts/src/sql/sql_update.cc", level = 2147483654, line = -1, prev = 0x7ff8cc0bc760} xa_state = XA_NOTR __FUNCTION__ = "open_tables" __PRETTY_FUNCTION__ = "bool open_tables(THD*, const DDL_options_st&, TABLE_LIST**, uint*, uint, Prelocking_strategy*)" #9 0x00005644c57a7b12 in open_tables (thd=0x5644c86f3950, tables=0x7ff8cc0bc670, counter=0x7ff8cc0bc690, flags=0) at /home/vsts/src/sql/sql_base.h:513 prelocking_strategy = { = {_vptr.Prelocking_strategy = 0x5644c6870ae0 }, } #10 0x00005644c58a91c4 in mysql_update (thd=0x5644c86f3950, table_list=0x7ff870005e28, fields=..., values=..., conds=0x7ff870006848, order_num=5, order=0x7ff870006ad8, limit=7, handle_duplicates=DUP_ERROR, ignore=true, found_return=0x7ff8cc0bcd50, updated_return=0x7ff8cc0bcde0) at /home/vsts/src/sql/sql_update.cc:285 using_limit = true safe_update = false used_key_is_modified = false transactional_table = 11 will_batch = false can_compare_record = 204 res = 1879052880 error = 32760 loc_error = 1879052880 dup_key_found = 11 need_sort = true reverse = false want_privilege = 32760 table_count = 1 updated = 281476855763168 found = 140706551940864 old_covering_keys = {map = 140706551941360} table = 0x7ff8cc0bc940 select = 0x0 info = {table = 0x5644c6356b29, forms = 0x700010e0, unlock_row = 0x5644c61485ad, read_record = 0x7ff870001250, thd = 0x7ff870001250, select = 0x70001228, cache_records = 3323407248, ref_length = 22084, struct_length = 0, reclength = 0, rec_cache_size = 3323359474, error_offset = 22084, index = 0, ref_pos = 0x7ff8cc0bc840 "P\022", record = 0x10000700010e0 , rec_buf = 0x7ff8cc0bc850 "\220\312\v\314\370\177", cache = 0x5644c60946a8 "\203\370\003t.\203\370\003\177\023\203\370\001t2\203\370\001\177&\205\300t", , cache_pos = 0x7ff870001250 "\271\301Fo\374\177", cache_end = 0x7ff870001250 "\271\301Fo\374\177", read_positions = 0x7ff8cc0bca90 "Hh", io_cache = 0x5644c6093ab8 <_db_return_+527>, print_error = 11, ignore_not_found_rows = false, copy_field = 0x7ff8cc0bcab0, copy_field_end = 0x50000000b} select_lex = 0x5644c86f7b88 id = 281476855763168 all_fields = { = { = {}, first = 0x5644c6b0f7e0 , last = 0x7ff8cc0bc740, elements = 0}, } killed_status = NOT_KILLED query_plan = {_vptr.Update_plan = 0x5644c6875be0 , impossible_where = false, no_partitions = false, updating_a_view = false, mem_root = 0x5644c86f88a8, table = 0x0, select = 0x7ff870001250, index = 64, scanned_rows = 140706551941072, select_lex = 0x5644c60946a8 , possible_keys = {map = 140705007669840}, using_filesort = false, using_io_buffer = false} explain = 0x5644c6093ab8 <_db_return_+527> _db_stack_frame_ = {func = 0x5644c6171a3f "mysql_execute_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7ff8cc0bcd10} __PRETTY_FUNCTION__ = "int mysql_update(THD*, TABLE_LIST*, List&, List&, COND*, uint, ORDER*, ha_rows, enum_duplicates, bool, ha_rows*, ha_rows*)" __FUNCTION__ = "mysql_update" err2 = 32760 #11 0x00005644c57ce748 in mysql_execute_command (thd=0x5644c86f3950) at /home/vsts/src/sql/sql_parse.cc:3790 found = 0 updated = 0 res = 0 up_result = 0 lex = 0x5644c86f73c0 select_lex = 0x5644c86f7b88 first_table = 0x7ff870005e28 all_tables = 0x7ff870005e28 unit = 0x5644c86f7488 have_table_map_for_update = false rpl_filter = 0x7ff8700010e0 _db_stack_frame_ = {func = 0x5644c61728f8 "mysql_parse", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7ff8cc0bd4f0} __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" orig_binlog_format = BINLOG_FORMAT_STMT orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT __FUNCTION__ = "mysql_execute_command" #12 0x00005644c57d9f13 in mysql_parse (thd=0x5644c86f3950, rawbuf=0x7ff870005b08 "UPDATE LOW_PRIORITY IGNORE `table0_aria_key_pk_parts_2_int_autoinc` AS X SET `col_int` = 812253184 WHERE X.`pk` BETWEEN 4 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LI"..., length=229, parser_state=0x7ff8cc0bd670) at /home/vsts/src/sql/sql_parse.cc:7468 found_semicolon = 0x0 lex = 0x5644c86f73c0 err = false error = 32760 _db_stack_frame_ = {func = 0x5644c61715d9 "dispatch_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7ff8cc0bd650} __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*)" __FUNCTION__ = "mysql_parse" #13 0x00005644c57c8437 in dispatch_command (command=COM_QUERY, thd=0x5644c86f3950, packet=0x5644c86fadf1 "UPDATE LOW_PRIORITY IGNORE `table0_aria_key_pk_parts_2_int_autoinc` AS X SET `col_int` = 812253184 WHERE X.`pk` BETWEEN 4 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LI"..., packet_length=230) at /home/vsts/src/sql/sql_parse.cc:1496 packet_end = 0x7ff870005bed "" parser_state = {m_input = {m_compute_digest = false}, m_lip = {m_thd = 0x5644c86f3950, yylineno = 1, yylval = 0x7ff8cc0bc740, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7ff870005bee "\004", m_tok_start = 0x7ff870005bee "\004", m_tok_end = 0x7ff870005bee "\004", m_end_of_query = 0x7ff870005bed "", m_tok_start_prev = 0x7ff870005bed "", m_buf = 0x7ff870005b08 "UPDATE LOW_PRIORITY IGNORE `table0_aria_key_pk_parts_2_int_autoinc` AS X SET `col_int` = 812253184 WHERE X.`pk` BETWEEN 4 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LI"..., m_buf_length = 229, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7ff870005c50 "UPDATE LOW_PRIORITY IGNORE `table0_aria_key_pk_parts_2_int_autoinc` AS X SET `col_int` = 812253184 WHERE X.`pk` BETWEEN 4 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LI"..., m_cpp_ptr = 0x7ff870005d35 "", m_cpp_tok_start = 0x7ff870005d35 "", m_cpp_tok_start_prev = 0x7ff870005d35 "", m_cpp_tok_end = 0x7ff870005d35 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x7ff8700cd5cb '\217' ..., m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = NO_COMMENT, m_cpp_text_start = 0x7ff870005d1c "7 /* QNO 446 CON_ID 13 */", m_cpp_text_end = 0x7ff870005d1d " /* QNO 446 CON_ID 13 */", m_underscore_cs = 0x0, m_digest = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 }}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x0} net = 0x5644c86f3c10 error = false do_end_of_statement = true _db_stack_frame_ = {func = 0x5644c61713cb "do_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7ff8cc0bde50} __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" __FUNCTION__ = "dispatch_command" #14 0x00005644c57c71a9 in do_command (thd=0x5644c86f3950) at /home/vsts/src/sql/sql_parse.cc:1124 return_value = false packet = 0x5644c86fadf0 "\003UPDATE LOW_PRIORITY IGNORE `table0_aria_key_pk_parts_2_int_autoinc` AS X SET `col_int` = 812253184 WHERE X.`pk` BETWEEN 4 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` L"... packet_length = 231 net = 0x5644c86f3c10 command = COM_QUERY _db_stack_frame_ = {func = 0x5644c6358ebd "?func", file = 0x5644c6358ec3 "?file", level = 2147483649, line = -1, prev = 0x0} __PRETTY_FUNCTION__ = "bool do_command(THD*)" #15 0x00005644c59028f2 in do_handle_one_connection (thd_arg=0x5644c86f3950) at /home/vsts/src/sql/sql_connect.cc:1330 create_user = true thd = 0x5644c86f3950 #16 0x00005644c5902641 in handle_one_connection (arg=0x5644c86f3950) at /home/vsts/src/sql/sql_connect.cc:1242 thd = 0x5644c86f3950 #17 0x00007ff8cffd46ba in start_thread (arg=0x7ff8cc0beb00) at pthread_create.c:333 __res = pd = 0x7ff8cc0beb00 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140706551950080, 7669664285794399464, 0, 140722175383455, 140706551950784, 0, -7673703720650640152, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #18 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 31 (Thread 0x7ff8cc108b00 (LWP 8670)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 No locals. #1 0x00005644c607790a in safe_cond_timedwait (cond=0x5644c86e8488, mp=0x5644c86e83d8, abstime=0x7ff8cc105ec0, file=0x5644c61a00c0 "/home/vsts/src/include/mysql/psi/mysql_thread.h", line=1202) at /home/vsts/src/mysys/thr_mutex.c:547 error = 32760 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 8670, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\336!\000\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 8670, __nusers = 1, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\336!\000\000\001", '\000' , __align = 1}, file = 0x5644c61a03fa "/home/vsts/src/sql/mdl.cc", name = 0x5644c61a05b4 "m_LOCK_wait_status", line = 1063, count = 0, create_flags = 0, active_flags = 0, id = 863, thread = 140706552253184, locked_mutex = 0x7ff8740424f0, used_mutex = 0x7ff874042558, prev = 0x0, next = 0x0} #2 0x00005644c590b8f0 in inline_mysql_cond_timedwait (that=0x5644c86e8488, mutex=0x5644c86e83d8, abstime=0x7ff8cc105ec0, src_file=0x5644c61a03fa "/home/vsts/src/sql/mdl.cc", src_line=1088) at /home/vsts/src/include/mysql/psi/mysql_thread.h:1202 result = 32760 #3 0x00005644c590cc43 in MDL_wait::timed_wait (this=0x5644c86e83d8, owner=0x5644c86e8390, abs_timeout=0x7ff8cc105ec0, set_status_on_timeout=false, wait_state_name=0x5644c6935d70 ) at /home/vsts/src/sql/mdl.cc:1088 old_stage = {m_key = 0, m_name = 0x5644c6151716 "Opening tables", m_flags = -871342608} result = MDL_wait::EMPTY wait_result = 0 _db_stack_frame_ = {func = 0x5644c61a0940 "MDL_context::acquire_lock", file = 0x5644c61a03fa "/home/vsts/src/sql/mdl.cc", level = 2147483658, line = -1, prev = 0x7ff8cc105ed0} __FUNCTION__ = "timed_wait" __PRETTY_FUNCTION__ = "MDL_wait::enum_wait_status MDL_wait::timed_wait(MDL_context_owner*, timespec*, bool, const PSI_stage_info*)" #4 0x00005644c590e780 in MDL_context::acquire_lock (this=0x5644c86e83d8, mdl_request=0x7ff87401a6c8, lock_wait_timeout=10) at /home/vsts/src/sql/mdl.cc:2125 lock = 0x7ff86c036a30 ticket = 0x7ff8740504b0 wait_status = MDL_wait::EMPTY _db_stack_frame_ = {func = 0x5644c6160ebe "open_table", file = 0x5644c61606a8 "/home/vsts/src/sql/sql_base.cc", level = 2147483657, line = -1, prev = 0x7ff8cc1061d0} __PRETTY_FUNCTION__ = "bool MDL_context::acquire_lock(MDL_request*, double)" abs_timeout = {tv_sec = 1548994447, tv_nsec = 141534000} abs_shortwait = {tv_sec = 1548994438, tv_nsec = 141534000} #5 0x00005644c5762092 in open_table_get_mdl_lock (thd=0x5644c86e82e0, ot_ctx=0x7ff8cc106580, mdl_request=0x7ff87401a6c8, flags=0, mdl_ticket=0x7ff8cc1061b0) at /home/vsts/src/sql/sql_base.cc:2115 mdl_deadlock_handler = { = {_vptr.Internal_error_handler = 0x5644c6870b40 , m_prev_internal_handler = 0x0}, m_ot_ctx = 0x7ff8cc106580, m_is_active = false} result = false mdl_request_shared = {type = 3323594739, duration = 22084, next_in_list = 0x7ff874009560, prev_in_list = 0x7ff874009560, ticket = 0x1000274009538, key = {m_length = 24720, m_db_name_length = 52240, m_hash_value = 32760, m_ptr = " =\t\306DV\000\000\372\003\032\306DV\000\000n\t\032\306DV\000\000\002\000\000\000\000\000\000\000 \000\000t\370\177\000\000`\225\000t\370\177\000\000\b\000\000\000\060\000\000\000\240`\020\314\370\177\000\000\340_\020\314\370\177\000\000\020`\020\314\370\177\000\000\001\000\000\000\000\000\000\000\363\a\032\306DV\000\000\300R\036\320\370\177", '\000' , "@`\020\314\370\177\000\000p\023\221\305DV\000\000\360\a\005t\370\177\000\000\371\376\006\306DV\000\000\n\000\000\000\000\000\000\000\360\223\000t\370\177\000\000``\020\314\370\177\000\000k\023\t\306\000\000\000\000Tw\026\306DV\000\000\000\000\000\000\000\000\000\000"..., static m_namespace_to_wait_state_name = {{m_key = 0, m_name = 0x5644c61a02cb "Waiting for global read lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a02e8 "Waiting for schema metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0310 "Waiting for table metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0330 "Waiting for stored function metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0360 "Waiting for stored procedure metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0390 "Waiting for trigger metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a03b8 "Waiting for event metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a03d8 "Waiting for commit lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a03f0 "User lock", m_flags = 0}}}} __PRETTY_FUNCTION__ = "bool open_table_get_mdl_lock(THD*, Open_table_context*, MDL_request*, uint, MDL_ticket**)" #6 0x00005644c576298d in open_table (thd=0x5644c86e82e0, table_list=0x7ff87401a2a0, ot_ctx=0x7ff8cc106580) at /home/vsts/src/sql/sql_base.cc:2406 table = 0x0 key = 0x7ff87401a6f1 "test" key_length = 34 alias = 0x7ff87401a288 "X" flags = 0 mdl_ticket = 0x2000 share = 0x0 gts_flags = 3423625648 _db_stack_frame_ = {func = 0x5644c61612d3 "open_and_process_table", file = 0x5644c61606a8 "/home/vsts/src/sql/sql_base.cc", level = 2147483656, line = -1, prev = 0x7ff8cc106490} __PRETTY_FUNCTION__ = "bool open_table(THD*, TABLE_LIST*, Open_table_context*)" #7 0x00005644c5765947 in open_and_process_table (thd=0x5644c86e82e0, lex=0x5644c86ebd50, tables=0x7ff87401a2a0, counter=0x7ff8cc106690, flags=0, prelocking_strategy=0x7ff8cc106600, has_prelocking_list=false, ot_ctx=0x7ff8cc106580) at /home/vsts/src/sql/sql_base.cc:4124 error = false safe_to_ignore_table = false _db_stack_frame_ = {func = 0x5644c6161415 "open_tables", file = 0x5644c61606a8 "/home/vsts/src/sql/sql_base.cc", level = 2147483655, line = -1, prev = 0x7ff8cc106560} __PRETTY_FUNCTION__ = "bool open_and_process_table(THD*, LEX*, TABLE_LIST*, uint*, uint, Prelocking_strategy*, bool, Open_table_context*)" #8 0x00005644c5766a40 in open_tables (thd=0x5644c86e82e0, options=..., start=0x7ff8cc106670, counter=0x7ff8cc106690, flags=0, prelocking_strategy=0x7ff8cc106600) at /home/vsts/src/sql/sql_base.cc:4639 table_to_open = 0x7ff8cc106670 sroutine_to_open = 0x5644c86ebde8 tables = 0x7ff87401a2a0 ot_ctx = {m_thd = 0x5644c86e82e0, m_failed_table = 0x0, m_start_of_statement_svp = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0}, m_timeout = 10, m_flags = 0, m_action = Open_table_context::OT_NO_ACTION, m_has_locks = false, m_has_protection_against_grl = true} error = false some_routine_modifies_data = false has_prelocking_list = false _db_stack_frame_ = {func = 0x5644c618ba39 "mysql_update", file = 0x5644c618b9d8 "/home/vsts/src/sql/sql_update.cc", level = 2147483654, line = -1, prev = 0x7ff8cc106760} xa_state = XA_NOTR __FUNCTION__ = "open_tables" __PRETTY_FUNCTION__ = "bool open_tables(THD*, const DDL_options_st&, TABLE_LIST**, uint*, uint, Prelocking_strategy*)" #9 0x00005644c57a7b12 in open_tables (thd=0x5644c86e82e0, tables=0x7ff8cc106670, counter=0x7ff8cc106690, flags=0) at /home/vsts/src/sql/sql_base.h:513 prelocking_strategy = { = {_vptr.Prelocking_strategy = 0x5644c6870ae0 }, } #10 0x00005644c58a91c4 in mysql_update (thd=0x5644c86e82e0, table_list=0x7ff87401a2a0, fields=..., values=..., conds=0x7ff87401ac60, order_num=5, order=0x7ff87401aef0, limit=7, handle_duplicates=DUP_ERROR, ignore=true, found_return=0x7ff8cc106d50, updated_return=0x7ff8cc106de0) at /home/vsts/src/sql/sql_update.cc:285 using_limit = true safe_update = false used_key_is_modified = false transactional_table = 16 will_batch = false can_compare_record = 204 res = 1946195296 error = 32760 loc_error = 1946195296 dup_key_found = 0 need_sort = true reverse = false want_privilege = 22084 table_count = 1 updated = 281476922905584 found = 140706552243968 old_covering_keys = {map = 140705074812256} table = 0x7ff8cc106940 select = 0x0 info = {table = 0x5644c6356b29, forms = 0x740093f0, unlock_row = 0x5644c61485ad, read_record = 0x7ff874009560, thd = 0x7ff874009560, select = 0x74009538, cache_records = 3323407248, ref_length = 22084, struct_length = 0, reclength = 0, rec_cache_size = 3323359474, error_offset = 22084, index = 0, ref_pos = 0x7ff8cc106840 "`\225", record = 0x10000740093f0 , rec_buf = 0x7ff8cc106850 "\220j\020\314\370\177", cache = 0x5644c60946a8 "\203\370\003t.\203\370\003\177\023\203\370\001t2\203\370\001\177&\205\300t", , cache_pos = 0x7ff874009560 "\271\301Fo\374\177", cache_end = 0x7ff874009560 "\271\301Fo\374\177", read_positions = 0x7ff8cc106a90 "`\254\001t\370\177", io_cache = 0x5644c6093ab8 <_db_return_+527>, print_error = 2, ignore_not_found_rows = false, copy_field = 0x7ff8cc106ab0, copy_field_end = 0x500000002} select_lex = 0x5644c86ec518 id = 281476922905584 all_fields = { = { = {}, first = 0x5644c6b0f7e0 , last = 0x7ff8cc106740, elements = 0}, } killed_status = NOT_KILLED query_plan = {_vptr.Update_plan = 0x5644c6875be0 , impossible_where = false, no_partitions = false, updating_a_view = false, mem_root = 0x5644c86ed238, table = 0x0, select = 0x7ff874009560, index = 64, scanned_rows = 140706552244176, select_lex = 0x5644c60946a8 , possible_keys = {map = 140705074812256}, using_filesort = false, using_io_buffer = false} explain = 0x5644c6093ab8 <_db_return_+527> _db_stack_frame_ = {func = 0x5644c6171a3f "mysql_execute_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7ff8cc106d10} __PRETTY_FUNCTION__ = "int mysql_update(THD*, TABLE_LIST*, List&, List&, COND*, uint, ORDER*, ha_rows, enum_duplicates, bool, ha_rows*, ha_rows*)" __FUNCTION__ = "mysql_update" err2 = 32760 #11 0x00005644c57ce748 in mysql_execute_command (thd=0x5644c86e82e0) at /home/vsts/src/sql/sql_parse.cc:3790 found = 0 updated = 0 res = 0 up_result = 0 lex = 0x5644c86ebd50 select_lex = 0x5644c86ec518 first_table = 0x7ff87401a2a0 all_tables = 0x7ff87401a2a0 unit = 0x5644c86ebe18 have_table_map_for_update = false rpl_filter = 0x7ff8740093f0 _db_stack_frame_ = {func = 0x5644c61728f8 "mysql_parse", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7ff8cc1074f0} __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" orig_binlog_format = BINLOG_FORMAT_STMT orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT __FUNCTION__ = "mysql_execute_command" #12 0x00005644c57d9f13 in mysql_parse (thd=0x5644c86e82e0, rawbuf=0x7ff874019fc8 "UPDATE LOW_PRIORITY IGNORE `view_table0_aria_int_autoinc` AS X SET `col_char_12` = 10 WHERE X.`col_int_key` < 2 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 7 /* QNO 387"..., length=213, parser_state=0x7ff8cc107670) at /home/vsts/src/sql/sql_parse.cc:7468 found_semicolon = 0x0 lex = 0x5644c86ebd50 err = false error = 32760 _db_stack_frame_ = {func = 0x5644c61715d9 "dispatch_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7ff8cc107650} __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*)" __FUNCTION__ = "mysql_parse" #13 0x00005644c57c8437 in dispatch_command (command=COM_QUERY, thd=0x5644c86e82e0, packet=0x5644c86ef781 "UPDATE LOW_PRIORITY IGNORE `view_table0_aria_int_autoinc` AS X SET `col_char_12` = 10 WHERE X.`col_int_key` < 2 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 7 /* QNO 387"..., packet_length=214) at /home/vsts/src/sql/sql_parse.cc:1496 packet_end = 0x7ff87401a09d "" parser_state = {m_input = {m_compute_digest = false}, m_lip = {m_thd = 0x5644c86e82e0, yylineno = 1, yylval = 0x7ff8cc106740, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7ff87401a09e "\004", m_tok_start = 0x7ff87401a09e "\004", m_tok_end = 0x7ff87401a09e "\004", m_end_of_query = 0x7ff87401a09d "", m_tok_start_prev = 0x7ff87401a09d "", m_buf = 0x7ff874019fc8 "UPDATE LOW_PRIORITY IGNORE `view_table0_aria_int_autoinc` AS X SET `col_char_12` = 10 WHERE X.`col_int_key` < 2 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 7 /* QNO 387"..., m_buf_length = 213, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7ff87401a100 "UPDATE LOW_PRIORITY IGNORE `view_table0_aria_int_autoinc` AS X SET `col_char_12` = 10 WHERE X.`col_int_key` < 2 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 7 /* QNO 387"..., m_cpp_ptr = 0x7ff87401a1d5 "", m_cpp_tok_start = 0x7ff87401a1d5 "", m_cpp_tok_start_prev = 0x7ff87401a1d5 "", m_cpp_tok_end = 0x7ff87401a1d5 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x7ff87406b19d '\217' ..., m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 103 'g', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = NO_COMMENT, m_cpp_text_start = 0x7ff87401a1bc "7 /* QNO 387 CON_ID 12 */", m_cpp_text_end = 0x7ff87401a1bd " /* QNO 387 CON_ID 12 */", m_underscore_cs = 0x0, m_digest = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 }}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x0} net = 0x5644c86e85a0 error = false do_end_of_statement = true _db_stack_frame_ = {func = 0x5644c61713cb "do_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7ff8cc107e50} __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" __FUNCTION__ = "dispatch_command" #14 0x00005644c57c71a9 in do_command (thd=0x5644c86e82e0) at /home/vsts/src/sql/sql_parse.cc:1124 return_value = false packet = 0x5644c86ef780 "\003UPDATE LOW_PRIORITY IGNORE `view_table0_aria_int_autoinc` AS X SET `col_char_12` = 10 WHERE X.`col_int_key` < 2 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 7 /* QNO 38"... packet_length = 215 net = 0x5644c86e85a0 command = COM_QUERY _db_stack_frame_ = {func = 0x5644c6358ebd "?func", file = 0x5644c6358ec3 "?file", level = 2147483649, line = -1, prev = 0x0} __PRETTY_FUNCTION__ = "bool do_command(THD*)" #15 0x00005644c59028f2 in do_handle_one_connection (thd_arg=0x5644c86e82e0) at /home/vsts/src/sql/sql_connect.cc:1330 create_user = true thd = 0x5644c86e82e0 #16 0x00005644c5902641 in handle_one_connection (arg=0x5644c86e82e0) at /home/vsts/src/sql/sql_connect.cc:1242 thd = 0x5644c86e82e0 #17 0x00007ff8cffd46ba in start_thread (arg=0x7ff8cc108b00) at pthread_create.c:333 __res = pd = 0x7ff8cc108b00 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140706552253184, 7669664285794399464, 0, 140722175383455, 140706552253888, 0, -7673703678774709016, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #18 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 30 (Thread 0x7ff8d1085740 (LWP 8600)): #0 0x00007ff8cf67374d in poll () at ../sysdeps/unix/syscall-template.S:84 No locals. #1 0x00005644c57031da in handle_connections_sockets () at /home/vsts/src/sql/mysqld.cc:6511 sock = {fd = 20, m_psi = 0x0} new_sock = {fd = 124, m_psi = 0x0} error_count = 0 thd = 0x5644c870a6c0 cAddr = {ss_family = 10, __ss_padding = "\231\262", '\000' , "\377\377\177\000\000\001\000\000\000\000DV\000\000\n\000\000\000\000\000\000\000dK\000\000)\027\000\000\370\241\024\306DV\000\000@ð\306DV\000\000\002\000\000\200\226\002\000\000\000\006\353\352\000\000\000\000\370\241\024\306DV\000\000dK\000\000\000\000\000\000МFo\374\177\000\000\370xo\305DV\000\000\370\241\024\306DV\000", __ss_align = 5931} ip_flags = 2 socket_flags = 2 extra_ip_flags = 0 flags = 2 retval = 1 vio_tmp = 0x5644c8711980 is_unix_sock = false socket_count = 2 fds = {{fd = 20, events = 1, revents = 0}, {fd = 21, events = 1, revents = 0}, {fd = -969579970, events = 22084, revents = 0}} pfs_fds = {{fd = 20, m_psi = 0x0}, {fd = 21, m_psi = 0x0}, {fd = 1866898496, m_psi = 0x5644c6076985 }} _db_stack_frame_ = {func = 0x5644c6358ebd "?func", file = 0x5644c6358ec3 "?file", level = 2147483649, line = -1, prev = 0x0} #2 0x00005644c5702196 in mysqld_main (argc=19, argv=0x5644c82581a8) at /home/vsts/src/sql/mysqld.cc:5936 please_close_stdin = true ho_error = 0 new_thread_stack_size = 295936 #3 0x00005644c56f7600 in main (argc=19, argv=0x7ffc6f46a238) at /home/vsts/src/sql/main.cc:25 No locals. Thread 29 (Thread 0x7ff8cc19cb00 (LWP 8666)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 No locals. #1 0x00005644c607790a in safe_cond_timedwait (cond=0x5644c86d1868, mp=0x5644c86d17b8, abstime=0x7ff8cc19a2e0, file=0x5644c61a00c0 "/home/vsts/src/include/mysql/psi/mysql_thread.h", line=1202) at /home/vsts/src/mysys/thr_mutex.c:547 error = 32760 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 8666, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\332!\000\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 8666, __nusers = 1, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\332!\000\000\001", '\000' , __align = 1}, file = 0x5644c61a03fa "/home/vsts/src/sql/mdl.cc", name = 0x5644c61a05b4 "m_LOCK_wait_status", line = 1063, count = 0, create_flags = 0, active_flags = 0, id = 839, thread = 140706552859392, locked_mutex = 0x7ff86c6ee6b0, used_mutex = 0x7ff86c6ee718, prev = 0x0, next = 0x0} #2 0x00005644c590b8f0 in inline_mysql_cond_timedwait (that=0x5644c86d1868, mutex=0x5644c86d17b8, abstime=0x7ff8cc19a2e0, src_file=0x5644c61a03fa "/home/vsts/src/sql/mdl.cc", src_line=1088) at /home/vsts/src/include/mysql/psi/mysql_thread.h:1202 result = 32760 #3 0x00005644c590cc43 in MDL_wait::timed_wait (this=0x5644c86d17b8, owner=0x5644c86d1770, abs_timeout=0x7ff8cc19a2e0, set_status_on_timeout=false, wait_state_name=0x5644c6935d70 ) at /home/vsts/src/sql/mdl.cc:1088 old_stage = {m_key = 0, m_name = 0x5644c6151716 "Opening tables", m_flags = -870735344} result = MDL_wait::EMPTY wait_result = 0 _db_stack_frame_ = {func = 0x5644c61a0940 "MDL_context::acquire_lock", file = 0x5644c61a03fa "/home/vsts/src/sql/mdl.cc", level = 2147483658, line = -1, prev = 0x7ff8cc19a2f0} __FUNCTION__ = "timed_wait" __PRETTY_FUNCTION__ = "MDL_wait::enum_wait_status MDL_wait::timed_wait(MDL_context_owner*, timespec*, bool, const PSI_stage_info*)" #4 0x00005644c590e780 in MDL_context::acquire_lock (this=0x5644c86d17b8, mdl_request=0x7ff86c474470, lock_wait_timeout=10) at /home/vsts/src/sql/mdl.cc:2125 lock = 0x7ff86c56d030 ticket = 0x7ff86c073e20 wait_status = MDL_wait::EMPTY _db_stack_frame_ = {func = 0x5644c6160ebe "open_table", file = 0x5644c61606a8 "/home/vsts/src/sql/sql_base.cc", level = 2147483657, line = -1, prev = 0x7ff8cc19a5f0} __PRETTY_FUNCTION__ = "bool MDL_context::acquire_lock(MDL_request*, double)" abs_timeout = {tv_sec = 1548994447, tv_nsec = 146239000} abs_shortwait = {tv_sec = 1548994438, tv_nsec = 146239000} #5 0x00005644c5762092 in open_table_get_mdl_lock (thd=0x5644c86d16c0, ot_ctx=0x7ff8cc19a9a0, mdl_request=0x7ff86c474470, flags=0, mdl_ticket=0x7ff8cc19a5d0) at /home/vsts/src/sql/sql_base.cc:2115 mdl_deadlock_handler = { = {_vptr.Internal_error_handler = 0x5644c6870b40 , m_prev_internal_handler = 0x0}, m_ot_ctx = 0x7ff8cc19a9a0, m_is_active = false} result = false mdl_request_shared = {type = 3424232592, duration = 32760, next_in_list = 0x5644c6093d20 <_db_doprnt_+519>, prev_in_list = 0x7ff86c3e7b00, ticket = 0x5644c63563c8, key = {m_length = 0, m_db_name_length = 0, m_hash_value = 0, m_ptr = "\000\000\000\000\000\000\000\000`\327Dl\370\177\000\000\b\000\000\000\060\000\000\000\240\244\031\314\370\177\000\000\340\243\031\314\370\177\000\000`\r\263\306DV\000\000T\023\034\306DV\000\000`\r\263\306DV\000\000\300R\036\320\370\177", '\000' , "`\327Dl\370\177\000\000\310\027\032l\002\000\001\000 \245\031\314\370\177\000\000\371\376\006\306DV\000\000\060\060\177l\370\177\000\000\200\026\032l\370\177\000\000`\244\031\314\370\177\000\000k\023\t\306DV\000\000`\327Dl\370\177\000\000Q\377\006\306DV\000\000\220\244\031\314\370\177\000\000\200\026\032l\370\177\000\000\220\244\031\314\370\177\000\000\205i\a\306DV\000\000"..., static m_namespace_to_wait_state_name = {{m_key = 0, m_name = 0x5644c61a02cb "Waiting for global read lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a02e8 "Waiting for schema metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0310 "Waiting for table metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0330 "Waiting for stored function metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0360 "Waiting for stored procedure metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0390 "Waiting for trigger metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a03b8 "Waiting for event metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a03d8 "Waiting for commit lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a03f0 "User lock", m_flags = 0}}}} __PRETTY_FUNCTION__ = "bool open_table_get_mdl_lock(THD*, Open_table_context*, MDL_request*, uint, MDL_ticket**)" #6 0x00005644c576298d in open_table (thd=0x5644c86d16c0, table_list=0x7ff86c474048, ot_ctx=0x7ff8cc19a9a0) at /home/vsts/src/sql/sql_base.cc:2406 table = 0x7ff86c44d760 key = 0x7ff86c474499 "test" key_length = 44 alias = 0x7ff86c474020 "table0_aria_key_pk_parts_2_int_autoinc" flags = 0 mdl_ticket = 0x7ff86c48bb10 share = 0x700000000 gts_flags = 3424232896 _db_stack_frame_ = {func = 0x5644c61612d3 "open_and_process_table", file = 0x5644c61606a8 "/home/vsts/src/sql/sql_base.cc", level = 2147483656, line = -1, prev = 0x7ff8cc19a8b0} __PRETTY_FUNCTION__ = "bool open_table(THD*, TABLE_LIST*, Open_table_context*)" #7 0x00005644c5765947 in open_and_process_table (thd=0x5644c86d16c0, lex=0x5644c86d5130, tables=0x7ff86c474048, counter=0x7ff8cc19aa34, flags=0, prelocking_strategy=0x7ff8cc19aab0, has_prelocking_list=false, ot_ctx=0x7ff8cc19a9a0) at /home/vsts/src/sql/sql_base.cc:4124 error = false safe_to_ignore_table = false _db_stack_frame_ = {func = 0x5644c6161415 "open_tables", file = 0x5644c61606a8 "/home/vsts/src/sql/sql_base.cc", level = 2147483655, line = -1, prev = 0x7ff8cc19a980} __PRETTY_FUNCTION__ = "bool open_and_process_table(THD*, LEX*, TABLE_LIST*, uint*, uint, Prelocking_strategy*, bool, Open_table_context*)" #8 0x00005644c5766a40 in open_tables (thd=0x5644c86d16c0, options=..., start=0x7ff8cc19aa18, counter=0x7ff8cc19aa34, flags=0, prelocking_strategy=0x7ff8cc19aab0) at /home/vsts/src/sql/sql_base.cc:4639 table_to_open = 0x7ff86c46ff10 sroutine_to_open = 0x5644c86d51c8 tables = 0x7ff86c474048 ot_ctx = {m_thd = 0x5644c86d16c0, m_failed_table = 0x0, m_start_of_statement_svp = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0}, m_timeout = 10, m_flags = 0, m_action = Open_table_context::OT_NO_ACTION, m_has_locks = false, m_has_protection_against_grl = true} error = false some_routine_modifies_data = false has_prelocking_list = false _db_stack_frame_ = {func = 0x5644c61615b1 "open_and_lock_tables", file = 0x5644c61606a8 "/home/vsts/src/sql/sql_base.cc", level = 2147483654, line = -1, prev = 0x7ff8cc19aa50} xa_state = XA_NOTR __FUNCTION__ = "open_tables" __PRETTY_FUNCTION__ = "bool open_tables(THD*, const DDL_options_st&, TABLE_LIST**, uint*, uint, Prelocking_strategy*)" #9 0x00005644c57680f8 in open_and_lock_tables (thd=0x5644c86d16c0, options=..., tables=0x7ff86c46ff08, derived=true, flags=0, prelocking_strategy=0x7ff8cc19aab0) at /home/vsts/src/sql/sql_base.cc:5385 counter = 1 mdl_savepoint = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0} _db_stack_frame_ = {func = 0x5644c6171a3f "mysql_execute_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7ff8cc19ad10} #10 0x00005644c575b308 in open_and_lock_tables (thd=0x5644c86d16c0, tables=0x7ff86c46ff08, derived=true, flags=0) at /home/vsts/src/sql/sql_base.h:544 prelocking_strategy = { = {_vptr.Prelocking_strategy = 0x5644c6870ae0 }, } #11 0x00005644c57cf290 in mysql_execute_command (thd=0x5644c86d16c0) at /home/vsts/src/sql/sql_parse.cc:4013 sel_result = 0x7ff86c44d760 explain = false res = 0 up_result = 0 lex = 0x5644c86d5130 select_lex = 0x5644c86d58f8 first_table = 0x7ff86c46ff08 all_tables = 0x7ff86c46ff08 unit = 0x5644c86d51f8 have_table_map_for_update = false rpl_filter = 0x7ff86c1a1680 _db_stack_frame_ = {func = 0x5644c61728f8 "mysql_parse", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7ff8cc19b4f0} __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" orig_binlog_format = BINLOG_FORMAT_STMT orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT __FUNCTION__ = "mysql_execute_command" #12 0x00005644c57d9f13 in mysql_parse (thd=0x5644c86d16c0, rawbuf=0x7ff86c46fb18 "INSERT LOW_PRIORITY IGNORE INTO `view_table0_aria_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT `col_char_12_key` FROM `view_table100_aria_key_pk_parts_2_int_autoinc` AS X WHERE X.`col_int_key`"..., length=307, parser_state=0x7ff8cc19b670) at /home/vsts/src/sql/sql_parse.cc:7468 found_semicolon = 0x0 lex = 0x5644c86d5130 err = false error = 32760 _db_stack_frame_ = {func = 0x5644c61715d9 "dispatch_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7ff8cc19b650} __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*)" __FUNCTION__ = "mysql_parse" #13 0x00005644c57c8437 in dispatch_command (command=COM_QUERY, thd=0x5644c86d16c0, packet=0x5644c86d8aa1 "INSERT LOW_PRIORITY IGNORE INTO `view_table0_aria_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT `col_char_12_key` FROM `view_table100_aria_key_pk_parts_2_int_autoinc` AS X WHERE X.`col_int_key`"..., packet_length=308) at /home/vsts/src/sql/sql_parse.cc:1496 packet_end = 0x7ff86c46fc4b "" parser_state = {m_input = {m_compute_digest = false}, m_lip = {m_thd = 0x5644c86d16c0, yylineno = 1, yylval = 0x7ff8cc19a740, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7ff86c46fc4c "\004", m_tok_start = 0x7ff86c46fc4c "\004", m_tok_end = 0x7ff86c46fc4c "\004", m_end_of_query = 0x7ff86c46fc4b "", m_tok_start_prev = 0x7ff86c46fc4b "", m_buf = 0x7ff86c46fb18 "INSERT LOW_PRIORITY IGNORE INTO `view_table0_aria_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT `col_char_12_key` FROM `view_table100_aria_key_pk_parts_2_int_autoinc` AS X WHERE X.`col_int_key`"..., m_buf_length = 307, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7ff86c46fcb0 "INSERT LOW_PRIORITY IGNORE INTO `view_table0_aria_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT `col_char_12_key` FROM `view_table100_aria_key_pk_parts_2_int_autoinc` AS X WHERE X.`col_int_key`"..., m_cpp_ptr = 0x7ff86c46fde3 "", m_cpp_tok_start = 0x7ff86c46fde3 "", m_cpp_tok_start_prev = 0x7ff86c46fde3 "", m_cpp_tok_end = 0x7ff86c46fde3 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x7ff86c48a250 '\217' ..., m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 103 'g', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = NO_COMMENT, m_cpp_text_start = 0x7ff86c46fdca "5 /* QNO 391 CON_ID 10 */", m_cpp_text_end = 0x7ff86c46fdcb " /* QNO 391 CON_ID 10 */", m_underscore_cs = 0x0, m_digest = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 }}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x0} net = 0x5644c86d1980 error = false do_end_of_statement = true _db_stack_frame_ = {func = 0x5644c61713cb "do_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7ff8cc19be50} __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" __FUNCTION__ = "dispatch_command" #14 0x00005644c57c71a9 in do_command (thd=0x5644c86d16c0) at /home/vsts/src/sql/sql_parse.cc:1124 return_value = false packet = 0x5644c86d8aa0 "\003INSERT LOW_PRIORITY IGNORE INTO `view_table0_aria_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT `col_char_12_key` FROM `view_table100_aria_key_pk_parts_2_int_autoinc` AS X WHERE X.`col_int_key"... packet_length = 309 net = 0x5644c86d1980 command = COM_QUERY _db_stack_frame_ = {func = 0x5644c6358ebd "?func", file = 0x5644c6358ec3 "?file", level = 2147483649, line = -1, prev = 0x0} __PRETTY_FUNCTION__ = "bool do_command(THD*)" #15 0x00005644c59028f2 in do_handle_one_connection (thd_arg=0x5644c86d16c0) at /home/vsts/src/sql/sql_connect.cc:1330 create_user = true thd = 0x5644c86d16c0 #16 0x00005644c5902641 in handle_one_connection (arg=0x5644c86d16c0) at /home/vsts/src/sql/sql_connect.cc:1242 thd = 0x5644c86d16c0 #17 0x00007ff8cffd46ba in start_thread (arg=0x7ff8cc19cb00) at pthread_create.c:333 __res = pd = 0x7ff8cc19cb00 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140706552859392, 7669664285794399464, 0, 140722175383455, 140706552860096, 0, -7673703599317814040, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #18 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 28 (Thread 0x7ff8cc230b00 (LWP 8634)): #0 0x00007ff8cf67374d in poll () at ../sysdeps/unix/syscall-template.S:84 No locals. #1 0x00005644c6118cc5 in vio_io_wait (vio=0x5644c8378930, event=VIO_IO_EVENT_READ, timeout=28800000) at /home/vsts/src/vio/viosocket.c:992 ret = 32764 revents = 8251 pfd = {fd = 42, events = 3, revents = 0} sd = 42 locker = 0x0 state = {m_flags = 0, m_socket = 0x5644c64a8040, m_thread = 0x5644c64a8114, m_number_of_bytes = 281476721543360, m_timer_start = 18446744073709551615, m_timer = 0x5644c606fef9 , m_operation = 1744833072, m_src_file = 0x7ff8680008c0 "", m_src_line = -870122432, m_wait = 0x5644c609136b } _db_stack_frame_ = {func = 0x5644c64a809a "vio_read", file = 0x5644c64a8040 "/home/vsts/src/vio/viosocket.c", level = 2147483651, line = -1, prev = 0x7ff8cc22fcc0} __PRETTY_FUNCTION__ = "vio_io_wait" #2 0x00005644c6117531 in vio_socket_io_wait (vio=0x5644c8378930, event=VIO_IO_EVENT_READ) at /home/vsts/src/vio/viosocket.c:108 timeout = 28800000 ret = 22084 __PRETTY_FUNCTION__ = "vio_socket_io_wait" #3 0x00005644c61176e4 in vio_read (vio=0x5644c8378930, buf=0x5644c86c08a0 "\a", size=4) at /home/vsts/src/vio/viosocket.c:184 error = 11 ret = -1 flags = 64 _db_stack_frame_ = {func = 0x5644c61713cb "do_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7ff8cc22fe50} __PRETTY_FUNCTION__ = "vio_read" #4 0x00005644c570bbb0 in my_real_read (net=0x5644c86ba490, complen=0x7ff8cc22fdc0, header=1 '\001') at /home/vsts/src/sql/net_serv.cc:877 pos = 0x5644c86c08a0 "\a" length = 140706553462144 i = 0 retry_count = 0 len = 18446744073709551615 expect_error_packet = 0 '\000' alarmed = 0 '\000' net_blocking = 0 '\000' remain = 4 count = 4 server_extension = 0x5644c86ba738 __PRETTY_FUNCTION__ = "ulong my_real_read(NET*, size_t*, my_bool)" #5 0x00005644c570c344 in my_net_read_packet (net=0x5644c86ba490, read_from_server=1 '\001') at /home/vsts/src/sql/net_serv.cc:1140 len = 94853370429067 complen = 0 #6 0x00005644c57c6be1 in do_command (thd=0x5644c86ba1d0) at /home/vsts/src/sql/sql_parse.cc:995 return_value = false packet = 0x0 packet_length = 0 net = 0x5644c86ba490 command = COM_PING _db_stack_frame_ = {func = 0x5644c6358ebd "?func", file = 0x5644c6358ec3 "?file", level = 2147483649, line = -1, prev = 0x0} __PRETTY_FUNCTION__ = "bool do_command(THD*)" #7 0x00005644c59028f2 in do_handle_one_connection (thd_arg=0x5644c86ba1d0) at /home/vsts/src/sql/sql_connect.cc:1330 create_user = true thd = 0x5644c86ba1d0 #8 0x00005644c5902641 in handle_one_connection (arg=0x5644c86ba1d0) at /home/vsts/src/sql/sql_connect.cc:1242 thd = 0x5644c86ba1d0 #9 0x00007ff8cffd46ba in start_thread (arg=0x7ff8cc230b00) at pthread_create.c:333 __res = pd = 0x7ff8cc230b00 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140706553465600, 7669664285794399464, 0, 140722175383455, 140706553466304, 0, -7673703519860919064, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #10 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 27 (Thread 0x7ff8cc1e6b00 (LWP 8664)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 No locals. #1 0x00005644c607790a in safe_cond_timedwait (cond=0x5644c86c5e68, mp=0x5644c86c5db8, abstime=0x7ff8cc1e49d0, file=0x5644c61a00c0 "/home/vsts/src/include/mysql/psi/mysql_thread.h", line=1202) at /home/vsts/src/mysys/thr_mutex.c:547 error = 32760 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 8664, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\330!\000\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 8664, __nusers = 1, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\330!\000\000\001", '\000' , __align = 1}, file = 0x5644c61a03fa "/home/vsts/src/sql/mdl.cc", name = 0x5644c61a05b4 "m_LOCK_wait_status", line = 1063, count = 0, create_flags = 0, active_flags = 0, id = 902, thread = 140706553162496, locked_mutex = 0x7ff86c6ff280, used_mutex = 0x7ff86c6ff2e8, prev = 0x0, next = 0x0} #2 0x00005644c590b8f0 in inline_mysql_cond_timedwait (that=0x5644c86c5e68, mutex=0x5644c86c5db8, abstime=0x7ff8cc1e49d0, src_file=0x5644c61a03fa "/home/vsts/src/sql/mdl.cc", src_line=1088) at /home/vsts/src/include/mysql/psi/mysql_thread.h:1202 result = 32760 #3 0x00005644c590cc43 in MDL_wait::timed_wait (this=0x5644c86c5db8, owner=0x5644c86c5d70, abs_timeout=0x7ff8cc1e49d0, set_status_on_timeout=true, wait_state_name=0x5644c6913d50 ) at /home/vsts/src/sql/mdl.cc:1088 old_stage = {m_key = 0, m_name = 0x5644c615120a "init", m_flags = -870430608} result = MDL_wait::EMPTY wait_result = 0 _db_stack_frame_ = {func = 0x5644c616085f "close_cached_tables", file = 0x5644c61606a8 "/home/vsts/src/sql/sql_base.cc", level = 2147483654, line = -1, prev = 0x7ff8cc1e49f0} __FUNCTION__ = "timed_wait" __PRETTY_FUNCTION__ = "MDL_wait::enum_wait_status MDL_wait::timed_wait(MDL_context_owner*, timespec*, bool, const PSI_stage_info*)" #4 0x00005644c58c2d5d in TABLE_SHARE::wait_for_old_version (this=0x7ff86c5470f8, thd=0x5644c86c5cc0, abstime=0x7ff8cc1e49d0, deadlock_weight=100) at /home/vsts/src/sql/table.cc:4073 mdl_context = 0x5644c86c5db8 ticket = { = {_vptr.MDL_wait_for_subgraph = 0x5644c6875d40 }, m_ctx = 0x5644c86c5db8, m_share = 0x7ff86c5470f8, m_deadlock_weight = 100, next_in_share = 0x0, prev_in_share = 0x7ff86c484950} wait_status = 32760 __PRETTY_FUNCTION__ = "bool TABLE_SHARE::wait_for_old_version(THD*, timespec*, uint)" #5 0x00005644c575f136 in close_cached_tables (thd=0x5644c86c5cc0, tables=0x0, wait_for_refresh=true, timeout=10) at /home/vsts/src/sql/sql_base.cc:565 r = 1 argument = {refresh_version = 5, element = 0x7ff86c4846b0} result = false abstime = {tv_sec = 1548994447, tv_nsec = 142694000} refresh_version = 5 _db_stack_frame_ = {func = 0x5644c6171a3f "mysql_execute_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7ff8cc1e4d10} __PRETTY_FUNCTION__ = "bool close_cached_tables(THD*, TABLE_LIST*, bool, ulong)" #6 0x00005644c5935ef1 in reload_acl_and_cache (thd=0x5644c86c5cc0, options=4, tables=0x0, write_to_binlog=0x7ff8cc1e4de0) at /home/vsts/src/sql/sql_reload.cc:343 result = false tmp_write_to_binlog = 1 __PRETTY_FUNCTION__ = "bool reload_acl_and_cache(THD*, long long unsigned int, TABLE_LIST*, int*)" #7 0x00005644c57d269d in mysql_execute_command (thd=0x5644c86c5cc0) at /home/vsts/src/sql/sql_parse.cc:4887 write_to_binlog = 1 res = 0 up_result = 0 lex = 0x5644c86c9730 select_lex = 0x5644c86c9ef8 first_table = 0x0 all_tables = 0x0 unit = 0x5644c86c97f8 have_table_map_for_update = false rpl_filter = 0x7ff86c0008c0 _db_stack_frame_ = {func = 0x5644c61728f8 "mysql_parse", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7ff8cc1e54f0} __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" orig_binlog_format = BINLOG_FORMAT_STMT orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT __FUNCTION__ = "mysql_execute_command" #8 0x00005644c57d9f13 in mysql_parse (thd=0x5644c86c5cc0, rawbuf=0x7ff86c0074a8 "FLUSH TABLES /* QNO 391 CON_ID 9 */", length=35, parser_state=0x7ff8cc1e5670) at /home/vsts/src/sql/sql_parse.cc:7468 found_semicolon = 0x0 lex = 0x5644c86c9730 err = false error = 32760 _db_stack_frame_ = {func = 0x5644c61715d9 "dispatch_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7ff8cc1e5650} __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*)" __FUNCTION__ = "mysql_parse" #9 0x00005644c57c8437 in dispatch_command (command=COM_QUERY, thd=0x5644c86c5cc0, packet=0x5644c86cd4f1 "FLUSH TABLES /* QNO 391 CON_ID 9 */ ", packet_length=36) at /home/vsts/src/sql/sql_parse.cc:1496 packet_end = 0x7ff86c0074cb "" parser_state = {m_input = {m_compute_digest = false}, m_lip = {m_thd = 0x5644c86c5cc0, yylineno = 1, yylval = 0x7ff8cc1e4740, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7ff86c0074cc "\004", m_tok_start = 0x7ff86c0074cc "\004", m_tok_end = 0x7ff86c0074cc "\004", m_end_of_query = 0x7ff86c0074cb "", m_tok_start_prev = 0x7ff86c0074cb "", m_buf = 0x7ff86c0074a8 "FLUSH TABLES /* QNO 391 CON_ID 9 */", m_buf_length = 35, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7ff86c007530 "FLUSH TABLES /* QNO 391 CON_ID 9 */", m_cpp_ptr = 0x7ff86c007553 "", m_cpp_tok_start = 0x7ff86c007553 "", m_cpp_tok_start_prev = 0x7ff86c007553 "", m_cpp_tok_end = 0x7ff86c007553 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x7ff86c4d7d5c '\217' ..., m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 103 'g', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = NO_COMMENT, m_cpp_text_start = 0x7ff86c00770b '\217' ..., m_cpp_text_end = 0x7ff86c00770c '\217' ..., m_underscore_cs = 0x0, m_digest = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 }}, m_lock_type = TL_READ_NO_INSERT, m_mdl_type = MDL_SHARED_HIGH_PRIO}, m_digest_psi = 0x0} net = 0x5644c86c5f80 error = false do_end_of_statement = true _db_stack_frame_ = {func = 0x5644c61713cb "do_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7ff8cc1e5e50} __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" __FUNCTION__ = "dispatch_command" #10 0x00005644c57c71a9 in do_command (thd=0x5644c86c5cc0) at /home/vsts/src/sql/sql_parse.cc:1124 return_value = false packet = 0x5644c86cd4f0 "\003FLUSH TABLES /* QNO 391 CON_ID 9 */ " packet_length = 37 net = 0x5644c86c5f80 command = COM_QUERY _db_stack_frame_ = {func = 0x5644c6358ebd "?func", file = 0x5644c6358ec3 "?file", level = 2147483649, line = -1, prev = 0x0} __PRETTY_FUNCTION__ = "bool do_command(THD*)" #11 0x00005644c59028f2 in do_handle_one_connection (thd_arg=0x5644c86c5cc0) at /home/vsts/src/sql/sql_connect.cc:1330 create_user = true thd = 0x5644c86c5cc0 #12 0x00005644c5902641 in handle_one_connection (arg=0x5644c86c5cc0) at /home/vsts/src/sql/sql_connect.cc:1242 thd = 0x5644c86c5cc0 #13 0x00007ff8cffd46ba in start_thread (arg=0x7ff8cc1e6b00) at pthread_create.c:333 __res = pd = 0x7ff8cc1e6b00 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140706553162496, 7669664285794399464, 0, 140722175383455, 300032, 94853420357184, -7673703630456326936, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #14 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 26 (Thread 0x7ff89d7fa700 (LWP 8630)): #0 0x00007ff8cf6755d3 in select () at ../sysdeps/unix/syscall-template.S:84 No locals. #1 0x00005644c5df5255 in os_thread_sleep (tm=1000000) at /home/vsts/src/storage/xtradb/os/os0thread.cc:307 t = {tv_sec = 0, tv_usec = 563694} #2 0x00005644c5f46694 in btr_defragment_thread () at /home/vsts/src/storage/xtradb/btr/btr0defragment.cc:708 item = 0x0 now = 0 elapsed = 0 pcur = 0x0 cursor = 0x0 index = 0x0 mtr = {state = 0, memo = {heap = 0x0, used = 0, data = '\000' , base = {count = 0, start = 0x0, end = 0x0}, list = {prev = 0x0, next = 0x0}, buf_end = 0, magic_n = 0}, log = {heap = 0x0, used = 0, data = '\000' , base = {count = 0, start = 0x0, end = 0x0}, list = {prev = 0x0, next = 0x0}, buf_end = 0, magic_n = 0}, inside_ibuf = 0, modifications = 0, made_dirty = 0, n_log_recs = 0, n_freed_pages = 0, log_mode = 0, start_lsn = 0, end_lsn = 0, magic_n = 0} first_block = 0x0 last_block = 0x0 #3 0x00007ff8cffd46ba in start_thread (arg=0x7ff89d7fa700) at pthread_create.c:333 __res = pd = 0x7ff89d7fa700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705771005696, 7669664285794399464, 0, 140722175366863, 140705771006400, 0, -7673810545211443992, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #4 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 25 (Thread 0x7ff8cc27ab00 (LWP 8632)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 No locals. #1 0x00005644c6077600 in safe_cond_wait (cond=0x5644c6b08b40 , mp=0x5644c6b0bbc0 , file=0x5644c6155720 "/home/vsts/src/include/mysql/psi/mysql_thread.h", line=1165) at /home/vsts/src/mysys/thr_mutex.c:493 error = 22084 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 8632, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\270!\000\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 8632, __nusers = 2, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\270!\000\000\002", '\000' , __align = 1}, file = 0x5644c6155f3d "/home/vsts/src/sql/slave.cc", name = 0x5644c614bde5 "LOCK_slave_background", line = 318, count = 0, create_flags = 0, active_flags = 0, id = 114, thread = 140706553768704, locked_mutex = 0x5644c869dfa0, used_mutex = 0x5644c869e008, prev = 0x0, next = 0x0} #2 0x00005644c571fff0 in inline_mysql_cond_wait (that=0x5644c6b08b40 , mutex=0x5644c6b0bbc0 , src_file=0x5644c6155f3d "/home/vsts/src/sql/slave.cc", src_line=336) at /home/vsts/src/include/mysql/psi/mysql_thread.h:1165 result = 22084 #3 0x00005644c5720ce0 in handle_slave_background (arg=0x0) at /home/vsts/src/sql/slave.cc:336 kill_list = 0x0 thd = 0x7ff874000b00 old_stage = {m_key = 0, m_name = 0x5644c6151f64 "Processing requests", m_flags = 0} stop = false __FUNCTION__ = "handle_slave_background" #4 0x00007ff8cffd46ba in start_thread (arg=0x7ff8cc27ab00) at pthread_create.c:333 __res = pd = 0x7ff8cc27ab00 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140706553768704, 7669664285794399464, 0, 140722175384415, 140706553769408, 0, -7673703550999431960, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #5 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 24 (Thread 0x7ff8d0f05b00 (LWP 8631)): #0 do_sigwait (sig=0x7ff8d0f05260, set=) at ../sysdeps/unix/sysv/linux/sigwait.c:64 ret = tmpset = {__val = {140706634027520, 94853380142026, 0, 14581413969920, 94853381005816, 94853391233152, 0, 3941271040, 94853381005816, 0, 140706634027584, 94853370181880, 94489280512, 94853370182887, 94853381005816, 94853391237824}} #1 __sigwait (set=, sig=0x7ff8d0f05260) at ../sysdeps/unix/sysv/linux/sigwait.c:96 oldtype = 0 result = 128 sig = 0x7ff8d0f05260 set = #2 0x00005644c56fd664 in signal_hand (arg=0x0) at /home/vsts/src/sql/mysqld.cc:3408 error = 0 set = {__val = {548869, 0 }} sig = 0 _db_stack_frame_ = {func = 0x5644c6358ebd "?func", file = 0x5644c6358ec3 "?file", level = 2147483649, line = -1, prev = 0x0} #3 0x00007ff8cffd46ba in start_thread (arg=0x7ff8d0f05b00) at pthread_create.c:333 __res = pd = 0x7ff8d0f05b00 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140706634029824, 7669664285794399464, 0, 140722175384399, 140706634030528, 0, -7673642382612073240, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #4 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 23 (Thread 0x7ff89dffb700 (LWP 8629)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 No locals. #1 0x00005644c5df4673 in os_cond_wait (cond=0x5644c82b2988, fast_mutex=0x5644c82b2950) at /home/vsts/src/storage/xtradb/os/os0sync.cc:196 mutex = 0x5644c82b2950 #2 0x00005644c5df49e1 in os_event_wait_low (event=0x5644c82b2950, reset_sig_count=1) at /home/vsts/src/storage/xtradb/os/os0sync.cc:477 No locals. #3 0x00005644c5f605d7 in buf_dump_thread () at /home/vsts/src/storage/xtradb/buf/buf0dump.cc:731 No locals. #4 0x00007ff8cffd46ba in start_thread (arg=0x7ff89dffb700) at pthread_create.c:333 __res = pd = 0x7ff89dffb700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705779398400, 7669664285794399464, 0, 140722175366863, 140705779399104, 0, -7673811646333684504, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #5 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 22 (Thread 0x7ff89e7fc700 (LWP 8628)): #0 0x00007ff8cf6755d3 in select () at ../sysdeps/unix/syscall-template.S:84 No locals. #1 0x00005644c5df5255 in os_thread_sleep (tm=1000000) at /home/vsts/src/storage/xtradb/os/os0thread.cc:307 t = {tv_sec = 0, tv_usec = 443459} #2 0x00005644c5f68d45 in page_cleaner_sleep_if_needed (next_loop_time=1548994438163) at /home/vsts/src/storage/xtradb/buf/buf0flu.cc:2678 cur_time = 1548994437163 #3 0x00005644c5f696c4 in buf_flush_lru_manager_thread (arg=0x0) at /home/vsts/src/storage/xtradb/buf/buf0flu.cc:2979 next_loop_time = 1548994438163 lru_sleep_time = 1000 lru_n_flushed = 0 #4 0x00007ff8cffd46ba in start_thread (arg=0x7ff89e7fc700) at pthread_create.c:333 __res = pd = 0x7ff89e7fc700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705787791104, 7669664285794399464, 0, 140722175366863, 140705787791808, 0, -7673812745308441368, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #5 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 21 (Thread 0x7ff8a4bdd700 (LWP 8624)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 No locals. #1 0x00005644c5df458b in os_cond_wait_timed (cond=0x5644c87fb4a8, fast_mutex=0x5644c87fb470, abstime=0x7ff8a4bdced0) at /home/vsts/src/storage/xtradb/os/os0sync.cc:159 mutex = 0x5644c87fb470 ret = 0 #2 0x00005644c5df4b8c in os_event_wait_time_low (event=0x5644c87fb470, time_in_usec=10000000, reset_sig_count=1) at /home/vsts/src/storage/xtradb/os/os0sync.cc:591 timed_out = 0 abstime = {tv_sec = 1548994445, tv_nsec = 105310000} #3 0x00005644c5fb8627 in dict_stats_thread () at /home/vsts/src/storage/xtradb/dict/dict0stats_bg.cc:534 No locals. #4 0x00007ff8cffd46ba in start_thread (arg=0x7ff8a4bdd700) at pthread_create.c:333 __res = pd = 0x7ff8a4bdd700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705892521728, 7669664285794399464, 0, 140722175366863, 140705892522432, 0, -7673757234466753304, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #5 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 20 (Thread 0x7ff8a5bdf700 (LWP 8622)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 No locals. #1 0x00005644c5df458b in os_cond_wait_timed (cond=0x5644c82ba3a8, fast_mutex=0x5644c82ba370, abstime=0x7ff8a5bdee70) at /home/vsts/src/storage/xtradb/os/os0sync.cc:159 mutex = 0x5644c82ba370 ret = 0 #2 0x00005644c5df4b8c in os_event_wait_time_low (event=0x5644c82ba370, time_in_usec=1000000, reset_sig_count=1) at /home/vsts/src/storage/xtradb/os/os0sync.cc:591 timed_out = 0 abstime = {tv_sec = 1548994438, tv_nsec = 107621000} #3 0x00005644c5eb8834 in srv_error_monitor_thread () at /home/vsts/src/storage/xtradb/srv/srv0srv.cc:2424 fatal_cnt = 0 old_lsn = 1652880 new_lsn = 1652880 sig_count = 1 waiter = 140705909307136 old_waiter = 140705909307136 sema = 0x0 old_sema = 0x0 #4 0x00007ff8cffd46ba in start_thread (arg=0x7ff8a5bdf700) at pthread_create.c:333 __res = pd = 0x7ff8a5bdf700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705909307136, 7669664285794399464, 0, 140722175366863, 140705909307840, 0, -7673759434563750680, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #5 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 19 (Thread 0x7ff89effd700 (LWP 8627)): #0 0x00007ff8cf6755d3 in select () at ../sysdeps/unix/syscall-template.S:84 No locals. #1 0x00005644c5df5255 in os_thread_sleep (tm=1000000) at /home/vsts/src/storage/xtradb/os/os0thread.cc:307 t = {tv_sec = 0, tv_usec = 444721} #2 0x00005644c5f68d45 in page_cleaner_sleep_if_needed (next_loop_time=1548994438164) at /home/vsts/src/storage/xtradb/buf/buf0flu.cc:2678 cur_time = 1548994437164 #3 0x00005644c5f69096 in buf_flush_page_cleaner_thread (arg=0x0) at /home/vsts/src/storage/xtradb/buf/buf0flu.cc:2819 page_cleaner_sleep_time = 1000 server_active = 0 next_loop_time = 1548994438164 n_flushed = 0 last_activity = 5 last_activity_time = 1548994431160 success = false #4 0x00007ff8cffd46ba in start_thread (arg=0x7ff89effd700) at pthread_create.c:333 __res = pd = 0x7ff89effd700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705796183808, 7669664285794399464, 0, 140722175366863, 140705796184512, 0, -7673813842135714584, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #5 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 18 (Thread 0x7ff8a75e7700 (LWP 8617)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 No locals. #1 0x00005644c5df4673 in os_cond_wait (cond=0x5644c8449cf8, fast_mutex=0x5644c8449cc0) at /home/vsts/src/storage/xtradb/os/os0sync.cc:196 mutex = 0x5644c8449cc0 #2 0x00005644c5df49e1 in os_event_wait_low (event=0x5644c8449cc0, reset_sig_count=1) at /home/vsts/src/storage/xtradb/os/os0sync.cc:477 No locals. #3 0x00005644c5df2fad in os_aio_simulated_handle (global_segment=9, message1=0x7ff8a75e6e80, message2=0x7ff8a75e6e88, type=0x7ff8a75e6e90, space_id=0x7ff8a75e6e98) at /home/vsts/src/storage/xtradb/os/os0file.cc:6204 array = 0x5644c841d5d0 segment = 3 consecutive_ios = {0x0 } n_consecutive = 0 total_len = 0 offs = 0 lowest_offset = 18446744073709551615 biggest_age = 0 age = 0 combined_buf = 0x0 combined_buf2 = 0x0 ret = 0 any_reserved = 0 n = 256 aio_slot = 0x0 #4 0x00005644c5fccb88 in fil_aio_wait (segment=9) at /home/vsts/src/storage/xtradb/fil/fil0fil.cc:6254 ret = 0 fil_node = 0x0 message = 0x5644c5df52f1 type = 19 space_id = 0 purpose = 0 #5 0x00005644c5ebcf46 in io_handler_thread (arg=0x5644c7370b48 ) at /home/vsts/src/storage/xtradb/srv/srv0start.cc:585 segment = 9 tid_i = 9 #6 0x00007ff8cffd46ba in start_thread (arg=0x7ff8a75e7700) at pthread_create.c:333 __res = pd = 0x7ff8a75e7700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705936602880, 7669664285794399464, 0, 140722175366863, 140705936603584, 0, -7673762453925759768, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #7 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 17 (Thread 0x7ff89f7fe700 (LWP 8626)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 No locals. #1 0x00005644c5df4673 in os_cond_wait (cond=0x5644c8259018, fast_mutex=0x5644c8258fe0) at /home/vsts/src/storage/xtradb/os/os0sync.cc:196 mutex = 0x5644c8258fe0 #2 0x00005644c5df49e1 in os_event_wait_low (event=0x5644c8258fe0, reset_sig_count=1) at /home/vsts/src/storage/xtradb/os/os0sync.cc:477 No locals. #3 0x00005644c5eb572e in srv_resume_thread (slot=0x5644c736c418 , sig_count=1, wait=true, timeout_usec=0) at /home/vsts/src/storage/xtradb/srv/srv0srv.cc:1082 timeout = false #4 0x00005644c5ebaaea in srv_purge_coordinator_suspend (slot=0x5644c736c418 , rseg_history_len=8) at /home/vsts/src/storage/xtradb/srv/srv0srv.cc:3492 wait = true timeout = true stop = true SRV_PURGE_MAX_TIMEOUT = 10000 sig_count = 1 #5 0x00005644c5ebae9c in srv_purge_coordinator_thread (arg=0x0) at /home/vsts/src/storage/xtradb/srv/srv0srv.cc:3583 slot = 0x5644c736c418 n_total_purged = 0 rseg_history_len = 8 #6 0x00007ff8cffd46ba in start_thread (arg=0x7ff89f7fe700) at pthread_create.c:333 __res = pd = 0x7ff89f7fe700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705804576512, 7669664285794399464, 0, 140722175366863, 140705804577216, 0, -7673814941110471448, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #7 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 16 (Thread 0x7ff8a7de8700 (LWP 8616)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 No locals. #1 0x00005644c5df4673 in os_cond_wait (cond=0x5644c8449c88, fast_mutex=0x5644c8449c50) at /home/vsts/src/storage/xtradb/os/os0sync.cc:196 mutex = 0x5644c8449c50 #2 0x00005644c5df49e1 in os_event_wait_low (event=0x5644c8449c50, reset_sig_count=1) at /home/vsts/src/storage/xtradb/os/os0sync.cc:477 No locals. #3 0x00005644c5df2fad in os_aio_simulated_handle (global_segment=8, message1=0x7ff8a7de7e80, message2=0x7ff8a7de7e88, type=0x7ff8a7de7e90, space_id=0x7ff8a7de7e98) at /home/vsts/src/storage/xtradb/os/os0file.cc:6204 array = 0x5644c841d5d0 segment = 2 consecutive_ios = {0x0 } n_consecutive = 0 total_len = 0 offs = 0 lowest_offset = 18446744073709551615 biggest_age = 0 age = 0 combined_buf = 0x0 combined_buf2 = 0x0 ret = 0 any_reserved = 0 n = 256 aio_slot = 0x0 #4 0x00005644c5fccb88 in fil_aio_wait (segment=8) at /home/vsts/src/storage/xtradb/fil/fil0fil.cc:6254 ret = 0 fil_node = 0x0 message = 0x5644c5df52f1 type = 19 space_id = 0 purpose = 0 #5 0x00005644c5ebcf46 in io_handler_thread (arg=0x5644c7370b40 ) at /home/vsts/src/storage/xtradb/srv/srv0start.cc:585 segment = 8 tid_i = 8 #6 0x00007ff8cffd46ba in start_thread (arg=0x7ff8a7de8700) at pthread_create.c:333 __res = pd = 0x7ff8a7de8700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705944995584, 7669664285794399464, 0, 140722175366863, 140705944996288, 0, -7673763552900516632, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #7 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 15 (Thread 0x7ff89ffff700 (LWP 8625)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 No locals. #1 0x00005644c5df458b in os_cond_wait_timed (cond=0x5644c8600ac8, fast_mutex=0x5644c8600a90, abstime=0x7ff89fffee20) at /home/vsts/src/storage/xtradb/os/os0sync.cc:159 mutex = 0x5644c8600a90 ret = 0 #2 0x00005644c5df4b8c in os_event_wait_time_low (event=0x5644c8600a90, time_in_usec=5000000, reset_sig_count=1) at /home/vsts/src/storage/xtradb/os/os0sync.cc:591 timed_out = 0 abstime = {tv_sec = 1548994440, tv_nsec = 105340000} #3 0x00005644c5f00be1 in ib_wqueue_timedwait (wq=0x5644c889de98, wait_in_usecs=5000000) at /home/vsts/src/storage/xtradb/ut/ut0wqueue.cc:154 error = 94853422243480 sig_count = 1 node = 0x0 #4 0x00005644c6003cce in fts_optimize_thread (arg=0x5644c889de98) at /home/vsts/src/storage/xtradb/fts/fts0opt.cc:2915 msg = 0x0 heap = 0x7ff898000a30 tables = 0x7ff898000ac8 heap_alloc = 0x7ff898000aa8 current = 0 done = 0 n_tables = 0 exit_event = 0x0 n_optimize = 0 wq = 0x5644c889de98 #5 0x00007ff8cffd46ba in start_thread (arg=0x7ff89ffff700) at pthread_create.c:333 __res = pd = 0x7ff89ffff700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705812969216, 7669664285794399464, 0, 140722175366847, 140705812969920, 0, -7673816042232711960, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #6 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 14 (Thread 0x7ff8a85e9700 (LWP 8615)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 No locals. #1 0x00005644c5df4673 in os_cond_wait (cond=0x5644c8449c18, fast_mutex=0x5644c8449be0) at /home/vsts/src/storage/xtradb/os/os0sync.cc:196 mutex = 0x5644c8449be0 #2 0x00005644c5df49e1 in os_event_wait_low (event=0x5644c8449be0, reset_sig_count=1) at /home/vsts/src/storage/xtradb/os/os0sync.cc:477 No locals. #3 0x00005644c5df2fad in os_aio_simulated_handle (global_segment=7, message1=0x7ff8a85e8e80, message2=0x7ff8a85e8e88, type=0x7ff8a85e8e90, space_id=0x7ff8a85e8e98) at /home/vsts/src/storage/xtradb/os/os0file.cc:6204 array = 0x5644c841d5d0 segment = 1 consecutive_ios = {0x0 } n_consecutive = 0 total_len = 0 offs = 0 lowest_offset = 18446744073709551615 biggest_age = 0 age = 0 combined_buf = 0x0 combined_buf2 = 0x0 ret = 0 any_reserved = 0 n = 256 aio_slot = 0x0 #4 0x00005644c5fccb88 in fil_aio_wait (segment=7) at /home/vsts/src/storage/xtradb/fil/fil0fil.cc:6254 ret = 0 fil_node = 0x0 message = 0x5644c5df52f1 type = 19 space_id = 0 purpose = 0 #5 0x00005644c5ebcf46 in io_handler_thread (arg=0x5644c7370b38 ) at /home/vsts/src/storage/xtradb/srv/srv0start.cc:585 segment = 7 tid_i = 7 #6 0x00007ff8cffd46ba in start_thread (arg=0x7ff8a85e9700) at pthread_create.c:333 __res = pd = 0x7ff8a85e9700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705953388288, 7669664285794399464, 0, 140722175366863, 140705953388992, 0, -7673764649727789848, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #7 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 13 (Thread 0x7ff8a53de700 (LWP 8623)): #0 0x00007ff8cf6755d3 in select () at ../sysdeps/unix/syscall-template.S:84 No locals. #1 0x00005644c5df5255 in os_thread_sleep (tm=1000000) at /home/vsts/src/storage/xtradb/os/os0thread.cc:307 t = {tv_sec = 0, tv_usec = 396543} #2 0x00005644c5eb9f9c in srv_master_sleep () at /home/vsts/src/storage/xtradb/srv/srv0srv.cc:3116 No locals. #3 0x00005644c5eba0e0 in srv_master_thread (arg=0x0) at /home/vsts/src/storage/xtradb/srv/srv0srv.cc:3166 slot = 0x5644c736c3e0 old_activity_count = 5 old_ibuf_merge_activity_count = 0 #4 0x00007ff8cffd46ba in start_thread (arg=0x7ff8a53de700) at pthread_create.c:333 __res = pd = 0x7ff8a53de700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705900914432, 7669664285794399464, 0, 140722175366863, 140705900915136, 0, -7673758333441510168, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #5 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 12 (Thread 0x7ff8a95eb700 (LWP 8613)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 No locals. #1 0x00005644c5df4673 in os_cond_wait (cond=0x5644c8449b38, fast_mutex=0x5644c8449b00) at /home/vsts/src/storage/xtradb/os/os0sync.cc:196 mutex = 0x5644c8449b00 #2 0x00005644c5df49e1 in os_event_wait_low (event=0x5644c8449b00, reset_sig_count=1) at /home/vsts/src/storage/xtradb/os/os0sync.cc:477 No locals. #3 0x00005644c5df2fad in os_aio_simulated_handle (global_segment=5, message1=0x7ff8a95eae80, message2=0x7ff8a95eae88, type=0x7ff8a95eae90, space_id=0x7ff8a95eae98) at /home/vsts/src/storage/xtradb/os/os0file.cc:6204 array = 0x5644c83e0fa0 segment = 3 consecutive_ios = {0x0 } n_consecutive = 0 total_len = 0 offs = 0 lowest_offset = 18446744073709551615 biggest_age = 0 age = 0 combined_buf = 0x0 combined_buf2 = 0x0 ret = 0 any_reserved = 0 n = 256 aio_slot = 0x0 #4 0x00005644c5fccb88 in fil_aio_wait (segment=5) at /home/vsts/src/storage/xtradb/fil/fil0fil.cc:6254 ret = 0 fil_node = 0x0 message = 0x5644c5df52f1 type = 19 space_id = 0 purpose = 0 #5 0x00005644c5ebcf46 in io_handler_thread (arg=0x5644c7370b28 ) at /home/vsts/src/storage/xtradb/srv/srv0start.cc:585 segment = 5 tid_i = 5 #6 0x00007ff8cffd46ba in start_thread (arg=0x7ff8a95eb700) at pthread_create.c:333 __res = pd = 0x7ff8a95eb700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705970173696, 7669664285794399464, 0, 140722175366863, 140705970174400, 0, -7673766849824787224, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #7 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 11 (Thread 0x7ff8a9dec700 (LWP 8612)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 No locals. #1 0x00005644c5df4673 in os_cond_wait (cond=0x5644c8449ac8, fast_mutex=0x5644c8449a90) at /home/vsts/src/storage/xtradb/os/os0sync.cc:196 mutex = 0x5644c8449a90 #2 0x00005644c5df49e1 in os_event_wait_low (event=0x5644c8449a90, reset_sig_count=1) at /home/vsts/src/storage/xtradb/os/os0sync.cc:477 No locals. #3 0x00005644c5df2fad in os_aio_simulated_handle (global_segment=4, message1=0x7ff8a9debe80, message2=0x7ff8a9debe88, type=0x7ff8a9debe90, space_id=0x7ff8a9debe98) at /home/vsts/src/storage/xtradb/os/os0file.cc:6204 array = 0x5644c83e0fa0 segment = 2 consecutive_ios = {0x0 } n_consecutive = 0 total_len = 0 offs = 0 lowest_offset = 18446744073709551615 biggest_age = 0 age = 0 combined_buf = 0x0 combined_buf2 = 0x0 ret = 0 any_reserved = 0 n = 256 aio_slot = 0x0 #4 0x00005644c5fccb88 in fil_aio_wait (segment=4) at /home/vsts/src/storage/xtradb/fil/fil0fil.cc:6254 ret = 0 fil_node = 0x0 message = 0x5644c5df52f1 type = 19 space_id = 0 purpose = 0 #5 0x00005644c5ebcf46 in io_handler_thread (arg=0x5644c7370b20 ) at /home/vsts/src/storage/xtradb/srv/srv0start.cc:585 segment = 4 tid_i = 4 #6 0x00007ff8cffd46ba in start_thread (arg=0x7ff8a9dec700) at pthread_create.c:333 __res = pd = 0x7ff8a9dec700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705978566400, 7669664285794399464, 0, 140722175366863, 140705978567104, 0, -7673767948799544088, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #7 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 10 (Thread 0x7ff8aa5ed700 (LWP 8611)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 No locals. #1 0x00005644c5df4673 in os_cond_wait (cond=0x5644c8449a58, fast_mutex=0x5644c8449a20) at /home/vsts/src/storage/xtradb/os/os0sync.cc:196 mutex = 0x5644c8449a20 #2 0x00005644c5df49e1 in os_event_wait_low (event=0x5644c8449a20, reset_sig_count=1) at /home/vsts/src/storage/xtradb/os/os0sync.cc:477 No locals. #3 0x00005644c5df2fad in os_aio_simulated_handle (global_segment=3, message1=0x7ff8aa5ece80, message2=0x7ff8aa5ece88, type=0x7ff8aa5ece90, space_id=0x7ff8aa5ece98) at /home/vsts/src/storage/xtradb/os/os0file.cc:6204 array = 0x5644c83e0fa0 segment = 1 consecutive_ios = {0x0 } n_consecutive = 0 total_len = 0 offs = 0 lowest_offset = 18446744073709551615 biggest_age = 0 age = 0 combined_buf = 0x0 combined_buf2 = 0x0 ret = 0 any_reserved = 0 n = 256 aio_slot = 0x0 #4 0x00005644c5fccb88 in fil_aio_wait (segment=3) at /home/vsts/src/storage/xtradb/fil/fil0fil.cc:6254 ret = 0 fil_node = 0x0 message = 0x5644c5df52f1 type = 19 space_id = 0 purpose = 0 #5 0x00005644c5ebcf46 in io_handler_thread (arg=0x5644c7370b18 ) at /home/vsts/src/storage/xtradb/srv/srv0start.cc:585 segment = 3 tid_i = 3 #6 0x00007ff8cffd46ba in start_thread (arg=0x7ff8aa5ed700) at pthread_create.c:333 __res = pd = 0x7ff8aa5ed700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705986959104, 7669664285794399464, 0, 140722175366863, 140705986959808, 0, -7673769045626817304, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #7 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 9 (Thread 0x7ff8a63e0700 (LWP 8621)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 No locals. #1 0x00005644c5df458b in os_cond_wait_timed (cond=0x5644c85a4118, fast_mutex=0x5644c85a40e0, abstime=0x7ff8a63dfeb0) at /home/vsts/src/storage/xtradb/os/os0sync.cc:159 mutex = 0x5644c85a40e0 ret = 0 #2 0x00005644c5df4b8c in os_event_wait_time_low (event=0x5644c85a40e0, time_in_usec=1000000, reset_sig_count=1) at /home/vsts/src/storage/xtradb/os/os0sync.cc:591 timed_out = 0 abstime = {tv_sec = 1548994438, tv_nsec = 105778000} #3 0x00005644c5dc4b37 in lock_wait_timeout_thread () at /home/vsts/src/storage/xtradb/lock/lock0wait.cc:597 slot = 0x5644c857abb8 sig_count = 1 event = 0x5644c85a40e0 #4 0x00007ff8cffd46ba in start_thread (arg=0x7ff8a63e0700) at pthread_create.c:333 __res = pd = 0x7ff8a63e0700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705917699840, 7669664285794399464, 0, 140722175366863, 8388608, 94853422266704, -7673760533538507544, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #5 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 8 (Thread 0x7ff8aadee700 (LWP 8610)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 No locals. #1 0x00005644c5df4673 in os_cond_wait (cond=0x5644c84499e8, fast_mutex=0x5644c84499b0) at /home/vsts/src/storage/xtradb/os/os0sync.cc:196 mutex = 0x5644c84499b0 #2 0x00005644c5df49e1 in os_event_wait_low (event=0x5644c84499b0, reset_sig_count=1) at /home/vsts/src/storage/xtradb/os/os0sync.cc:477 No locals. #3 0x00005644c5df2fad in os_aio_simulated_handle (global_segment=2, message1=0x7ff8aadede80, message2=0x7ff8aadede88, type=0x7ff8aadede90, space_id=0x7ff8aadede98) at /home/vsts/src/storage/xtradb/os/os0file.cc:6204 array = 0x5644c83e0fa0 segment = 0 consecutive_ios = {0x0 } n_consecutive = 0 total_len = 0 offs = 0 lowest_offset = 18446744073709551615 biggest_age = 0 age = 0 combined_buf = 0x0 combined_buf2 = 0x0 ret = 0 any_reserved = 0 n = 256 aio_slot = 0x0 #4 0x00005644c5fccb88 in fil_aio_wait (segment=2) at /home/vsts/src/storage/xtradb/fil/fil0fil.cc:6254 ret = 0 fil_node = 0x0 message = 0x5644c5df52f1 type = 19 space_id = 0 purpose = 0 #5 0x00005644c5ebcf46 in io_handler_thread (arg=0x5644c7370b10 ) at /home/vsts/src/storage/xtradb/srv/srv0start.cc:585 segment = 2 tid_i = 2 #6 0x00007ff8cffd46ba in start_thread (arg=0x7ff8aadee700) at pthread_create.c:333 __res = pd = 0x7ff8aadee700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705995351808, 7669664285794399464, 0, 140722175366863, 140705995352512, 0, -7673770144601574168, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #7 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 7 (Thread 0x7ff8a6be1700 (LWP 8618)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 No locals. #1 0x00005644c5df458b in os_cond_wait_timed (cond=0x5644c82d1a78, fast_mutex=0x5644c82d1a40, abstime=0x7ff8a6be0e80) at /home/vsts/src/storage/xtradb/os/os0sync.cc:159 mutex = 0x5644c82d1a40 ret = 0 #2 0x00005644c5df4b8c in os_event_wait_time_low (event=0x5644c82d1a40, time_in_usec=5000000, reset_sig_count=1) at /home/vsts/src/storage/xtradb/os/os0sync.cc:591 timed_out = 0 abstime = {tv_sec = 1548994438, tv_nsec = 921009000} #3 0x00005644c5eb8206 in srv_monitor_thread () at /home/vsts/src/storage/xtradb/srv/srv0srv.cc:2183 sig_count = 1 time_elapsed = 10 current_time = 1548994433 last_table_monitor_time = 1548994423 last_tablespace_monitor_time = 1548994423 last_monitor_time = 1548994423 mutex_skipped = 0 last_srv_print_monitor = 0 #4 0x00007ff8cffd46ba in start_thread (arg=0x7ff8a6be1700) at pthread_create.c:333 __res = pd = 0x7ff8a6be1700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705926092544, 7669664285794399464, 0, 140722175366863, 140705926093248, 0, -7673761630365780760, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #5 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 6 (Thread 0x7ff8b88db700 (LWP 8608)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 No locals. #1 0x00005644c5df4673 in os_cond_wait (cond=0x5644c8449908, fast_mutex=0x5644c84498d0) at /home/vsts/src/storage/xtradb/os/os0sync.cc:196 mutex = 0x5644c84498d0 #2 0x00005644c5df49e1 in os_event_wait_low (event=0x5644c84498d0, reset_sig_count=1) at /home/vsts/src/storage/xtradb/os/os0sync.cc:477 No locals. #3 0x00005644c5df2fad in os_aio_simulated_handle (global_segment=0, message1=0x7ff8b88dae80, message2=0x7ff8b88dae88, type=0x7ff8b88dae90, space_id=0x7ff8b88dae98) at /home/vsts/src/storage/xtradb/os/os0file.cc:6204 array = 0x5644c84133c0 segment = 0 consecutive_ios = {0x0 } n_consecutive = 0 total_len = 0 offs = 0 lowest_offset = 18446744073709551615 biggest_age = 0 age = 0 combined_buf = 0x0 combined_buf2 = 0x0 ret = 0 any_reserved = 0 n = 256 aio_slot = 0x0 #4 0x00005644c5fccb88 in fil_aio_wait (segment=0) at /home/vsts/src/storage/xtradb/fil/fil0fil.cc:6254 ret = 0 fil_node = 0x0 message = 0x5644c5df52f1 type = 19 space_id = 0 purpose = 0 #5 0x00005644c5ebcf46 in io_handler_thread (arg=0x5644c7370b00 ) at /home/vsts/src/storage/xtradb/srv/srv0start.cc:585 segment = 0 tid_i = 0 #6 0x00007ff8cffd46ba in start_thread (arg=0x7ff8b88db700) at pthread_create.c:333 __res = pd = 0x7ff8b88db700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140706224912128, 7669664285794399464, 0, 140722175366863, 140706224912832, 0, -7673731261725772568, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #7 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 5 (Thread 0x7ff8a8dea700 (LWP 8614)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 No locals. #1 0x00005644c5df4673 in os_cond_wait (cond=0x5644c8449ba8, fast_mutex=0x5644c8449b70) at /home/vsts/src/storage/xtradb/os/os0sync.cc:196 mutex = 0x5644c8449b70 #2 0x00005644c5df49e1 in os_event_wait_low (event=0x5644c8449b70, reset_sig_count=2) at /home/vsts/src/storage/xtradb/os/os0sync.cc:477 No locals. #3 0x00005644c5df2fad in os_aio_simulated_handle (global_segment=6, message1=0x7ff8a8de9e80, message2=0x7ff8a8de9e88, type=0x7ff8a8de9e90, space_id=0x7ff8a8de9e98) at /home/vsts/src/storage/xtradb/os/os0file.cc:6204 array = 0x5644c841d5d0 segment = 0 consecutive_ios = {0x0, 0x5644c8802e48, 0x7ff8a8de9c70, 0x5644c8802e60, 0x7ff8a8de9c98, 0x0, 0x7ff8a8de9ca0, 0x5644c5ec8d39 , 0x7ff8a8de9ca0, 0x5c2, 0x7ff8a8de9cc8, 0x7ff8a8de9d00, 0x7ff884000930, 0x7ff8840008c0, 0x7ff8a8de9cd0, 0x5644c5ecb698 <__gnu_cxx::__alloc_traits >::destroy(std::allocator&, sync_level_t*)+35>, 0x7ff884000930, 0x5644c737d460 , 0x7ff8a8dea700, 0x5644c737d4c8 , 0x7ff8a8de9d00, 0x5644c737d460 , 0x7ff884000940, 0x5644c737d4d0 , 0x7ff8a8de9d20, 0x5644c5ec7f2c , 0x7ff8a8de9d40, 0x5644c737d460 , 0x7ff8a8de9d40, 0x5644c5ec8118 , 0x7ff884000930, 0x5644c737d460 , 0x7ff8a8de9d90, 0x5644c5eca60a , 0x7ff8a8de9d90, 0x7ff8abffd390, 0x7ff884000930, 0x7ff8abffd3f8, 0x7ff8a8de9d90, 0x7ff8abffd390, 0x7ff8abffd390, 0x7ff8abffd400, 0x7ff8a8de9db0, 0x5644c5f47537 , 0x2abffd470, 0x7ff8abffd390, 0x7ff8a8de9dd0, 0x5644c5f479cc , 0x7ff8abffd470, 0x7ff8abffd390, 0x7ff8a8de9e50, 0x5644c5f5629e , 0x7ff8840008e0, 0x7ff8abffd2b8, 0x7ff8a8de9e10, 0xa00449da8, 0x2c8449da8, 0x5644c8449e18, 0x7ff8a8de9e30, 0x5644c85106b8, 0x1, 0x5644c8449da8, 0x7ff8a8de9e50, 0x7ff8abffd390} n_consecutive = 0 total_len = 94853382800168 offs = 94853400089696 lowest_offset = 18446744073709551615 biggest_age = 0 age = 94853400089696 combined_buf = 0x7ff884000950 "\210/\200\310DV" combined_buf2 = 0x0 ret = 140705961778288 any_reserved = 0 n = 256 aio_slot = 0x7ffc6f4656cf #4 0x00005644c5fccb88 in fil_aio_wait (segment=6) at /home/vsts/src/storage/xtradb/fil/fil0fil.cc:6254 ret = 1 fil_node = 0x5644c87f73d8 message = 0x7ff8abffd2b8 type = 11 space_id = 0 purpose = 501 #5 0x00005644c5ebcf46 in io_handler_thread (arg=0x5644c7370b30 ) at /home/vsts/src/storage/xtradb/srv/srv0start.cc:585 segment = 6 tid_i = 6 #6 0x00007ff8cffd46ba in start_thread (arg=0x7ff8a8dea700) at pthread_create.c:333 __res = pd = 0x7ff8a8dea700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140705961780992, 7669664285794399464, 0, 140722175366863, 140705961781696, 0, -7673765748702546712, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #7 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 4 (Thread 0x7ff8ccc99700 (LWP 8606)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 No locals. #1 0x00005644c607790a in safe_cond_timedwait (cond=0x5644c7336b00 , mp=0x5644c7336a40 , abstime=0x7ff8ccc98e50, file=0x5644c6278900 "/home/vsts/src/include/mysql/psi/mysql_thread.h", line=1202) at /home/vsts/src/mysys/thr_mutex.c:547 error = 0 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 8606, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\236!\000\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 8606, __nusers = 1, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\236!\000\000\001", '\000' , __align = 1}, file = 0x5644c6278930 "/home/vsts/src/storage/maria/ma_servicethread.c", name = 0x5644c6278992 "control->LOCK_control", line = 99, count = 0, create_flags = 0, active_flags = 0, id = 29, thread = 140706564380416, locked_mutex = 0x7ff8b4000b00, used_mutex = 0x7ff8b4000b68, prev = 0x0, next = 0x0} #2 0x00005644c5c1847c in inline_mysql_cond_timedwait (that=0x5644c7336b00 , mutex=0x5644c7336a40 , abstime=0x7ff8ccc98e50, src_file=0x5644c6278930 "/home/vsts/src/storage/maria/ma_servicethread.c", src_line=116) at /home/vsts/src/include/mysql/psi/mysql_thread.h:1202 result = 32760 #3 0x00005644c5c18913 in my_service_thread_sleep (control=0x5644c6940da0 , sleep_time=29000000000) at /home/vsts/src/storage/maria/ma_servicethread.c:115 abstime = {tv_sec = 1548994452, tv_nsec = 787181000} res = 0 '\000' _db_stack_frame_ = {func = 0x5644c6358ebd "?func", file = 0x5644c6358ec3 "?file", level = 2147483649, line = -1, prev = 0x0} #4 0x00005644c5c0d261 in ma_checkpoint_background (arg=0x1e) at /home/vsts/src/storage/maria/ma_checkpoint.c:708 interval = 30 sleeps = 1 sleep_time = 29 log_horizon_at_last_checkpoint = 4294975539 pagecache_flushes_at_last_checkpoint = 0 pages_bunch_size = 0 filter_param = {up_to_lsn = 4294975495, max_pages = 0} dfile = 0x0 kfile = 0x0 __PRETTY_FUNCTION__ = "ma_checkpoint_background" #5 0x00007ff8cffd46ba in start_thread (arg=0x7ff8ccc99700) at pthread_create.c:333 __res = pd = 0x7ff8ccc99700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140706564380416, 7669664285794399464, 0, 140722175381327, 140706564381120, 0, -7673704288257411864, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #6 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 3 (Thread 0x7ff8ab5ef700 (LWP 8609)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 No locals. #1 0x00005644c5df4673 in os_cond_wait (cond=0x5644c8449978, fast_mutex=0x5644c8449940) at /home/vsts/src/storage/xtradb/os/os0sync.cc:196 mutex = 0x5644c8449940 #2 0x00005644c5df49e1 in os_event_wait_low (event=0x5644c8449940, reset_sig_count=3) at /home/vsts/src/storage/xtradb/os/os0sync.cc:477 No locals. #3 0x00005644c5df2fad in os_aio_simulated_handle (global_segment=1, message1=0x7ff8ab5eee80, message2=0x7ff8ab5eee88, type=0x7ff8ab5eee90, space_id=0x7ff8ab5eee98) at /home/vsts/src/storage/xtradb/os/os0file.cc:6204 array = 0x5644c84091b0 segment = 0 consecutive_ios = {0x0, 0x5644c8802918, 0x7ff8ab5eec80, 0x5644c8802930, 0x7ff8ab5ef700, 0x0, 0xbb8, 0x5644c737d460 , 0x5644c8802900, 0x5644c8802900, 0x7ff8ab5eecb0, 0x0, 0x0, 0xb0, 0x7ff8ab5eecf0, 0x0, 0x7ff8ab5eecf0, 0x5644c5ec8d39 , 0x7ff8ab5eecf0, 0x5c2, 0x7ff8ab5eed18, 0x7ff8ab5eed50, 0x7ff8780008e0, 0x7ff8780008c0, 0x7ff8ab5eed20, 0x5644c5ecb698 <__gnu_cxx::__alloc_traits >::destroy(std::allocator&, sync_level_t*)+35>, 0x7ff8780008e0, 0x5644c737d460 , 0x7ff8ab5ef700, 0x5644c737d4c8 , 0x7ff8ab5eed50, 0x5644c737d460 , 0x7ff8780008f0, 0x5644c737d4d0 , 0x7ff8ab5eed70, 0x5644c5ec7f2c , 0x7ff8ab5eed90, 0x5644c737d460 , 0x7ff8ab5eed90, 0x5644c5ec8118 , 0x7ff8780008e0, 0x5644c737d460 , 0x7ff8ab5eede0, 0x5644c5eca60a , 0x7ff8ab5eedc0, 0x5644c8579cc8, 0x7ff8780008e0, 0x5644c8579d30, 0x7ff8ab5eede0, 0x5644c8579cc8, 0x5644c8579cc8, 0x5644c8579d38, 0x7ff8ab5eee00, 0x5644c5dc5218 , 0x7ff8ab5eee10, 0x5644c8579cc8, 0x7ff8ab5eee20, 0x5644c5dc5561 , 0x7ff8ab5eee20, 0x5644c8579cc8, 0x7ff8ab5eee30, 0x5644c5dcafeb , 0x7ff8ab5eee50, 0x5644c5dc9614 } n_consecutive = 0 total_len = 0 offs = 140705141885168 lowest_offset = 18446744073709551615 biggest_age = 0 age = 94853377452594 combined_buf = 0xbb8 combined_buf2 = 0x0 ret = 140706003741808 any_reserved = 0 n = 256 aio_slot = 0x7ffc6f4656cf #4 0x00005644c5fccb88 in fil_aio_wait (segment=1) at /home/vsts/src/storage/xtradb/fil/fil0fil.cc:6254 ret = 1 fil_node = 0x5644c87f7a58 message = 0x5644c87f82f9 type = 11 space_id = 0 purpose = 502 #5 0x00005644c5ebcf46 in io_handler_thread (arg=0x5644c7370b08 ) at /home/vsts/src/storage/xtradb/srv/srv0start.cc:585 segment = 1 tid_i = 1 #6 0x00007ff8cffd46ba in start_thread (arg=0x7ff8ab5ef700) at pthread_create.c:333 __res = pd = 0x7ff8ab5ef700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140706003744512, 7669664285794399464, 0, 140722175366863, 140706003745216, 0, -7673771245723814680, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #7 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 2 (Thread 0x7ff8cf361700 (LWP 8601)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 No locals. #1 0x00005644c607790a in safe_cond_timedwait (cond=0x5644c738b0e0 , mp=0x5644c738b020 , abstime=0x7ff8cf360f00, file=0x5644c6356aa0 "/home/vsts/src/include/mysql/psi/mysql_thread.h", line=1202) at /home/vsts/src/mysys/thr_mutex.c:547 error = 0 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 8601, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\231!\000\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 2, __count = 0, __owner = 8601, __nusers = 1, __kind = 3, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\002\000\000\000\000\000\000\000\231!\000\000\001\000\000\000\003", '\000' , __align = 2}, file = 0x5644c6356aa0 "/home/vsts/src/include/mysql/psi/mysql_thread.h", name = 0x5644c6356b01 "LOCK_timer", line = 1202, count = 0, create_flags = 0, active_flags = 0, id = 12, thread = 140706605045504, locked_mutex = 0x7ff8c8000b00, used_mutex = 0x7ff8c8000b68, prev = 0x0, next = 0x0} #2 0x00005644c60788aa in inline_mysql_cond_timedwait (that=0x5644c738b0e0 , mutex=0x5644c738b020 , abstime=0x7ff8cf360f00, src_file=0x5644c6356ad0 "/home/vsts/src/mysys/thr_timer.c", src_line=292) at /home/vsts/src/include/mysql/psi/mysql_thread.h:1202 result = 0 #3 0x00005644c6079358 in timer_handler (arg=0x0) at /home/vsts/src/mysys/thr_timer.c:292 error = 0 top_time = 0x5644c86cb1e0 now = {tv_sec = 1548994425, tv_nsec = 689808000} abstime = {tv_sec = 1548994445, tv_nsec = 689781000} #4 0x00007ff8cffd46ba in start_thread (arg=0x7ff8cf361700) at pthread_create.c:333 __res = pd = 0x7ff8cf361700 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140706605045504, 7669664285794399464, 0, 140722175383103, 140706605046208, 0, -7673710022038752024, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #5 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals. Thread 1 (Thread 0x7ff8cc152b00 (LWP 8668)): #0 __pthread_kill (threadid=, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 pd = tid = 8668 val = 0 #1 0x00005644c60720c2 in my_write_core (sig=11) at /home/vsts/src/mysys/stacktrace.c:477 No locals. #2 0x00005644c5a0cb61 in handle_fatal_signal (sig=11) at /home/vsts/src/sql/signal_handler.cc:296 curr_time = 1548994437 tm = {tm_sec = 57, tm_min = 13, tm_hour = 4, tm_mday = 1, tm_mon = 1, tm_year = 119, tm_wday = 5, tm_yday = 31, tm_isdst = 0, tm_gmtoff = 0, tm_zone = 0x5644c8258e40 "UTC"} thd = 0x5644c86dcc70 print_invalid_query_pointer = false #3 No locals. #4 0x00005644c5bdcbb5 in maria_create_trn_for_mysql (info=0x7ff8740a4620) at /home/vsts/src/storage/maria/ha_maria.cc:914 thd = 0x0 trn = 0x7ff868004fc0 _db_stack_frame_ = {func = 0x7ff8cc150730 "\240\a\025\314\370\177", file = 0x5644c6093af3 <_db_pargs_+20> "H\211E\370H\203", , level = 3324415133, line = 22084, prev = 0x3d68004fc0} #5 0x00005644c5bcbe0a in _ma_setup_live_state (info=0x7ff8740a4620) at /home/vsts/src/storage/maria/ma_state.c:65 trn = 0x7ff86801bf70 share = 0x7ff8740e67d0 tables = 0x7ff86801e8d0 history = 0x7ff8680d0020 _db_stack_frame_ = {func = 0x5644c626bab9 "ha_maria::implicit_commit", file = 0x5644c626b030 "/home/vsts/src/storage/maria/ha_maria.cc", level = 2147483656, line = -1, prev = 0x7ff8cc1507f0} __PRETTY_FUNCTION__ = "_ma_setup_live_state" #6 0x00005644c5be22b0 in ha_maria::implicit_commit (thd=0x5644c86dcc70, new_trn=true) at /home/vsts/src/storage/maria/ha_maria.cc:2929 handler = 0x7ff8740a4620 trn = 0x7ff86801bf70 error = 0 locked_tables = 4 used_tables = 0x7ff86801fc70 trn_next = 0x0 _db_stack_frame_ = {func = 0x5644c62260d1 "ha_commit_trans", file = 0x5644c6225b49 "/home/vsts/src/sql/handler.cc", level = 2147483655, line = -1, prev = 0x7ff8cc150880} __PRETTY_FUNCTION__ = "static int ha_maria::implicit_commit(THD*, bool)" #7 0x00005644c5a0f8dd in ha_commit_trans (thd=0x5644c86dcc70, all=true) at /home/vsts/src/sql/handler.cc:1357 error = 0 cookie = 5 trans = 0x5644c86dfe68 is_real_trans = true ha_info = 0x0 need_prepare_ordered = 160 need_commit_ordered = 10 xid = 140704873467840 _db_stack_frame_ = {func = 0x5644c61a28cb "trans_commit_implicit", file = 0x5644c61a2580 "/home/vsts/src/sql/transaction.cc", level = 2147483654, line = -1, prev = 0x7ff8cc150aa0} __PRETTY_FUNCTION__ = "int ha_commit_trans(THD*, bool)" rw_ha_count = 2 rw_trans = 204 mdl_request = {type = 1744850880, duration = 32760, next_in_list = 0x1000268004f98, prev_in_list = 0x7ff8cc1509b0, ticket = 0x5644c6093d20 <_db_doprnt_+519>, key = {m_length = 25150, m_db_name_length = 50741, m_hash_value = 22084, m_ptr = "\"\223'\306DV\000\000\300O\000h\370\177\000\000\230O\000h\002\000\001\000\300O\000h\370\177\000\000\371\376\006\306DV\000\000\300\t\025\314\370\177\000\000PN\000h\000\000\000\000\344\254\064\306DV\000\000\300O\000h\370\177\000\000\300O\000h\370\177\000\000\230O\000h\002\000\001\000 \n\025\314\370\177\000\000 =\t\306DV\000\000\300O\000h\370\177\000\000\371\376\006\306DV\000\000`\t\025\314\370\177\000\000PN\000h\000\000\000\000\366%\032\306DV\000\000\300O\000h\370\177\000\000\300O\000h\370\177\000\000\230O\000h\002\000\001\000p\n\025\314\370\177\000\000 =\t\306DV\000\000\242%\032\306DV\000\000\000&\032\306DV\000\000\000\000\000\000\000\000\000\000"..., static m_namespace_to_wait_state_name = {{m_key = 0, m_name = 0x5644c61a02cb "Waiting for global read lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a02e8 "Waiting for schema metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0310 "Waiting for table metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0330 "Waiting for stored function metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0360 "Waiting for stored procedure metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a0390 "Waiting for trigger metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a03b8 "Waiting for event metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a03d8 "Waiting for commit lock", m_flags = 0}, {m_key = 0, m_name = 0x5644c61a03f0 "User lock", m_flags = 0}}}} #8 0x00005644c59172a4 in trans_commit_implicit (thd=0x5644c86dcc70) at /home/vsts/src/sql/transaction.cc:294 res = false _db_stack_frame_ = {func = 0x5644c6171a3f "mysql_execute_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7ff8cc150d10} #9 0x00005644c57d5ab2 in mysql_execute_command (thd=0x5644c86dcc70) at /home/vsts/src/sql/sql_parse.cc:5814 res = 0 up_result = 0 lex = 0x5644c86e06e0 select_lex = 0x5644c86e0ea8 first_table = 0x7ff868012a48 all_tables = 0x7ff868012a48 unit = 0x5644c86e07a8 have_table_map_for_update = false rpl_filter = 0x7ff868004e50 _db_stack_frame_ = {func = 0x5644c61728f8 "mysql_parse", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7ff8cc1514f0} __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" orig_binlog_format = BINLOG_FORMAT_STMT orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT __FUNCTION__ = "mysql_execute_command" #10 0x00005644c57d9f13 in mysql_parse (thd=0x5644c86dcc70, rawbuf=0x7ff868012828 "ALTER IGNORE TABLE `table0_aria_int_autoinc` DROP FOREIGN KEY f /* 100307, ALGORITHM=NOCOPY */, LOCK=SHARED /* QNO 387 CON_ID 11 */", length=131, parser_state=0x7ff8cc151670) at /home/vsts/src/sql/sql_parse.cc:7468 found_semicolon = 0x0 lex = 0x5644c86e06e0 err = false error = 32760 _db_stack_frame_ = {func = 0x5644c61715d9 "dispatch_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7ff8cc151650} __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*)" __FUNCTION__ = "mysql_parse" #11 0x00005644c57c8437 in dispatch_command (command=COM_QUERY, thd=0x5644c86dcc70, packet=0x5644c86e4111 "ALTER IGNORE TABLE `table0_aria_int_autoinc` DROP FOREIGN KEY f /*!100307, ALGORITHM=NOCOPY */, LOCK=SHARED /* QNO 387 CON_ID 11 */ ", packet_length=132) at /home/vsts/src/sql/sql_parse.cc:1496 packet_end = 0x7ff8680128ab "" parser_state = {m_input = {m_compute_digest = false}, m_lip = {m_thd = 0x5644c86dcc70, yylineno = 1, yylval = 0x7ff8cc150740, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7ff8680128ac "\004", m_tok_start = 0x7ff8680128ac "\004", m_tok_end = 0x7ff8680128ac "\004", m_end_of_query = 0x7ff8680128ab "", m_tok_start_prev = 0x7ff8680128ab "", m_buf = 0x7ff868012828 "ALTER IGNORE TABLE `table0_aria_int_autoinc` DROP FOREIGN KEY f /* 100307, ALGORITHM=NOCOPY */, LOCK=SHARED /* QNO 387 CON_ID 11 */", m_buf_length = 131, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7ff868012910 "ALTER IGNORE TABLE `table0_aria_int_autoinc` DROP FOREIGN KEY f , LOCK=SHARED /* QNO 387 CON_ID 11 */", m_cpp_ptr = 0x7ff868012975 "", m_cpp_tok_start = 0x7ff868012975 "", m_cpp_tok_start_prev = 0x7ff868012975 "", m_cpp_tok_end = 0x7ff868012975 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x7ff86807fb15 '\217' ..., m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 111 'o', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = NO_COMMENT, m_cpp_text_start = 0x7ff868012957 "SHARED /* QNO 387 CON_ID 11 */", m_cpp_text_end = 0x7ff86801295d " /* QNO 387 CON_ID 11 */", m_underscore_cs = 0x0, m_digest = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 }}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x0} net = 0x5644c86dcf30 error = false do_end_of_statement = true _db_stack_frame_ = {func = 0x5644c61713cb "do_command", file = 0x5644c6171288 "/home/vsts/src/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7ff8cc151e50} __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" __FUNCTION__ = "dispatch_command" #12 0x00005644c57c71a9 in do_command (thd=0x5644c86dcc70) at /home/vsts/src/sql/sql_parse.cc:1124 return_value = false packet = 0x5644c86e4110 "\003ALTER IGNORE TABLE `table0_aria_int_autoinc` DROP FOREIGN KEY f /*!100307, ALGORITHM=NOCOPY */, LOCK=SHARED /* QNO 387 CON_ID 11 */ " packet_length = 133 net = 0x5644c86dcf30 command = COM_QUERY _db_stack_frame_ = {func = 0x5644c6358ebd "?func", file = 0x5644c6358ec3 "?file", level = 2147483649, line = -1, prev = 0x0} __PRETTY_FUNCTION__ = "bool do_command(THD*)" #13 0x00005644c59028f2 in do_handle_one_connection (thd_arg=0x5644c86dcc70) at /home/vsts/src/sql/sql_connect.cc:1330 create_user = true thd = 0x5644c86dcc70 #14 0x00005644c5902641 in handle_one_connection (arg=0x5644c86dcc70) at /home/vsts/src/sql/sql_connect.cc:1242 thd = 0x5644c86dcc70 #15 0x00007ff8cffd46ba in start_thread (arg=0x7ff8cc152b00) at pthread_create.c:333 __res = pd = 0x7ff8cc152b00 now = unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140706552556288, 7669664285794399464, 0, 140722175383455, 140706552556992, 0, -7673703709913221912, -7673710509807602456}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}} not_first_call = pagesize_m1 = sp = freesize = __PRETTY_FUNCTION__ = "start_thread" #16 0x00007ff8cf67f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 No locals.