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

Threads stuck waiting for mutex on THD::release_resources

Details

    • Bug
    • Status: On Hold
    • Medium
    • Resolution: Unresolved
    • 8.0.21-12
    • None
    • None
    • None

    Description

      Waiting on change buffer mutexes while global variables are locked by SHOW ENGINE INNODB STATUS:

      Thread 8238 (Thread 0x7f1819997700 (LWP 8287)):
      #0 0x00007f1ba2e03f7c in __lll_lock_wait () from /lib/x86_64-linux-gnu/libpthread.so.0
      #1 0x00007f1ba2dfdce6 in pthread_mutex_lock () from /lib/x86_64-linux-gnu/libpthread.so.0
      #2 0x000055c6cd073ea8 in native_mutex_lock (mutex=<optimized out>) at /mnt/workspace/percona-server-8.0-debian-binary-cve/label_exp/min-stretch-x64/test/percona-server-8.0.21-12/include/thr_mutex.h:93
      #3 my_mutex_lock (mp=<optimized out>) at /mnt/workspace/percona-server-8.0-debian-binary-cve/label_exp/min-stretch-x64/test/percona-server-8.0.21-12/include/thr_mutex.h:189
      #4 inline_mysql_mutex_lock (src_line=1090, src_file=0x55c6ceedd390 "/mnt/workspace/percona-server-8.0-debian-binary-cve/label_exp/min-stretch-x64/test/percona-server-8.0.21-12/sql/sql_class.cc", that=<optimized out>) at /mnt/workspace/percona-server-8.0-debian-binary-cve/label_exp/min-stretch-x64/test/percona-server-8.0.21-12/include/mysql/psi/mysql_mutex.h:255
      #5 THD::release_resources (this=this@entry=0x7f1880248000) at /mnt/workspace/percona-server-8.0-debian-binary-cve/label_exp/min-stretch-x64/test/percona-server-8.0.21-12/sql/sql_class.cc:1090
      #6 0x000055c6cd21938b in handle_connection ([email protected]=0x7f1842e23060) at /mnt/workspace/percona-server-8.0-debian-binary-cve/label_exp/min-stretch-x64/test/percona-server-8.0.21-12/sql/conn_handler/connection_handler_per_thread.cc:315
      #7 0x000055c6ce4e764d in pfs_spawn_thread (arg=0x7f1ba0062d60) at /mnt/workspace/percona-server-8.0-debian-binary-cve/label_exp/min-stretch-x64/test/percona-server-8.0.21-12/storage/perfschema/pfs.cc:2881
      #8 0x00007f1ba2dfb4a4 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #9 0x00007f1ba0ca6d0f in clone () from /lib/x86_64-linux-gnu/libc.so.6

       

       

      Attachments

        Issue Links

          Activity

            People

              marcelo.altmann Marcelo Altmann
              fernando.laudares@percona.com Fernando Laudares
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Time Spent - 2 weeks, 3 days, 6 hours, 17 minutes Remaining Estimate - 36 minutes
                  36m
                  Logged:
                  Time Spent - 2 weeks, 3 days, 6 hours, 17 minutes Remaining Estimate - 36 minutes
                  2w 3d 6h 17m

                  Smart Checklist