MYSQL is not starting after a improper shutdown

We had to do a forceful shutdown on our confluence server and after it came up, then mysql wouldn't start all the way. It just keeps trying to start and I see these messages in the /var/mysql/*log:

120807 14:20:19 ERROR Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

120807 14:20:29 Warning Setting lower_case_table_names=2 because file system for /var/mysql/ is case insensitive

InnoDB: The InnoDB memory heap has been disabled.

InnoDB: Mutex and rw_lock use GCC atomic builtins.

InnoDB: The log sequence number in ibdata files does not match

InnoDB: the log sequence number in the ib_logfiles!

120807 14:20:29 InnoDB: Database was not shut down normally!

InnoDB: Starting crash recovery.

InnoDB: Reading tablespace information from the .ibd files...

InnoDB: Restoring possible half-written data pages from the doublewrite

InnoDB: buffer...

120807 14:20:29 InnoDB: Started; log sequence number 0 43655

120807 14:20:29 ERROR Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

3 answers

This widget could not be displayed.

Hello Joe,

I strongly believe this issue should be reviewed by your DBA, since it seems to be entirely database-related. Can you try reaching him on this and letting us know the results?

This widget could not be displayed.

Is your mysql DB in the default location (/var/lib)?

If not, follow the below commands to fix this issue:

mysql_install_db –user=mysql –ldata=/newlocation

once you do that you can restart mysql

/etc/init.d/mysqld restart

The error basically means it can't find your DB.

This widget could not be displayed.

I think the problem was that we are using a separate DB on the server yet MySQL was still running and not configured properly. All is well now and was well even while I was getting those errors.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published Tuesday in Confluence

Add-on evaluation with confluence templates

Atlassian market place contains number of Apps/Addons which improves the capability of out of the box Atlassian products. It is good to follow a plugin evaluation process before install add-ons. So t...

105 views 12 6
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you