WARNING: --Thread 15672 has waited at trx0rseg.ic line 46 for 269.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 00000003C8D90480 '&block->lock' a writer (thread id 15672) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffff Last time read locked in file buf0flu.c line 1340 Last time write locked in file D:\winx64-packages\build\src\storage\xtradb\include\trx0rseg.ic line 46 STACK: Id: 5a24.3d38 (0x3d38 == 15672) pfs_rw_lock_x_lock_func+0x7c [include\sync0rw.ic @ 696] buf_page_get_gen+0x62a [buf\buf0buf.c @ 2961] trx_rsegf_get+0x39 [include\trx0rseg.ic @ 49] trx_purge_truncate_rseg_history+0x80 [trx\trx0purge.c @ 549] trx_purge_truncate_history+0x8e [trx\trx0purge.c @ 658] trx_purge_fetch_next_rec+0x51 [trx\trx0purge.c @ 1086] row_purge+0x29 [row\row0purge.c @ 759] row_purge_step+0x18 [row\row0purge.c @ 818] que_thr_step+0x208 [que\que0que.c @ 1259] que_run_threads_low+0x3d [que\que0que.c @ 1319] que_run_threads+0x30 [que\que0que.c @ 1358] trx_purge+0x1f7 [trx\trx0purge.c @ 1229] srv_purge_thread+0x17e [srv\srv0srv.c @ 4219] WARNING: --Thread 19348 has waited at trx0rseg.ic line 46 for 534.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 00000003C8D80AC0 '&block->lock' a writer (thread id 19348) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffff Last time read locked in file buf0flu.c line 1340 Last time write locked in file D:\winx64-packages\build\src\storage\xtradb\include\trx0rseg.ic line 46 STACK: Id: 5a24.3a3c (0x3a3c == 19348) pfs_rw_lock_x_lock_func+0x7c [include\sync0rw.ic @ 696] buf_page_get_gen+0x62a [buf\buf0buf.c @ 2961] trx_undo_page_get+0x3b [include\trx0undo.ic @ 159] trx_undo_reuse_cached+0x16d [trx\trx0undo.c @ 1664] trx_undo_assign_undo+0x89 [trx\trx0undo.c @ 1761] trx_undo_report_row_operation+0x15e [trx\trx0rec.c @ 1270] btr_cur_del_mark_set_clust_rec+0xb0 [btr\btr0cur.c @ 3036] row_upd_del_mark_clust_rec+0x79 [row\row0upd.c @ 2116] row_upd_clust_step+0x1e7 [row\row0upd.c @ 2228] row_upd+0x77 [row\row0upd.c @ 2339] row_upd_step+0xcd [row\row0upd.c @ 2482] row_update_for_mysql+0x13d [row\row0mysql.c @ 1505] ha_innobase::delete_row+0xac [handler\ha_innodb.cc @ 6816] handler::ha_delete_row+0x91 [sql\handler.cc @ 5261] mysql_delete+0x89d [sql\sql_delete.cc @ 346] mysql_execute_command+0x13db [sql\sql_parse.cc @ 3105] mysql_parse+0x104 [sql\sql_parse.cc @ 5936] dispatch_command+0x7ad [sql\sql_parse.cc @ 1082] do_command+0xff [sql\sql_parse.cc @ 793] do_handle_one_connection+0x146 [sql\sql_connect.cc @ 1268] handle_one_connection+0x44 [sql\sql_connect.cc @ 1186] WARNING --Thread 11552 has waited at fsp0fsp.c line 2998 for 534.00 seconds the semaphore: X-lock on RW-latch at 000000001327BDF0 '&space->latch' a writer (thread id 23448) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file D:\winx64-packages\build\src\storage\xtradb\fsp\fsp0fsp.c line 2998 STACK : Id: 5a24.2d20(0x2d20 == 11552) mtr_x_lock_func+0x1d [include\mtr0mtr.ic @ 294] fsp_reserve_free_extents+0x68 [fsp\fsp0fsp.c @ 3000] btr_cur_pessimistic_update+0x1ae [btr\btr0cur.c @ 2588] row_upd_clust_rec+0x122 [row\row0upd.c @ 2010] row_upd_clust_step+0x2e3 [row\row0upd.c @ 2290] row_upd+0x77 [row\row0upd.c @ 2339] row_upd_step+0xcd [row\row0upd.c @ 2482] row_update_for_mysql+0x13d [row\row0mysql.c @ 1505] ha_innobase::update_row+0x193 [handler\ha_innodb.cc @ 6702] handler::ha_update_row+0x9c [sql\handler.cc @ 5235] mysql_update+0xd83 [sql\sql_update.cc @ 767] mysql_execute_command+0xfda [sql\sql_parse.cc @ 2849] mysql_parse+0x104 [sql\sql_parse.cc @ 5936] dispatch_command+0x7ad [sql\sql_parse.cc @ 1082] do_command+0xff [sql\sql_parse.cc @ 793] do_handle_one_connection+0x146 [sql\sql_connect.cc @ 1268] handle_one_connection+0x44 [sql\sql_connect.cc @ 1186] WARNING --Thread 18256 has waited at trx0rseg.ic line 46 for 534.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 00000003C8D7FB90 '&block->lock' a writer (thread id 18256) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffff Last time read locked in file buf0flu.c line 1340 Last time write locked in file D:\winx64-packages\build\src\storage\xtradb\include\trx0rseg.ic line 46 STACK Id: 5a24.4750 (0x4750 == 18256) pfs_rw_lock_x_lock_func+0x7c [include\sync0rw.ic @ 696] buf_page_get_gen+0x62a [buf\buf0buf.c @ 2961] trx_rsegf_get+0x39 [include\trx0rseg.ic @ 49] trx_purge_add_update_undo_to_history+0x49 [trx\trx0purge.c @ 347] trx_undo_update_cleanup+0x25 [trx\trx0undo.c @ 1915] trx_write_serialisation_history+0x89 [trx\trx0trx.c @ 1039] <---ACQUIRES &rseg->mutex trx_commit_off_kernel+0x42 [trx\trx0trx.c @ 1147] trx_commit_for_mysql+0x46 [trx\trx0trx.c @ 1939] innobase_commit_ordered_2+0x1e7 [handler\ha_innodb.cc @ 3564] innobase_commit+0xe8 [handler\ha_innodb.cc @ 3705] commit_one_phase_2+0x51 [sql\handler.cc @ 1408] ha_commit_trans+0x33f [sql\handler.cc @ 1279] trans_commit+0x30 [sql\transaction.cc @ 187] mysql_execute_command+0x281b [sql\sql_parse.cc @ 3831] mysql_parse+0x104 [sql\sql_parse.cc @ 5936] dispatch_command+0x7ad [sql\sql_parse.cc @ 1082] do_command+0xff [sql\sql_parse.cc @ 793] do_handle_one_connection+0x146 [sql\sql_connect.cc @ 1268] handle_one_connection+0x44 [sql\sql_connect.cc @ 1186] WARNING --Thread 9328 has waited at trx0undo.ic line 156 for 534.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 000000030E1CC930 '&block->lock' a writer (thread id 9328) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffff Last time read locked in file buf0flu.c line 1340 Last time write locked in file D:\winx64-packages\build\src\storage\xtradb\include\trx0undo.ic line 156 STACK Id: 5a24.2470 (0x2470 == 9328) pfs_rw_lock_x_lock_func+0x7c [include\sync0rw.ic @ 696] buf_page_get_gen+0x62a [buf\buf0buf.c @ 2961] trx_undo_page_get+0x3b [include\trx0undo.ic @ 159] trx_undo_reuse_cached+0x16d [trx\trx0undo.c @ 1664] trx_undo_assign_undo+0x89 [trx\trx0undo.c @ 1761] trx_undo_report_row_operation+0x129 [trx\trx0rec.c @ 1251] btr_cur_ins_lock_and_undo+0xee [btr\btr0cur.c @ 1314] btr_cur_optimistic_insert+0x2b1 [btr\btr0cur.c @ 1519] row_ins_index_entry_low+0x3aa [row\row0ins.c @ 2189] row_ins_index_entry+0x64 [row\row0ins.c @ 2303] row_ins_index_entry_step+0x3c [row\row0ins.c @ 2393] row_ins+0x6e [row\row0ins.c @ 2524] row_ins_step+0xe6 [row\row0ins.c @ 2642] row_insert_for_mysql+0x168 [row\row0mysql.c @ 1255] ha_innobase::write_row+0x235 [handler\ha_innodb.cc @ 6371] handler::ha_write_row+0x91 [sql\handler.cc @ 5206] write_record+0x86 [sql\sql_insert.cc @ 1844] mysql_insert+0x6ed [sql\sql_insert.cc @ 986] mysql_execute_command+0x118f [sql\sql_parse.cc @ 2974] mysql_parse+0x104 [sql\sql_parse.cc @ 5936] dispatch_command+0x7ad [sql\sql_parse.cc @ 1082] do_command+0xff [sql\sql_parse.cc @ 793] do_handle_one_connection+0x146 [sql\sql_connect.cc @ 1268] handle_one_connection+0x44 [sql\sql_connect.cc @ 1186] WARNING --Thread 22296 has waited at row0upd.c line 2177 for 531.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0000000152D1A4C0 '&block->lock' a writer (thread id 22296) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffff Last time read locked in file row0sel.c line 4046 Last time write locked in file D:\winx64-packages\build\src\storage\xtradb\row\row0ins.c line 2033 STACK Id: 5a24.5718 (0x5718 = 22296) pfs_rw_lock_x_lock_func+0x7c [include\sync0rw.ic @ 696] buf_page_get_gen+0x62a [buf\buf0buf.c @ 2961] btr_cur_search_to_nth_level+0x397 [btr\btr0cur.c @ 736] btr_pcur_open_with_no_init_func+0x67 [include\btr0pcur.ic @ 485] btr_pcur_restore_position_func+0x191 [btr\btr0pcur.c @ 346] row_upd_clust_step+0xbb [row\row0upd.c @ 2179] row_upd+0x77 [row\row0upd.c @ 2339] row_upd_step+0xcd [row\row0upd.c @ 2482] row_update_for_mysql+0x13d [row\row0mysql.c @ 1505] ha_innobase::delete_row+0xac [handler\ha_innodb.cc @ 6816] handler::ha_delete_row+0x91 [sql\handler.cc @ 5261] mysql_delete+0x89d [sql\sql_delete.cc @ 346] mysql_execute_command+0x13db [sql\sql_parse.cc @ 3105] mysql_parse+0x104 [sql\sql_parse.cc @ 5936] dispatch_command+0x7ad [sql\sql_parse.cc @ 1082] do_command+0xff [sql\sql_parse.cc @ 793] do_handle_one_connection+0x146 [sql\sql_connect.cc @ 1268] handle_one_connection+0x44 [sql\sql_connect.cc @ 1186] WARNING --Thread 9120 has waited at trx0undo.c line 1758 for 534.00 seconds the semaphore: Mutex at 0000006570D4ECE0 '&rseg->mutex', lock var 1 waiters flag 1 Id: 5a24.23a0 (0x23a0 == 9120) pfs_mutex_enter_func+0x6f [include\sync0sync.ic @ 255] trx_undo_assign_undo+0x5e [trx\trx0undo.c @ 1761] <--- WAITS FOR &rseg->mutex trx_undo_report_row_operation+0x15e [trx\trx0rec.c @ 1270] btr_cur_del_mark_set_clust_rec+0xb0 [btr\btr0cur.c @ 3036] row_upd_del_mark_clust_rec+0x79 [row\row0upd.c @ 2116] row_upd_clust_step+0x1e7 [row\row0upd.c @ 2228] row_upd+0x77 [row\row0upd.c @ 2339] row_upd_step+0xcd [row\row0upd.c @ 2482] row_update_for_mysql+0x13d [row\row0mysql.c @ 1505] ha_innobase::delete_row+0xac [handler\ha_innodb.cc @ 6816] handler::ha_delete_row+0x91 [sql\handler.cc @ 5261] mysql_delete+0x89d [sql\sql_delete.cc @ 346] mysql_execute_command+0x13db [sql\sql_parse.cc @ 3105] mysql_parse+0x104 [sql\sql_parse.cc @ 5936] dispatch_command+0x7ad [sql\sql_parse.cc @ 1082] do_command+0xff [sql\sql_parse.cc @ 793] do_handle_one_connection+0x146 [sql\sql_connect.cc @ 1268] handle_one_connection+0x44 [sql\sql_connect.cc @ 1186] WARNING --Thread 6064 has waited at row0ins.c line 2033 for 534.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 000000035A297270 '&block->lock' a writer (thread id 6064) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffff Last time read locked in file buf0flu.c line 1340 STACK Id: 5a24.17b0 (0x17b0 == 6064) pfs_rw_lock_x_lock_func+0x7c [include\sync0rw.ic @ 696] buf_page_get_gen+0x62a [buf\buf0buf.c @ 2961] btr_cur_search_to_nth_level+0x397 [btr\btr0cur.c @ 736] row_ins_index_entry_low+0x101 [row\row0ins.c @ 2035] row_ins_index_entry+0x64 [row\row0ins.c @ 2303] row_ins_index_entry_step+0x3c [row\row0ins.c @ 2393] row_ins+0x6e [row\row0ins.c @ 2524] row_ins_step+0xe6 [row\row0ins.c @ 2642] row_insert_for_mysql+0x168 [row\row0mysql.c @ 1255] ha_innobase::write_row+0x235 [handler\ha_innodb.cc @ 6371] handler::ha_write_row+0x91 [sql\handler.cc @ 5206] write_record+0x86 [sql\sql_insert.cc @ 1844] mysql_insert+0x6ed [sql\sql_insert.cc @ 986] mysql_execute_command+0x118f [sql\sql_parse.cc @ 2974] mysql_parse+0x104 [sql\sql_parse.cc @ 5936] dispatch_command+0x7ad [sql\sql_parse.cc @ 1082] do_command+0xff [sql\sql_parse.cc @ 793] do_handle_one_connection+0x146 [sql\sql_connect.cc @ 1268] handle_one_connection+0x44 [sql\sql_connect.cc @ 1186] WARNING --Thread 23448 has waited at btr0btr.c line 738 for 534.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 00000001AE004C10 '&block->lock' a writer (thread id 23448) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffff Last time read locked in file buf0flu.c line 1340 Last time write locked in file D:\winx64-packages\build\src\storage\xtradb\btr\btr0btr.c line 738 STACK Id: 5a24.5b98 (0x5b98 == 23448) pfs_rw_lock_x_lock_func+0x7c [include\sync0rw.ic @ 696] buf_page_get_gen+0x62a [buf\buf0buf.c @ 2961] btr_block_get_func+0x42 [include\btr0btr.ic @ 62] btr_root_block_get+0x62 [btr\btr0btr.c @ 738] btr_root_get+0x15 [btr\btr0btr.c @ 778] btr_page_alloc_low+0x2b [btr\btr0btr.c @ 995] btr_page_alloc+0x5d [btr\btr0btr.c @ 1047] btr_page_split_and_insert+0x203 [btr\btr0btr.c @ 2674] btr_cur_pessimistic_insert+0x1b5 [btr\btr0cur.c @ 1756] row_ins_index_entry_low+0x449 [row\row0ins.c @ 2205] row_ins_index_entry+0x9e [row\row0ins.c @ 2315] row_ins_index_entry_step+0x3c [row\row0ins.c @ 2393] row_ins+0x6e [row\row0ins.c @ 2524] row_ins_step+0xe6 [row\row0ins.c @ 2642] row_insert_for_mysql+0x168 [row\row0mysql.c @ 1255] ha_innobase::write_row+0x235 [handler\ha_innodb.cc @ 6371] handler::ha_write_row+0x91 [sql\handler.cc @ 5206] write_record+0x86 [sql\sql_insert.cc @ 1844] mysql_insert+0x6ed [sql\sql_insert.cc @ 986] mysql_execute_command+0x118f [sql\sql_parse.cc @ 2974] mysql_parse+0x104 [sql\sql_parse.cc @ 5936] dispatch_command+0x7ad [sql\sql_parse.cc @ 1082] do_command+0xff [sql\sql_parse.cc @ 793] do_handle_one_connection+0x146 [sql\sql_connect.cc @ 1268] handle_one_connection+0x44 [sql\sql_connect.cc @ 1186]