Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-7512

Some threads with DML(delete/insert ) stuck in a hang state.

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.

       

       

      Attachments

        Issue Links

          Activity

            People

              marcelo.altmann Marcelo Altmann
              lalit.choudhary Lalit Choudhary
              Votes:
              1 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Time Spent - 4 days, 18 minutes Remaining Estimate - 3 hours, 54 minutes
                  3h 54m
                  Logged:
                  Time Spent - 4 days, 18 minutes Remaining Estimate - 3 hours, 54 minutes
                  4d 18m

                  Smart Checklist