Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL fails to start - quit without updating PID file

Discussion in 'Database Discussion' 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:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  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:
    168
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  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:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice