Starting MySQL... ERROR! The server quit without updating PID file

Apr 13, 2014
6
0
1
cPanel Access Level
Root Administrator
Hello im not sure if this is the correct place to post this but move if its not please any back to what i have posted for i had the full LAMP running find untill i installed cpanel and everything is still running fine a part from mysql for some reason when i start it up i get this error:

Starting MySQL... ERROR! The server quit without updating PID file (/var/lib/mysql/zeus.domain.com.pid).

And when looking at the log file this is what it says:
Code:
140414 01:53:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140414  1:53:06 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
140414  1:53:06 [Note] Plugin 'FEDERATED' is disabled.
140414  1:53:06 InnoDB: The InnoDB memory heap is disabled
140414  1:53:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140414  1:53:06 InnoDB: Compressed tables use zlib 1.2.3
140414  1:53:06 InnoDB: Using Linux native AIO
140414  1:53:06  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.
140414  1:53:09  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
140414  1:53:09 InnoDB: Fatal error: cannot initialize AIO sub-system
140414  1:53:09 [ERROR] Plugin 'InnoDB' init function returned error.
140414  1:53:09 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140414  1:53:09 [ERROR] Unknown/unsupported storage engine: InnoDB
140414  1:53:09 [ERROR] Aborting

140414  1:53:09 [Note] /usr/sbin/mysqld: Shutdown complete

140414 01:53:09 mysqld_safe mysqld from pid file /var/lib/mysql/zeus.domain.com.pid ended
Please can someone help me i have been trying to fix this for 3 days now.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,205
363
Hello :)

cPanel is designed for installation on a new operating system. Installing it over top of an existing configuration is not supported, and likely to result in several conflicts. MySQL, Apache, and PHP are automatically installed by default with cPanel. Are you able to install cPanel on a fresh copy of the OS?

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,205
363
i have done all this followed the documentation but i still receive the same error and when trying to restart in whm it crashes.
To clarify, you installed a minimal instance of CentOS, installed cPanel, and still receive the same MySQL error message related to InnoDB? This was not a reinstall of cPanel on top of an existing setup?

Thank you.
 
Apr 13, 2014
6
0
1
cPanel Access Level
Root Administrator
To clarify, you installed a minimal instance of CentOS, installed cPanel, and still receive the same MySQL error message related to InnoDB? This was not a reinstall of cPanel on top of an existing setup?

Thank you.
No its not i got my host to install the whole CentOS again and then i installed cpanel and received the same errors.

zeurs.domain.com.err:
Code:
140422 03:05:40 mysqld_safe mysqld from pid file /var/lib/mysql/zeus.domain.com.pid ended
140422 03:06:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140422  3:06:01 [Note] Plugin 'FEDERATED' is disabled.
140422  3:06:01 InnoDB: The InnoDB memory heap is disabled
140422  3:06:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140422  3:06:01 InnoDB: Compressed tables use zlib 1.2.3
140422  3:06:01 InnoDB: Using Linux native AIO
140422  3:06:01  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.
140422  3:06:03  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
140422  3:06:03 InnoDB: Fatal error: cannot initialize AIO sub-system
140422  3:06:03 [ERROR] Plugin 'InnoDB' init function returned error.
140422  3:06:03 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140422  3:06:03 [ERROR] Unknown/unsupported storage engine: InnoDB
140422  3:06:03 [ERROR] Aborting

140422  3:06:03 [Note] /usr/sbin/mysqld: Shutdown complete

140422 03:06:03 mysqld_safe mysqld from pid file /var/lib/mysql/zeus.domain.com.pid ended
my.cnf:
Code:
[mysqld]
innodb_file_per_table=1
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,205
363
This likely indicates that native AIO support is not enabled on the server. Add the following line to /etc/my.cnf and MySQL should then restart successfully:

Code:
innodb_use_native_aio = 0
Thank you.