[New LWP 229930] [New LWP 229875] [New LWP 229873] [New LWP 229934] [New LWP 229872] [New LWP 229939] [New LWP 229932] [New LWP 229877] [New LWP 229880] [New LWP 229876] [New LWP 229874] [New LWP 229878] [New LWP 229881] [New LWP 229883] [New LWP 229886] [New LWP 229888] [New LWP 229879] [New LWP 229887] [New LWP 229882] [New LWP 229890] [New LWP 229892] [New LWP 229895] [New LWP 229905] [New LWP 229897] [New LWP 229889] [New LWP 229904] [New LWP 229907] [New LWP 229898] [New LWP 229871] [New LWP 229891] [New LWP 229899] [New LWP 229884] [New LWP 229893] [New LWP 229924] [New LWP 229903] [New LWP 229894] [New LWP 229926] [New LWP 229938] [New LWP 229900] [New LWP 229901] [New LWP 229906] [New LWP 229928] [New LWP 229919] [New LWP 229910] [New LWP 229936] [New LWP 229921] [New LWP 229902] [New LWP 229909] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `/ten1/builds/10.2-bf1e09e0-deb/bin/mysqld --no-defaults --basedir=/ten1/builds/'. Program terminated with signal 6, Aborted. #0 0x00007f52697b99d1 in pthread_kill () from /lib64/libpthread.so.0 Thread 48 (Thread 0x7f5250abf700 (LWP 229909)): #0 0x00007f5267b6620d in poll () from /lib64/libc.so.6 No symbol table info available. #1 0x000055b391d358bf in vio_io_wait (vio=0x55b393835f40, event=VIO_IO_EVENT_READ, timeout=28800000) at /home/elenst/src/10.2/vio/viosocket.c:945 ret = 64 revents = 8251 pfd = {fd = 43, events = 3, revents = 0} sd = 43 locker = 0x0 state = {m_flags = 43, m_socket = 0x0, m_thread = 0xaf50abeab0, m_number_of_bytes = 94229738714704, m_timer_start = 139991517489840, m_timer = 0x55b391ccffdd , m_operation = 4294967295, m_src_file = 0x7f51e80008c0 "\211", m_src_line = 1353444048, m_wait = 0x55b391cf1f52 } _db_stack_frame_ = {func = 0x55b3921a76b2 "vio_read", file = 0x55b3921a7650 "/home/elenst/src/10.2/vio/viosocket.c", level = 2147483651, line = -1, prev = 0x7f5250abeb50} __PRETTY_FUNCTION__ = "vio_io_wait" #2 0x000055b391d340e2 in vio_socket_io_wait (vio=0x55b393835f40, event=VIO_IO_EVENT_READ) at /home/elenst/src/10.2/vio/viosocket.c:108 timeout = 28800000 ret = 32593 __PRETTY_FUNCTION__ = "vio_socket_io_wait" #3 0x000055b391d34296 in vio_read (vio=0x55b393835f40, buf=0x7f51e80088b0 "e\002-1!", size=4) at /home/elenst/src/10.2/vio/viosocket.c:184 error = 11 ret = -1 flags = 64 _db_stack_frame_ = {func = 0x55b391d92717 "do_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f5250abed20} __PRETTY_FUNCTION__ = "vio_read" #4 0x000055b3912279cf in my_real_read (net=0x7f51e8000dd8, complen=0x7f5250abec60, header=1 '\001') at /home/elenst/src/10.2/sql/net_serv.cc:905 pos = 0x7f51e80088b0 "e\002-1!" remain = 4 __PRETTY_FUNCTION__ = "ulong my_real_read(NET*, size_t*, my_bool)" retry_count = 0 expect_error_packet = 0 '\000' alarmed = 0 '\000' net_blocking = 0 '\000' count = 4 server_extension = 0x7f51e8001080 length = 139991517490256 i = 0 len = 18446744073709551615 #5 0x000055b3912281d7 in my_net_read_packet_reallen (net=0x7f51e8000dd8, read_from_server=1 '\001', reallen=0x7f5250abecc8) at /home/elenst/src/10.2/sql/net_serv.cc:1175 len = 139991517490336 complen = 0 #6 0x000055b39122818a in my_net_read_packet (net=0x7f51e8000dd8, read_from_server=1 '\001') at /home/elenst/src/10.2/sql/net_serv.cc:1159 reallen = 0 #7 0x000055b391305f20 in do_command (thd=0x7f51e8000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:1257 return_value = false packet = 0x0 packet_length = 0 net = 0x7f51e8000dd8 command = COM_QUERY __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #8 0x000055b39145fef6 in do_handle_one_connection (connect=0x55b394272580) at /home/elenst/src/10.2/sql/sql_connect.cc:1336 create_user = true thr_create_utime = 8347578847177 thd = 0x7f51e8000af0 #9 0x000055b39145fc41 in handle_one_connection (arg=0x55b394272580) at /home/elenst/src/10.2/sql/sql_connect.cc:1241 connect = 0x55b394272580 #10 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #11 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 47 (Thread 0x7f521bfff700 (LWP 229902)): #0 0x00007f52697bbe3d in nanosleep () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391884f94 in os_thread_sleep (tm=1000000) at /home/elenst/src/10.2/storage/innobase/os/os0thread.cc:231 t = {tv_sec = 1, tv_nsec = 0} #2 0x000055b391a1d904 in btr_defragment_thread () at /home/elenst/src/10.2/storage/innobase/btr/btr0defragment.cc:710 item = 0x0 now = 0 elapsed = 0 pcur = 0x0 cursor = 0x0 mtr = {m_memo = {m_heap = 0x0, m_list = {::block_t, void>> = {sentinel_ = {next = 0x7f521bffe918, prev = 0x7f521bffe918}}, size_ = 1}, m_size = 0, m_first_block = {> = {next = 0x7f521bffe8f8, prev = 0x7f521bffe8f8}, m_buf_end = 0, m_magic_n = 375767, m_data = '\000' , m_used = 0}}, m_log = {m_heap = 0x0, m_list = {::block_t, void>> = {sentinel_ = {next = 0x7f521bffeb58, prev = 0x7f521bffeb58}}, size_ = 1}, m_size = 0, m_first_block = {> = {next = 0x7f521bffeb38, prev = 0x7f521bffeb38}, m_buf_end = 0, m_magic_n = 375767, m_data = '\000' , m_used = 0}}, m_made_dirty = false, m_inside_ibuf = false, m_modifications = false, m_n_log_recs = 0, m_log_mode = MTR_LOG_ALL, m_user_space_id = 0, m_user_space = 0x0, m_undo_space = 0x0, m_sys_space = 0x0, m_state = MTR_STATE_INIT, m_flush_observer = 0x0, m_commit_lsn = 0} last_block = 0x0 __PRETTY_FUNCTION__ = "void* btr_defragment_thread(void*)" index = 0x0 first_block = 0x0 #3 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #4 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 46 (Thread 0x7f52509de700 (LWP 229921)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391cd78ae in safe_cond_timedwait (cond=0x7f51d4000cc0, mp=0x7f51d4000c10, abstime=0x7f52509dc110, file=0x55b391dc4a80 "/home/elenst/src/10.2/include/mysql/psi/mysql_thread.h", line=1193) at /home/elenst/src/10.2/mysys/thr_mutex.c:545 error = 21939 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 229921, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000!\202\003\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 229921, __nusers = 1, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000!\202\003\000\001", '\000' , __align = 1}, file = 0x55b391dc4d18 "/home/elenst/src/10.2/sql/mdl.cc", name = 0x55b391dc4edc "m_LOCK_wait_status", line = 1067, count = 0, create_flags = 0, active_flags = 0, id = 2657, thread = 139991516571392, locked_mutex = 0x7f51d40ffa20, used_mutex = 0x7f51d40ffa88, prev = 0x0, next = 0x0} #2 0x000055b391469ada in inline_mysql_cond_timedwait (that=0x7f51d4000cc0, mutex=0x7f51d4000c10, abstime=0x7f52509dc110, src_file=0x55b391dc4d18 "/home/elenst/src/10.2/sql/mdl.cc", src_line=1092) at /home/elenst/src/10.2/include/mysql/psi/mysql_thread.h:1193 result = 32593 #3 0x000055b39146ae60 in MDL_wait::timed_wait (this=0x7f51d4000c10, owner=0x7f51d4000bc0, abs_timeout=0x7f52509dc110, set_status_on_timeout=false, wait_state_name=0x55b3926c4570 ) at /home/elenst/src/10.2/sql/mdl.cc:1092 wait_result = 0 __FUNCTION__ = "timed_wait" __PRETTY_FUNCTION__ = "MDL_wait::enum_wait_status MDL_wait::timed_wait(MDL_context_owner*, timespec*, bool, const PSI_stage_info*)" old_stage = {m_key = 0, m_name = 0x55b391d6ded6 "Opening tables", m_flags = -2147483637} result = 32593 _db_stack_frame_ = {func = 0x55b391dc5270 "MDL_context::acquire_lock", file = 0x55b391dc4d18 "/home/elenst/src/10.2/sql/mdl.cc", level = 2147483659, line = -1, prev = 0x7f52509dc120} #4 0x000055b39146c76c in MDL_context::acquire_lock (this=0x7f51d4000c10, mdl_request=0x7f51d4011800, lock_wait_timeout=10) at /home/elenst/src/10.2/sql/mdl.cc:2138 ticket = 0x7f51d43fd600 __PRETTY_FUNCTION__ = "bool MDL_context::acquire_lock(MDL_request*, double)" lock = 0x7f51bc070230 wait_status = MDL_wait::EMPTY _db_stack_frame_ = {func = 0x55b391dc53c1 "MDL_context::acquire_locks", file = 0x55b391dc4d18 "/home/elenst/src/10.2/sql/mdl.cc", level = 2147483658, line = -1, prev = 0x7f52509dc1c0} abs_timeout = {tv_sec = 1618141028, tv_nsec = 807786000} abs_shortwait = {tv_sec = 1618141020, tv_nsec = 807896000} #5 0x000055b39146cc0d in MDL_context::acquire_locks (this=0x7f51d4000c10, mdl_requests=0x7f52509dc250, lock_wait_timeout=10) at /home/elenst/src/10.2/sql/mdl.cc:2258 sort_buf = 0x7f51d40e0090 p_req = 0x7f51d40e00a0 mdl_svp = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0} it = {list = 0x7f52509dc250, current = 0x0} req_count = 3 _db_stack_frame_ = {func = 0x55b391d8180b "lock_table_names", file = 0x55b391d80d48 "/home/elenst/src/10.2/sql/sql_base.cc", level = 2147483657, line = -1, prev = 0x7f52509dc270} #6 0x000055b39129cc62 in lock_table_names (thd=0x7f51d4000af0, options=..., tables_start=0x7f51d40113b0, tables_end=0x0, lock_wait_timeout=10, flags=0) at /home/elenst/src/10.2/sql/sql_base.cc:3831 res = false mdl_requests = { = {m_counter = 3}, > = {}, m_first = 0x7f52509dc290} error_handler = { = {_vptr.Internal_error_handler = 0x55b3925cd510 , m_prev_internal_handler = 0x0}, } __PRETTY_FUNCTION__ = "bool lock_table_names(THD*, const DDL_options_st&, TABLE_LIST*, TABLE_LIST*, ulong, uint)" table = 0x0 global_request = {type = MDL_INTENTION_EXCLUSIVE, duration = MDL_STATEMENT, next_in_list = 0x7f51d4011800, prev_in_list = 0x7f52509dc258, ticket = 0x7f51d4078630, key = {m_length = 3, m_db_name_length = 0, m_hash_value = 65537, m_ptr = "\000\000\000\221\263U\000\000\340\302\235PR\177\000\000\060\n\000\324Q\177\000\000\060\n\000\324Q\177\000\000\020\n\000\324\001\000\000\000 ŝPR\177\000\000\030Eϑ\263U\000\000\060ŝPR\177\000\000\220ŝPR\177\000\000\a\000\000\000\000\000\000\000\060\n\000\324Q\177\000\000\006\000\000\000\000\000\000\000\060\n\000\324Q\177\000\000\001\000\000\000\000\000\000\000j\231\060\221\263U\000\000\000^;hR\177\000\000\370\377\377\377\000\000\000\000\060?ّ\263U\000\000\000\000\000\000\000\000\000\000pÝPR\177\000\000\335\377̑\000\000\001\000\220ÝPR\177\000\000NRϑ\263U\000\000\220ÝPR\177\000\000\060\n\000\324Q\177\000\000\060\n\000\324Q\177\000\000\020\n\000"..., static m_namespace_to_wait_state_name = {{m_key = 0, m_name = 0x55b391dc4be2 "Waiting for global read lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4c00 "Waiting for schema metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4c28 "Waiting for table metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4c48 "Waiting for stored function metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4c78 "Waiting for stored procedure metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4ca8 "Waiting for trigger metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4cd0 "Waiting for event metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4cf0 "Waiting for commit lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4d08 "User lock", m_flags = 0}}}} org_lock_wait_timeout = 10 create_table = false _db_stack_frame_ = {func = 0x55b391d81880 "open_tables", file = 0x55b391d80d48 "/home/elenst/src/10.2/sql/sql_base.cc", level = 2147483656, line = -1, prev = 0x7f52509dc500} #7 0x000055b39129d1c2 in open_tables (thd=0x7f51d4000af0, options=..., start=0x7f52509dc598, counter=0x7f52509dc5b4, flags=0, prelocking_strategy=0x7f52509dc630) at /home/elenst/src/10.2/sql/sql_base.cc:4051 table = 0x7f52509dc500 some_routine_modifies_data = false _db_stack_frame_ = {func = 0x55b391d81a19 "open_and_lock_tables", file = 0x55b391d80d48 "/home/elenst/src/10.2/sql/sql_base.cc", level = 2147483655, line = -1, prev = 0x7f52509dc5d0} xa_state = XA_NOTR __PRETTY_FUNCTION__ = "bool open_tables(THD*, const DDL_options_st&, TABLE_LIST**, uint*, uint, Prelocking_strategy*)" table_to_open = 0x7f52509dc598 ot_ctx = {m_thd = 0x7f51d4000af0, 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 = false} has_prelocking_list = false __FUNCTION__ = "open_tables" sroutine_to_open = 0x7f51d40046c0 tables = 0x0 error = false #8 0x000055b39129e8ec in open_and_lock_tables (thd=0x7f51d4000af0, options=..., tables=0x7f51d40113b0, derived=true, flags=0, prelocking_strategy=0x7f52509dc630) at /home/elenst/src/10.2/sql/sql_base.cc:4880 counter = 0 mdl_savepoint = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0} _db_stack_frame_ = {func = 0x55b391daaefe "Sql_cmd_create_table::execute", file = 0x55b391da9420 "/home/elenst/src/10.2/sql/sql_table.cc", level = 2147483654, line = -1, prev = 0x7f52509dc6f0} #9 0x000055b3913eba8d in open_and_lock_tables (thd=0x7f51d4000af0, options=..., tables=0x7f51d40113b0, derived=true, flags=0) at /home/elenst/src/10.2/sql/sql_base.h:500 prelocking_strategy = { = {_vptr.Prelocking_strategy = 0x55b3925cdbf0 }, } #10 0x000055b3913ea92e in Sql_cmd_create_table::execute (this=0x7f51d4011390, thd=0x7f51d4000af0) at /home/elenst/src/10.2/sql/sql_table.cc:10897 result = 0x55b391dc70c0 save_thd_create_info_options = 0 _db_stack_frame_ = {func = 0x55b391d92e14 "mysql_execute_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7f52509dcb40} lex = 0x7f51d4004628 __PRETTY_FUNCTION__ = "virtual bool Sql_cmd_create_table::execute(THD*)" create_table = 0x7f51d40113b0 res = 0 used_engine = true create_info = { = { = {table_charset = 0x0, tabledef_version = {str = 0x0, length = 0}, connect_string = {str = 0x0, length = 0}, password = 0x0, tablespace = 0x0, comment = {str = 0x0, length = 0}, data_file_name = 0x0, index_file_name = 0x0, alias = 0x7f51d40113a8 "tmp", max_rows = 0, min_rows = 0, auto_increment_value = 0, table_options = 0, avg_row_length = 0, used_fields = 4096, key_block_size = 0, expression_length = 0, field_check_constraints = 0, stats_sample_pages = 0, null_bits = 0, options = 0, merge_insert_method = 0, extra_size = 0, db_type = 0x55b39384a690, row_type = ROW_TYPE_DEFAULT, transactional = HA_CHOICE_UNDEF, storage_media = HA_SM_DEFAULT, page_checksum = HA_CHOICE_UNDEF, option_list = 0x0, stats_auto_recalc = HA_STATS_AUTO_RECALC_DEFAULT, varchar = false, check_constraint_list = 0x0, option_struct = 0x0, fields_option_struct = 0x0, indexes_option_struct = 0x0, table = 0x0, pos_in_locked_tables = 0x0, mdl_ticket = 0x0, table_was_deleted = false, merge_list = 0x0}, = {default_table_charset = 0x0}, }, = {m_options = DDL_options_st::OPT_OR_REPLACE}, } alter_info = {static ALTER_ADD_COLUMN = 1, static ALTER_DROP_COLUMN = 2, static ALTER_CHANGE_COLUMN = 4, static ALTER_ADD_INDEX = 8, static ALTER_DROP_INDEX = 16, static ALTER_RENAME = 32, static ALTER_ORDER = 64, static ALTER_OPTIONS = 128, static ALTER_CHANGE_COLUMN_DEFAULT = 256, static ALTER_KEYS_ONOFF = 512, static ALTER_RECREATE = 1024, static ALTER_ADD_PARTITION = 2048, static ALTER_DROP_PARTITION = 4096, static ALTER_COALESCE_PARTITION = 8192, static ALTER_REORGANIZE_PARTITION = 16384, static ALTER_PARTITION = 32768, static ALTER_ADMIN_PARTITION = 65536, static ALTER_TABLE_REORG = 131072, static ALTER_REBUILD_PARTITION = 262144, static ALTER_ALL_PARTITION = 524288, static ALTER_REMOVE_PARTITIONING = 1048576, static ADD_FOREIGN_KEY = 2097152, static DROP_FOREIGN_KEY = 4194304, static ALTER_EXCHANGE_PARTITION = 8388608, static ALTER_TRUNCATE_PARTITION = 16777216, static ALTER_COLUMN_ORDER = 33554432, static ALTER_ADD_CHECK_CONSTRAINT = 134217728, static ALTER_DROP_CHECK_CONSTRAINT = 268435456, static ALTER_RENAME_COLUMN = 536870912, drop_list = { = { = {}, first = 0x55b3928a60c0 , last = 0x7f52509dc730, elements = 0}, }, alter_list = { = { = {}, first = 0x55b3928a60c0 , last = 0x7f52509dc748, elements = 0}, }, key_list = { = { = {}, first = 0x55b3928a60c0 , last = 0x7f52509dc760, elements = 0}, }, create_list = { = { = {}, first = 0x55b3928a60c0 , last = 0x7f52509dc778, elements = 0}, }, static CHECK_CONSTRAINT_IF_NOT_EXISTS = 1, check_constraint_list = { = { = {}, first = 0x55b3928a60c0 , last = 0x7f52509dc790, elements = 0}, }, flags = 0, keys_onoff = Alter_info::LEAVE_AS_IS, partition_names = { = { = {}, first = 0x55b3928a60c0 , last = 0x7f52509dc7b0, elements = 0}, }, num_parts = 0, requested_algorithm = Alter_info::ALTER_TABLE_ALGORITHM_DEFAULT, requested_lock = Alter_info::ALTER_TABLE_LOCK_DEFAULT} select_lex = 0x7f51d4004e28 first_table = 0x7f51d40113b0 link_to_local = 174 select_tables = 0x7f51d4012100 unit = 0x7f51d40046e8 #11 0x000055b391314be0 in mysql_execute_command (thd=0x7f51d4000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:6020 res = 0 lex = 0x7f51d4004628 _db_stack_frame_ = {func = 0x55b391d93c28 "mysql_parse", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f52509dd330} __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" orig_binlog_format = BINLOG_FORMAT_MIXED up_result = 0 rpl_filter = 0x7f51d4000a10 orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT __FUNCTION__ = "mysql_execute_command" select_lex = 0x7f51d4004e28 first_table = 0x7f51d40113b0 all_tables = 0x7f51d40113b0 unit = 0x7f51d40046e8 have_table_map_for_update = false #12 0x000055b391319775 in mysql_parse (thd=0x7f51d4000af0, rawbuf=0x7f51d4011128 "CREATE /* QNO 1144 CON_ID 21 */ OR REPLACE TABLE `tmp` ENGINE = InnoDB AS /* `t4_Aria` `id` id */ SELECT JSON_COMPACT( JSON_ARRAY( LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/01.json') ) ) AS fl"..., length=222, parser_state=0x7f52509dd520, is_com_multi=false, is_next_command=false) at /home/elenst/src/10.2/sql/sql_parse.cc:7794 found_semicolon = 0x0 lex = 0x7f51d4004628 err = false error = 32593 _db_stack_frame_ = {func = 0x55b391d92942 "dispatch_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f52509dd500} __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)" __FUNCTION__ = "mysql_parse" #13 0x000055b391307a5e in dispatch_command (command=COM_QUERY, thd=0x7f51d4000af0, packet=0x7f51d40088b1 "CREATE /* QNO 1144 CON_ID 21 */ OR REPLACE TABLE `tmp` ENGINE = InnoDB AS /* `t4_Aria` `id` id */ SELECT JSON_COMPACT( JSON_ARRAY( LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/01.json') ) ) AS fl"..., packet_length=223, is_com_multi=false, is_next_command=false) at /home/elenst/src/10.2/sql/sql_parse.cc:1828 packet_end = 0x7f51d4011206 "" parser_state = {m_input = {m_compute_digest = false}, m_lip = {m_thd = 0x7f51d4000af0, yylineno = 1, yylval = 0x7f52509dc550, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7f51d4011207 "\004", m_tok_start = 0x7f51d4011207 "\004", m_tok_end = 0x7f51d4011207 "\004", m_end_of_query = 0x7f51d4011206 "", m_tok_start_prev = 0x7f51d4011206 "", m_buf = 0x7f51d4011128 "CREATE /* QNO 1144 CON_ID 21 */ OR REPLACE TABLE `tmp` ENGINE = InnoDB AS /* `t4_Aria` `id` id */ SELECT JSON_COMPACT( JSON_ARRAY( LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/01.json') ) ) AS fl"..., m_buf_length = 222, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7f51d4011260 "CREATE /* QNO 1144 CON_ID 21 */ OR REPLACE TABLE `tmp` ENGINE = InnoDB AS /* `t4_Aria` `id` id */ SELECT JSON_COMPACT( JSON_ARRAY( LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/01.json') ) ) AS fl"..., m_cpp_ptr = 0x7f51d401133e "", m_cpp_tok_start = 0x7f51d401133e "", m_cpp_tok_start_prev = 0x7f51d401133e "", m_cpp_tok_end = 0x7f51d401133e "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x7f51d4407333 '\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 = 0x7f51d401133d "4", m_cpp_text_end = 0x7f51d401133e "", 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 = 0x7f51d4000dd8 do_end_of_statement = true __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)" __FUNCTION__ = "dispatch_command" error = false _db_stack_frame_ = {func = 0x55b391d92717 "do_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f52509ddd20} drop_more_results = false #14 0x000055b391306404 in do_command (thd=0x7f51d4000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:1382 return_value = false packet = 0x7f51d40088b0 "\003CREATE /* QNO 1144 CON_ID 21 */ OR REPLACE TABLE `tmp` ENGINE = InnoDB AS /* `t4_Aria` `id` id */ SELECT JSON_COMPACT( JSON_ARRAY( LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/01.json') ) ) AS f"... packet_length = 224 net = 0x7f51d4000dd8 command = COM_QUERY __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #15 0x000055b39145fef6 in do_handle_one_connection (connect=0x55b394272580) at /home/elenst/src/10.2/sql/sql_connect.cc:1336 create_user = true thr_create_utime = 8347585911635 thd = 0x7f51d4000af0 #16 0x000055b39145fc41 in handle_one_connection (arg=0x55b394272580) at /home/elenst/src/10.2/sql/sql_connect.cc:1241 connect = 0x55b394272580 #17 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #18 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 45 (Thread 0x7f52347ad700 (LWP 229936)): #0 0x00007f5267b6620d in poll () from /lib64/libc.so.6 No symbol table info available. #1 0x000055b391d358bf in vio_io_wait (vio=0x55b3941c1e70, event=VIO_IO_EVENT_READ, timeout=28800000) at /home/elenst/src/10.2/vio/viosocket.c:945 ret = 64 revents = 8251 pfd = {fd = 61, events = 3, revents = 0} sd = 61 locker = 0x0 state = {m_flags = 61, m_socket = 0x0, m_thread = 0xaf347acab0, m_number_of_bytes = 94229738714704, m_timer_start = 139991044508336, m_timer = 0x55b391ccffdd , m_operation = 4294967295, m_src_file = 0x7f51b00008c0 "\211", m_src_line = 880462544, m_wait = 0x55b391cf1f52 } _db_stack_frame_ = {func = 0x55b3921a76b2 "vio_read", file = 0x55b3921a7650 "/home/elenst/src/10.2/vio/viosocket.c", level = 2147483651, line = -1, prev = 0x7f52347acb50} __PRETTY_FUNCTION__ = "vio_io_wait" #2 0x000055b391d340e2 in vio_socket_io_wait (vio=0x55b3941c1e70, event=VIO_IO_EVENT_READ) at /home/elenst/src/10.2/vio/viosocket.c:108 timeout = 28800000 ret = 32593 __PRETTY_FUNCTION__ = "vio_socket_io_wait" #3 0x000055b391d34296 in vio_read (vio=0x55b3941c1e70, buf=0x7f51b00088b0 "\001", size=4) at /home/elenst/src/10.2/vio/viosocket.c:184 error = 11 ret = -1 flags = 64 _db_stack_frame_ = {func = 0x55b391d92717 "do_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f52347acd20} __PRETTY_FUNCTION__ = "vio_read" #4 0x000055b3912279cf in my_real_read (net=0x7f51b0000dd8, complen=0x7f52347acc60, header=1 '\001') at /home/elenst/src/10.2/sql/net_serv.cc:905 pos = 0x7f51b00088b0 "\001" remain = 4 __PRETTY_FUNCTION__ = "ulong my_real_read(NET*, size_t*, my_bool)" retry_count = 0 expect_error_packet = 0 '\000' alarmed = 0 '\000' net_blocking = 0 '\000' count = 4 server_extension = 0x7f51b0001080 length = 139991044508752 i = 0 len = 18446744073709551615 #5 0x000055b3912281d7 in my_net_read_packet_reallen (net=0x7f51b0000dd8, read_from_server=1 '\001', reallen=0x7f52347accc8) at /home/elenst/src/10.2/sql/net_serv.cc:1175 len = 139991044508832 complen = 0 #6 0x000055b39122818a in my_net_read_packet (net=0x7f51b0000dd8, read_from_server=1 '\001') at /home/elenst/src/10.2/sql/net_serv.cc:1159 reallen = 0 #7 0x000055b391305f20 in do_command (thd=0x7f51b0000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:1257 return_value = false packet = 0x0 packet_length = 0 net = 0x7f51b0000dd8 command = COM_QUERY __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #8 0x000055b39145fef6 in do_handle_one_connection (connect=0x55b3941b7720) at /home/elenst/src/10.2/sql/sql_connect.cc:1336 create_user = true thr_create_utime = 8347586704756 thd = 0x7f51b0000af0 #9 0x000055b39145fc41 in handle_one_connection (arg=0x55b3941b7720) at /home/elenst/src/10.2/sql/sql_connect.cc:1241 connect = 0x55b3941b7720 #10 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #11 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 44 (Thread 0x7f5250a74700 (LWP 229910)): #0 0x00007f5267b6620d in poll () from /lib64/libc.so.6 No symbol table info available. #1 0x000055b391d358bf in vio_io_wait (vio=0x55b394291000, event=VIO_IO_EVENT_READ, timeout=28800000) at /home/elenst/src/10.2/vio/viosocket.c:945 ret = 64 revents = 8251 pfd = {fd = 44, events = 3, revents = 0} sd = 44 locker = 0x0 state = {m_flags = 44, m_socket = 0x0, m_thread = 0xaf50a73ab0, m_number_of_bytes = 94229738714704, m_timer_start = 139991517182640, m_timer = 0x55b391ccffdd , m_operation = 4294967295, m_src_file = 0x7f51ec0008c0 "\211", m_src_line = 1353136848, m_wait = 0x55b391cf1f52 } _db_stack_frame_ = {func = 0x55b3921a76b2 "vio_read", file = 0x55b3921a7650 "/home/elenst/src/10.2/vio/viosocket.c", level = 2147483651, line = -1, prev = 0x7f5250a73b50} __PRETTY_FUNCTION__ = "vio_io_wait" #2 0x000055b391d340e2 in vio_socket_io_wait (vio=0x55b394291000, event=VIO_IO_EVENT_READ) at /home/elenst/src/10.2/vio/viosocket.c:108 timeout = 28800000 ret = 32593 __PRETTY_FUNCTION__ = "vio_socket_io_wait" #3 0x000055b391d34296 in vio_read (vio=0x55b394291000, buf=0x7f51ec48d380 "tamp\373#", size=4) at /home/elenst/src/10.2/vio/viosocket.c:184 error = 11 ret = -1 flags = 64 _db_stack_frame_ = {func = 0x55b391d92717 "do_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f5250a73d20} __PRETTY_FUNCTION__ = "vio_read" #4 0x000055b3912279cf in my_real_read (net=0x7f51ec000dd8, complen=0x7f5250a73c60, header=1 '\001') at /home/elenst/src/10.2/sql/net_serv.cc:905 pos = 0x7f51ec48d380 "tamp\373#" remain = 4 __PRETTY_FUNCTION__ = "ulong my_real_read(NET*, size_t*, my_bool)" retry_count = 0 expect_error_packet = 0 '\000' alarmed = 0 '\000' net_blocking = 0 '\000' count = 4 server_extension = 0x7f51ec001080 length = 139991517183056 i = 0 len = 18446744073709551615 #5 0x000055b3912281d7 in my_net_read_packet_reallen (net=0x7f51ec000dd8, read_from_server=1 '\001', reallen=0x7f5250a73cc8) at /home/elenst/src/10.2/sql/net_serv.cc:1175 len = 139991517183136 complen = 0 #6 0x000055b39122818a in my_net_read_packet (net=0x7f51ec000dd8, read_from_server=1 '\001') at /home/elenst/src/10.2/sql/net_serv.cc:1159 reallen = 0 #7 0x000055b391305f20 in do_command (thd=0x7f51ec000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:1257 return_value = false packet = 0x0 packet_length = 0 net = 0x7f51ec000dd8 command = COM_QUERY __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #8 0x000055b39145fef6 in do_handle_one_connection (connect=0x55b3941f6200) at /home/elenst/src/10.2/sql/sql_connect.cc:1336 create_user = true thr_create_utime = 8347578878645 thd = 0x7f51ec000af0 #9 0x000055b39145fc41 in handle_one_connection (arg=0x55b3941f6200) at /home/elenst/src/10.2/sql/sql_connect.cc:1241 connect = 0x55b3941f6200 #10 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #11 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 43 (Thread 0x7f5250a29700 (LWP 229919)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391cd78ae in safe_cond_timedwait (cond=0x7f51d00008c8, mp=0x7f51c8088260, abstime=0x7f5250a271b0, file=0x55b392064b50 "/home/elenst/src/10.2/include/mysql/psi/mysql_thread.h", line=1193) at /home/elenst/src/10.2/mysys/thr_mutex.c:545 error = 21939 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 229919, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\037\202\003\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 229919, __nusers = 6, __kind = 3, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\037\202\003\000\006\000\000\000\003", '\000' , __align = 1}, file = 0x55b392064b88 "/home/elenst/src/10.2/mysys/thr_lock.c", name = 0x55b392064bb0 "lock->mutex", line = 762, count = 0, create_flags = 0, active_flags = 0, id = 8968, thread = 139991516878592, locked_mutex = 0x7f51c8148fb0, used_mutex = 0x7f51c8149018, prev = 0x0, next = 0x0} #2 0x000055b391cd3f09 in inline_mysql_cond_timedwait (that=0x7f51d00008c8, mutex=0x7f51c8088260, abstime=0x7f5250a271b0, src_file=0x55b392064b88 "/home/elenst/src/10.2/mysys/thr_lock.c", src_line=575) at /home/elenst/src/10.2/include/mysql/psi/mysql_thread.h:1193 result = 0 #3 0x000055b391cd4584 in wait_for_lock (wait=0x7f51c8088330, data=0x7f51bc1001a8, in_wait_list=0 '\000', lock_wait_timeout=10) at /home/elenst/src/10.2/mysys/thr_lock.c:575 rc = 21939 thread_var = 0x7f51d00008c0 cond = 0x7f51d00008c8 wait_timeout = {tv_sec = 1618141028, tv_nsec = 66495000} result = THR_LOCK_ABORTED old_stage = {m_key = 0, m_name = 0x55b391d6e1a1 "Table lock", m_flags = -805297120} use_wait_callbacks = 1 '\001' __FUNCTION__ = "wait_for_lock" #4 0x000055b391cd50d2 in thr_lock (data=0x7f51bc1001a8, owner=0x7f51d0002420, lock_wait_timeout=10) at /home/elenst/src/10.2/mysys/thr_lock.c:1013 lock = 0x7f51c8088248 result = THR_LOCK_SUCCESS wait_queue = 0x7f51c8088330 lock_type = TL_WRITE wsrep_lock_inserted = 0 '\000' locker = 0x0 state = {m_flags = 1352823392, m_io_operation = 32594, m_table = 0x55b391cf1f52 , m_table_share = 0x7f51d0000a30, m_thread = 0x7f51d0000a10, m_timer_start = 94229735500936, m_timer = 0x158, m_wait = 0x7f5250a27290, m_index = 2434867115} #5 0x000055b391cd59bc in thr_multi_lock (data=0x7f51d00143e8, count=1, owner=0x7f51d0002420, lock_wait_timeout=10) at /home/elenst/src/10.2/mysys/thr_lock.c:1294 result = 21939 pos = 0x7f51d00143e8 end = 0x7f51d00143f0 first_lock = 0x55b3926a1b10 #6 0x000055b3916ac46d in mysql_lock_tables (thd=0x7f51d0000af0, sql_lock=0x7f51d00143c8, flags=0) at /home/elenst/src/10.2/sql/lock.cc:354 timeout = 10 org_stage = {m_key = 0, m_name = 0x0, m_flags = -805223440} __FUNCTION__ = "mysql_lock_tables" rc = 1 _db_stack_frame_ = {func = 0x55b391e96dc5 "mysql_lock_tables(tables)", file = 0x55b391e96c88 "/home/elenst/src/10.2/sql/lock.cc", level = 2147483656, line = -1, prev = 0x7f5250a273a0} #7 0x000055b3916ac26e in mysql_lock_tables (thd=0x7f51d0000af0, tables=0x7f51d00143c0, count=1, flags=0) at /home/elenst/src/10.2/sql/lock.cc:303 sql_lock = 0x7f51d00143c8 gld_flags = 3 _db_stack_frame_ = {func = 0x55b391d81b28 "lock_tables", file = 0x55b391d80d48 "/home/elenst/src/10.2/sql/sql_base.cc", level = 2147483655, line = -1, prev = 0x7f5250a27440} #8 0x000055b39129f1bb in lock_tables (thd=0x7f51d0000af0, tables=0x7f51d00122a8, count=1, flags=0) at /home/elenst/src/10.2/sql/sql_base.cc:5109 start = 0x7f51d00143c0 ptr = 0x7f51d00143c8 table = 0x0 _db_stack_frame_ = {func = 0x55b391daf051 "mysql_update", file = 0x55b391daefe8 "/home/elenst/src/10.2/sql/sql_update.cc", level = 2147483654, line = -1, prev = 0x7f5250a275b0} __PRETTY_FUNCTION__ = "bool lock_tables(THD*, TABLE_LIST*, uint, uint)" res = false #9 0x000055b3913fe361 in mysql_update (thd=0x7f51d0000af0, table_list=0x7f51d00122a8, fields=..., values=..., conds=0x0, order_num=1, order=0x7f51d0014160, limit=8, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f5250a27b60, updated_return=0x7f5250a27c10) at /home/elenst/src/10.2/sql/sql_update.cc:314 using_limit = true transactional_table = false loc_error = 0 dup_key_found = 1352824848 select = 0x0 info = {table = 0x0, forms = 0x0, unlock_row = 0x7f5250a27680, read_record = 0x1000091ccffdd, thd = 0x7f5250a276a0, select = 0x55b391cf524e , cache_records = 1352824480, ref_length = 32594, struct_length = 3489663536, reclength = 32593, rec_cache_size = 3489663536, error_offset = 32593, index = 3489663504, ref_pos = 0x7f5250a278e0 "0y\242PR\177", record = 0x55b391cf4518 <_db_return_+211> "\203\340\001\205\300\017\204", , rec_buf = 0x0, cache = 0x0, cache_pos = 0x7f5100000005
, cache_end = 0x7f51d0000a30 "\346\333\374\310\377\177", read_positions = 0x7f5250a276f0 "\020w\242PR\177", addon_field = 0xbb8ac851168e6600, io_cache = 0x7f5250a27830, print_error = 77, ignore_not_found_rows = 247, unpack = 0x7f5250a27710, copy_field = 0x7f00d00128c1, copy_field_end = 0x5500ffffffff} will_batch = 145 error = -1848035568 want_privilege = 32594 file_sort = 0x0 id = 0 killed_status = NOT_KILLED can_compare_record = false updated = 139989358742064 query_plan = {_vptr.Update_plan = 0x55b3925d4a30 , impossible_where = false, no_partitions = false, updating_a_view = 207, mem_root = 0x7f51d0005c68, table = 0xd0000a30, select = 0x55b3920656e8, index = 64, scanned_rows = 139991516870224, select_lex = 0x91ccffdd, possible_keys = {map = 94229734348487}, using_filesort = false, using_io_buffer = false} __FUNCTION__ = "mysql_update" safe_update = false found = 139989358742064 old_covering_keys = {map = 139991516869952} table = 0x7f5250a277f0 res = -1848836131 table_count = 1 __PRETTY_FUNCTION__ = "int mysql_update(THD*, TABLE_LIST*, List&, List&, COND*, uint, ORDER*, ha_rows, enum_duplicates, bool, ha_rows*, ha_rows*)" err2 = 65536 used_key_is_modified = false need_sort = true reverse = false select_lex = 0x7f51d0004e28 all_fields = { = { = {}, first = 0x55b3928a60c0 , last = 0x7f5250a27590, elements = 0}, } explain = 0x7f5100000006 _db_stack_frame_ = {func = 0x55b391d92e14 "mysql_execute_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7f5250a27b40} #10 0x000055b39130dd71 in mysql_execute_command (thd=0x7f51d0000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:4067 found = 0 updated = 0 res = 0 lex = 0x7f51d0004628 _db_stack_frame_ = {func = 0x55b391d93c28 "mysql_parse", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f5250a28330} __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" orig_binlog_format = BINLOG_FORMAT_MIXED up_result = 0 rpl_filter = 0x7f51d0000a10 orig_current_stmt_binlog_format = BINLOG_FORMAT_ROW __FUNCTION__ = "mysql_execute_command" select_lex = 0x7f51d0004e28 first_table = 0x7f51d00122a8 all_tables = 0x7f51d00122a8 unit = 0x7f51d00046e8 have_table_map_for_update = false #11 0x000055b391319775 in mysql_parse (thd=0x7f51d0000af0, rawbuf=0x7f51d0011128 "UPDATE /* QNO 1567 CON_ID 20 */ `tmp` SET fld = JSON_KEYS( JSON_REMOVE( '{\"swjwnuifxdccehoqyxijgcy\": \"wjwnuifxdccehoqyxijgcyxyqaucfapty\",\"jwnuifxdccehoqyxijg\": 100440836249273,\"wnuifxdc\": 619029143970"..., length=2149, parser_state=0x7f5250a28520, is_com_multi=false, is_next_command=false) at /home/elenst/src/10.2/sql/sql_parse.cc:7794 found_semicolon = 0x0 lex = 0x7f51d0004628 err = false error = 32593 _db_stack_frame_ = {func = 0x55b391d92942 "dispatch_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f5250a28500} __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)" __FUNCTION__ = "mysql_parse" #12 0x000055b391307a5e in dispatch_command (command=COM_QUERY, thd=0x7f51d0000af0, packet=0x7f51d00088b1 "UPDATE /* QNO 1567 CON_ID 20 */ `tmp` SET fld = JSON_KEYS( JSON_REMOVE( '{\"swjwnuifxdccehoqyxijgcy\": \"wjwnuifxdccehoqyxijgcyxyqaucfapty\",\"jwnuifxdccehoqyxijg\": 100440836249273,\"wnuifxdc\": 619029143970"..., packet_length=2150, is_com_multi=false, is_next_command=false) at /home/elenst/src/10.2/sql/sql_parse.cc:1828 packet_end = 0x7f51d001198d "" parser_state = {m_input = {m_compute_digest = false}, m_lip = {m_thd = 0x7f51d0000af0, yylineno = 1, yylval = 0x7f5250a27550, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7f51d001198e "\004", m_tok_start = 0x7f51d001198e "\004", m_tok_end = 0x7f51d001198e "\004", m_end_of_query = 0x7f51d001198d "", m_tok_start_prev = 0x7f51d001198d "", m_buf = 0x7f51d0011128 "UPDATE /* QNO 1567 CON_ID 20 */ `tmp` SET fld = JSON_KEYS( JSON_REMOVE( '{\"swjwnuifxdccehoqyxijgcy\": \"wjwnuifxdccehoqyxijgcyxyqaucfapty\",\"jwnuifxdccehoqyxijg\": 100440836249273,\"wnuifxdc\": 619029143970"..., m_buf_length = 2149, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7f51d00119e8 "UPDATE /* QNO 1567 CON_ID 20 */ `tmp` SET fld = JSON_KEYS( JSON_REMOVE( '{\"swjwnuifxdccehoqyxijgcy\": \"wjwnuifxdccehoqyxijgcyxyqaucfapty\",\"jwnuifxdccehoqyxijg\": 100440836249273,\"wnuifxdc\": 619029143970"..., m_cpp_ptr = 0x7f51d001224d "", m_cpp_tok_start = 0x7f51d001224d "", m_cpp_tok_start_prev = 0x7f51d001224d "", m_cpp_tok_end = 0x7f51d001224d "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x7f51d0131747 "displayType\\\" : \\\"table\\\",\\n \\\"downloadCount\\\" : 19144,\\n \205", 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 = 0x7f51d001224c "8", m_cpp_text_end = 0x7f51d001224d "", 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 = 0x7f51d0000dd8 do_end_of_statement = true __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)" __FUNCTION__ = "dispatch_command" error = false _db_stack_frame_ = {func = 0x55b391d92717 "do_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f5250a28d20} drop_more_results = false #13 0x000055b391306404 in do_command (thd=0x7f51d0000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:1382 return_value = false packet = 0x7f51d00088b0 "\003UPDATE /* QNO 1567 CON_ID 20 */ `tmp` SET fld = JSON_KEYS( JSON_REMOVE( '{\"swjwnuifxdccehoqyxijgcy\": \"wjwnuifxdccehoqyxijgcyxyqaucfapty\",\"jwnuifxdccehoqyxijg\": 100440836249273,\"wnuifxdc\": 61902914397"... packet_length = 2151 net = 0x7f51d0000dd8 command = COM_QUERY __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #14 0x000055b39145fef6 in do_handle_one_connection (connect=0x55b3941b7720) at /home/elenst/src/10.2/sql/sql_connect.cc:1336 create_user = true thr_create_utime = 8347585806327 thd = 0x7f51d0000af0 #15 0x000055b39145fc41 in handle_one_connection (arg=0x55b3941b7720) at /home/elenst/src/10.2/sql/sql_connect.cc:1241 connect = 0x55b3941b7720 #16 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #17 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 42 (Thread 0x7f52500ec700 (LWP 229928)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391cd78ae in safe_cond_timedwait (cond=0x7f51c0000cc0, mp=0x7f51c0000c10, abstime=0x7f52500ea400, file=0x55b391dc4a80 "/home/elenst/src/10.2/include/mysql/psi/mysql_thread.h", line=1193) at /home/elenst/src/10.2/mysys/thr_mutex.c:545 error = 21939 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 229928, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000(\202\003\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 229928, __nusers = 1, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000(\202\003\000\001", '\000' , __align = 1}, file = 0x55b391dc4d18 "/home/elenst/src/10.2/sql/mdl.cc", name = 0x55b391dc4edc "m_LOCK_wait_status", line = 1067, count = 0, create_flags = 0, active_flags = 0, id = 2234, thread = 139991507191552, locked_mutex = 0x7f51c00b7c30, used_mutex = 0x7f51c00b7c98, prev = 0x0, next = 0x0} #2 0x000055b391469ada in inline_mysql_cond_timedwait (that=0x7f51c0000cc0, mutex=0x7f51c0000c10, abstime=0x7f52500ea400, src_file=0x55b391dc4d18 "/home/elenst/src/10.2/sql/mdl.cc", src_line=1092) at /home/elenst/src/10.2/include/mysql/psi/mysql_thread.h:1193 result = 32593 #3 0x000055b39146ae60 in MDL_wait::timed_wait (this=0x7f51c0000c10, owner=0x7f51c0000bc0, abs_timeout=0x7f52500ea400, set_status_on_timeout=false, wait_state_name=0x55b3926c4570 ) at /home/elenst/src/10.2/sql/mdl.cc:1092 wait_result = 0 __FUNCTION__ = "timed_wait" __PRETTY_FUNCTION__ = "MDL_wait::enum_wait_status MDL_wait::timed_wait(MDL_context_owner*, timespec*, bool, const PSI_stage_info*)" old_stage = {m_key = 0, m_name = 0x55b391d6ded6 "Opening tables", m_flags = -2147483639} result = 32593 _db_stack_frame_ = {func = 0x55b391dc5270 "MDL_context::acquire_lock", file = 0x55b391dc4d18 "/home/elenst/src/10.2/sql/mdl.cc", level = 2147483657, line = -1, prev = 0x7f52500ea410} #4 0x000055b39146c76c in MDL_context::acquire_lock (this=0x7f51c0000c10, mdl_request=0x7f51c0011680, lock_wait_timeout=10) at /home/elenst/src/10.2/sql/mdl.cc:2138 ticket = 0x7f51c006a990 __PRETTY_FUNCTION__ = "bool MDL_context::acquire_lock(MDL_request*, double)" lock = 0x7f51b001e2e0 wait_status = MDL_wait::EMPTY _db_stack_frame_ = {func = 0x55b391dc53c1 "MDL_context::acquire_locks", file = 0x55b391dc4d18 "/home/elenst/src/10.2/sql/mdl.cc", level = 2147483656, line = -1, prev = 0x7f52500ea4b0} abs_timeout = {tv_sec = 1618141028, tv_nsec = 792105000} abs_shortwait = {tv_sec = 1618141020, tv_nsec = 792186000} #5 0x000055b39146cc0d in MDL_context::acquire_locks (this=0x7f51c0000c10, mdl_requests=0x7f52500ea540, lock_wait_timeout=10) at /home/elenst/src/10.2/sql/mdl.cc:2258 sort_buf = 0x7f51c00c94c0 p_req = 0x7f51c00c94d0 mdl_svp = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0} it = {list = 0x7f52500ea540, current = 0x0} req_count = 3 _db_stack_frame_ = {func = 0x55b391d8180b "lock_table_names", file = 0x55b391d80d48 "/home/elenst/src/10.2/sql/sql_base.cc", level = 2147483655, line = -1, prev = 0x7f52500ea560} #6 0x000055b39129cc62 in lock_table_names (thd=0x7f51c0000af0, options=..., tables_start=0x7f51c0011230, tables_end=0x0, lock_wait_timeout=10, flags=0) at /home/elenst/src/10.2/sql/sql_base.cc:3831 res = false mdl_requests = { = {m_counter = 3}, > = {}, m_first = 0x7f52500ea580} error_handler = { = {_vptr.Internal_error_handler = 0x55b3925cd510 , m_prev_internal_handler = 0x0}, } __PRETTY_FUNCTION__ = "bool lock_table_names(THD*, const DDL_options_st&, TABLE_LIST*, TABLE_LIST*, ulong, uint)" table = 0x0 global_request = {type = MDL_INTENTION_EXCLUSIVE, duration = MDL_STATEMENT, next_in_list = 0x7f51c0011680, prev_in_list = 0x7f52500ea548, ticket = 0x7f51c009a8a0, key = {m_length = 3, m_db_name_length = 0, m_hash_value = 65537, m_ptr = "\000\000\000\221\263U\000\000Х\016PR\177\000\000\060\n\000\300Q\177\000\000\060\n\000\300Q\177\000\000\020\n\000\300\001\000\000\000\020\250\016PR\177\000\000\030Eϑ\000\000\000\000_\242ޑ\263U\000\000\000\000\000\000\000\000\000\000\020\246\016PR\177\000\000\335\377̑\000\000\001\000\060\246\016PR\177\000\000NRϑ\263U\000\000\060\246\016PR\177\000\000\060\n\000\300Q\177\000\000\060\n\000\300Q\177\000\000\020\n\000\300\001\000\000\000p\250\016PR\177\000\000\030Eϑ\000\000\000\000d\243ޑ\263U\000\000\000\000\000\000\000\000\000\000p\246\016PR\177\000\000\335\377̑\000\000\001\000\220\246\016PR\177\000\000NRϑ\000\000\000\000\307\326ב\263U\000\000\000\000\000\000\000\000\000\000"..., static m_namespace_to_wait_state_name = {{m_key = 0, m_name = 0x55b391dc4be2 "Waiting for global read lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4c00 "Waiting for schema metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4c28 "Waiting for table metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4c48 "Waiting for stored function metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4c78 "Waiting for stored procedure metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4ca8 "Waiting for trigger metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4cd0 "Waiting for event metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4cf0 "Waiting for commit lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4d08 "User lock", m_flags = 0}}}} org_lock_wait_timeout = 10 create_table = false _db_stack_frame_ = {func = 0x55b391d81880 "open_tables", file = 0x55b391d80d48 "/home/elenst/src/10.2/sql/sql_base.cc", level = 2147483654, line = -1, prev = 0x7f52500ea7f0} #7 0x000055b39129d1c2 in open_tables (thd=0x7f51c0000af0, options=..., start=0x7f52500ea8b0, counter=0x7f52500ea8c8, flags=0, prelocking_strategy=0x7f52500ea8d0) at /home/elenst/src/10.2/sql/sql_base.cc:4051 table = 0x7f51c0011518 some_routine_modifies_data = false _db_stack_frame_ = {func = 0x55b391d92e14 "mysql_execute_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7f52500eab40} xa_state = XA_NOTR __PRETTY_FUNCTION__ = "bool open_tables(THD*, const DDL_options_st&, TABLE_LIST**, uint*, uint, Prelocking_strategy*)" table_to_open = 0x7f52500ea8b0 ot_ctx = {m_thd = 0x7f51c0000af0, 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 = false} has_prelocking_list = false __FUNCTION__ = "open_tables" sroutine_to_open = 0x7f51c00046c0 tables = 0x7f51c0011530 error = false #8 0x000055b3913036b8 in open_tables (thd=0x7f51c0000af0, tables=0x7f52500ea8b0, counter=0x7f52500ea8c8, flags=0, prelocking_strategy=0x7f52500ea8d0) at /home/elenst/src/10.2/sql/sql_base.h:249 No locals. #9 0x000055b39130a517 in lock_tables_open_and_lock_tables (thd=0x7f51c0000af0, tables=0x7f51c0011230) at /home/elenst/src/10.2/sql/sql_parse.cc:2821 deadlock_handler = { = {_vptr.Internal_error_handler = 0x55b3925cf1b0 , m_prev_internal_handler = 0x0}, m_need_reopen = 48} mdl_savepoint = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0} __PRETTY_FUNCTION__ = "bool lock_tables_open_and_lock_tables(THD*, TABLE_LIST*)" lock_tables_prelocking_strategy = { = { = {_vptr.Prelocking_strategy = 0x55b3925cdb90 }, }, } counter = 0 table = 0x217f #10 0x000055b391310089 in mysql_execute_command (thd=0x7f51c0000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:4710 res = 0 lex = 0x7f51c0004628 _db_stack_frame_ = {func = 0x55b391d93c28 "mysql_parse", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f52500eb330} __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" orig_binlog_format = BINLOG_FORMAT_MIXED up_result = 0 rpl_filter = 0x7f51c0000a10 orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT __FUNCTION__ = "mysql_execute_command" select_lex = 0x7f51c0004e28 first_table = 0x7f51c0011230 all_tables = 0x7f51c0011230 unit = 0x7f51c00046e8 have_table_map_for_update = false #11 0x000055b391319775 in mysql_parse (thd=0x7f51c0000af0, rawbuf=0x7f51c0011128 "LOCK /* QNO 1286 CON_ID 24 */ TABLE alt_t9 WRITE", length=48, parser_state=0x7f52500eb520, is_com_multi=false, is_next_command=false) at /home/elenst/src/10.2/sql/sql_parse.cc:7794 found_semicolon = 0x0 lex = 0x7f51c0004628 err = false error = 32593 _db_stack_frame_ = {func = 0x55b391d92942 "dispatch_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f52500eb500} __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)" __FUNCTION__ = "mysql_parse" #12 0x000055b391307a5e in dispatch_command (command=COM_QUERY, thd=0x7f51c0000af0, packet=0x7f51c00088b1 "LOCK /* QNO 1286 CON_ID 24 */ TABLE alt_t9 WRITE", packet_length=48, is_com_multi=false, is_next_command=false) at /home/elenst/src/10.2/sql/sql_parse.cc:1828 packet_end = 0x7f51c0011158 "" parser_state = {m_input = {m_compute_digest = false}, m_lip = {m_thd = 0x7f51c0000af0, yylineno = 1, yylval = 0x7f52500ea550, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7f51c0011159 "\004", m_tok_start = 0x7f51c0011159 "\004", m_tok_end = 0x7f51c0011159 "\004", m_end_of_query = 0x7f51c0011158 "", m_tok_start_prev = 0x7f51c0011158 "", m_buf = 0x7f51c0011128 "LOCK /* QNO 1286 CON_ID 24 */ TABLE alt_t9 WRITE", m_buf_length = 48, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7f51c00111b0 "LOCK /* QNO 1286 CON_ID 24 */ TABLE alt_t9 WRITE", m_cpp_ptr = 0x7f51c00111e0 "", m_cpp_tok_start = 0x7f51c00111e0 "", m_cpp_tok_start_prev = 0x7f51c00111e0 "", m_cpp_tok_end = 0x7f51c00111e0 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x7f51c004cbac "", 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 = 0x7f51c00111d4 "alt_t9 WRITE", m_cpp_text_end = 0x7f51c00111da " WRITE", 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 = 0x7f51c0000dd8 do_end_of_statement = true __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)" __FUNCTION__ = "dispatch_command" error = false _db_stack_frame_ = {func = 0x55b391d92717 "do_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f52500ebd20} drop_more_results = false #13 0x000055b391306404 in do_command (thd=0x7f51c0000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:1382 return_value = false packet = 0x7f51c00088b0 "\003LOCK /* QNO 1286 CON_ID 24 */ TABLE alt_t9 WRITE" packet_length = 49 net = 0x7f51c0000dd8 command = COM_QUERY __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #14 0x000055b39145fef6 in do_handle_one_connection (connect=0x55b3941b7720) at /home/elenst/src/10.2/sql/sql_connect.cc:1336 create_user = true thr_create_utime = 8347586224191 thd = 0x7f51c0000af0 #15 0x000055b39145fc41 in handle_one_connection (arg=0x55b3941b7720) at /home/elenst/src/10.2/sql/sql_connect.cc:1241 connect = 0x55b3941b7720 #16 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #17 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 41 (Thread 0x7f5250b55700 (LWP 229906)): #0 0x00007f52697bc361 in sigwait () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391216eed in signal_hand (arg=0x0) at /home/elenst/src/10.2/sql/mysqld.cc:3557 error = 0 set = {__val = {548869, 0 }} sig = 0 _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #2 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #3 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 40 (Thread 0x7f5220ff9700 (LWP 229901)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b3918845ae in os_event::timed_wait (this=0x55b3941b3df0, abstime=0x7f5220ff8c70) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:275 ret = 110 #2 0x000055b391884857 in os_event::wait_time_low (this=0x55b3941b3df0, time_in_usec=1000000, reset_sig_count=265603) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:385 timed_out = false abstime = {tv_sec = 1618141020, tv_nsec = 431963000} #3 0x000055b391884a28 in os_event_wait_time_low (event=0x55b3941b3df0, time_in_usec=1000000, reset_sig_count=0) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:490 No locals. #4 0x000055b391ac18b7 in fil_crypt_thread () at /home/elenst/src/10.2/storage/innobase/fil/fil0crypt.cc:2203 waited = 92 new_state = {key_id = 0, key_version = 0, rotate_key_age = 1} wait_start = 1618140927 thread_no = 3 thr = {thread_no = 3, first = false, space = 0x0, offset = 0, batch = 0, min_key_version_found = 0, end_lsn = 0, estimated_max_iops = 20, allocated_iops = 0, cnt_waited = 0, sum_waited_us = 0, crypt_stat = {pages_read_from_cache = 0, pages_read_from_disk = 0, pages_modified = 0, pages_flushed = 0, estimated_iops = 20}, scrub_data = {space = 55, scrubbing = false, compressed = false, current_table = 0x0, current_index = 0x0, savepoint = 0, scrub_stat = {page_reorganizations = 0, page_splits = 0, page_split_failures_underflow = 0, page_split_failures_out_of_filespace = 0, page_split_failures_missing_index = 0, page_split_failures_unknown = 0}}} recheck = false #5 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 39 (Thread 0x7f52217fa700 (LWP 229900)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b3918845ae in os_event::timed_wait (this=0x55b3941b3df0, abstime=0x7f52217f9c70) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:275 ret = 110 #2 0x000055b391884857 in os_event::wait_time_low (this=0x55b3941b3df0, time_in_usec=1000000, reset_sig_count=265603) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:385 timed_out = false abstime = {tv_sec = 1618141020, tv_nsec = 426754000} #3 0x000055b391884a28 in os_event_wait_time_low (event=0x55b3941b3df0, time_in_usec=1000000, reset_sig_count=0) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:490 No locals. #4 0x000055b391ac18b7 in fil_crypt_thread () at /home/elenst/src/10.2/storage/innobase/fil/fil0crypt.cc:2203 waited = 92 new_state = {key_id = 0, key_version = 0, rotate_key_age = 1} wait_start = 1618140927 thread_no = 1 thr = {thread_no = 1, first = false, space = 0x0, offset = 0, batch = 0, min_key_version_found = 0, end_lsn = 0, estimated_max_iops = 20, allocated_iops = 0, cnt_waited = 0, sum_waited_us = 0, crypt_stat = {pages_read_from_cache = 0, pages_read_from_disk = 0, pages_modified = 0, pages_flushed = 0, estimated_iops = 20}, scrub_data = {space = 55, scrubbing = false, compressed = false, current_table = 0x0, current_index = 0x0, savepoint = 0, scrub_stat = {page_reorganizations = 0, page_splits = 0, page_split_failures_underflow = 0, page_split_failures_out_of_filespace = 0, page_split_failures_missing_index = 0, page_split_failures_unknown = 0}}} recheck = false #5 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 38 (Thread 0x7f5234262700 (LWP 229938)): #0 0x00007f5267b6620d in poll () from /lib64/libc.so.6 No symbol table info available. #1 0x000055b391d358bf in vio_io_wait (vio=0x55b3942720e0, event=VIO_IO_EVENT_READ, timeout=28800000) at /home/elenst/src/10.2/vio/viosocket.c:945 ret = 64 revents = 8251 pfd = {fd = 62, events = 3, revents = 0} sd = 62 locker = 0x0 state = {m_flags = 62, m_socket = 0x0, m_thread = 0xaf34261ab0, m_number_of_bytes = 94229738714704, m_timer_start = 139991038958256, m_timer = 0x55b391ccffdd , m_operation = 4294967295, m_src_file = 0x7f51b40008c0 "", m_src_line = 874912464, m_wait = 0x55b391cf1f52 } _db_stack_frame_ = {func = 0x55b3921a76b2 "vio_read", file = 0x55b3921a7650 "/home/elenst/src/10.2/vio/viosocket.c", level = 2147483651, line = -1, prev = 0x7f5234261b50} __PRETTY_FUNCTION__ = "vio_io_wait" #2 0x000055b391d340e2 in vio_socket_io_wait (vio=0x55b3942720e0, event=VIO_IO_EVENT_READ) at /home/elenst/src/10.2/vio/viosocket.c:108 timeout = 28800000 ret = 32593 __PRETTY_FUNCTION__ = "vio_socket_io_wait" #3 0x000055b391d34296 in vio_read (vio=0x55b3942720e0, buf=0x7f51b40088b0 "\001", size=4) at /home/elenst/src/10.2/vio/viosocket.c:184 error = 11 ret = -1 flags = 64 _db_stack_frame_ = {func = 0x55b391d92717 "do_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f5234261d20} __PRETTY_FUNCTION__ = "vio_read" #4 0x000055b3912279cf in my_real_read (net=0x7f51b4000dd8, complen=0x7f5234261c60, header=1 '\001') at /home/elenst/src/10.2/sql/net_serv.cc:905 pos = 0x7f51b40088b0 "\001" remain = 4 __PRETTY_FUNCTION__ = "ulong my_real_read(NET*, size_t*, my_bool)" retry_count = 0 expect_error_packet = 0 '\000' alarmed = 0 '\000' net_blocking = 0 '\000' count = 4 server_extension = 0x7f51b4001080 length = 139991038958672 i = 0 len = 18446744073709551615 #5 0x000055b3912281d7 in my_net_read_packet_reallen (net=0x7f51b4000dd8, read_from_server=1 '\001', reallen=0x7f5234261cc8) at /home/elenst/src/10.2/sql/net_serv.cc:1175 len = 139991038958752 complen = 0 #6 0x000055b39122818a in my_net_read_packet (net=0x7f51b4000dd8, read_from_server=1 '\001') at /home/elenst/src/10.2/sql/net_serv.cc:1159 reallen = 0 #7 0x000055b391305f20 in do_command (thd=0x7f51b4000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:1257 return_value = false packet = 0x0 packet_length = 0 net = 0x7f51b4000dd8 command = COM_QUERY __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #8 0x000055b39145fef6 in do_handle_one_connection (connect=0x55b394272580) at /home/elenst/src/10.2/sql/sql_connect.cc:1336 create_user = true thr_create_utime = 8347587124939 thd = 0x7f51b4000af0 #9 0x000055b39145fc41 in handle_one_connection (arg=0x55b394272580) at /home/elenst/src/10.2/sql/sql_connect.cc:1241 connect = 0x55b394272580 #10 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #11 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 37 (Thread 0x7f5250137700 (LWP 229926)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391cd78ae in safe_cond_timedwait (cond=0x7f51cc000cc0, mp=0x7f51cc000c10, abstime=0x7f52501348d0, file=0x55b391dc4a80 "/home/elenst/src/10.2/include/mysql/psi/mysql_thread.h", line=1193) at /home/elenst/src/10.2/mysys/thr_mutex.c:545 error = 21939 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 229926, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000&\202\003\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 229926, __nusers = 1, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000&\202\003\000\001", '\000' , __align = 1}, file = 0x55b391dc4d18 "/home/elenst/src/10.2/sql/mdl.cc", name = 0x55b391dc4edc "m_LOCK_wait_status", line = 1067, count = 0, create_flags = 0, active_flags = 0, id = 2675, thread = 139991507498752, locked_mutex = 0x7f51cc0693f0, used_mutex = 0x7f51cc069458, prev = 0x0, next = 0x0} #2 0x000055b391469ada in inline_mysql_cond_timedwait (that=0x7f51cc000cc0, mutex=0x7f51cc000c10, abstime=0x7f52501348d0, src_file=0x55b391dc4d18 "/home/elenst/src/10.2/sql/mdl.cc", src_line=1092) at /home/elenst/src/10.2/include/mysql/psi/mysql_thread.h:1193 result = 32593 #3 0x000055b39146ae60 in MDL_wait::timed_wait (this=0x7f51cc000c10, owner=0x7f51cc000bc0, abs_timeout=0x7f52501348d0, set_status_on_timeout=false, wait_state_name=0x55b3926c4570 ) at /home/elenst/src/10.2/sql/mdl.cc:1092 wait_result = 0 __FUNCTION__ = "timed_wait" __PRETTY_FUNCTION__ = "MDL_wait::enum_wait_status MDL_wait::timed_wait(MDL_context_owner*, timespec*, bool, const PSI_stage_info*)" old_stage = {m_key = 0, m_name = 0x55b391d6ded6 "Opening tables", m_flags = 1343440896} result = 21939 _db_stack_frame_ = {func = 0x55b391dc5270 "MDL_context::acquire_lock", file = 0x55b391dc4d18 "/home/elenst/src/10.2/sql/mdl.cc", level = 2147483659, line = -1, prev = 0x7f52501348e0} #4 0x000055b39146c76c in MDL_context::acquire_lock (this=0x7f51cc000c10, mdl_request=0x7f51cc353fe0, lock_wait_timeout=10) at /home/elenst/src/10.2/sql/mdl.cc:2138 ticket = 0x7f51cc01e9c0 __PRETTY_FUNCTION__ = "bool MDL_context::acquire_lock(MDL_request*, double)" lock = 0x7f51bc070230 wait_status = MDL_wait::EMPTY _db_stack_frame_ = {func = 0x55b391d812be "open_table", file = 0x55b391d80d48 "/home/elenst/src/10.2/sql/sql_base.cc", level = 2147483658, line = -1, prev = 0x7f5250134bf0} abs_timeout = {tv_sec = 1618141028, tv_nsec = 833655000} abs_shortwait = {tv_sec = 1618141020, tv_nsec = 833742000} #5 0x000055b3912983c1 in open_table_get_mdl_lock (thd=0x7f51cc000af0, ot_ctx=0x7f5250134f80, mdl_request=0x7f51cc353fe0, flags=0, mdl_ticket=0x7f5250134bd0) at /home/elenst/src/10.2/sql/sql_base.cc:1462 mdl_deadlock_handler = { = {_vptr.Internal_error_handler = 0x55b3925cdc90 , m_prev_internal_handler = 0x0}, m_ot_ctx = 0x7f5250134f80, m_is_active = false} result = false mdl_request_shared = {type = 2458542272, duration = 21939, next_in_list = 0x55b39374be00, prev_in_list = 0x7f5250134a00, ticket = 0x55b391469805 , key = {m_length = 16024, m_db_name_length = 52239, m_hash_value = 32593, m_ptr = "x\276t\223\263U\000\000\340I\023PR\177\000\000\250\361F\221\263U\000\000\200>\017\314Q\177\000\000x\276t\223\263U\000\000\000\000\000\000\000\000\000\000\200>\017\314Q\177\000\000PJ\023PR\177\000\000\252\263F\221\263U\000\000\200>\017\314Q\177\000\000x\276t\223\263U\000\000\000J\023P\000\000\000\000\244\204͑\263U\000\000\210>\017\314Q\177\000\000\000\r\000\314Q\177\000\000PJ\023PR\177\000\000\272\376̑\263U\000\000PJ\023PR\177\000\000\335\377̑\263U\000\000\n\000\000\000\000\000\000\000\300\b\000\314\000\000\000\000\311yؑ\263U\000\000\000\000\000\000\000\000\000\000\200J\023PR\177\000\000\335\377̑\000\000\001\000\240J\023PR"..., static m_namespace_to_wait_state_name = {{m_key = 0, m_name = 0x55b391dc4be2 "Waiting for global read lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4c00 "Waiting for schema metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4c28 "Waiting for table metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4c48 "Waiting for stored function metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4c78 "Waiting for stored procedure metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4ca8 "Waiting for trigger metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4cd0 "Waiting for event metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4cf0 "Waiting for commit lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4d08 "User lock", m_flags = 0}}}} __PRETTY_FUNCTION__ = "bool open_table_get_mdl_lock(THD*, Open_table_context*, MDL_request*, uint, MDL_ticket**)" #6 0x000055b391298d67 in open_table (thd=0x7f51cc000af0, table_list=0x7f51cc353b90, ot_ctx=0x7f5250134f80) at /home/elenst/src/10.2/sql/sql_base.cc:1761 table = 0x0 key = 0x7f51cc354009 "test" alias = 0x7f51cc353b88 "tmp" flags = 0 gts_flags = 0 _db_stack_frame_ = {func = 0x55b391d8170b "open_and_process_table", file = 0x55b391d80d48 "/home/elenst/src/10.2/sql/sql_base.cc", level = 2147483657, line = -1, prev = 0x7f5250134e90} __PRETTY_FUNCTION__ = "bool open_table(THD*, TABLE_LIST*, Open_table_context*)" mdl_ticket = 0x7f5250134c00 key_length = 9 share = 0x7f5250134c00 #7 0x000055b39129c41c in open_and_process_table (thd=0x7f51cc000af0, tables=0x7f51cc353b90, counter=0x7f5250135014, flags=0, prelocking_strategy=0x7f5250135090, has_prelocking_list=false, ot_ctx=0x7f5250134f80) at /home/elenst/src/10.2/sql/sql_base.cc:3614 lex = 0x7f51cc004628 __PRETTY_FUNCTION__ = "bool open_and_process_table(THD*, TABLE_LIST*, uint*, uint, Prelocking_strategy*, bool, Open_table_context*)" error = false safe_to_ignore_table = false _db_stack_frame_ = {func = 0x55b391d81880 "open_tables", file = 0x55b391d80d48 "/home/elenst/src/10.2/sql/sql_base.cc", level = 2147483656, line = -1, prev = 0x7f5250134f60} #8 0x000055b39129d2aa in open_tables (thd=0x7f51cc000af0, options=..., start=0x7f5250134ff8, counter=0x7f5250135014, flags=0, prelocking_strategy=0x7f5250135090) at /home/elenst/src/10.2/sql/sql_base.cc:4083 some_routine_modifies_data = false _db_stack_frame_ = {func = 0x55b391d81a19 "open_and_lock_tables", file = 0x55b391d80d48 "/home/elenst/src/10.2/sql/sql_base.cc", level = 2147483655, line = -1, prev = 0x7f5250135030} xa_state = XA_NOTR __PRETTY_FUNCTION__ = "bool open_tables(THD*, const DDL_options_st&, TABLE_LIST**, uint*, uint, Prelocking_strategy*)" table_to_open = 0x7f5250134ff8 ot_ctx = {m_thd = 0x7f51cc000af0, 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} has_prelocking_list = false __FUNCTION__ = "open_tables" sroutine_to_open = 0x7f51cc0046c0 tables = 0x7f51cc353b90 error = false #9 0x000055b39129e8ec in open_and_lock_tables (thd=0x7f51cc000af0, options=..., tables=0x7f51cc353b90, derived=true, flags=0, prelocking_strategy=0x7f5250135090) at /home/elenst/src/10.2/sql/sql_base.cc:4880 counter = 1 mdl_savepoint = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0} _db_stack_frame_ = {func = 0x55b391ea73c8 "mysql_delete", file = 0x55b391ea73a0 "/home/elenst/src/10.2/sql/sql_delete.cc", level = 2147483654, line = -1, prev = 0x7f52501351a0} #10 0x000055b3912650b3 in open_and_lock_tables (thd=0x7f51cc000af0, tables=0x7f51cc353b90, derived=true, flags=0) at /home/elenst/src/10.2/sql/sql_base.h:509 prelocking_strategy = { = {_vptr.Prelocking_strategy = 0x55b3925cdbf0 }, } #11 0x000055b391721455 in mysql_delete (thd=0x7f51cc000af0, table_list=0x7f51cc353b90, conds=0x7f51cc354780, order_list=0x7f51cc005088, limit=1, options=549755813888, result=0x0) at /home/elenst/src/10.2/sql/sql_delete.cc:252 file_sort = 0x0 safe_update = 127 explain = 0x7f51cc652cd0 __PRETTY_FUNCTION__ = "bool mysql_delete(THD*, TABLE_LIST*, COND*, SQL_I_List*, ha_rows, ulonglong, select_result*)" will_batch = 120 transactional_table = 71 const_cond_result = false return_error = false reverse = false query_type = THD::ROW_QUERY_TYPE select_lex = 0x7f51cc004e28 with_select = false query_plan = { = {_vptr.Update_plan = 0x55b39267fa90 , impossible_where = false, no_partitions = false, updating_a_view = 72, mem_root = 0x7f51cc005c68, table = 0x55b3928baf60 , select = 0x7f5250135230, index = 64, scanned_rows = 94229734793646, select_lex = 0x0, possible_keys = {map = 139991507489360}, using_filesort = false, using_io_buffer = false}, deleting_all_rows = false} table = 0x7f52501351a0 order = 0x0 _db_stack_frame_ = {func = 0x55b391d92e14 "mysql_execute_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7f5250135b40} loc_error = 32594 select = 0x0 info = {table = 0x0, forms = 0x55b391cf524e , unlock_row = 0x7f5250135270, read_record = 0x7f51cc000a30, thd = 0x7f51cc000a30, select = 0x1cc000a10, cache_records = 1343444144, ref_length = 32594, struct_length = 2446279960, reclength = 0, rec_cache_size = 2447287577, error_offset = 21939, index = 0, ref_pos = 0x55b391dea6d2 "THD::lock_temporary_tables", record = 0x0, rec_buf = 0x7f52501352c0 "\340R\023PR\177", cache = 0x0, cache_pos = 0x7f52501352e0 "E\242ޑ\263U", cache_end = 0x55b391cf524e "\203\370\003t.\203\370\003\177\023\203\370\001t6\203\370\001\177(\205\300t", , read_positions = 0x7f52501352e0 "E\242ޑ\263U", addon_field = 0x7f51cc000a30, io_cache = 0x7f51cc000a30, print_error = 16, ignore_not_found_rows = 10, unpack = 0x55b391dea245, copy_field = 0x0, copy_field_end = 0x7f5250135310} const_cond = 81 deleted = 0 __FUNCTION__ = "mysql_delete" error = 1343443296 using_limit = true killed_status = NOT_KILLED #12 0x000055b39130f0c1 in mysql_execute_command (thd=0x7f51cc000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:4426 sel_result = 0x0 save_protocol = 0x7f51cc000a30 replaced_protocol = false res = 0 lex = 0x7f51cc004628 _db_stack_frame_ = {func = 0x55b391d93c28 "mysql_parse", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f5250136330} __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" orig_binlog_format = BINLOG_FORMAT_MIXED up_result = 0 rpl_filter = 0x7f51cc000a10 orig_current_stmt_binlog_format = BINLOG_FORMAT_ROW __FUNCTION__ = "mysql_execute_command" select_lex = 0x7f51cc004e28 first_table = 0x7f51cc353b90 all_tables = 0x7f51cc353b90 unit = 0x7f51cc0046e8 have_table_map_for_update = false #13 0x000055b391319775 in mysql_parse (thd=0x7f51cc000af0, rawbuf=0x7f51cc353768 "DELETE /* QNO 2201 CON_ID 23 */ FROM tmp WHERE LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/03.json') < '[167257741635259,false,null,224433559083125,true,null,true,true,3498391754186,false,true,2"..., length=448, parser_state=0x7f5250136520, is_com_multi=false, is_next_command=false) at /home/elenst/src/10.2/sql/sql_parse.cc:7794 found_semicolon = 0x0 lex = 0x7f51cc004628 err = false error = 32593 _db_stack_frame_ = {func = 0x55b391d92942 "dispatch_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f5250136500} __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)" __FUNCTION__ = "mysql_parse" #14 0x000055b391307a5e in dispatch_command (command=COM_QUERY, thd=0x7f51cc000af0, packet=0x7f51cc0088b1 "DELETE /* QNO 2201 CON_ID 23 */ FROM tmp WHERE LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/03.json') < '[167257741635259,false,null,224433559083125,true,null,true,true,3498391754186,false,true,2"..., packet_length=448, is_com_multi=false, is_next_command=false) at /home/elenst/src/10.2/sql/sql_parse.cc:1828 packet_end = 0x7f51cc353928 "" parser_state = {m_input = {m_compute_digest = false}, m_lip = {m_thd = 0x7f51cc000af0, yylineno = 1, yylval = 0x7f5250135550, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7f51cc353929 "\004", m_tok_start = 0x7f51cc353929 "\004", m_tok_end = 0x7f51cc353929 "\004", m_end_of_query = 0x7f51cc353928 "", m_tok_start_prev = 0x7f51cc353928 "", m_buf = 0x7f51cc353768 "DELETE /* QNO 2201 CON_ID 23 */ FROM tmp WHERE LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/03.json') < '[167257741635259,false,null,224433559083125,true,null,true,true,3498391754186,false,true,2"..., m_buf_length = 448, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7f51cc353980 "DELETE /* QNO 2201 CON_ID 23 */ FROM tmp WHERE LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/03.json') < '[167257741635259,false,null,224433559083125,true,null,true,true,3498391754186,false,true,2"..., m_cpp_ptr = 0x7f51cc353b40 "", m_cpp_tok_start = 0x7f51cc353b40 "", m_cpp_tok_start_prev = 0x7f51cc353b40 "", m_cpp_tok_end = 0x7f51cc353b40 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x7f51cc506774 '\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 = 0x7f51cc353b3f "1", m_cpp_text_end = 0x7f51cc353b40 "", 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 = 0x7f51cc000dd8 do_end_of_statement = true __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)" __FUNCTION__ = "dispatch_command" error = false _db_stack_frame_ = {func = 0x55b391d92717 "do_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f5250136d20} drop_more_results = false #15 0x000055b391306404 in do_command (thd=0x7f51cc000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:1382 return_value = false packet = 0x7f51cc0088b0 "\003DELETE /* QNO 2201 CON_ID 23 */ FROM tmp WHERE LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/03.json') < '[167257741635259,false,null,224433559083125,true,null,true,true,3498391754186,false,true,"... packet_length = 449 net = 0x7f51cc000dd8 command = COM_QUERY __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #16 0x000055b39145fef6 in do_handle_one_connection (connect=0x55b394272580) at /home/elenst/src/10.2/sql/sql_connect.cc:1336 create_user = true thr_create_utime = 8347586120228 thd = 0x7f51cc000af0 #17 0x000055b39145fc41 in handle_one_connection (arg=0x55b394272580) at /home/elenst/src/10.2/sql/sql_connect.cc:1241 connect = 0x55b394272580 #18 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #19 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 36 (Thread 0x7f5223fff700 (LWP 229894)): #0 0x00007f52697b8965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391884c55 in os_event::wait (this=0x55b3938773c0) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:158 ret = 0 #2 0x000055b391884719 in os_event::wait_low (this=0x55b3938773c0, reset_sig_count=4189) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:325 No locals. #3 0x000055b391884a4d in os_event_wait_low (event=0x55b3938773c0, reset_sig_count=0) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:507 No locals. #4 0x000055b3919672db in srv_resume_thread (slot=0x55b3926dd6f8 , sig_count=0, wait=true, timeout_usec=0) at /home/elenst/src/10.2/storage/innobase/srv/srv0srv.cc:934 timeout = false __PRETTY_FUNCTION__ = "bool srv_resume_thread(srv_slot_t*, int64_t, bool, ulint)" #5 0x000055b39196afd3 in srv_worker_thread (arg=0x0) at /home/elenst/src/10.2/storage/innobase/srv/srv0srv.cc:2614 slot = 0x55b3926dd6f8 __PRETTY_FUNCTION__ = "void* srv_worker_thread(void*)" thd = 0x7f520c000af0 #6 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #7 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 35 (Thread 0x7f521b7fe700 (LWP 229903)): #0 0x00007f52697b8965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391884c55 in os_event::wait (this=0x55b3938776c0) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:158 ret = 0 #2 0x000055b391884719 in os_event::wait_low (this=0x55b3938776c0, reset_sig_count=1) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:325 No locals. #3 0x000055b391884a4d in os_event_wait_low (event=0x55b3938776c0, reset_sig_count=0) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:507 No locals. #4 0x000055b391a2b412 in buf_resize_thread () at /home/elenst/src/10.2/storage/innobase/buf/buf0buf.cc:3113 No locals. #5 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 34 (Thread 0x7f5250993700 (LWP 229924)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391cd78ae in safe_cond_timedwait (cond=0x7f51c80008c8, mp=0x7f51c8088260, abstime=0x7f5250990d10, file=0x55b392064b50 "/home/elenst/src/10.2/include/mysql/psi/mysql_thread.h", line=1193) at /home/elenst/src/10.2/mysys/thr_mutex.c:545 error = 21939 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 229924, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000$\202\003\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 229924, __nusers = 7, __kind = 3, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000$\202\003\000\a\000\000\000\003", '\000' , __align = 1}, file = 0x55b392064b88 "/home/elenst/src/10.2/mysys/thr_lock.c", name = 0x55b392064bb0 "lock->mutex", line = 762, count = 0, create_flags = 0, active_flags = 0, id = 8968, thread = 139991516264192, locked_mutex = 0x7f51c8148fb0, used_mutex = 0x7f51c8149018, prev = 0x0, next = 0x0} #2 0x000055b391cd3f09 in inline_mysql_cond_timedwait (that=0x7f51c80008c8, mutex=0x7f51c8088260, abstime=0x7f5250990d10, src_file=0x55b392064b88 "/home/elenst/src/10.2/mysys/thr_lock.c", src_line=575) at /home/elenst/src/10.2/include/mysql/psi/mysql_thread.h:1193 result = 0 #3 0x000055b391cd4584 in wait_for_lock (wait=0x7f51c8088330, data=0x7f51cc04cb38, in_wait_list=0 '\000', lock_wait_timeout=10) at /home/elenst/src/10.2/mysys/thr_lock.c:575 rc = 21939 thread_var = 0x7f51c80008c0 cond = 0x7f51c80008c8 wait_timeout = {tv_sec = 1618141028, tv_nsec = 69344000} result = THR_LOCK_ABORTED old_stage = {m_key = 0, m_name = 0x55b391d6e1a1 "Table lock", m_flags = -939514848} use_wait_callbacks = 1 '\001' __FUNCTION__ = "wait_for_lock" #4 0x000055b391cd50d2 in thr_lock (data=0x7f51cc04cb38, owner=0x7f51c8002420, lock_wait_timeout=10) at /home/elenst/src/10.2/mysys/thr_lock.c:1013 lock = 0x7f51c8088248 result = THR_LOCK_SUCCESS wait_queue = 0x7f51c8088330 lock_type = TL_WRITE wsrep_lock_inserted = 0 '\000' locker = 0x0 state = {m_flags = 1352207808, m_io_operation = 32594, m_table = 0x55b391cf1f52 , m_table_share = 0x7f51c8000a30, m_thread = 0x7f51c8000a10, m_timer_start = 94229735500936, m_timer = 0x158, m_wait = 0x7f5250990df0, m_index = 2434867115} #5 0x000055b391cd59bc in thr_multi_lock (data=0x7f51c8013c40, count=1, owner=0x7f51c8002420, lock_wait_timeout=10) at /home/elenst/src/10.2/mysys/thr_lock.c:1294 result = 21939 pos = 0x7f51c8013c40 end = 0x7f51c8013c48 first_lock = 0x55b3926a1b10 #6 0x000055b3916ac46d in mysql_lock_tables (thd=0x7f51c8000af0, sql_lock=0x7f51c8013c20, flags=0) at /home/elenst/src/10.2/sql/lock.cc:354 timeout = 10 org_stage = {m_key = 0, m_name = 0x0, m_flags = -939443128} __FUNCTION__ = "mysql_lock_tables" rc = 1 _db_stack_frame_ = {func = 0x55b391e96dc5 "mysql_lock_tables(tables)", file = 0x55b391e96c88 "/home/elenst/src/10.2/sql/lock.cc", level = 2147483657, line = -1, prev = 0x7f5250990f00} #7 0x000055b3916ac26e in mysql_lock_tables (thd=0x7f51c8000af0, tables=0x7f51c8013c18, count=1, flags=0) at /home/elenst/src/10.2/sql/lock.cc:303 sql_lock = 0x7f51c8013c20 gld_flags = 3 _db_stack_frame_ = {func = 0x55b391d81b28 "lock_tables", file = 0x55b391d80d48 "/home/elenst/src/10.2/sql/sql_base.cc", level = 2147483656, line = -1, prev = 0x7f5250990fa0} #8 0x000055b39129f1bb in lock_tables (thd=0x7f51c8000af0, tables=0x7f51c80133f0, count=1, flags=0) at /home/elenst/src/10.2/sql/sql_base.cc:5109 start = 0x7f51c8013c18 ptr = 0x7f51c8013c20 table = 0x0 _db_stack_frame_ = {func = 0x55b391d81a19 "open_and_lock_tables", file = 0x55b391d80d48 "/home/elenst/src/10.2/sql/sql_base.cc", level = 2147483655, line = -1, prev = 0x7f5250991030} __PRETTY_FUNCTION__ = "bool lock_tables(THD*, TABLE_LIST*, uint, uint)" res = false #9 0x000055b39129e964 in open_and_lock_tables (thd=0x7f51c8000af0, options=..., tables=0x7f51c80133f0, derived=true, flags=0, prelocking_strategy=0x7f5250991090) at /home/elenst/src/10.2/sql/sql_base.cc:4889 counter = 1 mdl_savepoint = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0} _db_stack_frame_ = {func = 0x55b391ea73c8 "mysql_delete", file = 0x55b391ea73a0 "/home/elenst/src/10.2/sql/sql_delete.cc", level = 2147483654, line = -1, prev = 0x7f52509911a0} #10 0x000055b3912650b3 in open_and_lock_tables (thd=0x7f51c8000af0, tables=0x7f51c80133f0, derived=true, flags=0) at /home/elenst/src/10.2/sql/sql_base.h:509 prelocking_strategy = { = {_vptr.Prelocking_strategy = 0x55b3925cdbf0 }, } #11 0x000055b391721455 in mysql_delete (thd=0x7f51c8000af0, table_list=0x7f51c80133f0, conds=0x0, order_list=0x7f51c8005088, limit=1, options=549755813888, result=0x0) at /home/elenst/src/10.2/sql/sql_delete.cc:252 file_sort = 0x0 safe_update = false explain = 0x1a __PRETTY_FUNCTION__ = "bool mysql_delete(THD*, TABLE_LIST*, COND*, SQL_I_List*, ha_rows, ulonglong, select_result*)" will_batch = false transactional_table = false const_cond_result = false return_error = false reverse = false query_type = THD::ROW_QUERY_TYPE select_lex = 0x7f51c8004e28 with_select = false query_plan = { = {_vptr.Update_plan = 0x55b39267fa90 , impossible_where = false, no_partitions = false, updating_a_view = 34, mem_root = 0x7f51c8005c68, table = 0x7f52509912c0, select = 0x1b, index = 64, scanned_rows = 94229739263557, select_lex = 0x7f5267e4f51f, possible_keys = {map = 4611686018427387904}, using_filesort = false, using_io_buffer = false}, deleting_all_rows = false} table = 0x55b390d21040 order = 0x0 _db_stack_frame_ = {func = 0x55b391d92e14 "mysql_execute_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7f5250991b40} loc_error = 32594 select = 0x0 info = {table = 0x0, forms = 0x0, unlock_row = 0x7f5250991270, read_record = 0x1000091ccffdd, thd = 0x7f5250991290, select = 0x55b391cf524e , cache_records = 1352209040, ref_length = 32594, struct_length = 3355445808, reclength = 32593, rec_cache_size = 3355445808, error_offset = 32593, index = 3355445776, ref_pos = 0x7f52509914d0 "0\n", record = 0x91cf4518
, rec_buf = 0x55b39205daaf "alloc_dynamic", cache = 0x0, cache_pos = 0x7f52509912d0 "\360\022\231PR\177", cache_end = 0x1000091ccffdd
, read_positions = 0x7f52509912f0 "0\025\231PR\177", addon_field = 0x55b391cf524e , io_cache = 0x7f52509912f0, print_error = 48, ignore_not_found_rows = 10, unpack = 0x7f51c8000a30, copy_field = 0x1c8000a10, copy_field_end = 0x7f5250991530} const_cond = false deleted = 0 __FUNCTION__ = "mysql_delete" error = 1774109008 using_limit = true killed_status = NOT_KILLED #12 0x000055b39130f0c1 in mysql_execute_command (thd=0x7f51c8000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:4426 sel_result = 0x0 save_protocol = 0x7f51c8000a30 replaced_protocol = false res = 0 lex = 0x7f51c8004628 _db_stack_frame_ = {func = 0x55b391d93c28 "mysql_parse", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f5250992330} __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" orig_binlog_format = BINLOG_FORMAT_MIXED up_result = 0 rpl_filter = 0x7f51c8000a10 orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT __FUNCTION__ = "mysql_execute_command" select_lex = 0x7f51c8004e28 first_table = 0x7f51c80133f0 all_tables = 0x7f51c80133f0 unit = 0x7f51c80046e8 have_table_map_for_update = false #13 0x000055b391319775 in mysql_parse (thd=0x7f51c8000af0, rawbuf=0x7f51c80132e8 "DELETE /* QNO 1259 CON_ID 22 */ FROM tmp LIMIT 1", length=48, parser_state=0x7f5250992520, is_com_multi=false, is_next_command=false) at /home/elenst/src/10.2/sql/sql_parse.cc:7794 found_semicolon = 0x0 lex = 0x7f51c8004628 err = false error = 32593 _db_stack_frame_ = {func = 0x55b391d92942 "dispatch_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f5250992500} __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)" __FUNCTION__ = "mysql_parse" #14 0x000055b391307a5e in dispatch_command (command=COM_QUERY, thd=0x7f51c8000af0, packet=0x7f51c80088b1 "DELETE /* QNO 1259 CON_ID 22 */ FROM tmp LIMIT 1", packet_length=48, is_com_multi=false, is_next_command=false) at /home/elenst/src/10.2/sql/sql_parse.cc:1828 packet_end = 0x7f51c8013318 "" parser_state = {m_input = {m_compute_digest = false}, m_lip = {m_thd = 0x7f51c8000af0, yylineno = 1, yylval = 0x7f5250991550, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7f51c8013319 "\004", m_tok_start = 0x7f51c8013319 "\004", m_tok_end = 0x7f51c8013319 "\004", m_end_of_query = 0x7f51c8013318 "", m_tok_start_prev = 0x7f51c8013318 "", m_buf = 0x7f51c80132e8 "DELETE /* QNO 1259 CON_ID 22 */ FROM tmp LIMIT 1", m_buf_length = 48, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7f51c8013370 "DELETE /* QNO 1259 CON_ID 22 */ FROM tmp LIMIT 1", m_cpp_ptr = 0x7f51c80133a0 "", m_cpp_tok_start = 0x7f51c80133a0 "", m_cpp_tok_start_prev = 0x7f51c80133a0 "", m_cpp_tok_end = 0x7f51c80133a0 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x7f51c80a94b0 '\245' ..., 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 = 0x7f51c801339f "1", m_cpp_text_end = 0x7f51c80133a0 "", 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 = 0x7f51c8000dd8 do_end_of_statement = true __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)" __FUNCTION__ = "dispatch_command" error = false _db_stack_frame_ = {func = 0x55b391d92717 "do_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f5250992d20} drop_more_results = false #15 0x000055b391306404 in do_command (thd=0x7f51c8000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:1382 return_value = false packet = 0x7f51c80088b0 "\003DELETE /* QNO 1259 CON_ID 22 */ FROM tmp LIMIT 1" packet_length = 49 net = 0x7f51c8000dd8 command = COM_QUERY __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #16 0x000055b39145fef6 in do_handle_one_connection (connect=0x55b3941b7720) at /home/elenst/src/10.2/sql/sql_connect.cc:1336 create_user = true thr_create_utime = 8347586016271 thd = 0x7f51c8000af0 #17 0x000055b39145fc41 in handle_one_connection (arg=0x55b3941b7720) at /home/elenst/src/10.2/sql/sql_connect.cc:1241 connect = 0x55b3941b7720 #18 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #19 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 33 (Thread 0x7f5234ff9700 (LWP 229893)): #0 0x00007f52697b8965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391884c55 in os_event::wait (this=0x55b393877340) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:158 ret = 0 #2 0x000055b391884719 in os_event::wait_low (this=0x55b393877340, reset_sig_count=4480) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:325 No locals. #3 0x000055b391884a4d in os_event_wait_low (event=0x55b393877340, reset_sig_count=0) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:507 No locals. #4 0x000055b3919672db in srv_resume_thread (slot=0x55b3926dd6c0 , sig_count=0, wait=true, timeout_usec=0) at /home/elenst/src/10.2/storage/innobase/srv/srv0srv.cc:934 timeout = false __PRETTY_FUNCTION__ = "bool srv_resume_thread(srv_slot_t*, int64_t, bool, ulint)" #5 0x000055b39196afd3 in srv_worker_thread (arg=0x0) at /home/elenst/src/10.2/storage/innobase/srv/srv0srv.cc:2614 slot = 0x55b3926dd6c0 __PRETTY_FUNCTION__ = "void* srv_worker_thread(void*)" thd = 0x7f521c000af0 #6 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #7 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 32 (Thread 0x7f523d215700 (LWP 229884)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b3918845ae in os_event::timed_wait (this=0x55b393877640, abstime=0x7f523d214b00) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:275 ret = 5 #2 0x000055b391884857 in os_event::wait_time_low (this=0x55b393877640, time_in_usec=762000, reset_sig_count=121) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:385 timed_out = false abstime = {tv_sec = 1618141020, tv_nsec = 427900000} #3 0x000055b391884a28 in os_event_wait_time_low (event=0x55b393877640, time_in_usec=762000, reset_sig_count=121) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:490 No locals. #4 0x000055b391a4a4ef in pc_sleep_if_needed (next_loop_time=8347677372, sig_count=121, cur_time=8347676610) at /home/elenst/src/10.2/storage/innobase/buf/buf0flu.cc:2683 sleep_us = 762000 #5 0x000055b391a4b350 in buf_flush_page_cleaner_coordinator () at /home/elenst/src/10.2/storage/innobase/buf/buf0flu.cc:3149 curr_time = 8347676610 __PRETTY_FUNCTION__ = "void* buf_flush_page_cleaner_coordinator(void*)" n_flushed_last = 48 warn_count = 0 sig_count = 121 next_loop_time = 8347677372 n_flushed = 0 ret_sleep = 0 warn_interval = 1 last_pages = 28 n_evicted = 0 last_activity = 6214 success = false #6 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #7 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 31 (Thread 0x7f5221ffb700 (LWP 229899)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b3918845ae in os_event::timed_wait (this=0x55b3941b3df0, abstime=0x7f5221ffac70) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:275 ret = 110 #2 0x000055b391884857 in os_event::wait_time_low (this=0x55b3941b3df0, time_in_usec=1000000, reset_sig_count=265603) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:385 timed_out = false abstime = {tv_sec = 1618141020, tv_nsec = 427717000} #3 0x000055b391884a28 in os_event_wait_time_low (event=0x55b3941b3df0, time_in_usec=1000000, reset_sig_count=0) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:490 No locals. #4 0x000055b391ac18b7 in fil_crypt_thread () at /home/elenst/src/10.2/storage/innobase/fil/fil0crypt.cc:2203 waited = 92 new_state = {key_id = 0, key_version = 0, rotate_key_age = 1} wait_start = 1618140927 thread_no = 0 thr = {thread_no = 0, first = false, space = 0x0, offset = 0, batch = 0, min_key_version_found = 0, end_lsn = 0, estimated_max_iops = 20, allocated_iops = 0, cnt_waited = 0, sum_waited_us = 0, crypt_stat = {pages_read_from_cache = 0, pages_read_from_disk = 0, pages_modified = 0, pages_flushed = 0, estimated_iops = 20}, scrub_data = {space = 55, scrubbing = false, compressed = false, current_table = 0x0, current_index = 0x0, savepoint = 0, scrub_stat = {page_reorganizations = 0, page_splits = 0, page_split_failures_underflow = 0, page_split_failures_out_of_filespace = 0, page_split_failures_missing_index = 0, page_split_failures_unknown = 0}}} recheck = false #5 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 30 (Thread 0x7f5235ffb700 (LWP 229891)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b3918845ae in os_event::timed_wait (this=0x55b3941b2a90, abstime=0x7f5235ffab70) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:275 ret = 110 #2 0x000055b391884857 in os_event::wait_time_low (this=0x55b3941b2a90, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:385 timed_out = false abstime = {tv_sec = 1618141021, tv_nsec = 670476000} #3 0x000055b391884a28 in os_event_wait_time_low (event=0x55b3941b2a90, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:490 No locals. #4 0x000055b3919ce6bf in ib_wqueue_timedwait (wq=0x55b3941b2950, wait_in_usecs=5000000) at /home/elenst/src/10.2/storage/innobase/ut/ut0wqueue.cc:156 error = 72057594037927937 sig_count = 1 node = 0x0 #5 0x000055b391af8cb9 in fts_optimize_thread (arg=0x55b3941b2950) at /home/elenst/src/10.2/storage/innobase/fts/fts0opt.cc:2829 msg = 0x0 current = 0 done = 0 n_tables = 0 n_optimize = 0 wq = 0x55b3941b2950 __PRETTY_FUNCTION__ = "void* fts_optimize_thread(void*)" #6 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #7 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 29 (Thread 0x7f5269bd2880 (LWP 229871)): #0 0x00007f5267b6620d in poll () from /lib64/libc.so.6 No symbol table info available. #1 0x000055b39121cf63 in handle_connections_sockets () at /home/elenst/src/10.2/sql/mysqld.cc:6724 cAddr = {ss_family = 10, __ss_padding = "\207r", '\000' , "\377\377\177\000\000\001\000\000\000\000\263U\000\000\002\000\000\200.\002\000\000\022/\000\000)\030\000\000\340g֑\263U\000\000\300\026\212\222\263U\000\000\360\310\374\310\377\177\000\000P\350#\221\000\000\000\000\340g֑\263U\000\000\022/\000\000\000\000\000\000 \311\374\310\377\177\000\000\002\t!\221\263U\000\000\340g֑\263U\000", __ss_align = 6187} flags = 2 retval = 1 fds = {{fd = 22, events = 1, revents = 0}, {fd = 23, events = 1, revents = 0}, {fd = -922957760, events = 32767, revents = 0}} _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} sock = {fd = 22, m_psi = 0x0} new_sock = {fd = 24, m_psi = 0x0} error_count = 0 socket_flags = 2 ip_flags = 2 extra_ip_flags = 0 socket_count = 2 pfs_fds = {{fd = 22, m_psi = 0x0}, {fd = 23, m_psi = 0x0}, {fd = -922957680, m_psi = 0x55b391cd6926 }} #2 0x000055b39121c25b in mysqld_main (argc=31, argv=0x55b393719908) at /home/elenst/src/10.2/sql/mysqld.cc:6192 please_close_stdin = true ho_error = 0 new_thread_stack_size = 299008 #3 0x000055b3912105e5 in main (argc=31, argv=0x7fffc8fccb08) at /home/elenst/src/10.2/sql/main.cc:25 No locals. Thread 28 (Thread 0x7f52227fc700 (LWP 229898)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b3918845ae in os_event::timed_wait (this=0x55b3941b3df0, abstime=0x7f52227fbc70) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:275 ret = 110 #2 0x000055b391884857 in os_event::wait_time_low (this=0x55b3941b3df0, time_in_usec=1000000, reset_sig_count=265603) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:385 timed_out = false abstime = {tv_sec = 1618141020, tv_nsec = 428325000} #3 0x000055b391884a28 in os_event_wait_time_low (event=0x55b3941b3df0, time_in_usec=1000000, reset_sig_count=0) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:490 No locals. #4 0x000055b391ac18b7 in fil_crypt_thread () at /home/elenst/src/10.2/storage/innobase/fil/fil0crypt.cc:2203 waited = 92 new_state = {key_id = 0, key_version = 0, rotate_key_age = 1} wait_start = 1618140927 thread_no = 2 thr = {thread_no = 2, first = false, space = 0x0, offset = 0, batch = 0, min_key_version_found = 0, end_lsn = 0, estimated_max_iops = 20, allocated_iops = 0, cnt_waited = 0, sum_waited_us = 0, crypt_stat = {pages_read_from_cache = 0, pages_read_from_disk = 0, pages_modified = 0, pages_flushed = 0, estimated_iops = 20}, scrub_data = {space = 55, scrubbing = false, compressed = false, current_table = 0x0, current_index = 0x0, savepoint = 0, scrub_stat = {page_reorganizations = 0, page_splits = 0, page_split_failures_underflow = 0, page_split_failures_out_of_filespace = 0, page_split_failures_missing_index = 0, page_split_failures_unknown = 0}}} recheck = false #5 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 27 (Thread 0x7f5250b0a700 (LWP 229907)): #0 0x00007f52697b8965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391cd75ac in safe_cond_wait (cond=0x55b3928a61c0 , mp=0x55b3928a6100 , file=0x55b391d91a40 "/home/elenst/src/10.2/include/mysql/psi/mysql_thread.h", line=1156) at /home/elenst/src/10.2/mysys/thr_mutex.c:491 error = 32593 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 229907, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\023\202\003\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 229907, __nusers = 1, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\023\202\003\000\001", '\000' , __align = 1}, file = 0x55b391d91a78 "/home/elenst/src/10.2/sql/sql_manager.cc", name = 0x55b391d91adc "LOCK_manager", line = 116, count = 0, create_flags = 0, active_flags = 0, id = 134, thread = 139991517800192, locked_mutex = 0x55b39422ab00, used_mutex = 0x55b39422ab68, prev = 0x0, next = 0x0} #2 0x000055b3913027d4 in inline_mysql_cond_wait (that=0x55b3928a61c0 , mutex=0x55b3928a6100 , src_file=0x55b391d91a78 "/home/elenst/src/10.2/sql/sql_manager.cc", src_line=102) at /home/elenst/src/10.2/include/mysql/psi/mysql_thread.h:1156 result = 21939 #3 0x000055b391302bf7 in handle_manager (arg=0x0) at /home/elenst/src/10.2/sql/sql_manager.cc:102 cb = 0x0 error = 0 abstime = {tv_sec = 0, tv_nsec = 0} reset_flush_time = true _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #4 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 26 (Thread 0x7f521affd700 (LWP 229904)): #0 0x00007f52697b8965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391cd75ac in safe_cond_wait (cond=0x7f521affccc0, mp=0x7f521affcd00, file=0x55b391ed0bc0 "/home/elenst/src/10.2/include/mysql/psi/mysql_thread.h", line=1156) at /home/elenst/src/10.2/mysys/thr_mutex.c:491 error = 32593 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 229904, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\020\202\003\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 229904, __nusers = 1, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\020\202\003\000\001", '\000' , __align = 1}, file = 0x55b391ed24a0 "/home/elenst/src/10.2/storage/innobase/handler/ha_innodb.cc", name = 0x55b391ed24dd "thd_destructor_mutex", line = 341, count = 0, create_flags = 0, active_flags = 0, id = 38, thread = 139990617020160, locked_mutex = 0x7f51f80088b0, used_mutex = 0x7f51f8008918, prev = 0x0, next = 0x0} #2 0x000055b3917b7433 in inline_mysql_cond_wait (that=0x7f521affccc0, mutex=0x7f521affcd00, src_file=0x55b391ed24a0 "/home/elenst/src/10.2/storage/innobase/handler/ha_innodb.cc", src_line=347) at /home/elenst/src/10.2/include/mysql/psi/mysql_thread.h:1156 result = 21939 #3 0x000055b3917bb72d in thd_destructor_proxy () at /home/elenst/src/10.2/storage/innobase/handler/ha_innodb.cc:347 thd_destructor_mutex = {m_mutex = {global = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' , "\002", '\000' , __align = 0}, mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 1, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' , "\001", '\000' , __align = 0}, file = 0x55b391ed24a0 "/home/elenst/src/10.2/storage/innobase/handler/ha_innodb.cc", name = 0x55b391ed24dd "thd_destructor_mutex", line = 341, count = 0, create_flags = 0, active_flags = 0, id = 38, thread = 139990617020160, locked_mutex = 0x7f51f80088b0, used_mutex = 0x7f51f8008918, prev = 0x0, next = 0x0}, m_psi = 0x0} thd_destructor_cond = {m_cond = {__data = {__lock = 0, __futex = 1, __total_seq = 1, __wakeup_seq = 0, __woken_seq = 0, __mutex = 0x7f521affcd28, __nwaiters = 2, __broadcast_seq = 0}, __size = "\000\000\000\000\001\000\000\000\001", '\000' , "(\315\377\032R\177\000\000\002\000\000\000\000\000\000", __align = 4294967296}, m_psi = 0x0} myvar = 0x7f51f80008c0 __FUNCTION__ = "thd_destructor_proxy" thd = 0x7f51f8000af0 #4 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 25 (Thread 0x7f523c80f700 (LWP 229889)): #0 0x00007f52697bbe3d in nanosleep () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391884f94 in os_thread_sleep (tm=1000000) at /home/elenst/src/10.2/storage/innobase/os/os0thread.cc:231 t = {tv_sec = 1, tv_nsec = 0} #2 0x000055b39196a8db in srv_master_sleep () at /home/elenst/src/10.2/storage/innobase/srv/srv0srv.cc:2416 No locals. #3 0x000055b39196a9fb in srv_master_thread (arg=0x0) at /home/elenst/src/10.2/storage/innobase/srv/srv0srv.cc:2456 _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} slot = 0x55b3926dd650 old_activity_count = 6184 __PRETTY_FUNCTION__ = "void* srv_master_thread(void*)" #4 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 24 (Thread 0x7f5222ffd700 (LWP 229897)): #0 0x00007f52697b8965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391884c55 in os_event::wait (this=0x55b3938775c0) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:158 ret = 0 #2 0x000055b391884719 in os_event::wait_low (this=0x55b3938775c0, reset_sig_count=1) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:325 No locals. #3 0x000055b391884a4d in os_event_wait_low (event=0x55b3938775c0, reset_sig_count=0) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:507 No locals. #4 0x000055b391a41395 in buf_dump_thread () at /home/elenst/src/10.2/storage/innobase/buf/buf0dump.cc:806 __PRETTY_FUNCTION__ = "void* buf_dump_thread(void*)" #5 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 23 (Thread 0x7f5269a41700 (LWP 229905)): #0 0x00007f52697b8965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391cd75ac in safe_cond_wait (cond=0x55b3928ccfe8 , mp=0x55b3928ccf38 , file=0x55b391e905e0 "/home/elenst/src/10.2/include/mysql/psi/mysql_thread.h", line=1156) at /home/elenst/src/10.2/mysys/thr_mutex.c:491 error = 32593 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 229905, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\021\202\003\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 229905, __nusers = 1, __kind = 3, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\021\202\003\000\001\000\000\000\003", '\000' , __align = 1}, file = 0x55b391e90b78 "/home/elenst/src/10.2/sql/log.cc", name = 0x55b391e91c01 "LOCK_binlog_background_thread", line = 9894, count = 0, create_flags = 0, active_flags = 0, id = 41, thread = 139991936407296, locked_mutex = 0x55b3941bfeb0, used_mutex = 0x55b3941bff18, prev = 0x0, next = 0x0} #2 0x000055b39168ebb7 in inline_mysql_cond_wait (that=0x55b3928ccfe8 , mutex=0x55b3928ccf38 , src_file=0x55b391e90b78 "/home/elenst/src/10.2/sql/log.cc", src_line=9909) at /home/elenst/src/10.2/include/mysql/psi/mysql_thread.h:1156 result = 21939 #3 0x000055b3916a8607 in binlog_background_thread (arg=0x0) at /home/elenst/src/10.2/sql/log.cc:9909 stop = false queue = 0x0 __FUNCTION__ = "binlog_background_thread" __PRETTY_FUNCTION__ = "void* binlog_background_thread(void*)" next = 0x0 thd = 0x7f51fc000af0 _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #4 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 22 (Thread 0x7f52237fe700 (LWP 229895)): #0 0x00007f52697b8965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391884c55 in os_event::wait (this=0x55b393877440) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:158 ret = 0 #2 0x000055b391884719 in os_event::wait_low (this=0x55b393877440, reset_sig_count=3931) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:325 No locals. #3 0x000055b391884a4d in os_event_wait_low (event=0x55b393877440, reset_sig_count=0) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:507 No locals. #4 0x000055b3919672db in srv_resume_thread (slot=0x55b3926dd730 , sig_count=0, wait=true, timeout_usec=0) at /home/elenst/src/10.2/storage/innobase/srv/srv0srv.cc:934 timeout = false __PRETTY_FUNCTION__ = "bool srv_resume_thread(srv_slot_t*, int64_t, bool, ulint)" #5 0x000055b39196afd3 in srv_worker_thread (arg=0x0) at /home/elenst/src/10.2/storage/innobase/srv/srv0srv.cc:2614 slot = 0x55b3926dd730 __PRETTY_FUNCTION__ = "void* srv_worker_thread(void*)" thd = 0x7f5214000af0 #6 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #7 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 21 (Thread 0x7f52357fa700 (LWP 229892)): #0 0x00007f52697b8965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391884c55 in os_event::wait (this=0x55b3938772c0) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:158 ret = 0 #2 0x000055b391884719 in os_event::wait_low (this=0x55b3938772c0, reset_sig_count=2427) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:325 No locals. #3 0x000055b391884a4d in os_event_wait_low (event=0x55b3938772c0, reset_sig_count=2427) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:507 No locals. #4 0x000055b3919672db in srv_resume_thread (slot=0x55b3926dd688 , sig_count=2427, wait=true, timeout_usec=0) at /home/elenst/src/10.2/storage/innobase/srv/srv0srv.cc:934 timeout = false __PRETTY_FUNCTION__ = "bool srv_resume_thread(srv_slot_t*, int64_t, bool, ulint)" #5 0x000055b39196b49a in srv_purge_coordinator_suspend (slot=0x55b3926dd688 , rseg_history_len=44) at /home/elenst/src/10.2/storage/innobase/srv/srv0srv.cc:2775 wait = true timeout = true __PRETTY_FUNCTION__ = "void srv_purge_coordinator_suspend(srv_slot_t*, ulint)" stop = true SRV_PURGE_MAX_TIMEOUT = 10000 sig_count = 2427 #6 0x000055b39196b837 in srv_purge_coordinator_thread (arg=0x0) at /home/elenst/src/10.2/storage/innobase/srv/srv0srv.cc:2862 slot = 0x55b3926dd688 __PRETTY_FUNCTION__ = "void* srv_purge_coordinator_thread(void*)" rseg_history_len = 44 thd = 0x7f5228001d40 n_total_purged = 0 #7 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #8 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 20 (Thread 0x7f52367fc700 (LWP 229890)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b3918845ae in os_event::timed_wait (this=0x55b3944cc590, abstime=0x7f52367fbd70) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:275 ret = -1148532655 #2 0x000055b391884857 in os_event::wait_time_low (this=0x55b3944cc590, time_in_usec=10000000, reset_sig_count=50) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:385 timed_out = false abstime = {tv_sec = 1618141027, tv_nsec = 925717000} #3 0x000055b391884a28 in os_event_wait_time_low (event=0x55b3944cc590, time_in_usec=10000000, reset_sig_count=0) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:490 No locals. #4 0x000055b391aa1b93 in dict_stats_thread () at /home/elenst/src/10.2/storage/innobase/dict/dict0stats_bg.cc:475 No locals. #5 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 19 (Thread 0x7f523e217700 (LWP 229882)): #0 0x00007f5269385644 in __io_getevents_0_4 () from /lib64/libaio.so.1 No symbol table info available. #1 0x000055b391876e31 in LinuxAIOHandler::collect (this=0x7f523e216b10) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:1936 events = 0x55b39392efc0 timeout = {tv_sec = 0, tv_nsec = 500000000} ret = -1853338284 __PRETTY_FUNCTION__ = "void LinuxAIOHandler::collect()" io_ctx = 0x7f5269a45000 start_pos = 512 end_pos = 768 #2 0x000055b391877429 in LinuxAIOHandler::poll (this=0x7f523e216b10, m1=0x7f523e216bb0, m2=0x7f523e216bb8, request=0x7f523e216be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2097 n_pending = 0 err = DB_SUCCESS slot = 0x0 __PRETTY_FUNCTION__ = "dberr_t LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*)" #3 0x000055b39187758c in os_aio_linux_handler (global_segment=8, m1=0x7f523e216bb0, m2=0x7f523e216bb8, request=0x7f523e216be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2151 No locals. #4 0x000055b39187c245 in os_aio_handler (segment=8, m1=0x7f523e216bb0, m2=0x7f523e216bb8, request=0x7f523e216be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:5785 err = 32594 #5 0x000055b391ab8627 in fil_aio_wait (segment=8) at /home/elenst/src/10.2/storage/innobase/fil/fil0fil.cc:5141 node = 0x55b3944c38f0 type = {m_bpage = 0x0, m_fil_node = 0x0, m_type = 1} message = 0x7f5243a75bd0 __PRETTY_FUNCTION__ = "void fil_aio_wait(ulint)" err = DB_SUCCESS space_id = 0 dblwr = true purpose = FIL_TYPE_TABLESPACE #6 0x000055b39196dc03 in io_handler_thread (arg=0x55b39291af60 ) at /home/elenst/src/10.2/storage/innobase/srv/srv0start.cc:332 segment = 8 start = 2 __PRETTY_FUNCTION__ = "void* io_handler_thread(void*)" #7 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #8 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 18 (Thread 0x7f52377fe700 (LWP 229887)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b3918845ae in os_event::timed_wait (this=0x55b3938774c0, abstime=0x7f52377fdbb0) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:275 ret = 0 #2 0x000055b391884857 in os_event::wait_time_low (this=0x55b3938774c0, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:385 timed_out = false abstime = {tv_sec = 1618141020, tv_nsec = 657695000} #3 0x000055b391884a28 in os_event_wait_time_low (event=0x55b3938774c0, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:490 No locals. #4 0x000055b3919694b5 in srv_error_monitor_thread () at /home/elenst/src/10.2/storage/innobase/srv/srv0srv.cc:1909 old_lsn = 307379257 sig_count = 1 waiter = 139991095174912 old_waiter = 139991095174912 sema = 0x0 old_sema = 0x0 __PRETTY_FUNCTION__ = "void* srv_error_monitor_thread(void*)" fatal_cnt = 0 new_lsn = 307379257 #5 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 17 (Thread 0x7f523fa1a700 (LWP 229879)): #0 0x00007f5269385644 in __io_getevents_0_4 () from /lib64/libaio.so.1 No symbol table info available. #1 0x000055b391876e31 in LinuxAIOHandler::collect (this=0x7f523fa19b10) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:1936 events = 0x55b3938d0760 timeout = {tv_sec = 0, tv_nsec = 500000000} ret = 0 __PRETTY_FUNCTION__ = "void LinuxAIOHandler::collect()" io_ctx = 0x7f5269a54000 start_pos = 768 end_pos = 1024 #2 0x000055b391877429 in LinuxAIOHandler::poll (this=0x7f523fa19b10, m1=0x7f523fa19bb0, m2=0x7f523fa19bb8, request=0x7f523fa19be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2097 n_pending = 0 err = DB_SUCCESS slot = 0x0 __PRETTY_FUNCTION__ = "dberr_t LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*)" #3 0x000055b39187758c in os_aio_linux_handler (global_segment=5, m1=0x7f523fa19bb0, m2=0x7f523fa19bb8, request=0x7f523fa19be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2151 No locals. #4 0x000055b39187c245 in os_aio_handler (segment=5, m1=0x7f523fa19bb0, m2=0x7f523fa19bb8, request=0x7f523fa19be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:5785 err = 32594 #5 0x000055b391ab8627 in fil_aio_wait (segment=5) at /home/elenst/src/10.2/storage/innobase/fil/fil0fil.cc:5141 node = 0x0 type = {m_bpage = 0x0, m_fil_node = 0x0, m_type = 1} message = 0x0 __PRETTY_FUNCTION__ = "void fil_aio_wait(ulint)" err = DB_SUCCESS space_id = 0 dblwr = false purpose = FIL_TYPE_TEMPORARY #6 0x000055b39196dc03 in io_handler_thread (arg=0x55b39291af48 ) at /home/elenst/src/10.2/storage/innobase/srv/srv0start.cc:332 segment = 5 start = 2 __PRETTY_FUNCTION__ = "void* io_handler_thread(void*)" #7 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #8 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 16 (Thread 0x7f5236ffd700 (LWP 229888)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b3918845ae in os_event::timed_wait (this=0x55b393877540, abstime=0x7f5236ffcd30) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:275 ret = 110 #2 0x000055b391884857 in os_event::wait_time_low (this=0x55b393877540, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:385 timed_out = false abstime = {tv_sec = 1618141021, tv_nsec = 641643000} #3 0x000055b391884a28 in os_event_wait_time_low (event=0x55b393877540, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:490 No locals. #4 0x000055b391968fa3 in srv_monitor_thread () at /home/elenst/src/10.2/storage/innobase/srv/srv0srv.cc:1745 sig_count = 1 time_elapsed = 15 last_monitor_time = 1618141001 __PRETTY_FUNCTION__ = "void* srv_monitor_thread(void*)" current_time = 1618141016 mutex_skipped = 0 last_srv_print_monitor = 0 #5 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 15 (Thread 0x7f5237fff700 (LWP 229886)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b3918845ae in os_event::timed_wait (this=0x55b3943ad860, abstime=0x7f5237ffed50) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:275 ret = 110 #2 0x000055b391884857 in os_event::wait_time_low (this=0x55b3943ad860, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:385 timed_out = false abstime = {tv_sec = 1618141020, tv_nsec = 657567000} #3 0x000055b391884a28 in os_event_wait_time_low (event=0x55b3943ad860, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/src/10.2/storage/innobase/os/os0event.cc:490 No locals. #4 0x000055b391851176 in lock_wait_timeout_thread () at /home/elenst/src/10.2/storage/innobase/lock/lock0wait.cc:525 slot = 0x55b3943906e0 sig_count = 1 event = 0x55b3943ad860 __PRETTY_FUNCTION__ = "void* lock_wait_timeout_thread(void*)" #5 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 14 (Thread 0x7f523da16700 (LWP 229883)): #0 0x00007f5269385644 in __io_getevents_0_4 () from /lib64/libaio.so.1 No symbol table info available. #1 0x000055b391876e31 in LinuxAIOHandler::collect (this=0x7f523da15b10) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:1936 events = 0x55b393930fc0 timeout = {tv_sec = 0, tv_nsec = 500000000} ret = -1853338284 __PRETTY_FUNCTION__ = "void LinuxAIOHandler::collect()" io_ctx = 0x7f5269a42000 start_pos = 768 end_pos = 1024 #2 0x000055b391877429 in LinuxAIOHandler::poll (this=0x7f523da15b10, m1=0x7f523da15bb0, m2=0x7f523da15bb8, request=0x7f523da15be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2097 n_pending = 0 err = DB_SUCCESS slot = 0x0 __PRETTY_FUNCTION__ = "dberr_t LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*)" #3 0x000055b39187758c in os_aio_linux_handler (global_segment=9, m1=0x7f523da15bb0, m2=0x7f523da15bb8, request=0x7f523da15be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2151 No locals. #4 0x000055b39187c245 in os_aio_handler (segment=9, m1=0x7f523da15bb0, m2=0x7f523da15bb8, request=0x7f523da15be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:5785 err = 32594 #5 0x000055b391ab8627 in fil_aio_wait (segment=9) at /home/elenst/src/10.2/storage/innobase/fil/fil0fil.cc:5141 node = 0x55b3944c38f0 type = {m_bpage = 0x0, m_fil_node = 0x0, m_type = 1} message = 0x7f5243a27b60 __PRETTY_FUNCTION__ = "void fil_aio_wait(ulint)" err = DB_SUCCESS space_id = 0 dblwr = true purpose = FIL_TYPE_TABLESPACE #6 0x000055b39196dc03 in io_handler_thread (arg=0x55b39291af68 ) at /home/elenst/src/10.2/storage/innobase/srv/srv0start.cc:332 segment = 9 start = 2 __PRETTY_FUNCTION__ = "void* io_handler_thread(void*)" #7 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #8 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 13 (Thread 0x7f523ea18700 (LWP 229881)): #0 0x00007f5269385644 in __io_getevents_0_4 () from /lib64/libaio.so.1 No symbol table info available. #1 0x000055b391876e31 in LinuxAIOHandler::collect (this=0x7f523ea17b10) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:1936 events = 0x55b39392cfc0 timeout = {tv_sec = 0, tv_nsec = 500000000} ret = -1853338284 __PRETTY_FUNCTION__ = "void LinuxAIOHandler::collect()" io_ctx = 0x7f5269a48000 start_pos = 256 end_pos = 512 #2 0x000055b391877429 in LinuxAIOHandler::poll (this=0x7f523ea17b10, m1=0x7f523ea17bb0, m2=0x7f523ea17bb8, request=0x7f523ea17be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2097 n_pending = 0 err = DB_SUCCESS slot = 0x0 __PRETTY_FUNCTION__ = "dberr_t LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*)" #3 0x000055b39187758c in os_aio_linux_handler (global_segment=7, m1=0x7f523ea17bb0, m2=0x7f523ea17bb8, request=0x7f523ea17be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2151 No locals. #4 0x000055b39187c245 in os_aio_handler (segment=7, m1=0x7f523ea17bb0, m2=0x7f523ea17bb8, request=0x7f523ea17be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:5785 err = 32594 #5 0x000055b391ab8627 in fil_aio_wait (segment=7) at /home/elenst/src/10.2/storage/innobase/fil/fil0fil.cc:5141 node = 0x55b3944c38f0 type = {m_bpage = 0x0, m_fil_node = 0x0, m_type = 1} message = 0x7f5243a89040 __PRETTY_FUNCTION__ = "void fil_aio_wait(ulint)" err = DB_SUCCESS space_id = 0 dblwr = true purpose = FIL_TYPE_TABLESPACE #6 0x000055b39196dc03 in io_handler_thread (arg=0x55b39291af58 ) at /home/elenst/src/10.2/storage/innobase/srv/srv0start.cc:332 segment = 7 start = 2 __PRETTY_FUNCTION__ = "void* io_handler_thread(void*)" #7 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #8 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 12 (Thread 0x7f524021b700 (LWP 229878)): #0 0x00007f5269385644 in __io_getevents_0_4 () from /lib64/libaio.so.1 No symbol table info available. #1 0x000055b391876e31 in LinuxAIOHandler::collect (this=0x7f524021ab10) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:1936 events = 0x55b3938ce760 timeout = {tv_sec = 0, tv_nsec = 500000000} ret = 0 __PRETTY_FUNCTION__ = "void LinuxAIOHandler::collect()" io_ctx = 0x7f5269be0000 start_pos = 512 end_pos = 768 #2 0x000055b391877429 in LinuxAIOHandler::poll (this=0x7f524021ab10, m1=0x7f524021abb0, m2=0x7f524021abb8, request=0x7f524021abe0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2097 n_pending = 0 err = DB_SUCCESS slot = 0x0 __PRETTY_FUNCTION__ = "dberr_t LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*)" #3 0x000055b39187758c in os_aio_linux_handler (global_segment=4, m1=0x7f524021abb0, m2=0x7f524021abb8, request=0x7f524021abe0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2151 No locals. #4 0x000055b39187c245 in os_aio_handler (segment=4, m1=0x7f524021abb0, m2=0x7f524021abb8, request=0x7f524021abe0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:5785 err = 32594 #5 0x000055b391ab8627 in fil_aio_wait (segment=4) at /home/elenst/src/10.2/storage/innobase/fil/fil0fil.cc:5141 node = 0x0 type = {m_bpage = 0x0, m_fil_node = 0x0, m_type = 1} message = 0x0 __PRETTY_FUNCTION__ = "void fil_aio_wait(ulint)" err = DB_SUCCESS space_id = 0 dblwr = false purpose = FIL_TYPE_TEMPORARY #6 0x000055b39196dc03 in io_handler_thread (arg=0x55b39291af40 ) at /home/elenst/src/10.2/storage/innobase/srv/srv0start.cc:332 segment = 4 start = 2 __PRETTY_FUNCTION__ = "void* io_handler_thread(void*)" #7 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #8 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 11 (Thread 0x7f5250938700 (LWP 229874)): #0 0x00007f5269385644 in __io_getevents_0_4 () from /lib64/libaio.so.1 No symbol table info available. #1 0x000055b391876e31 in LinuxAIOHandler::collect (this=0x7f5250937b10) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:1936 events = 0x55b3938e0a00 timeout = {tv_sec = 0, tv_nsec = 500000000} ret = 0 __PRETTY_FUNCTION__ = "void LinuxAIOHandler::collect()" io_ctx = 0x7f5269a51000 start_pos = 0 end_pos = 256 #2 0x000055b391877429 in LinuxAIOHandler::poll (this=0x7f5250937b10, m1=0x7f5250937bb0, m2=0x7f5250937bb8, request=0x7f5250937be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2097 n_pending = 0 err = DB_SUCCESS slot = 0x0 __PRETTY_FUNCTION__ = "dberr_t LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*)" #3 0x000055b39187758c in os_aio_linux_handler (global_segment=0, m1=0x7f5250937bb0, m2=0x7f5250937bb8, request=0x7f5250937be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2151 No locals. #4 0x000055b39187c245 in os_aio_handler (segment=0, m1=0x7f5250937bb0, m2=0x7f5250937bb8, request=0x7f5250937be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:5785 err = 32594 #5 0x000055b391ab8627 in fil_aio_wait (segment=0) at /home/elenst/src/10.2/storage/innobase/fil/fil0fil.cc:5141 node = 0x0 type = {m_bpage = 0x0, m_fil_node = 0x0, m_type = 1} message = 0x0 __PRETTY_FUNCTION__ = "void fil_aio_wait(ulint)" err = DB_SUCCESS space_id = 0 dblwr = false purpose = FIL_TYPE_TEMPORARY #6 0x000055b39196dc03 in io_handler_thread (arg=0x55b39291af20 ) at /home/elenst/src/10.2/storage/innobase/srv/srv0start.cc:332 segment = 0 start = 2 __PRETTY_FUNCTION__ = "void* io_handler_thread(void*)" #7 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #8 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 10 (Thread 0x7f524121d700 (LWP 229876)): #0 0x00007f5269385644 in __io_getevents_0_4 () from /lib64/libaio.so.1 No symbol table info available. #1 0x000055b391876e31 in LinuxAIOHandler::collect (this=0x7f524121cb10) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:1936 events = 0x55b3938ca760 timeout = {tv_sec = 0, tv_nsec = 500000000} ret = 0 __PRETTY_FUNCTION__ = "void LinuxAIOHandler::collect()" io_ctx = 0x7f5269be6000 start_pos = 0 end_pos = 256 #2 0x000055b391877429 in LinuxAIOHandler::poll (this=0x7f524121cb10, m1=0x7f524121cbb0, m2=0x7f524121cbb8, request=0x7f524121cbe0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2097 n_pending = 0 err = DB_SUCCESS slot = 0x0 __PRETTY_FUNCTION__ = "dberr_t LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*)" #3 0x000055b39187758c in os_aio_linux_handler (global_segment=2, m1=0x7f524121cbb0, m2=0x7f524121cbb8, request=0x7f524121cbe0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2151 No locals. #4 0x000055b39187c245 in os_aio_handler (segment=2, m1=0x7f524121cbb0, m2=0x7f524121cbb8, request=0x7f524121cbe0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:5785 err = 32594 #5 0x000055b391ab8627 in fil_aio_wait (segment=2) at /home/elenst/src/10.2/storage/innobase/fil/fil0fil.cc:5141 node = 0x0 type = {m_bpage = 0x0, m_fil_node = 0x0, m_type = 1} message = 0x0 __PRETTY_FUNCTION__ = "void fil_aio_wait(ulint)" err = DB_SUCCESS space_id = 0 dblwr = false purpose = FIL_TYPE_TEMPORARY #6 0x000055b39196dc03 in io_handler_thread (arg=0x55b39291af30 ) at /home/elenst/src/10.2/storage/innobase/srv/srv0start.cc:332 segment = 2 start = 2 __PRETTY_FUNCTION__ = "void* io_handler_thread(void*)" #7 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #8 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 9 (Thread 0x7f523f219700 (LWP 229880)): #0 0x00007f5269385644 in __io_getevents_0_4 () from /lib64/libaio.so.1 No symbol table info available. #1 0x000055b391876e31 in LinuxAIOHandler::collect (this=0x7f523f218b10) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:1936 events = 0x55b39392afc0 timeout = {tv_sec = 0, tv_nsec = 500000000} ret = -1853338284 __PRETTY_FUNCTION__ = "void LinuxAIOHandler::collect()" io_ctx = 0x7f5269a4b000 start_pos = 0 end_pos = 256 #2 0x000055b391877429 in LinuxAIOHandler::poll (this=0x7f523f218b10, m1=0x7f523f218bb0, m2=0x7f523f218bb8, request=0x7f523f218be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2097 n_pending = 0 err = DB_SUCCESS slot = 0x0 __PRETTY_FUNCTION__ = "dberr_t LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*)" #3 0x000055b39187758c in os_aio_linux_handler (global_segment=6, m1=0x7f523f218bb0, m2=0x7f523f218bb8, request=0x7f523f218be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2151 No locals. #4 0x000055b39187c245 in os_aio_handler (segment=6, m1=0x7f523f218bb0, m2=0x7f523f218bb8, request=0x7f523f218be0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:5785 err = 32594 #5 0x000055b391ab8627 in fil_aio_wait (segment=6) at /home/elenst/src/10.2/storage/innobase/fil/fil0fil.cc:5141 node = 0x55b3944c38f0 type = {m_bpage = 0x0, m_fil_node = 0x0, m_type = 1} message = 0x7f5243a354c0 __PRETTY_FUNCTION__ = "void fil_aio_wait(ulint)" err = DB_SUCCESS space_id = 0 dblwr = true purpose = FIL_TYPE_TABLESPACE #6 0x000055b39196dc03 in io_handler_thread (arg=0x55b39291af50 ) at /home/elenst/src/10.2/storage/innobase/srv/srv0start.cc:332 segment = 6 start = 2 __PRETTY_FUNCTION__ = "void* io_handler_thread(void*)" #7 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #8 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 8 (Thread 0x7f5240a1c700 (LWP 229877)): #0 0x00007f5269385644 in __io_getevents_0_4 () from /lib64/libaio.so.1 No symbol table info available. #1 0x000055b391876e31 in LinuxAIOHandler::collect (this=0x7f5240a1bb10) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:1936 events = 0x55b3938cc760 timeout = {tv_sec = 0, tv_nsec = 500000000} ret = 0 __PRETTY_FUNCTION__ = "void LinuxAIOHandler::collect()" io_ctx = 0x7f5269be3000 start_pos = 256 end_pos = 512 #2 0x000055b391877429 in LinuxAIOHandler::poll (this=0x7f5240a1bb10, m1=0x7f5240a1bbb0, m2=0x7f5240a1bbb8, request=0x7f5240a1bbe0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2097 n_pending = 0 err = DB_SUCCESS slot = 0x0 __PRETTY_FUNCTION__ = "dberr_t LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*)" #3 0x000055b39187758c in os_aio_linux_handler (global_segment=3, m1=0x7f5240a1bbb0, m2=0x7f5240a1bbb8, request=0x7f5240a1bbe0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2151 No locals. #4 0x000055b39187c245 in os_aio_handler (segment=3, m1=0x7f5240a1bbb0, m2=0x7f5240a1bbb8, request=0x7f5240a1bbe0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:5785 err = 32594 #5 0x000055b391ab8627 in fil_aio_wait (segment=3) at /home/elenst/src/10.2/storage/innobase/fil/fil0fil.cc:5141 node = 0x0 type = {m_bpage = 0x0, m_fil_node = 0x0, m_type = 1} message = 0x0 __PRETTY_FUNCTION__ = "void fil_aio_wait(ulint)" err = DB_SUCCESS space_id = 0 dblwr = false purpose = FIL_TYPE_TEMPORARY #6 0x000055b39196dc03 in io_handler_thread (arg=0x55b39291af38 ) at /home/elenst/src/10.2/storage/innobase/srv/srv0start.cc:332 segment = 3 start = 2 __PRETTY_FUNCTION__ = "void* io_handler_thread(void*)" #7 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #8 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 7 (Thread 0x7f5250056700 (LWP 229932)): #0 0x00007f52697b8965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391cd75ac in safe_cond_wait (cond=0x55b39312b508 , mp=0x55b39312b458 , file=0x55b3920392e0 "/home/elenst/src/10.2/include/mysql/psi/mysql_thread.h", line=1156) at /home/elenst/src/10.2/mysys/thr_mutex.c:491 error = 32593 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 229932, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000,\202\003\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 229932, __nusers = 1, __kind = 3, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000,\202\003\000\001\000\000\000\003", '\000' , __align = 1}, file = 0x55b392039318 "/home/elenst/src/10.2/storage/maria/ma_loghandler.c", name = 0x55b39203b681 "log_descriptor.log_flush_lock", line = 8092, count = 0, create_flags = 0, active_flags = 0, id = 193, thread = 139991506577152, locked_mutex = 0x7f51ec06b420, used_mutex = 0x7f51ec06b488, prev = 0x0, next = 0x0} #2 0x000055b391b6f5b1 in inline_mysql_cond_wait (that=0x55b39312b508 , mutex=0x55b39312b458 , src_file=0x55b392039318 "/home/elenst/src/10.2/storage/maria/ma_loghandler.c", src_line=7847) at /home/elenst/src/10.2/include/mysql/psi/mysql_thread.h:1156 result = 32594 #3 0x000055b391b84318 in translog_flush_set_new_goal_and_wait (lsn=4593901635) at /home/elenst/src/10.2/storage/maria/ma_loghandler.c:7846 flush_no = 959 _db_stack_frame_ = {func = 0x55b39203e221 "translog_flush", file = 0x55b392039318 "/home/elenst/src/10.2/storage/maria/ma_loghandler.c", level = 2147483658, line = -1, prev = 0x7f5250054540} __PRETTY_FUNCTION__ = "translog_flush_set_new_goal_and_wait" #4 0x000055b391b84ca4 in translog_flush (lsn=4593901635) at /home/elenst/src/10.2/storage/maria/ma_loghandler.c:8107 abstime = {tv_sec = 139991506568624, tv_nsec = 150323855360} flush_interval = 139991506568656 time_spent = 12884901888 sent_to_disk = 0 flush_horizon = 27983859417097 rc = 0 '\000' hgroup_commit_at_start = -110 '\222' _db_stack_frame_ = {func = 0x55b392044438 "ma_commit", file = 0x55b392044408 "/home/elenst/src/10.2/storage/maria/ma_commit.c", level = 2147483657, line = -1, prev = 0x7f52500545d0} __PRETTY_FUNCTION__ = "translog_flush" #5 0x000055b391b9e279 in ma_commit (trn=0x7f51bc018830) at /home/elenst/src/10.2/storage/maria/ma_commit.c:66 res = 32593 commit_lsn = 4593901635 log_array = {{str = 0x0, length = 0}, {str = 0x7f52500543e0 "", length = 3}} _db_stack_frame_ = {func = 0x55b392037965 "ha_maria::implicit_commit", file = 0x55b392036ec8 "/home/elenst/src/10.2/storage/maria/ha_maria.cc", level = 2147483656, line = -1, prev = 0x7f5250054650} __PRETTY_FUNCTION__ = "ma_commit" #6 0x000055b391b696e2 in ha_maria::implicit_commit (thd=0x7f51b8000af0, new_trn=true) at /home/elenst/src/10.2/storage/maria/ha_maria.cc:2926 used_tables = 0x7f51c804f2b0 trn_next = 0x7f51b8000a10 __PRETTY_FUNCTION__ = "static int ha_maria::implicit_commit(THD*, bool)" trn = 0x7f51bc018830 error = 0 locked_tables = 1 _db_stack_frame_ = {func = 0x55b391e72da9 "ha_commit_trans", file = 0x55b391e727b8 "/home/elenst/src/10.2/sql/handler.cc", level = 2147483655, line = -1, prev = 0x7f52500546e0} #7 0x000055b391592c57 in ha_commit_trans (thd=0x7f51b8000af0, all=false) at /home/elenst/src/10.2/sql/handler.cc:1391 cookie = 0 need_prepare_ordered = 240 _db_stack_frame_ = {func = 0x55b391dc7504 "trans_commit_stmt", file = 0x55b391dc70c0 "/home/elenst/src/10.2/sql/transaction.cc", level = 2147483654, line = -1, prev = 0x7f5250054900} __PRETTY_FUNCTION__ = "int ha_commit_trans(THD*, bool)" mdl_request = {type = MDL_INTENTION_EXCLUSIVE, duration = MDL_STATEMENT, next_in_list = 0x7f51b80113b8, prev_in_list = 0x74616d2073776f52, ticket = 0x2031203a64656863, key = {m_length = 17184, m_db_name_length = 24936, m_hash_value = 1684367214, m_ptr = ": 1 Warnings: 0", '\000' , "\250&\000\270Q\177\000\000\004\000\000\000\000\000\000\000\270\023\001\270Q\177\000\000\000\000\000\000\000\000\000\000\272\376̑\000\000\000\000\026\351ڑ\263U\000\000\000\000\000\000\000\000\000\000\240G\005PR\177\000\000\335\377̑\000\000\001\000\300G\005PR\177\000\000NRϑ\263U\000\000\300G\005PR\177\000\000\060\n\000\270Q\177\000\000\060\n\000\270Q\177\000\000\020\n\000\270\001\000\000\000\020H\005PR\177\000\000%Cϑ\263U\000\000PH\005PR\177\000\000\335\377̑\024\006\000\000p\346ڑ\263U\000\000\026\351ڑ\263U\000\000\020H\005PR\177\000\000"..., static m_namespace_to_wait_state_name = {{m_key = 0, m_name = 0x55b391dc4be2 "Waiting for global read lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4c00 "Waiting for schema metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4c28 "Waiting for table metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4c48 "Waiting for stored function metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4c78 "Waiting for stored procedure metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4ca8 "Waiting for trigger metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4cd0 "Waiting for event metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4cf0 "Waiting for commit lock", m_flags = 0}, {m_key = 0, m_name = 0x55b391dc4d08 "User lock", m_flags = 0}}}} need_commit_ordered = 72 xid = 139988956088880 error = 0 trans = 0x7f51b8003dd0 is_real_trans = false ha_info = 0x7f51b8002e28 rw_ha_count = 5 rw_trans = 80 #8 0x000055b391475ad4 in trans_commit_stmt (thd=0x7f51b8000af0) at /home/elenst/src/10.2/sql/transaction.cc:510 _db_stack_frame_ = {func = 0x55b391d92e14 "mysql_execute_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7f5250054b40} res = 0 __PRETTY_FUNCTION__ = "bool trans_commit_stmt(THD*)" #9 0x000055b391314ea1 in mysql_execute_command (thd=0x7f51b8000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:6091 res = 0 lex = 0x7f51b8004628 _db_stack_frame_ = {func = 0x55b391d93c28 "mysql_parse", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f5250055330} __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" orig_binlog_format = BINLOG_FORMAT_MIXED up_result = 0 rpl_filter = 0x7f51b8000a10 orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT __FUNCTION__ = "mysql_execute_command" select_lex = 0x7f51b8004e28 first_table = 0x7f51b80113b8 all_tables = 0x7f51b80113b8 unit = 0x7f51b80046e8 have_table_map_for_update = false #10 0x000055b391319775 in mysql_parse (thd=0x7f51b8000af0, rawbuf=0x7f51b8011128 "UPDATE /* QNO 1145 CON_ID 26 */ `tmp` SET fld = JSON_MERGE_PATCH( LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/02.json'), LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/02.json') ) /* compatib"..., length=237, parser_state=0x7f5250055520, is_com_multi=false, is_next_command=false) at /home/elenst/src/10.2/sql/sql_parse.cc:7794 found_semicolon = 0x0 lex = 0x7f51b8004628 err = false error = 32593 _db_stack_frame_ = {func = 0x55b391d92942 "dispatch_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f5250055500} __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)" __FUNCTION__ = "mysql_parse" #11 0x000055b391307a5e in dispatch_command (command=COM_QUERY, thd=0x7f51b8000af0, packet=0x7f51b80088b1 "UPDATE /* QNO 1145 CON_ID 26 */ `tmp` SET fld = JSON_MERGE_PATCH( LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/02.json'), LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/02.json') ) /* compatib"..., packet_length=238, is_com_multi=false, is_next_command=false) at /home/elenst/src/10.2/sql/sql_parse.cc:1828 packet_end = 0x7f51b8011215 "" parser_state = {m_input = {m_compute_digest = false}, m_lip = {m_thd = 0x7f51b8000af0, yylineno = 1, yylval = 0x7f5250054550, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7f51b8011216 "\004", m_tok_start = 0x7f51b8011216 "\004", m_tok_end = 0x7f51b8011216 "\004", m_end_of_query = 0x7f51b8011215 "", m_tok_start_prev = 0x7f51b8011215 "", m_buf = 0x7f51b8011128 "UPDATE /* QNO 1145 CON_ID 26 */ `tmp` SET fld = JSON_MERGE_PATCH( LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/02.json'), LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/02.json') ) /* compatib"..., m_buf_length = 237, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7f51b8011270 "UPDATE /* QNO 1145 CON_ID 26 */ `tmp` SET fld = JSON_MERGE_PATCH( LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/02.json'), LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/02.json') ) /* compatib"..., m_cpp_ptr = 0x7f51b801135d "", m_cpp_tok_start = 0x7f51b801135d "", m_cpp_tok_start_prev = 0x7f51b801135d "", m_cpp_tok_end = 0x7f51b801135d "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x7f51b80288fc '\245' ..., 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 = 0x7f51b801135c "5", m_cpp_text_end = 0x7f51b801135d "", 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 = 0x7f51b8000dd8 do_end_of_statement = true __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)" __FUNCTION__ = "dispatch_command" error = false _db_stack_frame_ = {func = 0x55b391d92717 "do_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f5250055d20} drop_more_results = false #12 0x000055b391306404 in do_command (thd=0x7f51b8000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:1382 return_value = false packet = 0x7f51b80088b0 "\003UPDATE /* QNO 1145 CON_ID 26 */ `tmp` SET fld = JSON_MERGE_PATCH( LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/02.json'), LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/02.json') ) /* compati"... packet_length = 239 net = 0x7f51b8000dd8 command = COM_QUERY __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #13 0x000055b39145fef6 in do_handle_one_connection (connect=0x55b3941b7720) at /home/elenst/src/10.2/sql/sql_connect.cc:1336 create_user = true thr_create_utime = 8347586430970 thd = 0x7f51b8000af0 #14 0x000055b39145fc41 in handle_one_connection (arg=0x55b3941b7720) at /home/elenst/src/10.2/sql/sql_connect.cc:1241 connect = 0x55b3941b7720 #15 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #16 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 6 (Thread 0x7f5234217700 (LWP 229939)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391cd78ae in safe_cond_timedwait (cond=0x55b39289dcc0 , mp=0x55b3928a0440 , abstime=0x7f5234216cb0, file=0x55b391d64a60 "/home/elenst/src/10.2/include/mysql/psi/mysql_thread.h", line=1193) at /home/elenst/src/10.2/mysys/thr_mutex.c:545 error = 21939 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 229939, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\063\202\003\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 229939, __nusers = 1, __kind = 3, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\063\202\003\000\001\000\000\000\003", '\000' , __align = 1}, file = 0x55b391d667e0 "/home/elenst/src/10.2/sql/mysqld.cc", name = 0x55b391d6827e "LOCK_thread_cache", line = 2996, count = 0, create_flags = 0, active_flags = 0, id = 1638, thread = 139991038654208, locked_mutex = 0x7f51ec0081b0, used_mutex = 0x7f51ec008218, prev = 0x0, next = 0x0} #2 0x000055b391210e73 in inline_mysql_cond_timedwait (that=0x55b39289dcc0 , mutex=0x55b3928a0440 , abstime=0x7f5234216cb0, src_file=0x55b391d667e0 "/home/elenst/src/10.2/sql/mysqld.cc", src_line=3021) at /home/elenst/src/10.2/include/mysql/psi/mysql_thread.h:1193 result = 0 #3 0x000055b391215f83 in cache_thread (thd=0x7f51a8000af0) at /home/elenst/src/10.2/sql/mysqld.cc:3020 error = 32593 abstime = {tv_sec = 1618141313, tv_nsec = 47025000} _db_stack_frame_ = {func = 0x55b391d66edd "one_thread_per_connection_end", file = 0x55b391d667e0 "/home/elenst/src/10.2/sql/mysqld.cc", level = 2147483650, line = -1, prev = 0x7f5234216d20} __PRETTY_FUNCTION__ = "bool cache_thread(THD*)" #4 0x000055b391216227 in one_thread_per_connection_end (thd=0x7f51a8000af0, put_in_cache=true) at /home/elenst/src/10.2/sql/mysqld.cc:3109 wsrep_applier = false _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #5 0x000055b39145ffeb in do_handle_one_connection (connect=0x55b3941b7720) at /home/elenst/src/10.2/sql/sql_connect.cc:1355 create_user = true thr_create_utime = 8347587127171 thd = 0x7f51a8000af0 #6 0x000055b39145fc41 in handle_one_connection (arg=0x55b3941b7720) at /home/elenst/src/10.2/sql/sql_connect.cc:1241 connect = 0x55b3941b7720 #7 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #8 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 5 (Thread 0x7f526644c700 (LWP 229872)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391cd78ae in safe_cond_timedwait (cond=0x55b393134e40 , mp=0x55b393134d80 , abstime=0x7f526644bdc0, file=0x55b392065650 "/home/elenst/src/10.2/include/mysql/psi/mysql_thread.h", line=1193) at /home/elenst/src/10.2/mysys/thr_mutex.c:545 error = 110 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 229872, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\360\201\003\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 2, __count = 0, __owner = 229872, __nusers = 1, __kind = 3, __spins = 7, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\002\000\000\000\000\000\000\000\360\201\003\000\001\000\000\000\003\000\000\000\a", '\000' , __align = 2}, file = 0x55b392065650 "/home/elenst/src/10.2/include/mysql/psi/mysql_thread.h", name = 0x55b3920656c0 "LOCK_timer", line = 1193, count = 0, create_flags = 0, active_flags = 0, id = 12, thread = 139991879829248, locked_mutex = 0x7f5260000af0, used_mutex = 0x7f5260000b58, prev = 0x0, next = 0x0} #2 0x000055b391cd8865 in inline_mysql_cond_timedwait (that=0x55b393134e40 , mutex=0x55b393134d80 , abstime=0x7f526644bdc0, src_file=0x55b392065688 "/home/elenst/src/10.2/mysys/thr_timer.c", src_line=292) at /home/elenst/src/10.2/include/mysql/psi/mysql_thread.h:1193 result = 0 #3 0x000055b391cd9321 in timer_handler (arg=0x0) at /home/elenst/src/10.2/mysys/thr_timer.c:292 error = 110 top_time = 0x7f51bc006260 now = {tv_sec = 1618141001, tv_nsec = 468784000} abstime = {tv_sec = 1618141021, tv_nsec = 236405000} #4 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 4 (Thread 0x7f52347f8700 (LWP 229934)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391cd78ae in safe_cond_timedwait (cond=0x7f51bc0008c8, mp=0x7f51c8088260, abstime=0x7f52347f5d10, file=0x55b392064b50 "/home/elenst/src/10.2/include/mysql/psi/mysql_thread.h", line=1193) at /home/elenst/src/10.2/mysys/thr_mutex.c:545 error = 21939 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 229934, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000.\202\003\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 229934, __nusers = 4, __kind = 3, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000.\202\003\000\004\000\000\000\003", '\000' , __align = 1}, file = 0x55b392064b88 "/home/elenst/src/10.2/mysys/thr_lock.c", name = 0x55b392064bb0 "lock->mutex", line = 762, count = 0, create_flags = 0, active_flags = 0, id = 8968, thread = 139991044818688, locked_mutex = 0x7f51c8148fb0, used_mutex = 0x7f51c8149018, prev = 0x0, next = 0x0} #2 0x000055b391cd3f09 in inline_mysql_cond_timedwait (that=0x7f51bc0008c8, mutex=0x7f51c8088260, abstime=0x7f52347f5d10, src_file=0x55b392064b88 "/home/elenst/src/10.2/mysys/thr_lock.c", src_line=575) at /home/elenst/src/10.2/include/mysql/psi/mysql_thread.h:1193 result = 0 #3 0x000055b391cd4584 in wait_for_lock (wait=0x7f51c8088330, data=0x7f51d02d18f8, in_wait_list=0 '\000', lock_wait_timeout=10) at /home/elenst/src/10.2/mysys/thr_lock.c:575 rc = 21939 thread_var = 0x7f51bc0008c0 cond = 0x7f51bc0008c8 wait_timeout = {tv_sec = 1618141028, tv_nsec = 806469000} result = THR_LOCK_ABORTED old_stage = {m_key = 0, m_name = 0x55b391d6e1a1 "Table lock", m_flags = -1140841440} use_wait_callbacks = 1 '\001' __FUNCTION__ = "wait_for_lock" #4 0x000055b391cd50d2 in thr_lock (data=0x7f51d02d18f8, owner=0x7f51bc002420, lock_wait_timeout=10) at /home/elenst/src/10.2/mysys/thr_lock.c:1013 lock = 0x7f51c8088248 result = THR_LOCK_SUCCESS wait_queue = 0x7f51c8088330 lock_type = TL_WRITE wsrep_lock_inserted = 0 '\000' locker = 0x0 state = {m_flags = 880762304, m_io_operation = 32594, m_table = 0x55b391cf1f52 , m_table_share = 0x7f51bc000a30, m_thread = 0x7f51bc000a10, m_timer_start = 94229735500936, m_timer = 0x158, m_wait = 0x7f52347f5df0, m_index = 2434867115} #5 0x000055b391cd59bc in thr_multi_lock (data=0x7f51bc012138, count=1, owner=0x7f51bc002420, lock_wait_timeout=10) at /home/elenst/src/10.2/mysys/thr_lock.c:1294 result = 21939 pos = 0x7f51bc012138 end = 0x7f51bc012140 first_lock = 0x55b3926a1b10 #6 0x000055b3916ac46d in mysql_lock_tables (thd=0x7f51bc000af0, sql_lock=0x7f51bc012118, flags=0) at /home/elenst/src/10.2/sql/lock.cc:354 timeout = 10 org_stage = {m_key = 0, m_name = 0x0, m_flags = -1140776640} __FUNCTION__ = "mysql_lock_tables" rc = 1 _db_stack_frame_ = {func = 0x55b391e96dc5 "mysql_lock_tables(tables)", file = 0x55b391e96c88 "/home/elenst/src/10.2/sql/lock.cc", level = 2147483657, line = -1, prev = 0x7f52347f5f00} #7 0x000055b3916ac26e in mysql_lock_tables (thd=0x7f51bc000af0, tables=0x7f51bc012110, count=1, flags=0) at /home/elenst/src/10.2/sql/lock.cc:303 sql_lock = 0x7f51bc012118 gld_flags = 3 _db_stack_frame_ = {func = 0x55b391d81b28 "lock_tables", file = 0x55b391d80d48 "/home/elenst/src/10.2/sql/sql_base.cc", level = 2147483656, line = -1, prev = 0x7f52347f5fa0} #8 0x000055b39129f1bb in lock_tables (thd=0x7f51bc000af0, tables=0x7f51bc011328, count=1, flags=0) at /home/elenst/src/10.2/sql/sql_base.cc:5109 start = 0x7f51bc012110 ptr = 0x7f51bc012118 table = 0x0 _db_stack_frame_ = {func = 0x55b391d81a19 "open_and_lock_tables", file = 0x55b391d80d48 "/home/elenst/src/10.2/sql/sql_base.cc", level = 2147483655, line = -1, prev = 0x7f52347f6030} __PRETTY_FUNCTION__ = "bool lock_tables(THD*, TABLE_LIST*, uint, uint)" res = false #9 0x000055b39129e964 in open_and_lock_tables (thd=0x7f51bc000af0, options=..., tables=0x7f51bc011328, derived=true, flags=0, prelocking_strategy=0x7f52347f6090) at /home/elenst/src/10.2/sql/sql_base.cc:4889 counter = 1 mdl_savepoint = {m_stmt_ticket = 0x0, m_trans_ticket = 0x7f51bc084160} _db_stack_frame_ = {func = 0x55b391ea73c8 "mysql_delete", file = 0x55b391ea73a0 "/home/elenst/src/10.2/sql/sql_delete.cc", level = 2147483654, line = -1, prev = 0x7f52347f61a0} #10 0x000055b3912650b3 in open_and_lock_tables (thd=0x7f51bc000af0, tables=0x7f51bc011328, derived=true, flags=0) at /home/elenst/src/10.2/sql/sql_base.h:509 prelocking_strategy = { = {_vptr.Prelocking_strategy = 0x55b3925cdbf0 }, } #11 0x000055b391721455 in mysql_delete (thd=0x7f51bc000af0, table_list=0x7f51bc011328, conds=0x7f51bc011da0, order_list=0x7f51bc005088, limit=1, options=549755813888, result=0x0) at /home/elenst/src/10.2/sql/sql_delete.cc:252 file_sort = 0x0 safe_update = false explain = 0x7f52347f6190 __PRETTY_FUNCTION__ = "bool mysql_delete(THD*, TABLE_LIST*, COND*, SQL_I_List*, ha_rows, ulonglong, select_result*)" will_batch = 221 transactional_table = false const_cond_result = true return_error = false reverse = false query_type = THD::ROW_QUERY_TYPE select_lex = 0x7f51bc004e28 with_select = false query_plan = { = {_vptr.Update_plan = 0x55b39267fa90 , impossible_where = false, no_partitions = false, updating_a_view = false, mem_root = 0x7f51bc005c68, table = 0x55b391cf4518 <_db_return_+211>, select = 0x7f51bc13fd88, index = 64, scanned_rows = 94229735751434, select_lex = 0x0, possible_keys = {map = 139991044809296}, using_filesort = false, using_io_buffer = false}, deleting_all_rows = false} table = 0x7f52347f6190 order = 0x0 _db_stack_frame_ = {func = 0x55b391d92e14 "mysql_execute_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7f52347f6b40} loc_error = 32594 select = 0x0 info = {table = 0x0, forms = 0x55b391cf524e , unlock_row = 0x7f52347f6270, read_record = 0x7f51bc000a30, thd = 0x7f51bc000a30, select = 0x1bc000a10, cache_records = 880764080, ref_length = 32594, struct_length = 2446279960, reclength = 21939, rec_cache_size = 880763664, error_offset = 32594, index = 880764112, ref_pos = 0x7f510000000a
, record = 0xbc000a30
, rec_buf = 0x55b391ed5175 "innobase_commit", cache = 0x0, cache_pos = 0x7f52347f62d0 "\360b\177\064R\177", cache_end = 0x91ccffdd
, read_positions = 0x55b391d95f55 "intern_sys_var_ptr", addon_field = 0x0, io_cache = 0x7f52347f62f0, print_error = 221, ignore_not_found_rows = 255, unpack = 0x7f52347f6310, copy_field = 0x55b391cf524e , copy_field_end = 0x7f52347f6310} const_cond = false deleted = 0 __FUNCTION__ = "mysql_delete" error = 880763216 using_limit = true killed_status = NOT_KILLED #12 0x000055b39130f0c1 in mysql_execute_command (thd=0x7f51bc000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:4426 sel_result = 0x0 save_protocol = 0x7f51bc000a30 replaced_protocol = false res = 0 lex = 0x7f51bc004628 _db_stack_frame_ = {func = 0x55b391d93c28 "mysql_parse", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f52347f7330} __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" orig_binlog_format = BINLOG_FORMAT_MIXED up_result = 0 rpl_filter = 0x7f51bc000a10 orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT __FUNCTION__ = "mysql_execute_command" select_lex = 0x7f51bc004e28 first_table = 0x7f51bc011328 all_tables = 0x7f51bc011328 unit = 0x7f51bc0046e8 have_table_map_for_update = false #13 0x000055b391319775 in mysql_parse (thd=0x7f51bc000af0, rawbuf=0x7f51bc011128 "DELETE /* QNO 1151 CON_ID 27 */ FROM tmp WHERE LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/02.json') = '[\"e\",\"\",false,false,280712200159617,168482494159012]' LIMIT 1", length=171, parser_state=0x7f52347f7520, is_com_multi=false, is_next_command=false) at /home/elenst/src/10.2/sql/sql_parse.cc:7794 found_semicolon = 0x0 lex = 0x7f51bc004628 err = false error = 32593 _db_stack_frame_ = {func = 0x55b391d92942 "dispatch_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f52347f7500} __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)" __FUNCTION__ = "mysql_parse" #14 0x000055b391307a5e in dispatch_command (command=COM_QUERY, thd=0x7f51bc000af0, packet=0x7f51bc0088b1 "DELETE /* QNO 1151 CON_ID 27 */ FROM tmp WHERE LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/02.json') = '[\"e\",\"\",false,false,280712200159617,168482494159012]' LIMIT 1", packet_length=171, is_com_multi=false, is_next_command=false) at /home/elenst/src/10.2/sql/sql_parse.cc:1828 packet_end = 0x7f51bc0111d3 "" parser_state = {m_input = {m_compute_digest = false}, m_lip = {m_thd = 0x7f51bc000af0, yylineno = 1, yylval = 0x7f52347f6550, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7f51bc0111d4 "\004", m_tok_start = 0x7f51bc0111d4 "\004", m_tok_end = 0x7f51bc0111d4 "\004", m_end_of_query = 0x7f51bc0111d3 "", m_tok_start_prev = 0x7f51bc0111d3 "", m_buf = 0x7f51bc011128 "DELETE /* QNO 1151 CON_ID 27 */ FROM tmp WHERE LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/02.json') = '[\"e\",\"\",false,false,280712200159617,168482494159012]' LIMIT 1", m_buf_length = 171, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7f51bc011230 "DELETE /* QNO 1151 CON_ID 27 */ FROM tmp WHERE LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/02.json') = '[\"e\",\"\",false,false,280712200159617,168482494159012]' LIMIT 1", m_cpp_ptr = 0x7f51bc0112db "", m_cpp_tok_start = 0x7f51bc0112db "", m_cpp_tok_start_prev = 0x7f51bc0112db "", m_cpp_tok_end = 0x7f51bc0112db "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x7f51bc180441 '\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 = 0x7f51bc0112da "1", m_cpp_text_end = 0x7f51bc0112db "", 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 = 0x7f51bc000dd8 do_end_of_statement = true __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)" __FUNCTION__ = "dispatch_command" error = false _db_stack_frame_ = {func = 0x55b391d92717 "do_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f52347f7d20} drop_more_results = false #15 0x000055b391306404 in do_command (thd=0x7f51bc000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:1382 return_value = false packet = 0x7f51bc0088b0 "\003DELETE /* QNO 1151 CON_ID 27 */ FROM tmp WHERE LOAD_FILE('/home/elenst/rqg-elenst-dev/data/blobs/02.json') = '[\"e\",\"\",false,false,280712200159617,168482494159012]' LIMIT 1" packet_length = 172 net = 0x7f51bc000dd8 command = COM_QUERY __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #16 0x000055b39145fef6 in do_handle_one_connection (connect=0x55b394272580) at /home/elenst/src/10.2/sql/sql_connect.cc:1336 create_user = true thr_create_utime = 8347586535421 thd = 0x7f51bc000af0 #17 0x000055b39145fc41 in handle_one_connection (arg=0x55b394272580) at /home/elenst/src/10.2/sql/sql_connect.cc:1241 connect = 0x55b394272580 #18 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #19 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 3 (Thread 0x7f5251757700 (LWP 229873)): #0 0x00007f52697b8d12 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391cd78ae in safe_cond_timedwait (cond=0x55b39312b920 , mp=0x55b39312b860 , abstime=0x7f5251756d10, file=0x55b3920447e0 "/home/elenst/src/10.2/include/mysql/psi/mysql_thread.h", line=1193) at /home/elenst/src/10.2/mysys/thr_mutex.c:545 error = 21939 save_state = {global = {__data = {__lock = 1, __count = 0, __owner = 229873, __nusers = 1, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\361\201\003\000\001\000\000\000\002", '\000' , __align = 1}, mutex = {__data = {__lock = 1, __count = 0, __owner = 229873, __nusers = 1, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000\361\201\003\000\001", '\000' , __align = 1}, file = 0x55b392044818 "/home/elenst/src/10.2/storage/maria/ma_servicethread.c", name = 0x55b39204487f "control->LOCK_control", line = 99, count = 0, create_flags = 0, active_flags = 0, id = 31, thread = 139991530698496, locked_mutex = 0x7f524c000af0, used_mutex = 0x7f524c000b58, prev = 0x0, next = 0x0} #2 0x000055b391b9f504 in inline_mysql_cond_timedwait (that=0x55b39312b920 , mutex=0x55b39312b860 , abstime=0x7f5251756d10, src_file=0x55b392044818 "/home/elenst/src/10.2/storage/maria/ma_servicethread.c", src_line=116) at /home/elenst/src/10.2/include/mysql/psi/mysql_thread.h:1193 result = 0 #3 0x000055b391b9f9b6 in my_service_thread_sleep (control=0x55b3926e1d20 , sleep_time=29000000000) at /home/elenst/src/10.2/storage/maria/ma_servicethread.c:115 abstime = {tv_sec = 1618141040, tv_nsec = 525278000} res = 0 '\000' _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #4 0x000055b391b9445c in ma_checkpoint_background (arg=0x1e) at /home/elenst/src/10.2/storage/maria/ma_checkpoint.c:709 interval = 30 sleeps = 91 sleep_time = 29 log_horizon_at_last_checkpoint = 4590184184 pagecache_flushes_at_last_checkpoint = 22754 pages_bunch_size = 0 filter_param = {up_to_lsn = 4590184140, max_pages = 63} dfile = 0x7f524c002c80 kfile = 0x7f524c002090 __PRETTY_FUNCTION__ = "ma_checkpoint_background" #5 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 2 (Thread 0x7f5241a1e700 (LWP 229875)): #0 0x00007f5269385644 in __io_getevents_0_4 () from /lib64/libaio.so.1 No symbol table info available. #1 0x000055b391876e31 in LinuxAIOHandler::collect (this=0x7f5241a1db10) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:1936 events = 0x55b3938f0ce0 timeout = {tv_sec = 0, tv_nsec = 500000000} ret = 0 __PRETTY_FUNCTION__ = "void LinuxAIOHandler::collect()" io_ctx = 0x7f5269a4e000 start_pos = 0 end_pos = 256 #2 0x000055b391877429 in LinuxAIOHandler::poll (this=0x7f5241a1db10, m1=0x7f5241a1dbb0, m2=0x7f5241a1dbb8, request=0x7f5241a1dbe0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2097 n_pending = 0 err = DB_SUCCESS slot = 0x0 __PRETTY_FUNCTION__ = "dberr_t LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*)" #3 0x000055b39187758c in os_aio_linux_handler (global_segment=1, m1=0x7f5241a1dbb0, m2=0x7f5241a1dbb8, request=0x7f5241a1dbe0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:2151 No locals. #4 0x000055b39187c245 in os_aio_handler (segment=1, m1=0x7f5241a1dbb0, m2=0x7f5241a1dbb8, request=0x7f5241a1dbe0) at /home/elenst/src/10.2/storage/innobase/os/os0file.cc:5785 err = 32594 #5 0x000055b391ab8627 in fil_aio_wait (segment=1) at /home/elenst/src/10.2/storage/innobase/fil/fil0fil.cc:5141 node = 0x55b3944c3cb0 type = {m_bpage = 0x0, m_fil_node = 0x0, m_type = 1} message = 0x55b39418ee01 __PRETTY_FUNCTION__ = "void fil_aio_wait(ulint)" err = DB_SUCCESS space_id = 4294967280 dblwr = true purpose = FIL_TYPE_LOG #6 0x000055b39196dc03 in io_handler_thread (arg=0x55b39291af28 ) at /home/elenst/src/10.2/storage/innobase/srv/srv0start.cc:332 segment = 1 start = 2 __PRETTY_FUNCTION__ = "void* io_handler_thread(void*)" #7 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #8 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available. Thread 1 (Thread 0x7f52500a1700 (LWP 229930)): #0 0x00007f52697b99d1 in pthread_kill () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000055b391cd207d in my_write_core (sig=6) at /home/elenst/src/10.2/mysys/stacktrace.c:382 No locals. #2 0x000055b39158fc60 in handle_fatal_signal (sig=6) at /home/elenst/src/10.2/sql/signal_handler.cc:355 curr_time = 1618141019 tm = {tm_sec = 59, tm_min = 36, tm_hour = 11, tm_mday = 11, tm_mon = 3, tm_year = 121, tm_wday = 0, tm_yday = 100, tm_isdst = 0, tm_gmtoff = 0, tm_zone = 0x55b39371d1d0 "UTC"} thd = 0x7f51c4000af0 print_invalid_query_pointer = false #3 No symbol table info available. #4 0x00007f5267aa9207 in raise () from /lib64/libc.so.6 No symbol table info available. #5 0x00007f5267aaa8f8 in abort () from /lib64/libc.so.6 No symbol table info available. #6 0x00007f5267aa2026 in __assert_fail_base () from /lib64/libc.so.6 No symbol table info available. #7 0x00007f5267aa20d2 in __assert_fail () from /lib64/libc.so.6 No symbol table info available. #8 0x000055b391b84445 in translog_sync_files (min=1, max=2619214, sync_dir=0 '\000') at /home/elenst/src/10.2/storage/maria/ma_loghandler.c:7882 file = 0x0 fn = 2 rc = 0 '\000' flush_interval = 0 _db_stack_frame_ = {func = 0x55b39203e221 "translog_flush", file = 0x55b392039318 "/home/elenst/src/10.2/storage/maria/ma_loghandler.c", level = 2147483663, line = -1, prev = 0x7f525009b3e0} __PRETTY_FUNCTION__ = "translog_sync_files" #9 0x000055b391b850dd in translog_flush (lsn=11249439983363622) at /home/elenst/src/10.2/storage/maria/ma_loghandler.c:8199 abstime = {tv_sec = 139991506859088, tv_nsec = 1598106265088} flush_interval = 7583304208 time_spent = 139991506859024 sent_to_disk = 0 flush_horizon = 4592540119 rc = 0 '\000' hgroup_commit_at_start = 0 '\000' _db_stack_frame_ = {func = 0x55b392044699 "maria_flush_log_for_page", file = 0x55b3920444b0 "/home/elenst/src/10.2/storage/maria/ma_pagecrc.c", level = 2147483662, line = -1, prev = 0x7f525009b450} __PRETTY_FUNCTION__ = "translog_flush" #10 0x000055b391b9ecef in maria_flush_log_for_page (args=0x7f525009b4d0) at /home/elenst/src/10.2/storage/maria/ma_pagecrc.c:376 lsn = 11249439983363622 page = 0x7f52529d0080 "N\367'&f!Z" share = 0x7f51b01eb5f0 _db_stack_frame_ = {func = 0x55b39203fbcb "pagecache_fwrite", file = 0x55b39203fb98 "/home/elenst/src/10.2/storage/maria/ma_pagecache.c", level = 2147483661, line = -1, prev = 0x7f525009b4f0} __PRETTY_FUNCTION__ = "maria_flush_log_for_page" #11 0x000055b391b87e76 in pagecache_fwrite (pagecache=0x55b393136a60 , filedesc=0x7f5251a23418, buffer=0x7f52529d0080 "N\367'&f!Z", pageno=2, type=PAGECACHE_LSN_PAGE, flags=36) at /home/elenst/src/10.2/storage/maria/ma_pagecache.c:660 res = 0 args = {page = 0x7f52529d0080 "N\367'&f!Z", pageno = 2, data = 0x7f51b01eb5f0 "\376\376\t\003\f\002\004,", crypt_buf = 0x55b391b87a42 "\211E\374\213E\374\311\303UH\211\345H\203\354pH\211}\250H\211u\240H\211U\230\211M\224H\213E\250H\213@0H\205\300\017\204\213"} _db_stack_frame_ = {func = 0x55b392041771 "flush_cached_blocks", file = 0x55b39203fb98 "/home/elenst/src/10.2/storage/maria/ma_pagecache.c", level = 2147483660, line = -1, prev = 0x7f525009b5c0} __PRETTY_FUNCTION__ = "pagecache_fwrite" #12 0x000055b391b9193c in flush_cached_blocks (pagecache=0x55b393136a60 , file=0x7f51b01ebce0, cache=0x7f525009b6e0, end=0x7f525009b710, type=FLUSH_RELEASE, first_errno=0x7f525009b644) at /home/elenst/src/10.2/storage/maria/ma_pagecache.c:4419 block = 0x7f5251798c20 rc = 0 error = 0 '\000' count = 6 _db_stack_frame_ = {func = 0x55b3920417c5 "flush_pagecache_blocks_int", file = 0x55b39203fb98 "/home/elenst/src/10.2/storage/maria/ma_pagecache.c", level = 2147483659, line = -1, prev = 0x7f525009b6c0} __PRETTY_FUNCTION__ = "flush_cached_blocks" #13 0x000055b391b922e6 in flush_pagecache_blocks_int (pagecache=0x55b393136a60 , file=0x7f51b01ebce0, type=FLUSH_RELEASE, filter=0x0, filter_arg=0x0) at /home/elenst/src/10.2/storage/maria/ma_pagecache.c:4715 count = 7 end = 0x7f525009b718 first_in_switch = 0x0 block = 0x0 us_flusher = {file = 155, flush_queue = {last_thread = 0x0}, first_in_switch = 0 '\000'} error = 0 pos = 0x7f525009b710 next = 0x0 other_flusher = 0x0 cache_buff = {0x7f5251798c20, 0x7f5251798ae0, 0x7f525179b560, 0x7f525179b6a0, 0x7f525179aca0, 0x7f525179b100, 0x55b3920612c1, 0x55b39205fcd8, 0x10e18000000b, 0x7f525009f600, 0x7f51c4000a30, 0x1c4000a10, 0x7f525009b980, 0x91cf4518, 0x55b392063bea, 0x0, 0x55b392065d29, 0x0, 0x7f525009b790, 0x1000091ccffdd, 0x7f525009b7b0, 0x91cf524e, 0x55b392064378, 0x0, 0x7f525009b7c0, 0x1000091ccffdd, 0x7f525009b7e0, 0x55b391cf524e , 0x7f525009b7e0, 0x7f51c4000a30, 0x7f51c4000a30, 0x1c4000a10, 0x7f525009ba20, 0x55b391cf4518 <_db_return_+211>, 0x7f525009b810, 0x7f525009ba60, 0x7f520000000c, 0x7f51c4000a30, 0x55b3920550e8, 0x7f5267e503cc, 0x7f525009b840, 0xfffffffffffffff8, 0x7f525009b980, 0x7f5267e52cc4, 0x7f5267e530f8, 0x7f5267e516f9, 0x7f5267e530f8, 0x7f5267e516f9, 0x7f5267e53208, 0xa7, 0x97, 0xa7, 0x97, 0x7f51c4000a30, 0x7f525009cea0, 0x55b391ccfeba <_my_thread_var+20>, 0x7f525009b8c0, 0x7f525009b900, 0x1a, 0x7f5269beb000 <_rtld_local>, 0x7f52697b9700 , 0x0, 0x7f5269bec150, 0x7f5267baf4f6 , 0x7f5269bec150, 0x7f5267e503cc, 0x7f5267e51280, 0xfffffffffffffff8, 0x7f525009ba50, 0x7f5267e52cc4, 0x7f5267e530f8, 0x7f5267e516f9, 0x7f525009ba80, 0x7f52680551a0, 0x7f5267e53208, 0xa7, 0x97, 0x0, 0x0, 0x7f5267e503cc, 0x0, 0xfffffffffffffff8, 0x7f525009bac0, 0x7f5267e52cc4, 0x7f5267e530f8, 0x7f5267e516f9, 0x7f52697b9700 , 0x0, 0x7f5267e53208, 0xa7, 0x97, 0x1, 0x7f5267e51280, 0x7f525009ba50, 0x55b390d21000, 0x7f525009bfb0, 0x7f525009bd00, 0x7f525009ba40, 0x1a, 0x7f5267e503cc, 0x7f52697b9700 , 0xfffffffffffffff8, 0x7f525009bb60, 0x7f5267e52cc4, 0x7f5267e530f8, 0x7f5267e516f9, 0x7f5267e51280, 0x7f525009bac0, 0x7f5267e53208, 0xa7, 0x97, 0xfffffffffffffff8, 0x7f525009bbb0, 0x7f5267e52cc4, 0x7f5267e530f8, 0x7f5267e516f9, 0x0, 0x7f525009bae0, 0x1a, 0x7f5269beb000 <_rtld_local>, 0x7f52697b9700 , 0x0, 0x7f5269bec150, 0x7f5267baf4f6 , 0x0, 0x1, 0x7f5267e51280, 0x7f525009bb60, 0x55b390d21000, 0x7f525009c0c0, 0x7f525009be10, 0x7f525009bb20, 0x7f525009bc60, 0x7f52680551a0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x7f525009bc50, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x55b392217173, 0x7f525009bbc0, 0x55b3921c3470, 0x7f5267e50442, 0x55b3926a7e70 , 0xfffffffffffffff8, 0x7f525009bd20, 0x55b3921be5a4, 0x55b3921c3470, 0x7f5267e516f9, 0x0, 0x0, 0x55b392216d98, 0xb0fd, 0x10af, 0x7f525009be10, 0x7f5267b86f16 , 0x7f525009c0c0, 0x7f525009bc60, 0x7f525009c0c0, 0x7f5267b86da0 , 0x7f525009bca0, 0x1a, 0x7f5269beb000 <_rtld_local>, 0x7f52697b9700 , 0x0, 0x7f5269bec150, 0x7f5267baf4f6 , 0x0, 0x7f5200000001, 0x7f5267e51280, 0x7f525009bd20, 0x55b390d21000, 0x7f52699e5e7a, 0x55b390d21040, 0x9, 0x1a, 0x0, 0x0, 0x0, 0x0, 0x0, 0x55b3912993f8 , 0x7f525009beb8, 0x7f52697b9700 , 0x0, 0x7f5267b86da0 , 0x7f5267e51bbf <_Unwind_Find_FDE+447>...} cache = 0x7f525009b6e0 last_errno = 0 rc = 0 _db_stack_frame_ = {func = 0x55b392041920 "flush_pagecache_blocks_with_filter", file = 0x55b39203fb98 "/home/elenst/src/10.2/storage/maria/ma_pagecache.c", level = 2147483658, line = -1, prev = 0x7f525009f5c0} __PRETTY_FUNCTION__ = "flush_pagecache_blocks_int" #14 0x000055b391b92705 in flush_pagecache_blocks_with_filter (pagecache=0x55b393136a60 , file=0x7f51b01ebce0, type=FLUSH_RELEASE, filter=0x0, filter_arg=0x0) at /home/elenst/src/10.2/storage/maria/ma_pagecache.c:4832 res = 32593 _db_stack_frame_ = {func = 0x55b39204b54f "maria_close", file = 0x55b39204b520 "/home/elenst/src/10.2/storage/maria/ma_close.c", level = 2147483657, line = -1, prev = 0x7f525009f630} #15 0x000055b391be8d2e in maria_close (info=0x7f51b07fc840) at /home/elenst/src/10.2/storage/maria/ma_close.c:49 error = 0 flag = -1848683954 share_can_be_freed = 0 '\000' share = 0x7f51b01eb5f0 internal_table = 0 '\000' _db_stack_frame_ = {func = 0x55b391e73827 "ha_close", file = 0x55b391e727b8 "/home/elenst/src/10.2/sql/handler.cc", level = 2147483656, line = -1, prev = 0x7f525009f6b0} __PRETTY_FUNCTION__ = "maria_close" #16 0x000055b391b64aba in ha_maria::close (this=0x7f51b01e9328) at /home/elenst/src/10.2/storage/maria/ha_maria.cc:1277 tmp = 0x7f51b07fc840 #17 0x000055b3915965f1 in handler::ha_close (this=0x7f51b01e9328) at /home/elenst/src/10.2/sql/handler.cc:2657 _db_stack_frame_ = {func = 0x55b391db15fb "closefrm", file = 0x55b391db0c18 "/home/elenst/src/10.2/sql/table.cc", level = 2147483655, line = 2657, prev = 0x7f525009f710} __PRETTY_FUNCTION__ = "int handler::ha_close()" #18 0x000055b391417bfa in closefrm (table=0x7f51b01e8720) at /home/elenst/src/10.2/sql/table.cc:3525 error = 0 _db_stack_frame_ = {func = 0x55b391d80e18 "close_cached_tables", file = 0x55b391d80d48 "/home/elenst/src/10.2/sql/sql_base.cc", level = 2147483654, line = -1, prev = 0x7f525009f850} #19 0x000055b391506f01 in intern_close_table (table=0x7f51b01e8720) at /home/elenst/src/10.2/sql/table_cache.cc:222 __PRETTY_FUNCTION__ = "void intern_close_table(TABLE*)" #20 0x000055b391507308 in tc_purge (mark_flushed=true) at /home/elenst/src/10.2/sql/table_cache.cc:335 argument = {purge_tables = { = {}, > = {}, m_first = 0x7f51c4152780}, mark_flushed = true} table = 0x7f51b01e8720 #21 0x000055b3912963de in close_cached_tables (thd=0x7f51c4000af0, tables=0x0, wait_for_refresh=true, timeout=10) at /home/elenst/src/10.2/sql/sql_base.cc:374 abstime = {tv_sec = 139991506876528, tv_nsec = 94229746031424} __PRETTY_FUNCTION__ = "bool close_cached_tables(THD*, TABLE_LIST*, bool, ulong)" result = false refresh_version = 21 _db_stack_frame_ = {func = 0x55b391d92e14 "mysql_execute_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7f525009fb40} #22 0x000055b39149afa9 in reload_acl_and_cache (thd=0x7f51c4000af0, options=4, tables=0x0, write_to_binlog=0x7f525009fc10) at /home/elenst/src/10.2/sql/sql_reload.cc:344 result = false tmp_write_to_binlog = 1 __PRETTY_FUNCTION__ = "bool reload_acl_and_cache(THD*, long long unsigned int, TABLE_LIST*, int*)" #23 0x000055b391312061 in mysql_execute_command (thd=0x7f51c4000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:5201 write_to_binlog = 1 res = 0 lex = 0x7f51c4004628 _db_stack_frame_ = {func = 0x55b391d93c28 "mysql_parse", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f52500a0330} __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" orig_binlog_format = BINLOG_FORMAT_MIXED up_result = 0 rpl_filter = 0x7f51c4000a10 orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT __FUNCTION__ = "mysql_execute_command" select_lex = 0x7f51c4004e28 first_table = 0x0 all_tables = 0x0 unit = 0x7f51c40046e8 have_table_map_for_update = false #24 0x000055b391319775 in mysql_parse (thd=0x7f51c4000af0, rawbuf=0x7f51c40132e8 "FLUSH /* QNO 1291 CON_ID 25 */ TABLES", length=37, parser_state=0x7f52500a0520, is_com_multi=false, is_next_command=false) at /home/elenst/src/10.2/sql/sql_parse.cc:7794 found_semicolon = 0x0 lex = 0x7f51c4004628 err = false error = 32593 _db_stack_frame_ = {func = 0x55b391d92942 "dispatch_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f52500a0500} __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)" __FUNCTION__ = "mysql_parse" #25 0x000055b391307a5e in dispatch_command (command=COM_QUERY, thd=0x7f51c4000af0, packet=0x7f51c40088b1 "FLUSH /* QNO 1291 CON_ID 25 */ TABLES", packet_length=37, is_com_multi=false, is_next_command=false) at /home/elenst/src/10.2/sql/sql_parse.cc:1828 packet_end = 0x7f51c401330d "" parser_state = {m_input = {m_compute_digest = false}, m_lip = {m_thd = 0x7f51c4000af0, yylineno = 1, yylval = 0x7f525009f550, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7f51c401330e "\004", m_tok_start = 0x7f51c401330e "\004", m_tok_end = 0x7f51c401330e "\004", m_end_of_query = 0x7f51c401330d "", m_tok_start_prev = 0x7f51c401330d "", m_buf = 0x7f51c40132e8 "FLUSH /* QNO 1291 CON_ID 25 */ TABLES", m_buf_length = 37, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7f51c4013368 "FLUSH /* QNO 1291 CON_ID 25 */ TABLES", m_cpp_ptr = 0x7f51c401338d "", m_cpp_tok_start = 0x7f51c401338d "", m_cpp_tok_start_prev = 0x7f51c401338d "", m_cpp_tok_end = 0x7f51c401338d "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x7f51c41505d1 "4z\025\217\217\217\217", , m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 39 '\'', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = NO_COMMENT, m_cpp_text_start = 0x7f51c401338d "", m_cpp_text_end = 0x7f51c4013395 "U", 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 = 0x7f51c4000dd8 do_end_of_statement = true __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)" __FUNCTION__ = "dispatch_command" error = false _db_stack_frame_ = {func = 0x55b391d92717 "do_command", file = 0x55b391d925a0 "/home/elenst/src/10.2/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f52500a0d20} drop_more_results = false #26 0x000055b391306404 in do_command (thd=0x7f51c4000af0) at /home/elenst/src/10.2/sql/sql_parse.cc:1382 return_value = false packet = 0x7f51c40088b0 "\003FLUSH /* QNO 1291 CON_ID 25 */ TABLES" packet_length = 38 net = 0x7f51c4000dd8 command = COM_QUERY __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = {func = 0x55b392067a97 "?func", file = 0x55b392067a9d "?file", level = 2147483649, line = -1, prev = 0x0} #27 0x000055b39145fef6 in do_handle_one_connection (connect=0x55b394272580) at /home/elenst/src/10.2/sql/sql_connect.cc:1336 create_user = true thr_create_utime = 8347586327753 thd = 0x7f51c4000af0 #28 0x000055b39145fc41 in handle_one_connection (arg=0x55b394272580) at /home/elenst/src/10.2/sql/sql_connect.cc:1241 connect = 0x55b394272580 #29 0x00007f52697b4dd5 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #30 0x00007f5267b70ead in clone () from /lib64/libc.so.6 No symbol table info available.