Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-29053

safe_mutex: Trying to destroy a mutex cache->lock that was locked at innobase/fts/fts0fts.cc on shutdown

    XMLWordPrintable

    Details

      Description

      Debug discussion with Thiru. Seen in bb-10.10-MDEV-28883, but likely unrelated as per discussions with Thiru. Core+mysqld+libs+error log sent via drive/email.

      10.10.0 2db18fdb3d68d906fbd188ec570a64502ba55849 (Debug)

      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x0000153a4b571859 in __GI_abort () at abort.c:79
      #2  0x000055eb6d644864 in safe_mutex_destroy (mp=mp@entry=0x1539c84caf50, 
          file=file@entry=0x55eb6da857d8 "/test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc", line=line@entry=274)
          at /test/bb-10.10-MDEV-28883_dbg/mysys/thr_mutex.c:602
      #3  0x000055eb6d57deef in inline_mysql_mutex_destroy (src_line=274, 
          src_file=0x55eb6da857d8 "/test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc", that=0x1539c84caf50)
          at /test/bb-10.10-MDEV-28883_dbg/include/mysql/psi/mysql_thread.h:724
      #4  fts_cache_destroy (cache=0x1539c84caf50) at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc:274
      #5  0x000055eb6d5828f0 in fts_t::~fts_t (this=0x1539c8201250, __in_chrg=<optimized out>)
          at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc:5080
      #6  0x000055eb6d58295c in fts_free (table=table@entry=0x1539c84c5790)
          at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc:5117
      #7  0x000055eb6d5147f5 in dict_sys_t::remove (this=this@entry=0x55eb6e05c940 <dict_sys>, table=0x1539c84c5790, 
          lru=lru@entry=false, keep=keep@entry=false) at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/dict/dict0dict.cc:1957
      #8  0x000055eb6d514cfb in dict_sys_t::close (this=0x55eb6e05c940 <dict_sys>)
          at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/dict/dict0dict.cc:4592
      #9  0x000055eb6d4025f3 in innodb_shutdown () at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/srv/srv0start.cc:1765
      #10 0x000055eb6d1fd64c in innobase_end () at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/handler/ha_innodb.cc:4310
      #11 0x000055eb6cefdff9 in ha_finalize_handlerton (plugin=0x55eb6fecc900) at /test/bb-10.10-MDEV-28883_dbg/sql/handler.cc:596
      #12 0x000055eb6cc3354a in plugin_deinitialize (plugin=0x55eb6fecc900, ref_check=ref_check@entry=true)
          at /test/bb-10.10-MDEV-28883_dbg/sql/sql_plugin.cc:1269
      #13 0x000055eb6cc3742b in reap_plugins () at /test/bb-10.10-MDEV-28883_dbg/sql/sql_plugin.cc:1343
      #14 0x000055eb6cc37f0e in plugin_shutdown () at /test/bb-10.10-MDEV-28883_dbg/sql/sql_plugin.cc:2051
      #15 0x000055eb6cadd2b0 in clean_up (print_message=print_message@entry=true) at /test/bb-10.10-MDEV-28883_dbg/sql/mysqld.cc:1987
      #16 0x000055eb6cae966c in mysqld_main (argc=<optimized out>, argv=<optimized out>)
          at /test/bb-10.10-MDEV-28883_dbg/sql/mysqld.cc:5937
      #17 0x000055eb6cadcb66 in main (argc=<optimized out>, argv=<optimized out>) at /test/bb-10.10-MDEV-28883_dbg/sql/main.cc:34
      

      10.10.0 2db18fdb3d68d906fbd188ec570a64502ba55849 (Debug)

      2022-07-02  5:06:35 0 [ERROR] InnoDB: (Too many concurrent transactions) while getting next doc id for table `test`.`articles`
      2022-07-02  5:06:35 0 [ERROR] InnoDB: (Too many concurrent transactions) during SYNC of table `test`.`articles`
      2022-07-02  5:06:35 0 [Note] InnoDB: FTS optimize thread exiting.
      2022-07-02  5:06:35 0 [Note] InnoDB: Starting shutdown...
      safe_mutex: Found wrong usage of mutex 'cache->lock' and 'LOCK_global_system_variables'
      Mutex currently locked (in reverse order):
      LOCK_global_system_variables      /test/bb-10.10-MDEV-28883_dbg/storage/innobase/buf/buf0dump.cc  line 182
      cache->lock                       /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc  line 4077
      2022-07-02  5:06:35 0 [Note] InnoDB: Dumping buffer pool(s) to /dev/shm/130567/9332/data/ib_buffer_pool
      2022-07-02  5:06:35 0 [Note] InnoDB: Buffer pool(s) dump completed at 220702  5:06:35
      safe_mutex: Trying to destroy a mutex cache->lock that was locked at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc, line 4077 at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc, line 274
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.