Wer plötzlich bei seinem Ubuntu OpenVZ VPS MySQL nicht mehr starten kann und diesen Error im mysgl error.log sehen kann:
141213 8:01:52 [Note] Plugin 'FEDERATED' is disabled. 141213 8:01:52 InnoDB: The InnoDB memory heap is disabled 141213 8:01:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins 141213 8:01:52 InnoDB: Compressed tables use zlib 1.2.8 141213 8:01:52 InnoDB: Using Linux native AIO 141213 8:01:52 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. 141213 8:01:55 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 141213 8:01:55 InnoDB: Fatal error: cannot initialize AIO sub-system 141213 8:01:55 [ERROR] Plugin 'InnoDB' init function returned error. 141213 8:01:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 141213 8:01:55 [ERROR] Unknown/unsupported storage engine: InnoDB 141213 8:01:55 [ERROR] Aborting
Muß in der MySQL my.cnf unter
[mysqld]
Diese Zeile einfügen:
innodb_use_native_aio = 0
Danach startet der MySQL Server wieder.
Es handelt sich um einen Bug von OpenVZ.