Results 1 to 5 of 5

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

  1. #1
    jh@excello.cz is offline New Member
    Join Date
    Feb 2013
    Posts
    3
    Rep Power
    2

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

    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:

    Code:
    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.plzmsetup.01012014-165121.log
    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, <OUTPUT> 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.

  2. #2
    jh@excello.cz is offline New Member
    Join Date
    Feb 2013
    Posts
    3
    Rep Power
    2

    Default

    Nothing? Will this be resolved in the 8.0.7 release?

  3. #3
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,480
    Rep Power
    56

    Default

    Quote Originally Posted by jh@excello.cz View Post
    Nothing? Will this be resolved in the 8.0.7 release?
    Not unless you've filed a bug report for this problem.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  4. #4
    bulletxt is offline Member
    Join Date
    Apr 2010
    Posts
    13
    Rep Power
    5

    Default

    Quote Originally Posted by phoenix View Post
    Not unless you've filed a bug report for this problem.
    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.

  5. #5
    jh@excello.cz is offline New Member
    Join Date
    Feb 2013
    Posts
    3
    Rep Power
    2

    Default

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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 09-17-2013, 08:14 PM
  2. MySQL Table Upgrade - Is it necessary?
    By jv494 in forum Administrators
    Replies: 6
    Last Post: 02-24-2012, 12:46 AM
  3. Replies: 4
    Last Post: 11-28-2011, 03:01 AM
  4. Replies: 0
    Last Post: 11-24-2011, 04:27 AM
  5. Upgrade to Zimbra 7 - Table upgrade required
    By n8bounds in forum Administrators
    Replies: 10
    Last Post: 04-25-2011, 11:07 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •