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

InnoDB Cannot close file Pending operations and pending fsync

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.16
    • None
    • None
    • Ubuntu 20, mariadb 10.6.16, fully NVME pcie 4.0, high end server, hundreds databases with hundreds tables

    Description

      Hi,

      we have version 10.6 more than year. Yesterday we updated to 10.6.16 (before 10.6.12), we hoped it will solve our problem, but it doesn't.

      ur mariadb error log is filled repeatelly with problems with pending operations, pending fsync.

      Don't know what's problem. I know, its 'NOTE", not 'WARNING'/'ERROR', but...

      Example of 3 types of "error":
      A) pending fsync:
      [Note] InnoDB: Cannot close file ./XXX/YYY.ibd because of pending fsync

      B) pending operations:
      [Note] InnoDB: Cannot close file ./XXX/YYY.ibd because of 4 pending operations

      C) both:
      [Note] InnoDB: Cannot close file ./XXX/YYY.ibd because of 8 pending operations and pending fsync

      Every time its another database or table, not same. We have about 100 lines per day logged with this.

      We are thinking to upgrade 10.6 to 10.11, but not sure, if this can helps, because 10.6 is still maintained for long time, so...

      If it will necessary, I can provide more informations, ask me if something else is needed.
      MariaDB 10.1 and 10.3 without problem.
      We have high end server and fully nvme pcie 4.0 drivers.
      We have hundreds of databases and every database have hundreds of tables.
      We aren't facing any problems with real performance.
      Ubuntu 20, kernel 5.4.0-156-generic
      2x CPU Intel(R) Xeon(R) Gold 5218R CPU @ 2.10GHz (Total 40 cores, 80 threads)
      innodb_buffer_pool_size=200G
      innodb_io_capacity=2000
      innodb_io_capacity_max=4000
      Total server RAM is 756G

      Thank you.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              shaim Dominik Shaim
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.