Starting MySQL... ERROR! The server quit without updating PID file
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:
Please can someone help me i have been trying to fix this for 3 days now.
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 endedPlease can someone help me i have been trying to fix this for 3 days now.
-
Is this problem occured suddenly ? 0 -
[quote="mahdy_sharifi, post: 1620531">Is this problem occured suddenly ?
as soon as i install cpanel0 -
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. 0 -
I will try this now and let you know 0 -
i have done all this followed the documentation but i still receive the same error and when trying to restart in whm it crashes. 0 -
What's in your my.cnf? There is this old post: InnoDB: Error: io_setup() failed - MySQL Bugs Not sure if that's of any use to you or not. 0 -
[quote="TheUnknownCoder, post: 1626681">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.0 -
[quote="cPanelMichael, post: 1627222">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: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:[mysqld] innodb_file_per_table=10 -
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: innodb_use_native_aio = 0
Thank you.0 -
[quote="cPanelMichael, post: 1627372">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: innodb_use_native_aio = 0
Thank you.
I love you dude thanks a lot :).0 -
It just happened on one of my servers. Fixed, thanks. 0
Please sign in to leave a comment.
Comments
12 comments