Upgrade from 7.2.6 to 8.0.6 fails while 'Adding TAG table...' mysql upgrade

jh@excello.cz · Post by **jh@excello.cz** » Wed Jan 01, 2014 10:00 am

I'M USING ZSC OPEN SOURCE 7.2.6 ON UBUNTU 10.04 AND I WAS ABOUT TO UPGRADE TO 8.X - ACTUALLY 8.0.6 (PREVIOUS RELEASES CAN'T UPGRADE VERSION 7.2.6). BUT IT FAILS ON MYSQL TABLES UPGRADE WITH THIS MESSAGE:

UPGRADING FROM 7.2.6_GA_2926 TO 8.0.6_GA_5922

STOPPING ZIMBRA SERVICES...DONE.

STARTING MYSQL...DONE.

THIS APPEARS TO BE 7.2.6_GA

UPGRADING LDAP DATA...DONE.

UPGRADING LDAP CONFIGURATION DATABASE...DONE.

LOADING DATABASE...DONE.

CHECKING LDAP STATUS...NOT RUNNING.

RUNNING ZMLDAPAPPLYLDIF...DONE.

CHECKING LDAP STATUS...NOT RUNNING.

STARTING LDAP...DONE.

CHECKING LDAP STATUS...ALREADY RUNNING.

RUNNING MYSQL_UPGRADE...DONE.

REDOLOG VERSION UPDATE REQUIRED.

WED JAN 1 16:52:34 2014: VERIFIED REDOLOG VERSION 1.31.

WED JAN 1 16:52:34 2014: UPDATING REDOLOG SCHEMA VERSION FROM 1.31 TO 1.42.

REDOLOG VERSION UPDATE FINISHED.

SCHEMA UPGRADE REQUIRED FROM VERSION 65 TO 92.

RUNNING /OPT/ZIMBRA/LIBEXEC/SCRIPTS/MIGRATE20120611_7TO8_BUNDLE.PL

WED JAN 1 16:52:38 2014: VERIFIED SCHEMA VERSION 65.

WED JAN 1 16:52:40 2014: ADDING DEVICE INFORMATION COLUMNS TO ZIMBRA.MOBILE_DEVICES TABLE...

WED JAN 1 16:52:41 2014: ADDING ZIMBRA.PENDING_ACL_PUSH TABLE...

WED JAN 1 16:52:42 2014: ADDING TAG TABLE...

...........

WED JAN 1 16:52:54 2014: ADDING TAGGED_ITEM TABLE...

..........WED JAN 1 16:52:56 2014: DB: CREATE TABLE IF NOT EXISTS MBOXGROUP60.TAGGED_ITEM (

MAILBOX_ID INTEGER UNSIGNED NOT NULL,

TAG_ID INTEGER NOT NULL,

ITEM_ID INTEGER UNSIGNED NOT NULL,
UNIQUE INDEX I_TAGGED_ITEM_UNIQUE (MAILBOX_ID, TAG_ID, ITEM_ID),

CONSTRAINT FK_TAGGED_ITEM_TAG FOREIGN KEY (MAILBOX_ID, TAG_ID) REFERENCES MBOXGROUP60.TAG(MAILBOX_ID, ID) ON DELETE CASCADE,

CONSTRAINT FK_TAGGED_ITEM_ITEM FOREIGN KEY (MAILBOX_ID, ITEM_ID) REFERENCES MBOXGROUP60.MAIL_ITEM(MAILBOX_ID, ID) ON DELETE CASCADE

) ENGINE = INNODB;: CAN'T CREATE TABLE 'MBOXGROUP60.TAGGED_ITEM' (ERRNO: 150)
DIED AT /OPT/ZIMBRA/LIBEXEC/SCRIPTS/MIGRATE.PM LINE 368, LINE 74.

SCRIPT FAILED WITH CODE 256: - EXITING

UPGRADE FAILED - EXITING.

IS THERE ANY EXPLANATION FOR THIS?
I ALSO TRIED TO DO RELEASE UPGRADE TO 12.04.3LTS AND PERFORM UPGRADE BUT THE RESULT IS THE SAME. LOG ATTACHED.
zmsetup.01012014-165121.log

jh@excello.cz · Post by **jh@excello.cz** » Sat Jan 11, 2014 8:05 am

Nothing? Will this be resolved in the 8.0.7 release?

phoenix · Post by **phoenix** » Sat Jan 11, 2014 11:30 am

[quote user="jh@excello.cz"]Nothing? Will this be resolved in the 8.0.7 release?[/QUOTE]Not unless you've filed a bug report for this problem.

bulletxt · Post by **bulletxt** » Sat Feb 01, 2014 9:37 am

[quote user="10330phoenix"]Not unless you've filed a bug report for this problem.[/QUOTE]
I filled the bug for the guy as i'm also running 7.2.6. No one yet replied. Im afraid doing an upgrade till someone has more to say on this.

jh@excello.cz · Post by **jh@excello.cz** » Tue Feb 04, 2014 3:53 am

Because i can't find your i've filled one also - https://bugzilla.zimbra.com/show_bug.cgi?id=86388