Results 1 to 7 of 7

Thread: Failure Upgrading from 4.5.11 to 5.0.6 Open-Source

Hybrid View

  1. #1
    Join Date
    Sep 2006
    Posts
    30
    Rep Power
    9

    Default Failure Upgrading from 4.5.11 to 5.0.6 Open-Source

    Upgrade starts, then:

    Tue Jun 24 01:21:24 2008: SELECT value FROM config WHERE name = 'db.version'
    This appears to be 4.5.11_GA
    Redolog Version: 1.22 New Redolog Version: 1.22
    Schema upgrade required
    Running /opt/zimbra/libexec/scripts/migrate20070614-BriefcaseFolder.pl
    Tue Jun 24 01:21:29 2008: Verified schema version 38.
    ..........Tue Jun 24 01:21:32 2008: DB: UPDATE mboxgroup41.mail_item mi, mailbox mb
    SET mi.name = CONCAT('Briefcase - renamed (', mi.id, ' - 1214288488)'),
    mi.subject = CONCAT('Briefcase - renamed (', mi.id, ' - 1214288488)'),
    mi.mod_metadata = mb.change_checkpoint,
    mi.mod_content = mb.change_checkpoint,
    mi.change_date = 1214288488
    WHERE mi.mailbox_id = 41 AND mi.folder_id = 1 AND
    mi.id != 16 AND LOWER(mi.name) = LOWER('Briefcase') AND
    mb.id = mi.mailbox_id;: Table 'mboxgroup41.mail_item' doesn't exist

    Died at /opt/zimbra/libexec/scripts/Migrate.pm line 361, line 41.
    Script failed with code 256: - exiting
    UPGRADE FAILED - exiting


    I have no idea how to proceed - any suggestions?

  2. #2
    Join Date
    Sep 2006
    Posts
    30
    Rep Power
    9

    Default

    I tried it again tonight, after shutting down all other services. Same exact error. Is there a utility or something to run a consistency check on mysql prior to an upgrade?

  3. #3
    Join Date
    Sep 2005
    Posts
    57
    Rep Power
    10

    Default

    Hi, the error message says the upgrade script was trying to run some SQL command against mboxgroup41.mail_item table but the table wasn't there. Either the mail_item table is missing or the mboxgroup41 database is missing. Use mysql client to check which is the case. "use mboxgroup41" command will fail if the database isn't there. If the database is there, do "desc mboxgroup41.mail_item". That will fail if the table is missing.

    Either way, this is indicating something went wrong during creation of mailbox 41, which was way before the upgrade. Check "select * from zimbra.mailbox where id=41". There must be a row for mailbox 41, and that is why the upgrade script is trying to process that mailbox and its mailbox group. The solution is to drop mboxgroup41 database and delete the id=41 row from mailbox table. Likewise for all other mailboxes that were not created properly. There was an old bug that produced this condition, and it has since been fixed.

    To see all mailbox group databases, do this in mysql client:

    show databases like 'mboxgroup%';

    You can cross reference this with the groups being referenced by the mailbox table:

    select distinct group_id from zimbra.mailbox;

    Then, you can see the mailboxes for these groups:

    select id, group_id, comment from zimbra.mailbox where group_id in (...);

    where "..." is the comma-separated list of group ids from the second query.

    For each group and mailbox referring to it, clean up by doing:

    drop database mboxgroupX;
    delete from zimbra.mailbox where group_id=X;

    You can't recover from a mistake during drop/delete, so be very careful!

    After the cleanup, run the upgrade again.
    Bugzilla - Wiki - Downloads - Before posting... Search!

  4. #4
    Join Date
    Aug 2007
    Posts
    23
    Rep Power
    8

    Default

    I realy feel like it's a solution for me, but I get:
    mysql> drop database mboxgroup20;
    ERROR 1010 (HY000): Error dropping database (can't rmdir './mboxgroup20', errno: 39)
    Why I can't delete it?
    tried from both zimbra and root accounts, stopped zimbra, chmoded 777 to that folder

  5. #5
    Join Date
    Sep 2005
    Posts
    57
    Rep Power
    10

    Default

    Errno 39 is ENOTEMPTY, directory not empty. I think it's saying you have tables in mboxgroup20 database, and you must drop the tables before dropping the database. Try:

    mysql> use mboxgroup20;
    mysql> show tables;
    mysql> drop table [table name]; (for each table)

    If that still doesn't work, shutdown mysql and move everything under the directory out, restart and drop again. Try it this way rather than deleting the directory, because you want to tell mysql you're dropping the database.
    Bugzilla - Wiki - Downloads - Before posting... Search!

  6. #6
    Join Date
    Aug 2007
    Posts
    23
    Rep Power
    8

    Default

    Thanks a lot!
    emtying directory worked
    now will try to upgrade from 5.0.2 to 5.0.4 then to 5.0.8

  7. #7
    Join Date
    Aug 2007
    Posts
    23
    Rep Power
    8

    Default

    but now, i can't this -
    delete from zimbra.mailbox where group_id=20;
    ERROR 2013 (HY000): Lost connection to MySQL server during query

Similar Threads

  1. upgrading from 5.0.4 to 5.0.5 opensource
    By smoke in forum Installation
    Replies: 4
    Last Post: 10-19-2008, 11:38 AM
  2. [Installation] Zimbra Desktop - Ubuntu 8.04 Hardy
    By kaltera in forum Installation Help
    Replies: 1
    Last Post: 06-18-2008, 05:43 AM
  3. [SOLVED] Is zimbra really open source product ?
    By hernad in forum Developers
    Replies: 3
    Last Post: 08-18-2007, 11:30 PM
  4. Error message in Server status
    By Max Ma in forum Installation
    Replies: 20
    Last Post: 04-19-2007, 09:55 AM
  5. M3 problem with shares
    By titangears in forum Users
    Replies: 4
    Last Post: 01-12-2006, 01:01 PM

Posting Permissions

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