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

FULLTEXT INDEX activity causes InnoDB hang

    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

              • Assignee:
                thiru Thirunarayanan Balathandayuthapani
                Reporter:
                Novkovski Stevo
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: