[SOLVED] Upgrade 5.0.2 to 5.0.4 OSS Failed

[Chewie71]

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

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

[Chewie71]

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

[Chewie71]

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

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

[Chewie71]

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