Plesk shows SQLSTATE[HY000] [2002] No such file or directory: InnoDB: Warning: io_setup() failed with EAGAIN

Created:

2016-11-16 13:21:55 UTC

Modified:

2017-04-24 11:15:32 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Plesk shows SQLSTATE[HY000] [2002] No such file or directory: InnoDB: Warning: io_setup() failed with EAGAIN

Applicable to:

  • Plesk for Linux

Symptoms

Plesk shows the following error:

ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory

Mysql service is down.

The following error can be found during MySQL start:

# /etc/init.d/mysqld start && tail -fn0 /var/log/mysql/error.log
141004 14:31:15 InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
InnoDB: Warning: io_setup() attempt 1 failed.
InnoDB: Warning: io_setup() attempt 2 failed.
InnoDB: Warning: io_setup() attempt 3 failed.
InnoDB: Warning: io_setup() attempt 4 failed.
InnoDB: Warning: io_setup() attempt 5 failed.
141004 14:31:19 InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
141004 14:31:19 InnoDB: Fatal error: cannot initialize AIO sub-system
141004 14:31:19 [ERROR] Plugin 'InnoDB' init function returned error.
141004 14:31:19 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE fail

Cause

Capacity limits were exceeded.

Resolution

  1. Set the parameter innodb_use_native_aio=0 in my.cnf :

    # vi /etc/my.cnf
    [mysqld]
    ...
    innodb_use_native_aio=0
    ...
  2. Start mysql :

    # service mysqld restart
Have more questions? Submit a request
Please sign in to leave a comment.