How does one resume / retry, and what exactly is the problem?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.
8.7.11 to 8.8.12 fails on MySQL migration
-
joho
- Advanced member
- Posts: 74
- Joined: Tue Apr 26, 2016 9:24 am
- ZCS/ZD Version: Release 8.8.15.GA.4177.UBUNTU20.64
8.7.11 to 8.8.12 fails on MySQL migration
Everything in the upgrade was coming along nicely, until this:
-
joho
- Advanced member
- Posts: 74
- Joined: Tue Apr 26, 2016 9:24 am
- ZCS/ZD Version: Release 8.8.15.GA.4177.UBUNTU20.64
Re: 8.7.11 to 8.8.12 fails on MySQL migration
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.