MySQL fails to start - quit without updating PID file
Im getting the following errors, and I cant seem to work out why. I've done some digging but cant find a concrete answer.
Error:
Service Error
The "mysql" service failed to start.
Startup Log
Starting MySQL.. ERROR! The server quit without updating PID file (/var/lib/mysql/<>.pid).
Log Messages
150729 15:44:21 mysqld_safe mysqld from pid file /var/lib/mysql/<>.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/<>.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/<>.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/<>.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/<>.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/<>.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-
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. 0 -
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 0 -
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? 0 -
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. 0 -
What is your mysql version (mysql -V) ? And you could tail the last 50 lines from error log using this command: tail -n 50 /var/lib/mysql/$(hostname).err0 -
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: 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: 0 -
It looks like InnoDB corruption. This thread should help: InnoDB Repair Guide Thank you. 0
Please sign in to leave a comment.
Comments
7 comments