Insufficient async disk I/O kernel resources
Published 29 June 2023
In some cases, we have observed containers failing to create with errors referencing a kernel restriction on IO requests. In these cases we have found that raising that limit resolves this issue.
Typical error messages
Database engine | Typical error messages |
---|---|
Oracle |
|
SQL Server | Reason: 0x00000003 /usr/bin/find: '/proc/10/map_files': Permission denied |
MySQL |
|
Configuration change
Increasing the sysctl
value fs.aio-max-nr
is the solution recommended by Oracle. You can do this by running the follow command:
sudo sysctl fs.aio-max-nr=1048576
However, in order to persist this change across reboots you will need to edit the /etc/sysctl.conf
file and add the line
fs.aio-max-nr=1048576
You can then run sudo sysctl -p /etc/sysctl.conf
to load the change.
You may want to increase or decrease the value as appropriate for the number of containers in use on your node. The value given in our example is the simply Oracle's recommended value.