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

Long semaphore wait crash

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 5.5.33a
    • 5.5.34
    • None
    • Debian Squeeze, 64 bit

    Description

      Our MariaDB server is crashing on long semaphor wait. It is happening usually at night when database backups are running (but sometimes also in the middle of the day). I'm 100% sure it's related to one of our users because when i moved him to different server, the problem moves with him. There were enough of memory and we had the same problem with MySQL 5.5. Everytime it happend, the mentioned user is running simultanious SELECT and TRUNCATE on the same table.

      Attachments

        1. mysql2.log.gz
          98 kB
        2. mysql.log.gz
          53 kB
        3. my.cnf
          6 kB
        4. index_products.frm
          8 kB
        5. global_variables.txt
          11 kB

        Activity

          People

            jplindst Jan Lindström (Inactive)
            azurit azurit
            Votes:
            0 Vote for this issue
            Watchers:
            7 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.