Results 1 to 4 of 4

Thread: [SOLVED] Upgrade 5.0.2 to 5.0.4 OSS Failed

  1. #1
    Chewie71 is offline Trained Alumni
    Join Date
    Sep 2006
    Location
    Illinois
    Posts
    374
    Rep Power
    8

    Default [SOLVED] Upgrade 5.0.2 to 5.0.4 OSS Failed

    Not sure what went wrong. I'm running 5.0.2 OSS on CentOS4 on my home server and ran into problems during the upgrade. I got a bunch of "ERROR 1040: Too many connections" errors.

    Help?

    Matt

    Code:
    Restoring existing configuration file from /opt/zimbra/.saveconfig/config.save...done
    Operations logged to /tmp/zmsetup.03242008-213820.log
    Starting ldap...done.
    Setting defaults...done.
    Upgrading from 5.0.2_GA_1975 to 5.0.4_GA_2101
    Stopping zimbra services
    Verifying /opt/zimbra/conf/my.cnf
    Starting mysql
    Starting logger mysql
    Mon Mar 24 21:49:13 2008: SELECT value FROM config WHERE name = 'db.version'
    ERROR 1040 (08004): Too many connections
    This appears to be 5.0.2_GA
    Redolog Version: 1.21 New Redolog Version: 1.22
    Mon Mar 24 21:49:21 2008: Verified redolog version 1.21.
    Mon Mar 24 21:49:21 2008: Updating Redolog schema version from 1.21 to 1.22.
    Schema upgrade required
    Running /opt/zimbra/libexec/scripts/migrate20080130-ImapFlags.pl
    Mon Mar 24 21:49:34 2008: Verified schema version 50.
    Mon Mar 24 21:49:35 2008: Adding flags column to mboxgroup1.imap_message.
    Mon Mar 24 21:49:37 2008: Adding flags column to mboxgroup2.imap_message.
    Mon Mar 24 21:49:38 2008: Adding flags column to mboxgroup3.imap_message.
    Mon Mar 24 21:49:39 2008: Adding flags column to mboxgroup4.imap_message.
    Mon Mar 24 21:49:40 2008: Adding flags column to mboxgroup5.imap_message.
    Mon Mar 24 21:49:42 2008: Adding flags column to mboxgroup6.imap_message.
    Mon Mar 24 21:49:43 2008: Adding flags column to mboxgroup7.imap_message.
    Mon Mar 24 21:49:45 2008: Adding flags column to mboxgroup8.imap_message.
    Mon Mar 24 21:49:48 2008: Verified schema version 50.
    Mon Mar 24 21:49:48 2008: Updating DB schema version from 50 to 51.
    Running /opt/zimbra/libexec/scripts/migrate20080213-IndexDeferredColumn.pl
    Mon Mar 24 21:50:00 2008: Verified schema version 51.
    Mon Mar 24 21:50:00 2008: Adding idx_deferred_count column to Mailbox table.
    Mon Mar 24 21:50:08 2008: Verified schema version 51.
    Mon Mar 24 21:50:08 2008: Updating DB schema version from 51 to 52.
    Stopping mysql
    An upgrade of the logger schema is necessary from version 0
    Running /opt/zimbra/libexec/scripts/migrateLogger1-index.pl
    Mon Mar 24 21:50:52 2008: Adding Indices
    Mon Mar 24 21:50:52 2008: alter table mta add index i_arrive_time (arrive_time);
    alter table amavis add index i_arrive_time (arrive_time);
    alter table mta_aggregate add index i_period_start (period_start);
    alter table mta_aggregate add index i_period_end (period_end);
    alter table amavis_aggregate add index i_period_start (period_start);
    alter table amavis_aggregate add index i_period_end (period_end);
    CREATE TABLE config (
            name        VARCHAR(255) NOT NULL PRIMARY KEY,
            value       TEXT,
            description TEXT,
            modified    TIMESTAMP
    ) ENGINE = MyISAM;
    
    ERROR 1040 (08004): Too many connections
    Running /opt/zimbra/libexec/scripts/migrateLogger2-config.pl
    Mon Mar 24 21:51:00 2008: Adding Config
    Mon Mar 24 21:51:00 2008: DROP TABLE IF EXISTS config;
    CREATE TABLE config (
            name        VARCHAR(255) NOT NULL PRIMARY KEY,
            value       TEXT,
            description TEXT,
            modified    TIMESTAMP
    ) ENGINE = MyISAM;
    
    ERROR 1040 (08004): Too many connections
    Mon Mar 24 21:51:03 2008: DELETE from zimbra_logger.config WHERE name = 'db.version';
    INSERT into zimbra_logger.config (name,value) values ('db.version',2);
    
    ERROR 1040 (08004): Too many connections
    Running /opt/zimbra/libexec/scripts/migrateLogger3-diskindex.pl
    Mon Mar 24 21:51:13 2008: SELECT value FROM config WHERE name = 'db.version'
    ERROR 1040 (08004): Too many connections
    Mon Mar 24 21:51:15 2008: Schema version mismatch.  Expected version 2.  Version in the database is 0.
    
    Script failed with code 1 - exiting
    UPGRADE FAILED - exiting

  2. #2
    Chewie71 is offline Trained Alumni
    Join Date
    Sep 2006
    Location
    Illinois
    Posts
    374
    Rep Power
    8

    Default

    It looks like maybe it couldn't find the Logger table in the database...perhaps there was some corruption in the DB before I started the upgrade?

    I noticed a few days ago I wasn't getting statistics anymore which kind of leads me down this path. Plus the point where it tries to find the logger schema, it comes up with "version 0".

    Thoughts?

    Matt

  3. #3
    Chewie71 is offline Trained Alumni
    Join Date
    Sep 2006
    Location
    Illinois
    Posts
    374
    Rep Power
    8

    Default

    /opt/zimbra/logger/db/data/my.host.name.err is filled with this error.

    Code:
    080324 21:48:58 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/raw_logs' is marked as crashed and last (automatic?) repair failed
    Is there a way I can repair that table and then continue the upgrade where it left off?

    Matt

  4. #4
    Chewie71 is offline Trained Alumni
    Join Date
    Sep 2006
    Location
    Illinois
    Posts
    374
    Rep Power
    8

    Default

    John Holder helped...and put in this ticket Bug 26281 - Check Logger DB integrity and Connection Prior to Installing.

    These are the steps I took to get it working...

    - rpm -e zcs-logger package
    - removed the /opt/zimbra/logger/db stuff
    - reran the installation

    I think it's ok now.

    Matt

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 03-10-2008, 09:31 PM
  2. Problem with Mail Server - Need help!
    By joeleo in forum Installation
    Replies: 2
    Last Post: 03-04-2008, 12:03 PM
  3. My Zimbra server down ... please help :)
    By frankb in forum Administrators
    Replies: 2
    Last Post: 12-12-2007, 11:29 AM
  4. failed upgrade, failed restore, big trouble
    By feralcoder in forum Installation
    Replies: 2
    Last Post: 03-19-2007, 05:38 PM
  5. Lotus migration
    By babou in forum Migration
    Replies: 15
    Last Post: 03-05-2007, 10:33 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
  •