Zimbra: How to solve InnoDB: Error: Column last_update in table “mysql”.”innodb_table_stats”

Hello everyone, for the last couple of days I’ve been receiving notifications from my monitoring systems about disk issues on one of my Zimbra Servers. The system is an old one I had with Zimbra Collaboration 8.6, and from there it has been upgraded to 8.7, 8.7.1 and 8.7.6 and finally to 8.7.10.

Finding the disk issue

I’ve started with the basics, what directory or file was eating my disk space without my knowledge? To do that, I’ve used the commands df and du, both always handy:

Checking that my disk was 100% full

Checking which folder in Zimbra was using all the space, mind the log folder:

Checking which logs inside that folder were stealing all the disk space, mind the mysql_error.log:

So, now we know which log is using all the available disk space, let’s do a tail and see what’s going on, I saw that the error was filling the log every second with the next:

How to solve InnoDB: Error: Column last_update in table “mysql”.”innodb_table_stats”

For some reason during the upgrade Zimbra didn’t fix this automatically (https://bugzilla.zimbra.com/show_bug.cgi?id=107976) , so let’s try to run the next commands to get rid of this problem:

As you might not have any disk space left, we will first wipe the mysql_error.log file with the next command, and perform a reboot:

Once the system is back online, let’s fix the issue.

First, we will need the mysql root password to run the command later:

Now we know the password we can manually create the folder and the symbolic link:

And last but not least run manually the upgrade command, which will take some seconds depending on the size of your Database:

Let’s run the last zmcontrol restart, and then we can now take a look at the log file again to see if the error now is gone, if everything went well you might see something like this:

That’s it for today guys, I hope this Blog post helps you as much as it helped me.

Advertisements

One thought

Comments are closed.