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

InnoDB: A long semaphore wait

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.2.36
    • N/A
    • Storage Engine - InnoDB
    • Red Hat Enterprise Linux Server release 6.10 (Santiago)
      Dual Intel(R) Xeon(R) CPU E5-2660 v3 @ 2.60GHz, 256GB RAM, SSD storage

    Description

      Since few weeks we observe constant DB crashes every night around 1AM. We tried to check everything but we cannot pinpoint the root cause of the crashes. Can you please point us in the right direction? I'm attaching the crash log, unfortunately I don't have root access to server so I cannot collect crash dumps, but if those will be needed I will try to chase administrator of that server for help.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24378 Crashes on Semaphore wait > 600 seconds

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

          Activity

            Ascending order - Click to sort in descending order
            skibbi Cristiano Niguerola created issue -
            alice Alice Sherepa made changes -
            Field Original Value New Value
            alice Alice Sherepa added a comment -

            it looks related to MDEV-24378, so maybe upgrade to 10.2.37 will help

            alice Alice Sherepa added a comment - it looks related to MDEV-24378 , so maybe upgrade to 10.2.37 will help
            skibbi Cristiano Niguerola added a comment -

            I was afraid of this answer. Unfortunately due to old RedHat we cannot upgrade to anything newer at the moment

            skibbi Cristiano Niguerola added a comment - I was afraid of this answer. Unfortunately due to old RedHat we cannot upgrade to anything newer at the moment
            alice Alice Sherepa made changes -
            Assignee Marko Mäkelä [ marko ]
            elenst Elena Stepanova added a comment -

            Why does old RedHat prevent you from upgrading 10.2.36 to 10.2.37? If you are using MariaDB repository, 10.2 is still provided for RHEL 6, so 10.2.37 should be available.
            Or are you using MariaDB packages from the RedHat-owned repo, and they don't update it anymore?
            Technically you can still switch to MariaDB repo, but you would have to uninstall the old one first and then install the new one, direct upgrade won't work. I imagine you don't want to do it without a good reason in production, but maybe you could try it in staging to see if it helps to get rid of the problem.

            elenst Elena Stepanova added a comment - Why does old RedHat prevent you from upgrading 10.2.36 to 10.2.37? If you are using MariaDB repository, 10.2 is still provided for RHEL 6, so 10.2.37 should be available. Or are you using MariaDB packages from the RedHat-owned repo, and they don't update it anymore? Technically you can still switch to MariaDB repo, but you would have to uninstall the old one first and then install the new one, direct upgrade won't work. I imagine you don't want to do it without a good reason in production, but maybe you could try it in staging to see if it helps to get rid of the problem.
            elenst Elena Stepanova made changes -
            Labels crash crash need_feedback
            skibbi Cristiano Niguerola added a comment -

            There are no mariadb 10.2.37 under this link:
            https://downloads.mariadb.com/MariaDB/mariadb-10.2.37/yum/rhel6-amd64/rpms/
            Are you suggesting us to use those:
            https://downloads.mariadb.com/MariaDB/mariadb-10.2.37/bintar-linux-systemd-x86_64/
            Are they compatible with RHEL6?

            skibbi Cristiano Niguerola added a comment - There are no mariadb 10.2.37 under this link: https://downloads.mariadb.com/MariaDB/mariadb-10.2.37/yum/rhel6-amd64/rpms/ Are you suggesting us to use those: https://downloads.mariadb.com/MariaDB/mariadb-10.2.37/bintar-linux-systemd-x86_64/ Are they compatible with RHEL6?
            elenst Elena Stepanova added a comment -

            I'm not sure why they are not available there. You can find the packages at mariadb.org:
            http://yum.mariadb.org/10.2.37/rhel6-amd64/

            elenst Elena Stepanova added a comment - I'm not sure why they are not available there. You can find the packages at mariadb.org: http://yum.mariadb.org/10.2.37/rhel6-amd64/
            elenst Elena Stepanova made changes -
            Component/s Storage Engine - InnoDB [ 10129 ]
            Fix Version/s N/A [ 14700 ]
            Resolution Incomplete [ 4 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 120095 ] MariaDB v4 [ 159022 ]

            People

              marko Marko Mäkelä
              skibbi Cristiano Niguerola
              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.