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

FULLTEXT INDEX activity causes InnoDB hang

    XMLWordPrintable

Details

    Description

      We are experiencing technical difficulties with the latest MariaDB 10.1.41-MariaDB.
      This is only happening on one server while we have more with the same system package versions.

      The database is freezing and does not accept new connections.
      The error_log shows so much error data eg:

      InnoDB: Warning: a long semaphore wait:
      		 
      --Thread 140300680931072 has waited at dict0dict.cc line 984 for 241.00 seconds the semaphore:
      		 
      Mutex at 0x7f9e26c112e8 '&dict_sys->mutex', lock var 1
      		 
      Last time reserved by thread 140300697716480 in file not yet reserved line 0, waiters flag 1
      		 
      InnoDB: Warning: semaphore wait:
      		 
      --Thread 140300680931072 has waited at dict0dict.cc line 984 for 241.00 seconds the semaphore:
      		 
      Mutex at 0x7f9e26c112e8 '&dict_sys->mutex', lock var 1
      		 
      Last time reserved by thread 140300697716480 in file not yet reserved line 0, waiters flag 1

      We can provide more error log data but not in a public.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20987 InnoDB fails to start when fts table has FK relation

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23856 fts_optimize_wq accessed after shutdown of FTS Optimize thread

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19529 InnoDB hang on DROP FULLTEXT INDEX

          • Major - Major loss of function.
          • Closed

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              Novkovski Stevo
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.