The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Database Discussions' started by TheUnknownCoder, Apr 13, 2014.

  1. TheUnknownCoder

    Joined:
    Apr 13, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    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.
     
  2. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    177
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Is this problem occured suddenly ?
     
  3. TheUnknownCoder

    Joined:
    Apr 13, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    as soon as i install cpanel
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  5. TheUnknownCoder

    Joined:
    Apr 13, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I will try this now and let you know
     
  6. Shavaun

    Shavaun Well-Known Member

    Joined:
    Aug 15, 2013
    Messages:
    106
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
  7. TheUnknownCoder

    Joined:
    Apr 13, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    i have done all this followed the documentation but i still receive the same error and when trying to restart in whm it crashes.
     
  8. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,482
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
  9. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    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.
     
  10. TheUnknownCoder

    Joined:
    Apr 13, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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
    
     
    #10 TheUnknownCoder, Apr 22, 2014
    Last edited by a moderator: Apr 22, 2014
  11. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  12. TheUnknownCoder

    Joined:
    Apr 13, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I love you dude thanks a lot :).
     
  13. simonas

    simonas Well-Known Member

    Joined:
    Apr 21, 2013
    Messages:
    141
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Lithuania
    cPanel Access Level:
    Root Administrator
    It just happened on one of my servers. Fixed, thanks.
     
Loading...

Share This Page