Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Duplicate
-
8.0.21-12
-
None
-
None
-
None
Description
Some thread with DML(delete/insert ) stuck in a hang state.
mysql -e "show full processlist"|grep -iv sleep Id User Host db Command Time State Info Rows_sent Rows_examined 2560149 <user> localhost NULL Killed 1096282 updating /* */ DELETE FROM
---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 6596591616 Dictionary memory allocated 9403499 Buffer pool size 393168 Buffer pool size, bytes 6441664512 Free buffers 32806 Database pages 576642 Old database pages 212708 Modified db pages 439630 Pending reads 0 Pending writes: LRU 0, flush list 6, single page 0 Pages made young 12901069, not young 409442897 0.00 youngs/s, 0.00 non-youngs/s Pages read 160589051, created 10369431, written 211927853 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 576642, unzip_LRU len: 57894 I/O sum[0]:cur[0], unzip sum[0]:cur[0]
threads are stuck for a long time with the same pending flush list writes. And the issue is only resolved by restarting MySQL. Killing the thread has no effect as the thread then just stays in the Killed state.