8.7.11 to 8.8.12 fails on MySQL migration

Ask questions about your setup or get help installing ZCS server (ZD section below).
User avatar
joho
Posts: 43
Joined: Tue Apr 26, 2016 9:24 am
ZCS/ZD Version: Release 8.8.12.GA.3794.UBUNTU16.64

8.7.11 to 8.8.12 fails on MySQL migration

Postby joho » Sat Jun 01, 2019 12:18 am

Everything in the upgrade was coming along nicely, until this:

Upgrading from 8.7.11_GA_1854 to 8.8.12_GA_3794
Stopping zimbra services...done.
This appears to be 8.7.11_GA
Starting mysql...done.
Checking ldap status...not running.
Checking ldap status...not running.
Starting ldap...done.
Checking ldap status...already running.
Running mysql_upgrade...done.
Schema upgrade required from version 108 to 109.
Running /opt/zimbra/libexec/scripts/migrate20180301-ZimbraChat.pl
Sat Jun 1 02:14:23 2019: Verified schema version 108.
ERROR 1932 (42S02) at line 45: Table 'chat.MESSAGE' doesn't exist in engine
Sat Jun 1 02:14:24 2019: Error while running '/opt/zimbra/bin/mysql --user=zimbra --password=Zp9POT6JRsLAYNOOxOAYg_uIX --database=zimbra --batch --skip-column-names'.
Script failed with code 256: - exiting
UPGRADE FAILED - exiting.

How does one resume / retry, and what exactly is the problem?


User avatar
joho
Posts: 43
Joined: Tue Apr 26, 2016 9:24 am
ZCS/ZD Version: Release 8.8.12.GA.3794.UBUNTU16.64

Re: 8.7.11 to 8.8.12 fails on MySQL migration

Postby joho » Sat Jun 01, 2019 9:11 am

After quite some time, I sat down and recreated the chat database by hand, using the SQL content of one of the migration scripts. This made the database integrity checks pass and the installation could continue. I have no idea why this wasn't handled by the install.sh script, but it wasn't, no matter what I did.

Return to “Installation and Upgrade”

Who is online

Users browsing this forum: No registered users and 7 guests