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

"a long semaphore wait" After Upgrading to 10.1.41

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.1.41
    • 10.1
    • None
    • CentOS Linux release 7.6.1810

    Description

      Ever since we upgraded to 10.1.41, we have been having non-stop issues in several of our large servers where the logs start filling up with semaphore errors and working with any InnoDB table seems to lock up.

      Doing research, I found people talking about disabling the `innodb_adaptive_hash_index` by setting it to 0 to fix the issue, and I have tried this without success. With it disabled, the issue still crops back up.

      Doing some more research, I found issue #16467 (https://jira.mariadb.org/browse/MDEV-16467) which was in the update log for MariaDB 10.1.41, so I am wondering if that is related to our issues.

      Any help will be awesome. I have attached the log output we see.

      Attachments

        1. dump.txt
          162 kB
          James Coleman
        2. InnoDB Monitor Output Log.txt
          52 kB
          James Coleman

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              james.coleman-ah James Coleman
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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