When trying restart mysqld service I'm getting this erroe: Cannot start/stop/restart service: MySQL Daemon failed to start.

Anybody have idea how to solve it? I'm running centos 6.5, from what I see I'm missing file: /var/lib/mysql/mysql.sock

mysql error logs

    140707 12:09:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140707 12:09:29 [Note] libgovernor.so not found
140707 12:09:29 [Warning] option 'innodb-buffer-pool-size': signed value 2097152 adjusted to 5242880
140707 12:09:29 [Warning] option 'innodb-additional-mem-pool-size': signed value 512000 adjusted to 524288
140707 12:09:29 [Note] Plugin 'FEDERATED' is disabled.
140707 12:09:29 InnoDB: The InnoDB memory heap is disabled
140707 12:09:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140707 12:09:29 InnoDB: Compressed tables use zlib 1.2.3
140707 12:09:29 InnoDB: Using Linux native AIO
140707 12:09:29  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.
140707 12:09:31  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
140707 12:09:31 InnoDB: Fatal error: cannot initialize AIO sub-system
140707 12:09:31 [ERROR] Plugin 'InnoDB' init function returned error.
140707 12:09:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140707 12:09:31 [ERROR] Unknown/unsupported storage engine: InnoDB
140707 12:09:31 [ERROR] Aborting

140707 12:09:31 [Note] /usr/libexec/mysqld: Shutdown complete

140707 12:09:31 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

thanks for answers but I needed to restore it from backup

  • Check mysql error logs – TBI Infotech Jul 7 '14 at 9:38
  • 1
    try and start it interactivly – Koen van der Rijt Jul 7 '14 at 9:50
  • try and start it interactivly - how? – user229565 Jul 7 '14 at 9:51
  • This is not an error log! – melsayed Jul 7 '14 at 10:07
  • Make sure to check the error log first, if you can't find anything useful, try running it manually: /usr/sbin/mysqld & be careful when you stop it, use SIGTERM – melsayed Jul 7 '14 at 10:10

This seems to be an issue with AIO not being able to be setup. It may be because:

  1. Space limitations via quota: Do you have quotas setup for the user you're starting MySQL with? Try looking at quota -s
  2. Space limitations via HD: Perhaps you're running out of space. Look at df -h and see if any drive is close to capacity.
  3. Permission issues: Does the user you're trying to restart the service with have the appropriate permissions?
  4. Configuration changes: Did you change configuration recently? As a test, try reverting your configuration in my.cnf. You may also want to try disabling AIO with innodb_use_native_aio = 0 but that is just a workaround really.
  5. Database corruption: I haven't seen this error pop up due to database corruption but I suppose it is a possibility.

Hope this helps.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.