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.

MySQL fails to start - quit without updating PID file

Discussion in 'Database Discussions' started by damtech, Jul 29, 2015.

  1. damtech

    damtech Member

    Joined:
    Jan 2, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Im getting the following errors, and I cant seem to work out why. I've done some digging but cant find a concrete answer.
    Code:
    Error:
    Service Error
    The “mysql” service failed to start.
    
    Startup Log
    Starting MySQL.. ERROR! The server quit without updating PID file (/var/lib/mysql/<<SERVER HOSTNAME>>.pid).
    
    Log Messages
    150729 15:44:21 mysqld_safe mysqld from pid file /var/lib/mysql/<<SERVER HOSTNAME>>.pid ended
    150729 15:44:21 [Note] /usr/sbin/mysqld: Shutdown complete
    150729 15:44:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150729 15:43:44 mysqld_safe mysqld from pid file /var/lib/mysql/<<SERVER HOSTNAME>>.pid ended
    150729 15:43:44 [Note] /usr/sbin/mysqld: Shutdown complete
    150729 15:43:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150729 15:43:05 mysqld_safe mysqld from pid file /var/lib/mysql/<<SERVER HOSTNAME>>.pid ended
    150729 15:43:05 [Note] /usr/sbin/mysqld: Shutdown complete
    150729 15:43:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150729 15:41:51 mysqld_safe mysqld from pid file /var/lib/mysql/<<SERVER HOSTNAME>>.pid ended
    150729 15:41:51 [Note] /usr/sbin/mysqld: Shutdown complete
    150729 15:41:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150729 15:41:01 mysqld_safe mysqld from pid file /var/lib/mysql/<<SERVER HOSTNAME>>.pid ended
    150729 15:41:01 [Note] /usr/sbin/mysqld: Shutdown complete
    150729 15:40:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150729 15:36:52 mysqld_safe mysqld from pid file /var/lib/mysql/<<SERVER HOSTNAME>>.pid ended
    150729 15:36:52 [Note] /usr/sbin/mysqld: Shutdown complete
    150729 15:41:51 [Note] /usr/sbin/mysqld: Shutdown complete
    150729 15:41:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150729 15:41:01 mysqld_safe mysqld from pid file /var/lib/mysql/265887.vps-10.com.pid ended
    150729 15:41:01 [Note] /usr/sbin/mysqld: Shutdown complete
    150729 15:40:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150729 15:36:52 mysqld_safe mysqld from pid file /var/lib/mysql/265887.vps-10.com.pid ended
    150729 15:36:52 [Note] /usr/sbin/mysqld: Shutdown complete
     
    #1 damtech, Jul 29, 2015
    Last edited by a moderator: Jul 29, 2015
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,852
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Do you notice any specific error messages in /var/lib/mysql/$hostname.err if you attempt to restart MySQL? What are the contents of your /etc/my.cnf file?

    Thank you.
     
  3. damtech

    damtech Member

    Joined:
    Jan 2, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Contents of My.Conf are:

    [mysqld]
    open_files_limit=10088
    innodb_file_per_table=1
    default-storage-engine=MyISAM
    max_allowed_packet=268435456
    innodb_buffer_pool_size=55574528
    innodb_use_native_aio = 0

    Ill find the log file and paste that for you now
     
  4. damtech

    damtech Member

    Joined:
    Jan 2, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    The log file must be too large as im having trouble opening it...

    Can i rename it, and try and start MySQL again to get a clean log?
     
  5. damtech

    damtech Member

    Joined:
    Jan 2, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    OK
    Not sure how but I got the MySQL server running
    Sites are loading (ish)
    When I go into cpanel and bring up the mysql databases section, it says the server is offline
    When I go into phpMyAdmin, it lists all the tables on the left hand side, but on the right hand side it says no tables found.

    I think there's obviously something not talking to each other.
     
  6. ModServ

    ModServ Well-Known Member

    Joined:
    Oct 17, 2006
    Messages:
    332
    Likes Received:
    5
    Trophy Points:
    18
    Location:
    Egypt
    cPanel Access Level:
    Root Administrator
    What is your mysql version (mysql -V) ? And you could tail the last 50 lines from error log using this command:

    Code:
    tail -n 50 /var/lib/mysql/$(hostname).err
     
  7. damtech

    damtech Member

    Joined:
    Jan 2, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thank you!

    Details below. It looks at though it doesnt really know what to do with the MySQL files i Imported...

    mysql Ver 14.14 Distrib 5.5.42, for Linux (x86_64) using readline 5.1




    150730 16:46:25 InnoDB: Initializing buffer pool, size = 53.0M
    150730 16:46:25 InnoDB: Completed initialization of buffer pool
    150730 16:46:25 InnoDB: highest supported file format is Barracuda.
    InnoDB: The log sequence number in ibdata files does not match
    InnoDB: the log sequence number in the ib_logfiles!
    150730 16:46:25 InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Error: checksum mismatch in file ./designs_drupaltest/blocked_ips.ibd
    InnoDB: Error: checksum mismatch in file ./designs_drupaltest/actions.ibd
    InnoDB: Error: checksum mismatch in file ./designs_drupaltest/cache.ibd
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    150730 16:46:25 InnoDB: Error: table 'designs_drupaltest/actions'
    InnoDB: in InnoDB data dictionary has tablespace id 615,
    InnoDB: but tablespace with that id or name does not exist. Have
    InnoDB: you deleted or moved .ibd files?
    InnoDB: This may also be a table created with CREATE TEMPORARY TABLE
    InnoDB: whose .ibd and .frm files MySQL automatically removed, but the
    InnoDB: table still exists in the InnoDB internal data dictionary.
    InnoDB: Please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html
    InnoDB: for how to resolve the issue.
    150730 16:46:25 InnoDB: Error: table 'designs_drupaltest/blocked_ips'
    InnoDB: in InnoDB data dictionary has tablespace id 617,
    InnoDB: but tablespace with that id or name does not exist. Have
    InnoDB: you deleted or moved .ibd files?
    InnoDB: This may also be a table created with CREATE TEMPORARY TABLE
    InnoDB: whose .ibd and .frm files MySQL automatically removed, but the
    InnoDB: table still exists in the InnoDB internal data dictionary.
    InnoDB: Please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html
    InnoDB: for how to resolve the issue.
    150730 16:46:25 InnoDB: Error: table 'designs_drupaltest/cache'
    InnoDB: in InnoDB data dictionary has tablespace id 618,
    InnoDB: but tablespace with that id or name does not exist. Have
    InnoDB: you deleted or moved .ibd files?
    InnoDB: This may also be a table created with CREATE TEMPORARY TABLE
    InnoDB: whose .ibd and .frm files MySQL automatically removed, but the
    InnoDB: table still exists in the InnoDB internal data dictionary.
    InnoDB: Please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html
    InnoDB: for how to resolve the issue.
    150730 16:46:25 InnoDB: Waiting for the background threads to start
    150730 16:46:26 InnoDB: 5.5.42 started; log sequence number 68953387132
    150730 16:46:26 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    150730 16:46:26 [Note] - '0.0.0.0' resolves to '0.0.0.0';
    150730 16:46:26 [Note] Server socket created on IP: '0.0.0.0'.
    150730 16:46:26 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.42-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,852
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page