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

MariaDB server hang with all threads idle

    XMLWordPrintable

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

        1. mariadb-hang.txt
          85 kB
          Alex Strange
        2. mysql gdb.txt
          166 kB
          Alex Strange

        Activity

          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.