Errors mysql After Upgrade to 8.7

Ask questions about your setup or get help installing ZCS server (ZD section below).
matrixsup
Posts: 7
Joined: Wed Aug 24, 2016 9:11 pm
Location: Surat,Gujarat,India

Errors mysql After Upgrade to 8.7

Postby matrixsup » Fri Aug 26, 2016 7:36 pm

1.Seeing Some Errors in /opt.zimbra/log/mysql_error.log as follows.

InnoDB: Error: Fetch of persistent statistics requested for table "mboxgroup62"."mail_item" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

The Objects within Mboxgroup being tag/mail_items etc,

2. InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).

Can any onehelp me understand if any issue & how to fix .All Email Operations Working Fine.


racerock
Posts: 11
Joined: Tue Sep 20, 2016 10:09 am

Re: Errors mysql After Upgrade to 8.7

Postby racerock » Tue Sep 20, 2016 10:19 am

Same issue here on all my 8.6_1200 to 8.7 upgrades the pre-database check prior to upgrade reports its clean,however, Once the upgrade is completed everything appears to function correctly, but I find similar errors, being endlessly reported in the /opt/zimbra/log/mysql_error.log..
EG:
7fb6b59f1b00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).

7fb6b59f1b00 InnoDB: Error: Fetch of persistent statistics requested for table "mboxgroup18"."tag" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

7fb6b59f1b00 InnoDB: Error: Fetch of persistent statistics requested for table "mboxgroup11"."tombstone" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

etc.. etc ..
hmmblah
Posts: 40
Joined: Fri Sep 12, 2014 11:44 pm

Re: Errors mysql After Upgrade to 8.7

Postby hmmblah » Thu Sep 22, 2016 1:54 pm

Same thing here. My stat graphs also show "No Data Available" in the admin console.
cerri
Posts: 22
Joined: Sat Sep 13, 2014 3:03 am

Re: Errors mysql After Upgrade to 8.7

Postby cerri » Mon Sep 26, 2016 2:11 pm

I can confirm the problem, on 3 installations upgraded from 8.6 (last patchlevel).
mefistoteles
Posts: 2
Joined: Wed Sep 28, 2016 9:37 pm

Re: Errors mysql After Upgrade to 8.7

Postby mefistoteles » Thu Oct 06, 2016 6:26 am

Hi

This behavior is caused by bug in Zimbra installation script which doesn't perform mysql_upgrade during Zimbra upgrade process.

Resolution:

1. Obtain mysql root password:
$ zmlocalconfig -s | grep mysql | grep password

2. Create missing directory and symbolic link:
$ mkdir /opt/zimbra/data/tmp/mysqldata
$ ln -s /opt/zimbra/data/tmp/mysql/mysql.sock /opt/zimbra/data/tmp/mysqldata/mysql.sock

3. Perform mysql_upgrade
$ /opt/zimbra/common/bin/mysql_upgrade -u root -p

That's it

Cheers,

mefistoteles
racerock
Posts: 11
Joined: Tue Sep 20, 2016 10:09 am

Re: Errors mysql After Upgrade to 8.7

Postby racerock » Sat Oct 08, 2016 5:23 pm

I confirm after taking the steps described above by mefistoteles the mysql_error.log no longer reports any errors and everything appears to function normally


Many Thanks
User avatar
zmbr16
Posts: 22
Joined: Wed Jul 06, 2016 5:17 am
Location: Hoboken, New Jersey in the United States
ZCS/ZD Version: 8.7.7_GA_1787.FOSS
Contact:

Re: Errors mysql After Upgrade to 8.7

Postby zmbr16 » Sat Dec 10, 2016 6:55 am

Thank you mefistoteles,

I confirm too, after executing the given commands sequence, I no longer see those errors in my /opt/zimbra/log/mysql_error.log.
User avatar
msquadrat
Advanced member
Advanced member
Posts: 54
Joined: Mon Oct 14, 2013 10:09 am

Re: Errors mysql After Upgrade to 8.7

Postby msquadrat » Tue May 23, 2017 7:51 pm

Many thanks as well for the workaround. I opened a pull request to have this Bug 107976 fixed, hopefully in the next release: https://github.com/Zimbra/zm-build/pull/23

Return to “Installation and Upgrade”

Who is online

Users browsing this forum: No registered users and 3 guests