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

All query hangs in processlist

    XMLWordPrintable

Details

    Description

      Suddenly, all queries hang on mariadb, and can not execute normally.

      Attachments contains stack, processlist, err log, innodb status.

      From engine innodb status:

      We got the following information:

      Dictionary memory allocated 11142855
      		 
      Buffer pool size        1441791
      		 
      Buffer pool size, bytes 23622303744
      		 
      Free buffers            0
      		 
      Database pages          1302517
      		 
      Old database pages      480825
      		 
      Modified db pages       81780
      		 
      Percent of dirty pages(LRU & free pages): 6.279
      		 
      Max dirty pages percent: 75.000
      		 
      Pending reads 102

      Free buffers 0, is it normally?

      And from the stack, many threads hang on select function.

      Is this a bug?

      Attachments

        1. iostat.jpeg
          iostat.jpeg
          138 kB
        2. my3309.cnf
          2 kB
        3. processlist0.jpeg
          processlist0.jpeg
          152 kB
        4. processlist1.jpeg
          processlist1.jpeg
          181 kB
        5. processlist2.jpeg
          processlist2.jpeg
          122 kB
        6. processlist3.jpeg
          processlist3.jpeg
          181 kB
        7. SGRDB-mysql01.err
          187 kB
        8. show_engine_innodb.txt
          40 kB
        9. show_status.txt
          36 kB
        10. stack
          123 kB

        Activity

          People

            Unassigned Unassigned
            louis.hust louis hust
            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.