Uploaded image for project: 'MariaDB Foundation Development'
  1. MariaDB Foundation Development
  2. MDBF-1100

InnoDB: native AIO failed: falling back to innodb_use_native_aio=OFF

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • N/A
    • N/A
    • Buildbot
    • None

    Description

      Sporadic test failures were reported where the aio-nr-max limit was exceeded on some buildbot hosts while multiple MTR runs were present.

      Example of a failed build (intel-bbw1):
      https://buildbot.mariadb.org/#/builders/873/builds/2542

      2025-07-20 17:36:57 0 [Warning] InnoDB: native AIO failed: falling back to innodb_use_native_aio=OFF
      ^ Found warnings in /home/buildbot/amd64-centos-stream10/build/mysql-test/var/6/log/mysqld.3.err
      

      Looking at the limit for the autogen/amd64 worker hosts, I've identified two potential machines where we should definitely increase the limit.

      intel-bbw1 + ro-apexis-bbw3.

      cat /proc/sys/fs/aio-max-nr
      ------------------------------
      amd-bbw2:      1474560
      us-intel-bbw1: 131072
      hz-bbw2:       2211840
      apexis-bbw3:   131072
      

      Attachments

        Activity

          People

            faust Faustin Lammler
            rvarzaru Varzaru Razvan-Liviu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 1h
                1h