MySQL fails to start - quit without updating PID file

damtech

Member
Jan 2, 2013
11
0
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
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,222
463
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.
 

damtech

Member
Jan 2, 2013
11
0
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
 

damtech

Member
Jan 2, 2013
11
0
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.
 

damtech

Member
Jan 2, 2013
11
0
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)