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

MariaDB server hang with all threads idle

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.0.17
    • N/A
    • Platform FreeBSD
    • None
    • FreeBSD 10.1-RELEASE-p7 / x86-64 / MariaDB 10.0.17

    Description

      I have a production MariaDB server which is occasionally experiencing a hang; it refuses new connections, does not create any more threads, and stays at 0% cpu until forced to restart.

      I'm using threadpool:
      thread_handling=pool-of-threads
      thread_pool_size=48
      thread_pool_max_threads=128
      thread_pool_idle_timeout=30

      and xtrabackup. The issue always occurs around the same time of day (once every week or two) so I suspect it may be related to xtrabackup's pausing the server to backup.

      Captured a gdb backtrace in this state, but imposed a workaround of restarting the process rather than try to debug further, since the server is being used.

      Attachments

        Activity

          astrange Alex Strange created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Labels need_feedback
          elenst Elena Stepanova made changes -
          Assignee Jan Lindström [ jplindst ]
          serg Sergei Golubchik made changes -
          Assignee Jan Lindström [ jplindst ]
          elenst Elena Stepanova made changes -
          Component/s OTHER [ 10125 ]
          Fix Version/s N/A [ 14700 ]
          Resolution Incomplete [ 4 ]
          Status Open [ 1 ] Closed [ 6 ]
          astrange Alex Strange made changes -
          Attachment mariadb-hang.txt [ 40415 ]
          elenst Elena Stepanova made changes -
          Labels need_feedback
          elenst Elena Stepanova made changes -
          Resolution Incomplete [ 4 ]
          Status Closed [ 6 ] Stalled [ 10000 ]
          elenst Elena Stepanova made changes -
          Fix Version/s 10.0 [ 16000 ]
          Fix Version/s N/A [ 14700 ]
          Assignee Vladislav Vaintroub [ wlad ]
          wlad Vladislav Vaintroub made changes -
          Component/s Platform FreeBSD [ 10139 ]
          Component/s OTHER [ 10125 ]
          Fix Version/s N/A [ 14700 ]
          Fix Version/s 10.0 [ 16000 ]
          Resolution Incomplete [ 4 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 69800 ] MariaDB v4 [ 149227 ]

          People

            wlad Vladislav Vaintroub
            astrange Alex Strange
            Votes:
            0 Vote for this issue
            Watchers:
            6 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.