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

          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.