mysqld, thd->thread_id = 32: Thread 25 (Thread 0x7f4825e3f700 (LWP 3680)): #0 TrxInInnoDB::exit (trx=trx@entry=0x7f61594df418) at /coriant/mariadb/10.2.10/storage/innobase/include/trx0trx.h:1532 #1 0x00005586b5456859 in end_stmt (trx=0x7f61594df418) at /coriant/mariadb/10.2.10/storage/innobase/include/trx0trx.h:1451 #2 end_stmt (this=) at /coriant/mariadb/10.2.10/storage/innobase/handler/ha_innodb.cc:16000 #3 ha_innobase::reset (this=) at /coriant/mariadb/10.2.10/storage/innobase/handler/ha_innodb.cc:16014 #4 0x00005586b50dab68 in close_thread_table (thd=thd@entry=0x7f47600009a8, table_ptr=table_ptr@entry=0x7f4760000a68) at /coriant/mariadb/10.2.10/sql/sql_base.cc:891 #5 0x00005586b50dacfb in close_thread_tables (thd=0x7f47600009a8) at /coriant/mariadb/10.2.10/sql/sql_base.cc:848 #6 0x00005586b5139e54 in Prepared_statement::prepare (this=this@entry=0x7f4760006098, packet=packet@entry=0x7f47608f24f9 "", packet_len=packet_len@entry=221) at /coriant/mariadb/10.2.10/sql/sql_prepare.cc:3972 #7 0x00005586b513be0d in mysqld_stmt_prepare (thd=0x7f47600009a8, packet=0x7f47608f24f9 "", packet_length=221) at /coriant/mariadb/10.2.10/sql/sql_prepare.cc:2654 #8 0x00005586b512c9dd in dispatch_command (command=command@entry=COM_STMT_PREPARE, thd=thd@entry=0x7f47600009a8, packet=packet@entry=0x7f47608f24f9 "", packet_length=packet_length@entry=221, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /coriant/mariadb/10.2.10/sql/sql_parse.cc:1762 #9 0x00005586b512da69 in do_command (thd=0x7f47600009a8) at /coriant/mariadb/10.2.10/sql/sql_parse.cc:1360 #10 0x00005586b51f1a5a in do_handle_one_connection (connect=connect@entry=0x558747f7b568) at /coriant/mariadb/10.2.10/sql/sql_connect.cc:1354 #11 0x00005586b51f1b7d in handle_one_connection (arg=arg@entry=0x558747f7b568) at /coriant/mariadb/10.2.10/sql/sql_connect.cc:1260 #12 0x00005586b57e937d in pfs_spawn_thread (arg=0x558747b2a228) at /coriant/mariadb/10.2.10/storage/perfschema/pfs.cc:1863 #13 0x00007f616ac8de25 in start_thread () from /lib64/libpthread.so.0 #14 0x00007f6169d7434d in clone () from /lib64/libc.so.6 mysqld, thd->thread_id = 62: Thread 12 (Thread 0x7f4825a7d700 (LWP 3939)): #0 0x00007f616ac91945 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00005586b54cefd1 in wait (this=) at /coriant/mariadb/10.2.10/storage/innobase/os/os0event.cc:166 #2 wait_low (reset_sig_count=, this=0x7f48380103d0) at /coriant/mariadb/10.2.10/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x7f48380103d0, reset_sig_count=) at /coriant/mariadb/10.2.10/storage/innobase/os/os0event.cc:535 #4 0x00005586b556b068 in sync_array_wait_event (arr=0x5586b71bd3b0, cell=@0x7f4825a7a000: 0x7f61598db390) at /coriant/mariadb/10.2.10/storage/innobase/sync/sync0arr.cc:475 #5 0x00005586b5469b65 in enter (line=, filename=, max_delay=, max_spins=60, this=0x7f61594df418) at /coriant/mariadb/10.2.10/storage/innobase/include/ib0mutex.h:516 #6 PolicyMutex >::enter (this=this@entry=0x7f61594df418, n_spins=, n_delay=, name=name@entry=0x5586b598d228 "/coriant/mariadb/10.2.10/storage/innobase/include/trx0trx.h", line=line@entry=1502) at /coriant/mariadb/10.2.10/storage/innobase/include/ib0mutex.h:635 #7 0x00005586b545eda8 in enter (disable=false, trx=0x7f61594df418) at /coriant/mariadb/10.2.10/storage/innobase/include/trx0trx.h:1502 #8 TrxInInnoDB (disable=false, trx=, this=) at /coriant/mariadb/10.2.10/storage/innobase/include/trx0trx.h:1397 #9 innobase_commit (hton=0x5586b71857f8, thd=0x7f47280009a8, commit_trx=) at /coriant/mariadb/10.2.10/storage/innobase/handler/ha_innodb.cc:4735 #10 0x00005586b52b62d6 in commit_one_phase_2 (trans=0x7f4728003a98, trans=0x7f4728003a98, is_real_trans=false, all=false, thd=0x7f47280009a8) at /coriant/mariadb/10.2.10/sql/handler.cc:1567 #11 ha_commit_trans (thd=thd@entry=0x7f47280009a8, all=all@entry=false) at /coriant/mariadb/10.2.10/sql/handler.cc:1454 #12 0x00005586b51ff7a7 in trans_commit_stmt (thd=thd@entry=0x7f47280009a8) at /coriant/mariadb/10.2.10/sql/transaction.cc:510 #13 0x00005586b5121704 in mysql_execute_command (thd=) at /coriant/mariadb/10.2.10/sql/sql_parse.cc:6235 #14 0x00005586b513ceae in Prepared_statement::execute (this=this@entry=0x7f4728006098, expanded_query=expanded_query@entry=0x7f4825a7bfa0, open_cursor=open_cursor@entry=false) at /coriant/mariadb/10.2.10/sql/sql_prepare.cc:4736 #15 0x00005586b513d03f in Prepared_statement::execute_loop (this=0x7f4728006098, expanded_query=0x7f4825a7bfa0, open_cursor=false, packet_end=, packet=) at /coriant/mariadb/10.2.10/sql/sql_prepare.cc:4165 #16 0x00005586b513dd97 in mysql_stmt_execute_common (thd=thd@entry=0x7f47280009a8, stmt_id=167435, packet=packet@entry=0x7f47288eb702 "", packet_end=packet_end@entry=0x7f47288eb702 "", cursor_flags=0, bulk_op=bulk_op@entry=false, read_types=read_types@entry=false) at /coriant/mariadb/10.2.10/sql/sql_prepare.cc:3185 #17 0x00005586b513de27 in mysqld_stmt_execute (thd=thd@entry=0x7f47280009a8, packet_arg=packet_arg@entry=0x7f47288eb6f9 "\v\216\002", packet_length=packet_length@entry=9) at /coriant/mariadb/10.2.10/sql/sql_prepare.cc:3083 #18 0x00005586b512bb72 in dispatch_command (command=command@entry=COM_STMT_EXECUTE, thd=thd@entry=0x7f47280009a8, packet=packet@entry=0x7f47288eb6f9 "\v\216\002", packet_length=packet_length@entry=9, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /coriant/mariadb/10.2.10/sql/sql_parse.cc:1747 #19 0x00005586b512da69 in do_command (thd=0x7f47280009a8) at /coriant/mariadb/10.2.10/sql/sql_parse.cc:1360 #20 0x00005586b51f1a5a in do_handle_one_connection (connect=connect@entry=0x5586b71a1978) at /coriant/mariadb/10.2.10/sql/sql_connect.cc:1354 #21 0x00005586b51f1b7d in handle_one_connection (arg=arg@entry=0x5586b71a1978) at /coriant/mariadb/10.2.10/sql/sql_connect.cc:1260 #22 0x00005586b57e937d in pfs_spawn_thread (arg=0x558747b224a8) at /coriant/mariadb/10.2.10/storage/perfschema/pfs.cc:1863 #23 0x00007f616ac8de25 in start_thread () from /lib64/libpthread.so.0 #24 0x00007f6169d7434d in clone () from /lib64/libc.so.6 p *trx (=0x7f61594df418): $19 = {mutex = {m_impl = {m_lock_word = 2, m_event = 0x7f48380103d0, m_policy = {m_count = {m_spins = 0, m_waits = 0, m_calls = 0, m_enabled = false}, m_id = LATCH_ID_TRX}}, m_ptr = 0x0}, in_depth = 1, in_innodb = 0, abort = false, id = 11255158, no = 18446744073709551615, state = TRX_STATE_ACTIVE, read_view = 0x0, trx_list = {prev = 0x7f61594dc698, next = 0x0}, no_list = {prev = 0x0, next = 0x0}, lock = {n_active_thrs = 0, que_state = TRX_QUE_RUNNING, wait_lock = 0x0, deadlock_mark = 150, was_chosen_as_deadlock_victim = false, wait_started = 1511440188, wait_thr = 0x0, rec_pool = std::vector of length 8, capacity 8 = {0x7f4838010580, 0x7f48380106d8, 0x7f4838010830, 0x7f4838010988, 0x7f4838010ae0, 0x7f4838010c38, 0x7f4838010d90, 0x7f4838010ee8}, table_pool = std::vector of length 8, capacity 8 = {0x7f48380110d0, 0x7f4838011128, 0x7f4838011180, 0x7f48380111d8, 0x7f4838011230, 0x7f4838011288, 0x7f48380112e0, 0x7f4838011338}, rec_cached = 4, table_cached = 8, lock_heap = 0x7f483800ff50, trx_locks = {count = 12, start = 0x7f48380110d0, end = 0x7f4838011338, node = &ib_lock_t::trx_locks}, table_locks = std::vector of length 8, capacity 32 = {0x7f48380110d0, 0x7f4838011128, 0x7f4838011180, 0x7f48380111d8, 0x7f4838011230, 0x7f4838011288, 0x7f48380112e0, 0x7f4838011338}, cancel = false, n_rec_locks = 20, start_stmt = true}, is_recovered = false, hit_list = empty std::list, killed_by = 0, op_info = 0x5586b59882bf "", isolation_level = 1, check_foreigns = true, is_registered = true, active_commit_ordered = 0, check_unique_secondary = true, flush_log_later = false, must_flush_log_later = false, duplicates = 0, dict_operation = TRX_DICT_OP_NONE, declared_to_be_inside_innodb = false, n_tickets_to_enter_innodb = 0, dict_operation_lock_mode = 0, start_time = 1511440294, start_time_micro = 12694764405, commit_lsn = 304497838770, table_id = 0, mysql_thd = 0x7f47280009a8, abort_type = TRX_SERVER_ABORT, mysql_log_file_name = 0x0, mysql_log_offset = 722145344, n_mysql_tables_in_use = 1, mysql_n_tables_locked = 1, mysql_trx_list = {prev = 0x7f61594df798, next = 0x7f61594df098}, error_state = DB_SUCCESS, error_info = 0x0, error_key_num = 18446744073709551615, sess = 0x558747afdd00, graph = 0x0, trx_savepoints = {count = 0, start = 0x0, end = 0x0, node = &trx_named_savept_t::trx_savepoints}, undo_mutex = {m_impl = {m_lock_word = 0, m_event = 0x7f4838010490, m_policy = {m_count = {m_spins = 0, m_waits = 0, m_calls = 0, m_enabled = false}, m_id = LATCH_ID_TRX_UNDO}}, m_ptr = 0x0}, undo_no = 174, undo_rseg_space = 0, last_sql_stat_start = {least_undo_no = 174}, rsegs = {m_redo = { rseg = 0x558747b15bb0, insert_undo = 0x7f47f48d0b20, update_undo = 0x7f473828e0f0}, m_noredo = {rseg = 0x0, undo = 0x0}}, roll_limit = 0, pages_undone = 0, n_autoinc_rows = 0, autoinc_locks = 0x7f472800ee20, read_only = false, auto_commit = false, will_lock = 3, fts_trx = 0x0, fts_next_doc_id = 0, flush_tables = 0, ddl = false, internal = false, n_ref = 0, version = 81344, xid = 0x7f483800fda0, mod_tables = std::set with 5 elements = {[0] = 0x7f47f408d8c0, [1] = 0x7f47f40f7b80, [2] = 0x7f47f413f060, [3] = 0x7f47f43c3a10, [4] = 0x7f47f44b9120}, detailed_error = 0x7f483800fe40 "", flush_observer = 0x0, n_rec_lock_waits = 0, n_table_lock_waits = 0, total_rec_lock_wait_time = 0, total_table_lock_wait_time = 0, wsrep_event = 0x0, magic_n = 91118598}